Package com.j256.ormlite.stmt

Examples of com.j256.ormlite.stmt.SelectArg

41
42
43
44
45
46
47
48
49
50
51
52
  /**
   * Add a column to be set to a value for UPDATE statements. This will generate something like columnName = 'value'
   * with the value escaped if necessary.
   */
  public StatementBuilder<T, ID> updateColumnValue(String columnName, Object value) throws SQLException {
    FieldType fieldType = verifyColumnName(columnName);
    if (fieldType.isForeignCollection()) {
      throw new SQLException("Can't update foreign colletion field: " + columnName);
    }
    addUpdateColumnToList(columnName, new SetValue(columnName, fieldType, value));
    return this;
  }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    this.dao = dao;
    this.dataClass = tableConfig.getDataClass();
    this.tableName = tableConfig.getTableName();
    this.fieldTypes = tableConfig.getFieldTypes(databaseType);
    // find the id field
    FieldType findIdFieldType = null;
    for (FieldType fieldType : fieldTypes) {
      if (fieldType.isId() || fieldType.isGeneratedId() || fieldType.isGeneratedIdSequence()) {
        if (findIdFieldType != null) {
          throw new SQLException("More than 1 idField configured for class " + dataClass + " ("
              + findIdFieldType + "," + fieldType + ")");
        }
        findIdFieldType = fieldType;
      }
    }
    // if we just have 1 field and it is a generated-id then inserts will be blank which is not allowed.
    if (fieldTypes.length == 1 && findIdFieldType != null && findIdFieldType.isGeneratedId()) {
      throw new SQLException("Must have more than a single field which is a generated-id for class " + dataClass);
    }
    // can be null if there is no id field
    this.idField = findIdFieldType;
    this.constructor = tableConfig.getConstructor();
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
   * {@link #escapeValue(StringBuilder, String)} methods and should have any column names escaped using the
   * {@link #escapeColumnName(String)} or {@link #escapeColumnName(StringBuilder, String)} methods.
   * </p>
   */
  public StatementBuilder<T, ID> updateColumnExpression(String columnName, String expression) throws SQLException {
    FieldType fieldType = verifyColumnName(columnName);
    if (fieldType.isForeignCollection()) {
      throw new SQLException("Can't update foreign colletion field: " + columnName);
    }
    addUpdateColumnToList(columnName, new SetExpression(columnName, fieldType, expression));
    return this;
  }
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
      for (FieldType fieldType : fieldTypes) {
        map.put(fieldType.getDbColumnName(), fieldType);
      }
      fieldNameMap = map;
    }
    FieldType fieldType = fieldNameMap.get(columnName);
    // if column name is not found
    if (fieldType == null) {
      // look to see if someone is using the field-name instead of column-name
      for (FieldType fieldType2 : fieldTypes) {
        if (fieldType2.getFieldName().equals(columnName)) {
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
   * Return the array of field objects pulled from the data object.
   */
  protected Object[] getFieldObjects(Object data) throws SQLException {
    Object[] objects = new Object[argFieldTypes.length];
    for (int i = 0; i < argFieldTypes.length; i++) {
      FieldType fieldType = argFieldTypes[i];
      objects[i] = fieldType.extractJavaFieldToSqlArgValue(data);
      if (objects[i] == null && fieldType.getDefaultValue() != null) {
        objects[i] = fieldType.getDefaultValue();
      }
    }
    return objects;
  }
View Full Code Here
96
97
98
99
100
101
102
103
104
        sb.append(",");
      }
      sb.append("?");
    }
    sb.append(")");
    FieldType idField = tableInfo.getIdField();
    String queryNext = buildQueryNextSequence(databaseType, idField);
    return new MappedCreate<T, ID>(tableInfo, sb.toString(), argFieldTypes, queryNext);
  }
View Full Code Here
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
TOP

Related Classes of com.j256.ormlite.stmt.SelectArg

  • 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.BaseForeignCollection
  • com.j256.ormlite.dao.Dao.CreateOrUpdateStatus
  • com.j256.ormlite.dao.DaoManager
  • com.j256.ormlite.dao.DaoManagerTest
  • com.j256.ormlite.dao.DoubleDbOpenTest
    • 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.