Package com.scooterframework.orm.sqldataexpress.object

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

84
85
86
87
88
89
90
91
92
93
94
        }
        return (td != null)?td.getFirstRow():null;
    }
   
    public static RowData createRecord(Map<String, Object> inputs, String connName, String table) {
        RowInfo ri = getRowInfo(connName, table);
        inputs = StringUtil.convertKeyToUpperCase(inputs);
       
        StringBuilder insertSQL = new StringBuilder();
        insertSQL.append("INSERT INTO ").append(SqlExpressUtil.getExpandedTableName(connName, table));
        insertSQL.append(" ").append(prepareInsertSQL(ri, inputs));
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
       
        return record;
    }
   
    public static int updateRecord(Map<String, Object> inputs, String connName, String table, String restfulId) {
        RowInfo ri = getRowInfo(connName, table);
        inputs = StringUtil.convertKeyToUpperCase(inputs);
       
        StringBuilder updateSQL = new StringBuilder();
        updateSQL.append("UPDATE ").append(SqlExpressUtil.getExpandedTableName(connName, table));
        updateSQL.append(" SET ").append(prepareSetSQL(ri, inputs));
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
       
        return updateCount;
    }
   
    public static int deleteRecord(Map<String, Object> inputs, String connName, String table, String restfulId) {
        RowInfo ri = getRowInfo(connName, table);
       
        StringBuilder deleteSQL = new StringBuilder();
        deleteSQL.append("DELETE FROM ").append(SqlExpressUtil.getExpandedTableName(connName, table));
       
        String condition = prepareDynamicWhereClauseForRestfulId(inputs, ri, restfulId);
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
       
        return deleteCount;
    }
   
    public static RowInfo getRowInfo(String connName, String table) {
        RowInfo ri = null;
        TableInfo ti = SqlExpressUtil.lookupTableInfo(connName, table);
        if (ti != null) {
            ri = ti.getHeader();
        }
       
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
      super(connName, Record.getFinderSql(connName, tableName));
      this.tableName = tableName;
    }
   
    protected List<RowData> retrieveList() {
      RowInfo ri = Record.getRowInfo(connName, tableName);
     
      Map<String, Object> inputs = new HashMap<String, Object>();
      inputs.putAll(inputOptions);
      inputs.put(DataProcessor.input_key_database_connection_name, connName);
     
View Full Code Here
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
            stmt = conn.createStatement();

            // Query the table
            rs = stmt.executeQuery(sqlString);
           
            RowInfo header = new RowInfo(table, rs.getMetaData());
            header.setCatalog(catalog);
            header.setSchema(schema);
            header.setTable(table);
           
            ti.setHeader(header);
            DAOUtil.closeResultSet(rs);

            //set more properties
            DatabaseMetaData dbmd = conn.getMetaData();
            rs2 = dbmd.getColumns(toUpperCaseIfAllowed(dba, catalog),
                toUpperCaseIfAllowed(dba, schema),
                toUpperCaseIfAllowed(dba, table), (String)null);
            header.setResultSetMetaDataForTable(rs2);
           
            // set some table properties
            //ti.setSchema(ti.getHeader().getColumnInfo(0).getSchemaName());
            //ti.setCatalog(ti.getHeader().getColumnInfo(0).getCatalogName());
           
            // get primary keys
            if (!header.hasPrimaryKey()) {
                PrimaryKey pk = lookupPrimaryKey(dba, conn, catalog, schema, table);
                if (pk != null) header.setPrimaryKeyColumns(pk.getColumns());
            }
        }
        finally {
            DAOUtil.closeResultSet(rs);
            DAOUtil.closeResultSet(rs2);
View Full Code Here
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
            DatabaseMetaData dbmd = conn.getMetaData();
            rs = dbmd.getColumns(toUpperCaseIfAllowed(dba, catalog),
                toUpperCaseIfAllowed(dba, schema),
                toUpperCaseIfAllowed(dba, viewName), (String)null);
           
            RowInfo header = ti.getHeader();
            header.setResultSetMetaDataForView(rs);
            header.setCatalog(catalog);
            header.setSchema(schema);
            header.setTable(viewName);
           
            // set some table properties
            ti.setSchema(ti.getHeader().getColumnInfo(0).getSchemaName());
            ti.setCatalog(ti.getHeader().getColumnInfo(0).getCatalogName());
            ti.setType(TableInfo.TYPE_VIEW);
           
            header.setCatalog(ti.getCatalog());
            header.setSchema(ti.getSchema());
            header.setTable(ti.getName());
        }
        finally {
            DAOUtil.closeResultSet(rs);
        }
       
View Full Code Here
578
579
580
581
582
583
584
585
     *
     * @param model model name
     * @return RowInfo for the model
     */
    public static RowInfo getRowInfo(String model) {
        RowInfo ri = homeInstance(model).getRowInfo();
        return (ri != null)?ri:(new RowInfo());
    }
View Full Code Here
599
600
601
602
603
604
605
     *
     * @param record a record object
     * @return RowInfo attribute of the record.
     */
    public static RowInfo rowInfoOf(ActiveRecord record) {
        return (record != null)?record.getRowInfo():(new RowInfo());
    }
View Full Code Here
609
610
611
612
613
614
615
     *
     * @param record a record object
     * @return RowInfo attribute of the record.
     */
    public static RowInfo rowInfoOf(RowData record) {
        return (record != null)?record.getRowInfo():(new RowInfo());
    }
View Full Code Here
TOP

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

  • com.scooterframework.builtin.databrowser.Record
  • com.scooterframework.builtin.databrowser.RecordsController
  • com.scooterframework.builtin.databrowser.TableSqlPageListSource
  • com.scooterframework.orm.activerecord.ActiveRecord
  • com.scooterframework.orm.activerecord.IncludeHelper
  • com.scooterframework.orm.activerecord.RelationManager
  • com.scooterframework.orm.activerecord.TableGateway
  • com.scooterframework.orm.sqldataexpress.parser.JdbcStatementParser
  • com.scooterframework.orm.sqldataexpress.processor.DataProcessorImpl
  • com.scooterframework.orm.sqldataexpress.processor.JdbcStatementProcessor
    • 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.