Package com.scooterframework.orm.sqldataexpress.object

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

2661
2662
2663
2664
2665
2666
2667
2668
2669
2670
2671
2672
2673
2674
2675
2676
2677
2678
2679
2680
2681
2682
2683
2684
2685
2686
2687
2688
2689
2690
2691
        StringBuilder names = new StringBuilder();
        StringBuilder values = new StringBuilder();
        int maxSize = rd.getSize();
        int positionIndex = 0;
        ColumnInfo ci = null;
        int i = 0;
    for (i = 0; i < maxSize - 1; i++) {
            ci = ri.getColumnInfo(i);
            if (ci.isPrimaryKey() && autoPopulatePrimaryKey) continue;
            if (ci.isReadOnly() || !ci.isWritable()) continue;
            if (changedOnly && !modifiedColumns.contains(ci.getColumnName())) continue;

            names.append(ci.getColumnName()).append(", ");
            values.append("?, ");
            positionIndex = positionIndex + 1;
            outs.put(positionIndex+"", rd.getField(i));
        }

        //the last column: i=maxSize-1
        ci = ri.getColumnInfo(i);
    if (!ci.isReadOnly()
        && ci.isWritable()
        && (!changedOnly || changedOnly
            && modifiedColumns.contains(ci.getColumnName()))) {
            names.append(ci.getColumnName()).append("");
            values.append("?");
            positionIndex = positionIndex + 1;
            outs.put(positionIndex+"", rd.getField(i));
        }
