Package org.apache.torque.map

Examples of org.apache.torque.map.ColumnMap

68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
        tMap.setJavaName("RolesUser");
        tMap.setOMClass( org.oslcm.om.RolesUser.class );
        tMap.setPeerClass( org.oslcm.om.RolesUserPeer.class );
        tMap.setPrimaryKeyMethod("none");

        ColumnMap cMap = null;


    // ------------- Column: ID --------------------
        cMap = new ColumnMap( "ID", tMap);
        cMap.setType( new Integer(0) );
        cMap.setTorqueType( "INTEGER" );
        cMap.setUsePrimitive(true);
        cMap.setPrimaryKey(true);
        cMap.setNotNull(true);
        cMap.setJavaName( "Id" );
        cMap.setAutoIncrement(true);
        cMap.setProtected(false);
                cMap.setInheritance("false");
                    cMap.setPosition(1);
          tMap.addColumn(cMap);
    // ------------- Column: ID_USER --------------------
        cMap = new ColumnMap( "ID_USER", tMap);
        cMap.setType( new Integer(0) );
        cMap.setTorqueType( "INTEGER" );
        cMap.setUsePrimitive(true);
        cMap.setPrimaryKey(false);
        cMap.setNotNull(true);
        cMap.setJavaName( "IdUser" );
        cMap.setAutoIncrement(false);
        cMap.setProtected(false);
                cMap.setInheritance("false");
                  cMap.setForeignKey("OSLCM_USERS", "ID_USER");
            cMap.setPosition(2);
          tMap.addColumn(cMap);
    // ------------- Column: ID_ROL --------------------
        cMap = new ColumnMap( "ID_ROL", tMap);
        cMap.setType( new Integer(0) );
        cMap.setTorqueType( "INTEGER" );
        cMap.setUsePrimitive(true);
        cMap.setPrimaryKey(false);
        cMap.setNotNull(true);
        cMap.setJavaName( "IdRol" );
        cMap.setAutoIncrement(false);
        cMap.setProtected(false);
                cMap.setInheritance("false");
                  cMap.setForeignKey("OSLCM_ROLES", "ID_ROL");
            cMap.setPosition(3);
          tMap.addColumn(cMap);
        tMap.setUseInheritance(false);
    }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
        tMap.setOMClass( org.oslcm.om.Environment.class );
        tMap.setPeerClass( org.oslcm.om.EnvironmentPeer.class );
        tMap.setDescription("Entornos");
        tMap.setPrimaryKeyMethod("none");

        ColumnMap cMap = null;


    // ------------- Column: ID_ENVIRONMENT --------------------
        cMap = new ColumnMap( "ID_ENVIRONMENT", tMap);
        cMap.setType( new Integer(0) );
        cMap.setTorqueType( "INTEGER" );
        cMap.setUsePrimitive(true);
        cMap.setPrimaryKey(true);
        cMap.setNotNull(true);
        cMap.setJavaName( "IdEnvironment" );
        cMap.setAutoIncrement(true);
        cMap.setProtected(false);
            cMap.setDescription("Codigo unico del entorno");
              cMap.setInheritance("false");
                    cMap.setPosition(1);
          tMap.addColumn(cMap);
    // ------------- Column: TYPE --------------------
        cMap = new ColumnMap( "TYPE", tMap);
        cMap.setType( new Integer(0) );
        cMap.setTorqueType( "INTEGER" );
        cMap.setUsePrimitive(true);
        cMap.setPrimaryKey(false);
        cMap.setNotNull(true);
        cMap.setJavaName( "Type" );
        cMap.setAutoIncrement(false);
        cMap.setProtected(false);
            cMap.setDescription("Typo de entorno");
              cMap.setInheritance("false");
                    cMap.setPosition(2);
          tMap.addColumn(cMap);
    // ------------- Column: DESCRIPTION --------------------
        cMap = new ColumnMap( "DESCRIPTION", tMap);
        cMap.setType( "" );
        cMap.setTorqueType( "VARCHAR" );
        cMap.setUsePrimitive(true);
        cMap.setPrimaryKey(false);
        cMap.setNotNull(true);
        cMap.setJavaName( "Description" );
        cMap.setAutoIncrement(false);
        cMap.setProtected(false);
            cMap.setDescription("La descripcion");
              cMap.setInheritance("false");
                cMap.setSize( 150 );
                  cMap.setPosition(3);
          tMap.addColumn(cMap);
        tMap.setUseInheritance(false);
    }
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
        {
            return false;
        }
        setIdTable("ID_TABLE");
        TableMap tMap = getIdTable();
        ColumnMap idTableId = new ColumnMap("QUANTITY", tMap);
        idTableId.setType(Integer.valueOf(0));
        idTableId.setPrimaryKey(true);
        tMap.addColumn(idTableId);
        ColumnMap tableName = new ColumnMap("TABLE_NAME", tMap);
        tableName.setType("");
        tMap.addColumn(tableName);
        ColumnMap nextId = new ColumnMap("NEXT_ID", tMap);
        nextId.setType(Integer.valueOf(0));
        tMap.addColumn(nextId);
        ColumnMap quantity = new ColumnMap("QUANTITY", tMap);
        quantity.setType(Integer.valueOf(0));
        tMap.addColumn(quantity);
        idBroker = new IDBroker(this);
        addIdGenerator(IDMethod.ID_BROKER, idBroker);
        return true;
    }
