Package com.scooterframework.orm.sqldataexpress.object

Examples of com.scooterframework.orm.sqldataexpress.object.TableInfo

403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
        try {
          conn = getConnection(connName);
            DatabaseMetaData dbmd = conn.getMetaData();
            rs = dbmd.getTables(catalog, schema, tableName, types);
            while (rs.next()) {
                TableInfo ti = new TableInfo();
                ti.setCatalog(rs.getString("TABLE_CAT"));
                ti.setName(rs.getString("TABLE_NAME"));
                ti.setRemarks(rs.getString("REMARKS"));
                ti.setSchema(rs.getString("TABLE_SCHEM"));
                ti.setType(rs.getString("TABLE_TYPE"));
                list.add(ti);
            }
            rs.close();
        }
        catch(SQLException ex) {
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
     
        if (tableName == null) return null;
       
        String fullTableName = getFullTableName(connName, catalog, schema, tableName);
        String tableKey = getTableKey(connName, fullTableName);
        TableInfo ti = null;
        if (DatabaseConfig.getInstance().isInDevelopmentEnvironment()) {
          ti = (TableInfo)CurrentThreadCache.get(tableKey);
            return ti;
        }
       
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
      }
     
        if (tableName == null) return null;
       
        String tableKey = getTableKey(connName, tableName);
        TableInfo ti = null;
        if (DatabaseConfig.getInstance().isInDevelopmentEnvironment()) {
          ti = (TableInfo)CurrentThreadCache.get(tableKey);
            return ti;
        }
       
View Full Code Here
237
238
239
240
241
242
243
244
245
246
  static String getOrderByClauseFromTableMetaInfo(Map<String, Object> inputs) {
    String connName = getConnectionName(inputs);
    String table = getTableOrViewName(inputs);
    if (table == null) return null;
   
    TableInfo ti = SqlExpressUtil.lookupTableInfo(connName, table);
    if (ti == null) return null;
    String[] columns = ti.getHeader().getColumnNames();
    return (columns != null && columns.length > 0)?columns[0]:null;
  }
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
            conn = SqlExpressUtil.getReadonlyConnection(connName);
            List<TableInfo> tmp = SqlExpressUtil.getDatabaseTables(connName, catalog, schema, null, types);
            if (tmp != null) {
              Iterator<TableInfo> it = tmp.iterator();
              while(it.hasNext()) {
                TableInfo ti = (TableInfo)it.next();
                if (!SqlExpressUtil.isNiceDBString(ti.getName())) continue;
                tableInfos.add(ti);
              }
            }
        }
        catch(Exception ex) {
View Full Code Here
91
92
93
94
95
96
97
98
        Object result = SqlExpressUtil.countTotalRecords(connName, table);
        return (result != null)?result.toString():"0";
    }
   
    public static RowInfo getTableHeaderInfo(String connName, String table) {
      TableInfo ti = SqlExpressUtil.lookupTableInfo(connName, table);
      return (ti != null)?ti.getHeader():null;
    }
View Full Code Here
TOP

Related Classes of com.scooterframework.orm.sqldataexpress.object.TableInfo

  • com.scooterframework.builtin.databrowser.Record
  • com.scooterframework.builtin.databrowser.Table
  • com.scooterframework.orm.activerecord.ActiveRecord
  • com.scooterframework.orm.sqldataexpress.parser.JdbcStatementParser
  • com.scooterframework.orm.sqldataexpress.util.DBStore
  • com.scooterframework.orm.sqldataexpress.util.SqlExpressUtil
  • com.scooterframework.orm.sqldataexpress.vendor.DBAdapter
    • 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.