Package org.apache.torque.map

Examples of org.apache.torque.map.TableMap


    public void testOrderBy() throws TorqueException
    {
        // we need a rudementary databaseMap for this test case to work
        DatabaseMap dbMap = Torque.getDatabaseMap(Torque.getDefaultDB());

        TableMap tableMap = new TableMap("AUTHOR", dbMap);
        dbMap.addTable(tableMap);

        ColumnMap columnMap = new ColumnMap("NAME", tableMap);
        columnMap.setType("");
        tableMap.addColumn(columnMap);

        columnMap = new ColumnMap("AUTHOR_ID", tableMap);
        columnMap.setType(new Integer(0));
        tableMap.addColumn(columnMap);

        // check that alias'ed tables are referenced by their alias
        // name when added to the select clause.
        Criteria criteria = new Criteria();
        criteria.addSelectColumn("AUTHOR.NAME");
View Full Code Here


        public void doBuild() throws TorqueException
        {
            dbMap = Torque.getDatabaseMap(TURBINE_NAME);

            dbMap.addTable(tableName);
            TableMap tMap = dbMap.getTable(tableName);

            tMap.setPrimaryKeyMethod(TableMap.NATIVE);

            tMap.setPrimaryKeyMethodInfo(tableName);

            tMap.addPrimaryKey(tableName + "ID", new Integer(0));
            tMap.addColumn(tableName + "NAME", "", 50 );
        }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("PORTLET_MEDIATYPE");
        TableMap tMap = dbMap.getTable("PORTLET_MEDIATYPE");

        tMap.setPrimaryKeyMethod(TableMap.NATIVE);

        tMap.setPrimaryKeyMethodInfo("PORTLET_MEDIATYPE");

              tMap.addForeignKey(
                "PORTLET_MEDIATYPE.ID", new Long(0) , "PORTLET" ,
                "ID");
                    tMap.addForeignKey(
                "PORTLET_MEDIATYPE.MEDIA_ID", new Long(0) , "MEDIATYPE" ,
                "ID");
          }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("CATEGORY");
        TableMap tMap = dbMap.getTable("CATEGORY");

        tMap.setPrimaryKeyMethod(TableMap.NATIVE);

        tMap.setPrimaryKeyMethodInfo("CATEGORY");

              tMap.addPrimaryKey("CATEGORY.ID", new Long(0));
                    tMap.addColumn("CATEGORY.NAME", new String());
                    tMap.addColumn("CATEGORY.GROUPE", new String());
                    tMap.addForeignKey(
                "CATEGORY.OWNER", new Long(0) , "PORTLET" ,
                "ID");
          }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("PORTLET");
        TableMap tMap = dbMap.getTable("PORTLET");

        tMap.setPrimaryKeyMethod(TableMap.NATIVE);

        tMap.setPrimaryKeyMethodInfo("PORTLET");

              tMap.addPrimaryKey("PORTLET.ID", new Long(0));
                    tMap.addColumn("PORTLET.NAME", new String());
                    tMap.addColumn("PORTLET.HIDDEN", new Integer(0));
                    tMap.addColumn("PORTLET.CLASSNAME", new String());
                    tMap.addColumn("PORTLET.TYPE", new String());
                    tMap.addColumn("PORTLET.APPLICATION", new Integer(0));
                    tMap.addColumn("PORTLET.PARENT", new Long(0));
                    tMap.addColumn("PORTLET.URL", new String());
                    tMap.addColumn("PORTLET.CACHEDONURL", new Integer(0));
                    tMap.addColumn("PORTLET.ROLE", new String());
                    tMap.addColumn("PORTLET.TITLE", new String());
                    tMap.addColumn("PORTLET.DESCRIPTION", new String());
                    tMap.addColumn("PORTLET.IMAGE", new String());
                    tMap.addColumn("PORTLET.SECURITY", new String());
          }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("MEDIATYPE");
        TableMap tMap = dbMap.getTable("MEDIATYPE");

        tMap.setPrimaryKeyMethod(TableMap.NATIVE);

        tMap.setPrimaryKeyMethodInfo("MEDIATYPE");

              tMap.addPrimaryKey("MEDIATYPE.ID", new Long(0));
                    tMap.addColumn("MEDIATYPE.NAME", new String());
                    tMap.addColumn("MEDIATYPE.HIDDEN", new Integer(0));
                    tMap.addColumn("MEDIATYPE.MIMETYPE", new String());
                    tMap.addColumn("MEDIATYPE.ROLE", new String());
                    tMap.addColumn("MEDIATYPE.TITLE", new String());
                    tMap.addColumn("MEDIATYPE.DESCRIPTION", new String());
                    tMap.addColumn("MEDIATYPE.IMAGE", new String());
          }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("COFFEES");
        TableMap tMap = dbMap.getTable("COFFEES");

        tMap.setPrimaryKeyMethod(TableMap.NATIVE);

        tMap.setPrimaryKeyMethodInfo("COFFEES");

              tMap.addPrimaryKey("COFFEES.COFFEE_ID", new Integer(0));
                    tMap.addColumn("COFFEES.COFFEE_NAME", new String());
                    tMap.addColumn("COFFEES.SUPPLIER_ID", new Integer(0));
                    tMap.addColumn("COFFEES.PRICE", new Double(0));
                    tMap.addColumn("COFFEES.SALES", new Integer(0));
                    tMap.addColumn("COFFEES.TOTAL", new Integer(0));
          }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("PORTLET_PARAMETER");
        TableMap tMap = dbMap.getTable("PORTLET_PARAMETER");

        tMap.setPrimaryKeyMethod(TableMap.NATIVE);

        tMap.setPrimaryKeyMethodInfo("PORTLET_PARAMETER");

              tMap.addPrimaryKey("PORTLET_PARAMETER.ID", new Long(0));
                    tMap.addColumn("PORTLET_PARAMETER.NAME", new String());
                    tMap.addColumn("PORTLET_PARAMETER.VALUE", new String());
                    tMap.addColumn("PORTLET_PARAMETER.TYPE", new String());
                    tMap.addColumn("PORTLET_PARAMETER.HIDDEN", new Integer(0));
                    tMap.addColumn("PORTLET_PARAMETER.ROLE", new String());
                    tMap.addColumn("PORTLET_PARAMETER.CACHEDONVALUE", new Integer(0));
                    tMap.addColumn("PORTLET_PARAMETER.CACHEDONNAME", new Integer(0));
                    tMap.addColumn("PORTLET_PARAMETER.TITLE", new String());
                    tMap.addColumn("PORTLET_PARAMETER.DESCRIPTION", new String());
                    tMap.addColumn("PORTLET_PARAMETER.IMAGE", new String());
                    tMap.addForeignKey(
                "PORTLET_PARAMETER.PORTLET_ID", new Long(0) , "PORTLET" ,
                "ID");
                    tMap.addColumn("PORTLET_PARAMETER.SECURITY", new String());
          }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("TURBINE_ROLE_PERMISSION");
        TableMap tMap = dbMap.getTable("TURBINE_ROLE_PERMISSION");

        tMap.setPrimaryKeyMethod("none");


              tMap.addForeignPrimaryKey(
                "TURBINE_ROLE_PERMISSION.ROLE_ID", new Integer(0) , "TURBINE_ROLE" ,
                "ROLE_ID");
                    tMap.addForeignPrimaryKey(
                "TURBINE_ROLE_PERMISSION.PERMISSION_ID", new Integer(0) , "TURBINE_PERMISSION" ,
                "PERMISSION_ID");
          }
