Package com.j256.ormlite.stmt.query

Examples of com.j256.ormlite.stmt.query.BaseComparisonTest

51
52
53
54
55
56
57
58
59
60
61
        tableInfo.getFieldTypes(), "query-for-id");
  }

  protected static <T, ID> String buildStatement(DatabaseType databaseType, TableInfo<T, ID> tableInfo)
      throws SQLException {
    FieldType idField = tableInfo.getIdField();
    if (idField == null) {
      throw new SQLException("Cannot query-for-id with " + tableInfo.getDataClass()
          + " because it doesn't have an id field");
    }
    // build the select statement by hand
View Full Code Here
17
18
19
20
21
22
23
24
25
26
27
    super(tableInfo, statement, argFieldTypes);
  }

  public static <T, ID> MappedUpdate<T, ID> build(DatabaseType databaseType, TableInfo<T, ID> tableInfo)
      throws SQLException {
    FieldType idField = tableInfo.getIdField();
    if (idField == null) {
      throw new SQLException("Cannot update " + tableInfo.getDataClass() + " because it doesn't have an id field");
    }
    if (tableInfo.getFieldTypes().length == 1) {
      throw new SQLException("Cannot update " + tableInfo.getDataClass()
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
   * NOTE: Use of this means that the resulting objects may not have a valid ID column value so cannot be deleted or
   * updated.
   * </p>
   */
  public QueryBuilder<T, ID> groupBy(String columnName) {
    FieldType fieldType = verifyColumnName(columnName);
    if (fieldType.isForeignCollection()) {
      throw new IllegalArgumentException("Can't groupBy foreign colletion field: " + columnName);
    }
    if (groupByList == null) {
      groupByList = new ArrayList<String>();
    }
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
183
184
   */
  public static <T> FieldType extractIdFieldType(ConnectionSource connectionSource, Class<T> clazz, String tableName)
      throws SQLException {
    for (Class<?> classWalk = clazz; classWalk != null; classWalk = classWalk.getSuperclass()) {
      for (Field field : classWalk.getDeclaredFields()) {
        FieldType fieldType = FieldType.createFieldType(connectionSource, tableName, field, clazz);
        if (fieldType != null
            && (fieldType.isId() || fieldType.isGeneratedId() || fieldType.isGeneratedIdSequence())) {
          return fieldType;
        }
      }
    }
    return null;
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
145
  /**
   * Add "ORDER BY" clause to the SQL query statement.
   */
  public QueryBuilder<T, ID> orderBy(String columnName, boolean ascending) {
    FieldType fieldType = verifyColumnName(columnName);
    if (fieldType.isForeignCollection()) {
      throw new IllegalArgumentException("Can't orderBy foreign colletion field: " + columnName);
    }
    if (orderByList == null) {
      orderByList = new ArrayList<OrderBy>();
    }
View Full Code Here
240
241
242
243
244
245
246
247
248
249
250
    }
    appendOffset(sb);
  }

  private void addSelectColumnToList(String columnName) {
    FieldType fieldType = verifyColumnName(columnName);
    if (fieldType.isForeignCollection()) {
      throw new IllegalArgumentException("Can't select from foreign colletion field: " + columnName);
    }
    selectColumnList.add(columnName);
  }
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
  private static <T> FieldType[] extractFieldTypes(ConnectionSource connectionSource, Class<T> clazz, String tableName)
      throws SQLException {
    List<FieldType> fieldTypes = new ArrayList<FieldType>();
    for (Class<?> classWalk = clazz; classWalk != null; classWalk = classWalk.getSuperclass()) {
      for (Field field : classWalk.getDeclaredFields()) {
        FieldType fieldType = FieldType.createFieldType(connectionSource, tableName, field, clazz);
        if (fieldType != null) {
          fieldTypes.add(fieldType);
        }
      }
    }
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
      if (first) {
        first = false;
      } else {
        sb.append(',');
      }
      FieldType fieldType = tableInfo.getFieldTypeByColumnName(columnName);
      appendFieldColumnName(sb, fieldType, fieldTypeList);
      if (fieldType == idField) {
        hasId = true;
      }
    }
View Full Code Here
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
  private FieldType[] convertFieldConfigs(ConnectionSource connectionSource, String tableName,
      List<DatabaseFieldConfig> fieldConfigs) throws SQLException {
    List<FieldType> fieldTypes = new ArrayList<FieldType>();
    for (DatabaseFieldConfig fieldConfig : fieldConfigs) {
      FieldType fieldType = null;
      // walk up the classes until we find the field
      for (Class<?> classWalk = dataClass; classWalk != null; classWalk = classWalk.getSuperclass()) {
        Field field;
        try {
          field = classWalk.getDeclaredField(fieldConfig.getFieldName());
        } catch (NoSuchFieldException e) {
          // we ignore this and just loop hopefully finding it in a upper class
          continue;
        }
        if (field != null) {
          fieldType = new FieldType(connectionSource, tableName, field, fieldConfig, dataClass);
          break;
        }
      }

      if (fieldType == null) {
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
    if (value == null) {
      return null;
    } else if (fieldType == null) {
      return value;
    } else if (fieldType.isForeign() && fieldType.getFieldType() == value.getClass()) {
      FieldType idFieldType = fieldType.getForeignIdField();
      return idFieldType.extractJavaFieldValue(value);
    } else {
      return fieldType.convertJavaFieldToSqlArgValue(value);
    }
  }
View Full Code Here
TOP

Related Classes of com.j256.ormlite.stmt.query.BaseComparisonTest

  • android.database.sqlite.SQLiteStatement
  • com.j256.ormlite.android.AndroidDatabaseConnection
  • com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper
  • com.j256.ormlite.dao.BaseDaoImpl
  • com.j256.ormlite.dao.BaseDaoImplTest
  • com.j256.ormlite.dao.Dao.CreateOrUpdateStatus
  • com.j256.ormlite.dao.DaoManager
  • com.j256.ormlite.dao.DaoManagerTest
  • com.j256.ormlite.dao.DoubleDbOpenTest
  • com.j256.ormlite.dao.RuntimeExceptionDaoTest
    • 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.