View Full Code Here
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
        final Database database = Torque.getDatabase(dbName);
        {
            Column databaseColumn = resolveAliasAndAsColumnAndSchema(
                    column,
                    criteria);
            ColumnMap columnMap = null;
            {
                DatabaseMap databaseMap = database.getDatabaseMap();
                TableMap tableMap = databaseMap.getTable(
                        databaseColumn.getTableName());
                if (tableMap != null)
                {
                    columnMap = tableMap.getColumn(
                            databaseColumn.getColumnName());
                }
            }
            if (columnMap != null)
            {
                // do not use ignoreCase on columns
                // which do not contain String values
                ignoreCase = ignoreCase
                    && columnMap.getType() instanceof String;
            }
        }

        for (int j = 0; j < criterion.getClauses().size(); j++)
        {
View Full Code Here
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
        // Check for each String/Character column and apply
        // toUpperCase().
        for (OrderBy orderBy : orderByList)
        {
            Column column = orderBy.getColumn();
            ColumnMap columnMap = MapHelper.getColumnMap(column, crit);
            String sqlExpression = column.getSqlExpression();

            // Either we are not able to look up the column in the
            // databaseMap, then simply use the case in orderBy and
            // hope the user knows what he is
            // doing.
            // Or we only ignore case in order by for string columns
            // which do not have a function around them
            if (columnMap == null
                    || (columnMap.getType() instanceof String
                        && sqlExpression.indexOf('(') == -1))
            {
                if (orderBy.isIgnoreCase() || crit.isIgnoreCase())
                {
                    final Adapter adapter = Torque.getAdapter(crit.getDbName());
View Full Code Here
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
        }
        Column column = (Column) value;
        Column databaseColumn = resolveAliasAndAsColumnAndSchema(
                column,
                criteria);
        ColumnMap columnMap = null;
        {
            DatabaseMap databaseMap = database.getDatabaseMap();
            TableMap tableMap = databaseMap.getTable(
                    databaseColumn.getTableName());
            if (tableMap != null)
            {
                columnMap = tableMap.getColumn(
                        databaseColumn.getColumnName());
            }
        }
        if (columnMap == null)
        {
            return true;
        }
        // do not use ignoreCase on columns
        // which do not contain String values
        return columnMap.getType() instanceof String;
    }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
        databasePostgresql = Torque.getDatabase("postgresql");
        databaseMysql = Torque.getDatabase("mysql");
        databaseOracle = Torque.getDatabase("oracle");
        tableMap = databaseMap.addTable("TABLE");
        {
            stringColumnMap = new ColumnMap("COLUMN1", tableMap);
            stringColumnMap.setType(new String(""));
            stringColumnMap.setJavaType("String");
            tableMap.addColumn(stringColumnMap);
        }
        {
            ColumnMap columnMap2 = new ColumnMap("COLUMN2", tableMap);
            columnMap2.setType(new String(""));
            columnMap2.setJavaType("String");
            tableMap.addColumn(columnMap2);
        }
        {
            ColumnMap columnMap3 = new ColumnMap("COLUMN3", tableMap);
            columnMap3.setType(new String(""));
            columnMap3.setJavaType("String");
            tableMap.addColumn(columnMap3);
        }
        {
            integerColumnMap = new ColumnMap("COLUMN4", tableMap);
            integerColumnMap.setType(new Integer(0));
            integerColumnMap.setJavaType("Integer");
            tableMap.addColumn(integerColumnMap);
        }
    }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        DatabaseMap fullyQualifiedDatatabaseMap
            = Torque.getDatabaseMap("fullyQualifiedDatatabaseMap");
        TableMap tableMap = new TableMap(
                "schema.fully_qualified_table",
                fullyQualifiedDatatabaseMap);
        ColumnMap columnMap = new ColumnMap("column", tableMap);
        basePeerImpl.setTableMap(tableMap);
        Criteria criteria = new Criteria();
        criteria.where(columnMap, 42);

        // execute
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
        DatabaseMap databaseMap = Torque.getDatabaseMap("postgresql");
        if (!databaseMap.containsTable("TABLE"))
        {
            TableMap tableMap = databaseMap.addTable("TABLE");
            {
                ColumnMap columnMap1 = new ColumnMap("COLUMN1", tableMap);
                columnMap1.setType(new String(""));
                columnMap1.setJavaType("String");
                tableMap.addColumn(columnMap1);
            }
            {
                ColumnMap columnMap2 = new ColumnMap("COLUMN2", tableMap);
                columnMap2.setType(new String(""));
                columnMap2.setJavaType("String");
                tableMap.addColumn(columnMap2);
            }
            {
                ColumnMap columnMap3 = new ColumnMap("COLUMN3", tableMap);
                columnMap3.setType(new String(""));
                columnMap3.setJavaType("String");
                tableMap.addColumn(columnMap3);
            }
            {
                ColumnMap columnMap4 = new ColumnMap("COLUMN4", tableMap);
                columnMap4.setType(new Integer(0));
                columnMap4.setJavaType("Integer");
                tableMap.addColumn(columnMap4);
            }
        }
    }
View Full Code Here
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
        // we need a rudimentary databaseMap for this test case to work
        DatabaseMap dbMap = Torque.getDatabaseMap(Torque.getDefaultDB());

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

        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.
        c.addSelectColumn(new ColumnImpl("AUTHOR", "NAME"));
View Full Code Here
TOP

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

  • org.apache.torque.BaseTestCase
  • org.apache.torque.criteria.CriteriaTest
  • org.apache.torque.Database
  • org.apache.torque.sql.SqlBuilder
  • org.apache.torque.util.BasePeer
  • org.apache.torque.util.BasePeerImpl
  • org.apache.torque.util.BasePeerImplTest
  • org.apache.torque.util.CriteriaTest
  • org.apache.torque.util.SQLBuilder
  • org.apache.turbine.services.schedule.map.JobEntryMapBuilder
    • 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.