View Full Code Here
2736
2737
2738
2739
2740
2741
2742
2743
2744
2745
2746
2747
2748
2749
2750
2751
2752
            throw new IllegalArgumentException("Error in prepareSetSQL: no RowInfo.");

        int maxSize = rd.getSize();

        int i = 0;
        ColumnInfo ci = null;
    for (i = 0; i < maxSize; i++) {
            ci = ri.getColumnInfo(i);
            if (ci.isReadOnly() || !ci.isWritable() || ci.isPrimaryKey()) continue;
            if (changedOnly && !modifiedColumns.contains(ci.getColumnName())) continue;

            strBuffer.append(ci.getColumnName()).append(" = ?, ");
            outs.put(startPosition + "", rd.getField(i));
            startPosition = startPosition + 1;
        }

        return startPosition;
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
    List<Map<String, Object>> columns = new ArrayList<Map<String, Object>>();
    RowInfo ri = O.rowInfoOf(recordHome);
    Iterator<ColumnInfo> it = O.columns(recordHome);
    while(it.hasNext()) {
      ColumnInfo ci = (ColumnInfo)it.next();
      String columnName = ci.getColumnName();
        boolean isAuditedColumn = ri.isAuditedForCreateOrUpdate(columnName);
        if (isAuditedColumn) continue;

        if (ci.isAutoIncrement()) continue;

      String columnNameLower = columnName.toLowerCase();
        boolean isPKColumn = ri.isPrimaryKeyColumn(columnName);
        if (!isPKColumn && ci.isAutoIncrement()) continue;
      boolean isRequired = ri.isRequiredColumn(columnName);
        boolean isLongText = ri.isLongTextColumn(columnName, 255);
        boolean isDateColumn = ri.isDateColumn(columnName);
        boolean isTimestampColumn = ri.isTimestampColumn(columnName);
        int size = 80;
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
182
183
184
    public static String prepareInsertSQL(RowInfo ri, Map<String, Object> inputs) {
        Set<String> inputKeys = inputs.keySet();
        StringBuilder names = new StringBuilder();
        StringBuilder values = new StringBuilder();
        int maxSize = ri.getDimension();
        ColumnInfo ci = null;
        for(int i = 0; i < maxSize; i++) {
            ci = ri.getColumnInfo(i);
            String columnName = ci.getColumnName();
            if (columnName == null) continue;
           
            columnName = columnName.toUpperCase();
            if (!inputKeys.contains(columnName)) {
              if (!ri.isAuditedForCreate(columnName)) {
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
   
    public static String prepareSetSQL(RowInfo ri, Map<String, Object> inputs) {
        Set<String> inputKeys = inputs.keySet();
        StringBuilder sb = new StringBuilder();
        int maxSize = ri.getDimension();
        ColumnInfo ci = null;
        for(int i = 0; i < maxSize; i++) {
            ci = ri.getColumnInfo(i);
            String columnName = ci.getColumnName();
            if (columnName == null) continue;
           
            columnName = columnName.toUpperCase();
            if (ci.isReadOnly() || !ci.isWritable() || ci.isPrimaryKey()) continue;

            if (!inputKeys.contains(columnName)) {
              if (!ri.isAuditedForUpdate(columnName)) {
                continue;
              }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
    List<Map<String, Object>> columns = new ArrayList<Map<String, Object>>();
    RowInfo ri = O.rowInfoOf(recordHome);
    Iterator<ColumnInfo> it = O.columns(recordHome);
    while(it.hasNext()) {
      ColumnInfo ci = it.next();
      String columnName = ci.getColumnName();
        boolean isAuditedColumn = ri.isAuditedForCreateOrUpdate(columnName);
        if (isAuditedColumn) continue;

        if (ci.isAutoIncrement()) continue;

      String columnNameLower = columnName.toLowerCase();
      boolean isRequired = ri.isRequiredColumn(columnName);
        boolean isLongText = ri.isLongTextColumn(columnName, 255);
        boolean isDateColumn = ri.isDateColumn(columnName);
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
        if (onlyColumnsStr != null && onlyColumnsStr.trim().length() > 0)
          onlyColumns = Converters.convertStringToSet(onlyColumnsStr.toUpperCase());
       
        int columnWidth = cursor.getDimension();
        for (int i = 0; i < columnWidth; i++) {
            ColumnInfo ci = cursor.getColumnInfo(i);
            String columnName = ci.getColumnName();
            if ((exceptColumns != null && exceptColumns.contains(columnName)) ||
                (onlyColumns != null && !onlyColumns.contains(columnName))) {
              continue;
            }
            allowedColumns.add(columnName);
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
138
        RowInfo header = new RowInfo();
        int columnWidth = cursor.getDimension();
        List<ColumnInfo> allowedColumnInfos = new ArrayList<ColumnInfo>();
       
        for (int i = 0; i < columnWidth; i++) {
            ColumnInfo ci = cursor.getColumnInfo(i);
            if (allowedColumns.contains(ci.getColumnName())) {
              allowedColumnInfos.add(ci);
            }
        }
       
        header.setColumnInfoList(allowedColumnInfos);
View Full Code Here
2167
2168
2169
2170
2171
2172
2173
2174
2175
2176
2177
2178
2179
2180
2181
2182
2183
2184
2185
    String updateSQL = "UPDATE " + home.getTableName();

    try {
      Map<String, Object> inputs = new HashMap<String, Object>();
      StringBuilder strBuffer = new StringBuilder();
      ColumnInfo ci = null;
      RowInfo ri = home.getRowInfo();
      for (Map.Entry<String, Object> entry : fieldData.entrySet()) {
        String field = entry.getKey();
        if (field == null) continue;

        ci = ri.getColumnInfo(field);
        if (!ri.isValidColumnName(field) || ci.isReadOnly()
            || !ci.isWritable() || ci.isPrimaryKey())
          continue;

        String token = getUniqueToken(field, conditionsSQLData, true);
        strBuffer.append(field).append(" = ?").append(token).append(", ");
        inputs.put(token, entry.getValue());
View Full Code Here
TOP

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

  • com.scooterframework.builtin.databrowser.Record
  • com.scooterframework.orm.activerecord.ActiveRecord
  • com.scooterframework.orm.activerecord.TableGateway
  • com.scooterframework.orm.sqldataexpress.processor.DataProcessorImpl
  • com.scooterframework.tools.generator.ViewAddGenerator
  • com.scooterframework.tools.generator.ViewEditGenerator
    • 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.