View Full Code Here

    public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("default");

        dbMap.addTable("TURBINE_USER");
        TableMap tMap = dbMap.getTable("TURBINE_USER");

        tMap.setPrimaryKeyMethod(TableMap.NATIVE);

        tMap.setPrimaryKeyMethodInfo("TURBINE_USER");

              tMap.addPrimaryKey("TURBINE_USER.USER_ID", new Integer(0));
                    tMap.addColumn("TURBINE_USER.LOGIN_NAME", new String());
                    tMap.addColumn("TURBINE_USER.PASSWORD_VALUE", new String());
                    tMap.addColumn("TURBINE_USER.FIRST_NAME", new String());
                    tMap.addColumn("TURBINE_USER.LAST_NAME", new String());
                    tMap.addColumn("TURBINE_USER.EMAIL", new String());
                    tMap.addColumn("TURBINE_USER.CONFIRM_VALUE", new String());
                    tMap.addColumn("TURBINE_USER.MODIFIED", new Date());
                    tMap.addColumn("TURBINE_USER.CREATED", new Date());
                    tMap.addColumn("TURBINE_USER.LAST_LOGIN", new Date());
                    tMap.addColumn("TURBINE_USER.DISABLED", new String());
                    tMap.addColumn("TURBINE_USER.OBJECTDATA", new Object());
                    tMap.addColumn("TURBINE_USER.PASSWORD_CHANGED", new Date());
          }
View Full Code Here

TOP

Related Classes of org.apache.torque.map.TableMap

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.