Package com.scooterframework.orm.sqldataexpress.object

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

2817
2818
2819
2820
2821
2822
2823
2824
2825
2826
2827
     */
    protected void beforeSetData() {
        if (hasCopied) return;

        if (latestDbRowData == null) {
            latestDbRowData = new RowData(rowInfo, copyArray(rowData.getFields()));
        }
        else {
            latestDbRowData.setFields(copyArray(rowData.getFields()));
        }

View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
                            cellValues[i] = dba.getObjectFromResultSetByType(rs,
                                                                         cursor.getColumnJavaClassName(i),
                                                                         cursor.getColumnSqlDataType(i),
                                                                         i+1);
                        }
                        rt.addRow(new RowData(cursor, cellValues));
                    }
                    rs.close();
                }
                else {
                    returnTO.addNamedObject(p.getName(), dba.getObjectFromStatementByType(cstmt,
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
                                                                            i+1));
                            }
                        }
                       
                        if (cellValues.size() > 0)
                            rt.addRow(new RowData(newHeader, cellValues.toArray()));
                    }
                    rs.close();
                }
                else {
                    if (outputFilter.containsKey(p.getName())) {
View Full Code Here
780
781
782
783
784
785
786
787
788
789
790
791
792
        if(parentRt == null || childRt == null || childRt.getTableSize() == 0) return;

        int size = parentRt.getAllRows().size();
        Map<String, Object> connectorMap = new HashMap<String, Object>();
        for (int i = 0; i < size; i++) {
            RowData parentRow = parentRt.getRow(i);
            populateConnectorMap(connectorMap, parentRow, connectorList);
            parentRow.addChildRowToMap(processorName, getMatchingRowDataList(connectorMap, childRt));

            //clear the map for next row
            connectorMap.clear();
        }
    }
View Full Code Here
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
    private List<RowData> getMatchingRowDataList(Map<String, Object> connectorMap, TableData childRt) {
        List<RowData> filteredList = new ArrayList<RowData>();
        boolean allPassed = true;
        int size = childRt.getTableSize();
        for (int i=0; i<size; i++) {
            RowData child = childRt.getRow(i);

            for (Map.Entry<String, Object> entry :connectorMap.entrySet()) {
                String key = entry.getKey();
                Object keyData = entry.getValue();
                Object rowData = child.getField(key);
                if (rowData == null || !rowData.toString().equalsIgnoreCase(keyData.toString())) {
                    allPassed = false;
                    break;
                }
            }
View Full Code Here
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
            int size = parentRows.size();
            if (size > 0) {
                int rowIndex = 0;
                for (int i = 0; i < size -1; i++) {
                    rowIndex = i;
                    RowData parentRow = parentRows.get(i);
                    childQuery += populateChildInputs(rowIndex, childIp.getInputs(), parentRow, query) + " UNION ";
                }

                //last row
                rowIndex = size -1;
                RowData parentRow = (RowData)parentRows.get(rowIndex);
                childQuery += populateChildInputs(rowIndex, childIp.getInputs(), parentRow, query);
            }
        }
        else
        if (InputInfo.CONSTRUCT_CHILD_QUERY_MAKE_NEW_WHERE_CLAUSE.equals(childIp.getChildQueryType())) {
            int size = parentRows.size();
            if (size > 0) {
                String conditionPart1 = "(" + childIp.getFKString() + ") in ";
                String conditionPart2 = "";
                int rowIndex = 0;
                for (int i = 0; i < size -1; i++) {
                    rowIndex = i;
                    RowData parentRow = parentRows.get(i);
                    conditionPart2 += populateConditionPart2(rowIndex, childIp, parentRow) + ", ";
                }

                //last row
                rowIndex = size -1;
                RowData parentRow = parentRows.get(rowIndex);
                conditionPart2 += populateConditionPart2(rowIndex, childIp, parentRow);
                childQuery += " WHERE " + conditionPart1 + "(" + conditionPart2 + ")";
            }
        }
        else
        if (InputInfo.CONSTRUCT_CHILD_QUERY_ADD_TO_WHERE_CLAUSE.equals(childIp.getChildQueryType())) {
            int size = parentRows.size();
            if (size > 0) {
                String conditionPart1 = "(" + childIp.getFKString() + ") in ";
                String conditionPart2 = "";
                int rowIndex = 0;
                for (int i = 0; i < size -1; i++) {
                    rowIndex = i;
                    RowData parentRow = (RowData)parentRows.get(i);
                    conditionPart2 += populateConditionPart2(rowIndex, childIp, parentRow) + ", ";
                }

                //last row
                rowIndex = size -1;
                RowData parentRow = (RowData)parentRows.get(rowIndex);
                conditionPart2 += populateConditionPart2(rowIndex, childIp, parentRow);
                childQuery += " AND " + conditionPart1 + "(" + conditionPart2 + ")";
            }
        }
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
110
111
        inputs.put(DataProcessor.input_key_database_connection_name, connName);
        OmniDTO returnTO =
            SqlServiceConfig.getSqlService().execute(inputs, DataProcessorTypes.DIRECT_SQL_STATEMENT_PROCESSOR, insertSQL.toString());
        int insertCount = returnTO.getUpdatedRowCount();
       
        RowData record = null;
        if (insertCount == 1) {
            record = new RowData(ri, null);
            record.setData(inputs);
        }
       
        return record;
    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
        String table = getTable();
        setViewData("table", table);
       
        String connName = database;
        RowInfo ri = Record.getRowInfo(connName, table);
        RowData rd = new RowData(ri, null);
        setViewData("record", rd);
       
        return null;
    }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
        String table = getTable();
        setViewData("table", table);
       
        String connName = database;
        Map<String, Object> inputs = params();
        RowData record = null;
        try {
            record = Record.createRecord(inputs, connName, table);
            if (record == null) {
                flash("notice", "There is no record inserted with inputs as " + inputs + ".");
            }
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
        setViewData("table", table);
       
        String connName = database;
        String restfulId = p("id");
        Map<String, Object> inputs = params();
        RowData record = null;
        try {
            record = Record.getRow(connName, table, restfulId);
            if (record != null) {
                record.setData(inputs);
               
                int updateCount = Record.updateRecord(inputs, connName, table, restfulId);
                if (updateCount == 0) {
                    flash("notice", "There is no record updated in table \"" + table +
                    "\" with restful id as \"" + restfulId + "\".");
View Full Code Here
TOP

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

  • com.scooterframework.builtin.databrowser.Record
  • com.scooterframework.builtin.databrowser.RecordsController
  • com.scooterframework.orm.activerecord.ActiveRecord
  • com.scooterframework.orm.activerecord.IncludeHelper
  • com.scooterframework.orm.activerecord.ReferenceDataLoader$ReferenceDataTimerTask
  • com.scooterframework.orm.activerecord.TableGateway
  • com.scooterframework.orm.sqldataexpress.processor.JdbcStatementProcessor
  • com.scooterframework.orm.sqldataexpress.processor.StoredProcedureProcessor
  • com.scooterframework.orm.sqldataexpress.service.SqlServiceClientTest
  • com.scooterframework.orm.sqldataexpress.service.SqlServiceImpl
    • 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.