Package org.apache.empire.db

Examples of org.apache.empire.db.DBColumn

68
69
70
71
72
73
74
75
76
77
        final DBReference dbReference = references[0];
    assertEquals(dbReference.getSourceColumn(), employees.getColumn("DEPARTMENT_ID"));
        assertEquals(dbReference.getTargetColumn(), departments.getColumn("DEPARTMENT_ID"));
       
        final DBColumn salary = employees.getColumn("SALARY");

        assertThat(salary.getDataType(), is(DECIMAL));
        assertThat(salary.getSize(), is(121.212));
    }
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
        sql.append("COMMENT ON ");
        sql.append(type);
        sql.append(" ");
        if (expr instanceof DBColumn)
        {
            DBColumn c = (DBColumn)expr;
            c.getRowSet().addSQL(sql, DBExpr.CTX_NAME);
            sql.append(".");
        }
        expr.addSQL(sql, DBExpr.CTX_NAME);
        sql.append(" IS '");
        sql.append(comment);
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
179
        sql.append("COMMENT ON ");
        sql.append(type);
        sql.append(" ");
        if (expr instanceof DBColumn)
        {
            DBColumn c = (DBColumn)expr;
            c.getRowSet().addSQL(sql, DBExpr.CTX_NAME);
            sql.append(".");
        }
        expr.addSQL(sql, DBExpr.CTX_NAME);
        sql.append(" IS '");
        sql.append(comment);
View Full Code Here
425
426
427
428
429
430
431
432
433
434
435
               
                if (dbTable != null)
                {
                   
                    // check if the found column exists in the found DBTable
                    DBColumn col = dbTable.getColumn(columnName);
                    if (col == null)
                    {
                        log.warn("COLUMN NOT FOUND IN " + db.getClass().getName() + "\t: [" + tableName + "]["
                                       + columnName + "][" + dataType + "][" + dataLength + "]");
                        continue;
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
        DBDatabase db = t.getDatabase();
        createComment(db, "TABLE", t, t.getComment(), script);
        Iterator<DBColumn> columns = t.getColumns().iterator();
        while (columns.hasNext())
        {
            DBColumn c = columns.next();
            String com = c.getComment();
            if (com != null)
                createComment(db, "COLUMN", c, com, script);
        }
    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
    }
    // Foreign Key
    Map<DBColumn, DBColumn> referencesMap = t.getColumnReferences();
    if (referencesMap != null)
    {
      DBColumn source = null,target = null;
      for (Entry<DBColumn, DBColumn> entry : referencesMap.entrySet())
      {
        source = entry.getKey();
        target = entry.getValue();
        sql.append((addSeparator) ? ",\r\n   " : "\r\n   ");
        sql.append("FOREIGN KEY (");
        source.addSQL(sql, DBExpr.CTX_NAME);
        sql.append(") REFERENCES ");
        sql.append(target.getRowSet().getName());
        sql.append(" (");
        target.addSQL(sql, DBExpr.CTX_NAME);
        sql.append(")");
View Full Code Here
137
138
139
140
141
142
143
144
    public EmployeeListPage()
    {
        EmployeeListPage.log.trace("EmployeeListPage created");
        TEmployees EMP = getDatabase().T_EMPLOYEES;
       
        DBColumn defSortColumn = EMP.EMPLOYEE_ID;
        employees = new BeanListPageElement<EmployeeListEntry>(this, EmployeeListEntry.class, defSortColumn, EmployeeListPage.EMPLOYEES_PROPERTY);
    }
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
  private void gatherRelations(DBDatabase db, DatabaseMetaData dbMeta, ArrayList<String> tables) throws SQLException{
    ResultSet relations = null;
    String fkTableName, pkTableName, fkColName, pkColName, relName;
    DBTableColumn fkCol, pkCol;
    DBTable fkTable, pkTable;
    DBColumn col;
   
    // Add all Relations
    for (String tableName :tables) {
     
      // check for foreign-keys
View Full Code Here
560
561
562
563
564
565
566
567
568
569
570
571
        // add Comments
        createComment(db, "TABLE", t, t.getComment(), script);
        columns = t.getColumns().iterator();
        while (columns.hasNext())
        {
            DBColumn c = columns.next();
            String com = c.getComment();
            if (com != null)
                createComment(db, "COLUMN", c, com, script);
        }
        // done
        return success();
View Full Code Here
794
795
796
797
798
799
800
801
802
803
804
805
        sql.append("COMMENT ON ");
        sql.append(type);
        sql.append(" ");
        if (expr instanceof DBColumn)
        {
            DBColumn c = (DBColumn)expr;
            c.getRowSet().addSQL(sql, DBExpr.CTX_NAME);
            sql.append(".");
        }
        expr.addSQL(sql, DBExpr.CTX_NAME);
        sql.append(" IS '");
        sql.append(comment);
View Full Code Here
TOP

Related Classes of org.apache.empire.db.DBColumn

  • org.apache.empire.data.DataType
  • org.apache.empire.db.codegen.CodeGenParser
  • org.apache.empire.db.codegen.CodeGenParserTest
  • org.apache.empire.db.expr.compare.DBCompareColExpr
  • org.apache.empire.db.expr.join.DBJoinExpr
  • org.apache.empire.db.expr.set.DBSetExpr
  • org.apache.empire.db.oracle.DBDatabaseDriverOracle
  • org.apache.empire.db.oracle.OracleDDLGenerator
  • org.apache.empire.db.sqlite.SQLiteDDLGenerator
  • org.apache.empire.jsf2.websample.web.pages.EmployeeListPage
    • 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.