Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
com.landawn.abacus.android.util.SQLiteExecutor Maven / Gradle / Ivy
/*
* Copyright (C) 2015 HaiYang Li
*
* Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
* in compliance with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software distributed under the License
* is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
* or implied. See the License for the specific language governing permissions and limitations under
* the License.
*/
package com.landawn.abacus.android.util;
import static com.landawn.abacus.util.WD.COMMA_SPACE;
import static com.landawn.abacus.util.WD._BRACE_L;
import static com.landawn.abacus.util.WD._BRACE_R;
import static com.landawn.abacus.util.WD._EQUAL;
import static com.landawn.abacus.util.WD._SPACE;
import java.lang.reflect.Method;
import java.lang.reflect.Modifier;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Collection;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.concurrent.ConcurrentHashMap;
import com.landawn.abacus.DataSet;
import com.landawn.abacus.DirtyMarker;
import com.landawn.abacus.condition.Between;
import com.landawn.abacus.condition.Binary;
import com.landawn.abacus.condition.Condition;
import com.landawn.abacus.condition.ConditionFactory.L;
import com.landawn.abacus.condition.Expression;
import com.landawn.abacus.condition.In;
import com.landawn.abacus.condition.Junction;
import com.landawn.abacus.core.RowDataSet;
import com.landawn.abacus.exception.DuplicatedResultException;
import com.landawn.abacus.util.ClassUtil;
import com.landawn.abacus.util.DateUtil;
import com.landawn.abacus.util.N;
import com.landawn.abacus.util.NamedSQL;
import com.landawn.abacus.util.NamingPolicy;
import com.landawn.abacus.util.ObjectPool;
import com.landawn.abacus.util.Objectory;
import com.landawn.abacus.util.SQLBuilder;
import com.landawn.abacus.util.SQLBuilder.PAC;
import com.landawn.abacus.util.SQLBuilder.PLC;
import com.landawn.abacus.util.SQLBuilder.PSC;
import com.landawn.abacus.util.SQLBuilder.SP;
import com.landawn.abacus.util.SQLParser;
import com.landawn.abacus.util.StringUtil;
import com.landawn.abacus.util.StringUtil.Strings;
import com.landawn.abacus.util.WD;
import com.landawn.abacus.util.u.Nullable;
import com.landawn.abacus.util.u.Optional;
import com.landawn.abacus.util.u.OptionalBoolean;
import com.landawn.abacus.util.u.OptionalByte;
import com.landawn.abacus.util.u.OptionalChar;
import com.landawn.abacus.util.u.OptionalDouble;
import com.landawn.abacus.util.u.OptionalFloat;
import com.landawn.abacus.util.u.OptionalInt;
import com.landawn.abacus.util.u.OptionalLong;
import com.landawn.abacus.util.u.OptionalShort;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
/**
* It's a simple wrapper of SQliteDatabase on Android.
*
* @since 0.8
*
* @author Haiyang Li
*
* @see android.database.sqlite.SQLiteDatabase
* @see android.database.sqlite.SQLiteOpenHelper
* @see com.landawn.abacus.util.SQLBuilder
*/
public final class SQLiteExecutor {
public static final NamingPolicy DEFAULT_NAMING_POLICY = NamingPolicy.LOWER_CASE_WITH_UNDERSCORE;
private static final Map, Set> readOnlyPropNamesMap = new ConcurrentHashMap<>();
private static final Map, Set> readOrWriteOnlyPropNamesMap = new ConcurrentHashMap<>();
private static final String ID = "id";
private static final String _ID = "_id";
private final SQLiteDatabase sqliteDB;
private final NamingPolicy columnNamingPolicy;
public SQLiteExecutor(final SQLiteDatabase sqliteDatabase) {
this(sqliteDatabase, DEFAULT_NAMING_POLICY);
}
/**
*
* @param sqliteDatabase
* @param columnNamingPolicy a naming convention to convert the entity/property names in the Entity/Map parameter to table/column names
*/
public SQLiteExecutor(final SQLiteDatabase sqliteDatabase, final NamingPolicy columnNamingPolicy) {
this.sqliteDB = sqliteDatabase;
this.columnNamingPolicy = columnNamingPolicy == null ? DEFAULT_NAMING_POLICY : columnNamingPolicy;
}
/**
* The properties will be excluded by add/addAll/batchAdd and update/updateAll/batchUpdate operations if the input is an entity.
*
* @param targetClass
* @param readOnlyPropNames
*/
public static void registerReadOnlyProps(Class targetClass, Collection readOnlyPropNames) {
N.checkArgument(ClassUtil.isEntity(targetClass), ClassUtil.getCanonicalClassName(targetClass) + " is not an entity class with getter/setter methods");
N.checkArgNotNullOrEmpty(readOnlyPropNames, "'readOnlyPropNames'");
final Set set = new HashSet();
for (String propName : readOnlyPropNames) {
set.add(ClassUtil.getPropNameByMethod(ClassUtil.getPropGetMethod(targetClass, propName)));
}
readOnlyPropNamesMap.put(targetClass, set);
if (readOrWriteOnlyPropNamesMap.containsKey(targetClass)) {
readOrWriteOnlyPropNamesMap.get(targetClass).addAll(set);
} else {
readOrWriteOnlyPropNamesMap.put(targetClass, new HashSet<>(set));
}
}
/**
* The properties will be ignored by update/updateAll/batchUpdate operations if the input is an entity.
*
* @param targetClass
* @param writeOnlyPropNames
*/
public static void registerWriteOnlyProps(Class targetClass, Collection writeOnlyPropNames) {
N.checkArgument(ClassUtil.isEntity(targetClass), ClassUtil.getCanonicalClassName(targetClass) + " is not an entity class with getter/setter methods");
N.checkArgNotNullOrEmpty(writeOnlyPropNames, "'writeOnlyPropNames'");
final Set set = new HashSet();
for (String propName : writeOnlyPropNames) {
set.add(ClassUtil.getPropNameByMethod(ClassUtil.getPropGetMethod(targetClass, propName)));
}
if (readOrWriteOnlyPropNamesMap.containsKey(targetClass)) {
readOrWriteOnlyPropNamesMap.get(targetClass).addAll(set);
} else {
readOrWriteOnlyPropNamesMap.put(targetClass, set);
}
}
public SQLiteDatabase sqliteDB() {
return sqliteDB;
}
static DataSet extractData(Class targetClass, Cursor cursor) {
return extractData(targetClass, cursor, 0, Integer.MAX_VALUE);
}
/**
*
* @param targetClass an entity class with getter/setter methods.
* @param cursor
* @param offset
* @param count
* @return
*/
static DataSet extractData(Class targetClass, Cursor cursor, int offset, int count) {
final int columnCount = cursor.getColumnCount();
final List columnNameList = N.asList(cursor.getColumnNames());
final List> columnList = new ArrayList<>(columnCount);
for (int i = 0; i < columnCount; i++) {
columnList.add(new ArrayList<>(count > 9 ? 9 : count));
}
final Type[] selectColumnTypes = new Type[columnCount];
for (int i = 0; i < columnCount; i++) {
selectColumnTypes[i] = Type.valueOf(ClassUtil.getPropGetMethod(targetClass, columnNameList.get(i)).getReturnType());
}
if (offset > 0) {
cursor.moveToPosition(offset - 1);
}
while (count-- > 0 && cursor.moveToNext()) {
for (int columnIndex = 0; columnIndex < columnCount; columnIndex++) {
columnList.get(columnIndex).add(selectColumnTypes[columnIndex].get(cursor, columnIndex));
}
}
return new RowDataSet(columnNameList, columnList);
}
@SuppressWarnings("rawtypes")
static DataSet extractData(Cursor cursor, Class[] selectColumnTypes) {
return extractData(cursor, selectColumnTypes, 0, Integer.MAX_VALUE);
}
@SuppressWarnings("rawtypes")
static DataSet extractData(Cursor cursor, Class[] selectColumnTypes, int offset, int count) {
return extractData(cursor, Type.arrayOf(selectColumnTypes), offset, count);
}
@SuppressWarnings("rawtypes")
static DataSet extractData(Cursor cursor, Collection selectColumnTypes) {
return extractData(cursor, selectColumnTypes, 0, Integer.MAX_VALUE);
}
@SuppressWarnings("rawtypes")
static DataSet extractData(Cursor cursor, Collection selectColumnTypes, int offset, int count) {
return extractData(cursor, Type.arrayOf(selectColumnTypes.toArray(new Class[selectColumnTypes.size()])), offset, count);
}
@Deprecated
@SuppressWarnings("rawtypes")
static DataSet extractData(Cursor cursor, Type[] selectColumnTypes) {
return extractData(cursor, selectColumnTypes, 0, Integer.MAX_VALUE);
}
@Deprecated
@SuppressWarnings("rawtypes")
static DataSet extractData(Cursor cursor, Type[] selectColumnTypes, int offset, int count) {
final int columnCount = cursor.getColumnCount();
final List columnNameList = N.asList(cursor.getColumnNames());
final List> columnList = new ArrayList<>(columnCount);
for (int i = 0; i < columnCount; i++) {
columnList.add(new ArrayList<>(count > 9 ? 9 : count));
}
if (offset > 0) {
cursor.moveToPosition(offset - 1);
}
while (count-- > 0 && cursor.moveToNext()) {
for (int columnIndex = 0; columnIndex < columnCount; columnIndex++) {
columnList.get(columnIndex).add(selectColumnTypes[columnIndex].get(cursor, columnIndex));
}
}
return new RowDataSet(columnNameList, columnList);
}
/**
* Returns values from all rows associated with the specified targetClass if the specified targetClass is an entity class, otherwise, only returns values from first column.
*
* @param targetClass entity class or specific column type.
* @param cursor
* @return
*/
static List toList(Class targetClass, Cursor cursor) {
return toList(targetClass, cursor, 0, Integer.MAX_VALUE);
}
/**
* Returns values from all rows associated with the specified targetClass if the specified targetClass is an entity class, otherwise, only returns values from first column.
*
* @param targetClass entity class or specific column type.
* @param cursor
* @param offset
* @param count
* @return
*/
static List toList(Class targetClass, Cursor cursor, int offset, int count) {
if (ClassUtil.isEntity(targetClass)) {
final DataSet ds = extractData(targetClass, cursor, offset, count);
if (ds == null || ds.isEmpty()) {
return new ArrayList<>();
} else {
return ds.toList(targetClass);
}
} else {
return toList(targetClass, cursor, 0, offset, count);
}
}
/**
* Returns the values from the specified column.
*
* @param targetClass entity class or specific column type.
* @param cursor
* @param columnIndex
* @return
*/
static List toList(Class targetClass, Cursor cursor, int columnIndex) {
return toList(targetClass, cursor, columnIndex, 0, Integer.MAX_VALUE);
}
/**
* Returns the values from the specified column.
*
* @param targetClass entity class or specific column type.
* @param cursor
* @param columnIndex
* @param offset
* @param count
* @return
*/
static List toList(final Class targetClass, final Cursor cursor, final int columnIndex, int offset, int count) {
if (columnIndex < 0 || columnIndex >= cursor.getColumnCount()) {
throw new IllegalArgumentException("Invalid column index: " + columnIndex);
}
if (offset > 0) {
cursor.moveToPosition(offset - 1);
}
final List resultList = new ArrayList<>();
if (ClassUtil.isEntity(targetClass)) {
final Method propSetMethod = ClassUtil.getPropSetMethod(targetClass, cursor.getColumnName(columnIndex));
final Type selectColumnType = Type.valueOf(propSetMethod.getParameterTypes()[0]);
while (count-- > 0 && cursor.moveToNext()) {
T entity = N.newEntity(targetClass);
ClassUtil.setPropValue(entity, propSetMethod, selectColumnType.get(cursor, columnIndex));
resultList.add(entity);
}
} else {
final Type selectColumnType = Type.valueOf(targetClass);
while (count-- > 0 && cursor.moveToNext()) {
resultList.add(selectColumnType.get(cursor, columnIndex));
}
}
return resultList;
}
/**
*
* @param targetClass entity class with getter/setter methods.
* @param cursor
* @return
*/
static T toEntity(Class targetClass, Cursor cursor) {
return toEntity(targetClass, cursor, 0);
}
/**
*
* @param targetClass entity class with getter/setter methods.
* @param cursor
* @param rowNum
* @return
*/
static T toEntity(Class targetClass, Cursor cursor, int rowNum) {
final List list = toList(targetClass, cursor, rowNum, 1);
return N.isNullOrEmpty(list) ? null : list.get(0);
}
static T toEntity(final Class targetClass, final ContentValues contentValues) {
return toEntity(targetClass, contentValues, NamingPolicy.LOWER_CAMEL_CASE);
}
/**
*
* @param targetClass an Map class or Entity class with getter/setter methods.
* @param contentValues
* @p
* @return
*/
@SuppressWarnings("deprecation")
static T toEntity(final Class targetClass, final ContentValues contentValues, NamingPolicy namingPolicy) {
if (!(ClassUtil.isEntity(targetClass) || targetClass.equals(Map.class))) {
throw new IllegalArgumentException("The target class must be an entity class with getter/setter methods or Map.class. But it is: "
+ ClassUtil.getCanonicalClassName(targetClass));
}
if (targetClass.isAssignableFrom(Map.class)) {
final Map map = (Map) ((Modifier.isAbstract(targetClass.getModifiers())
? new HashMap<>(N.initHashCapacity(contentValues.size())) : N.newInstance(targetClass)));
Object propValue = null;
switch (namingPolicy) {
case LOWER_CAMEL_CASE: {
for (String propName : contentValues.keySet()) {
propValue = contentValues.get(propName);
if (propValue instanceof ContentValues) {
map.put(ClassUtil.formalizePropName(propName), toEntity(targetClass, (ContentValues) propValue, namingPolicy));
} else {
map.put(ClassUtil.formalizePropName(propName), propValue);
}
}
break;
}
case LOWER_CASE_WITH_UNDERSCORE: {
for (String propName : contentValues.keySet()) {
propValue = contentValues.get(propName);
if (propValue instanceof ContentValues) {
map.put(ClassUtil.toLowerCaseWithUnderscore(propName), toEntity(targetClass, (ContentValues) propValue, namingPolicy));
} else {
map.put(ClassUtil.toLowerCaseWithUnderscore(propName), propValue);
}
}
break;
}
case UPPER_CASE_WITH_UNDERSCORE: {
for (String propName : contentValues.keySet()) {
propValue = contentValues.get(propName);
if (propValue instanceof ContentValues) {
map.put(ClassUtil.toUpperCaseWithUnderscore(propName), toEntity(targetClass, (ContentValues) propValue, namingPolicy));
} else {
map.put(ClassUtil.toUpperCaseWithUnderscore(propName), propValue);
}
}
break;
}
default:
throw new IllegalArgumentException("Unsupported NamingPolicy: " + namingPolicy);
}
return (T) map;
} else {
final T entity = N.newInstance(targetClass);
Object propValue = null;
Method propSetMethod = null;
Class parameterType = null;
for (String propName : contentValues.keySet()) {
propSetMethod = ClassUtil.getPropSetMethod(targetClass, propName);
if (propSetMethod == null) {
continue;
}
parameterType = propSetMethod.getParameterTypes()[0];
propValue = contentValues.get(propName);
if (propValue != null && !parameterType.isAssignableFrom(propValue.getClass())) {
if (propValue instanceof ContentValues) {
if (Map.class.isAssignableFrom(parameterType) || ClassUtil.isEntity(parameterType)) {
ClassUtil.setPropValue(entity, propSetMethod, toEntity(parameterType, (ContentValues) propValue, namingPolicy));
} else {
ClassUtil.setPropValue(entity, propSetMethod,
N.valueOf(parameterType, N.stringOf(toEntity(Map.class, (ContentValues) propValue, namingPolicy))));
}
} else {
ClassUtil.setPropValue(entity, propSetMethod, propValue);
}
} else {
ClassUtil.setPropValue(entity, propSetMethod, propValue);
}
}
if (isDirtyMarkerEntity(entity.getClass())) {
((DirtyMarker) entity).markDirty(false);
}
return entity;
}
}
static ContentValues toContentValues(final Object obj, final Collection ignoredPropNames) {
return toContentValues(obj, ignoredPropNames, DEFAULT_NAMING_POLICY);
}
/**
*
* @param obj an instance of Map or Entity.
* @param namingPolicy
* @return
*/
static ContentValues toContentValues(final Object obj, final Collection ignoredPropNames, final NamingPolicy namingPolicy) {
return toContentValues(obj, ignoredPropNames, namingPolicy, false);
}
public Optional get(Class targetClass, long id) throws DuplicatedResultException {
return get(targetClass, id, null);
}
/**
* Find the entity from table specified by simple class name of the targetClass by the specified id
*
* @param targetClass
* @param id
* @param selectPropNames
* @return
* @throws DuplicatedResultException if more than one records are found.
*/
public Optional get(Class targetClass, long id, Collection selectPropNames) throws DuplicatedResultException {
return Optional.ofNullable(gett(targetClass, id, selectPropNames));
}
public T gett(Class targetClass, long id) throws DuplicatedResultException {
return gett(targetClass, id, null);
}
/**
* Find the entity from table specified by simple class name of the targetClass by the specified id
*
* @param targetClass
* @param id
* @param selectPropNames
* @return
* @throws DuplicatedResultException if more than one records are found.
*/
public T gett(Class targetClass, long id, Collection selectPropNames) throws DuplicatedResultException {
final Condition whereClause = L.eq(ID, id);
final List entities = list(targetClass, selectPropNames, whereClause, null, 0, 2);
if (entities.size() > 1) {
throw new DuplicatedResultException("More than one records found by condition: " + whereClause.toString());
}
return (entities.size() > 0) ? entities.get(0) : null;
}
@SuppressWarnings("deprecation")
private static ContentValues toContentValues(final Object obj, final Collection ignoredPropNames, final NamingPolicy namingPolicy,
final boolean isForUpdate) {
final ContentValues result = new ContentValues();
final boolean notNullOrEmptyIgnorePropNames = N.notNullOrEmpty(ignoredPropNames);
@SuppressWarnings("rawtypes")
Type type = null;
if (Map.class.isAssignableFrom(obj.getClass())) {
Map props = (Map) obj;
switch (namingPolicy) {
case LOWER_CAMEL_CASE: {
String propName = null;
for (Map.Entry entry : props.entrySet()) {
propName = ClassUtil.formalizePropName(entry.getKey());
if (notNullOrEmptyIgnorePropNames && (ignoredPropNames.contains(entry.getKey()) || ignoredPropNames.contains(propName))) {
continue;
}
if (entry.getValue() == null) {
result.putNull(propName);
} else {
type = Type.valueOf(entry.getValue().getClass());
type.set(result, propName, entry.getValue());
}
}
break;
}
case LOWER_CASE_WITH_UNDERSCORE: {
String propName = null;
for (Map.Entry entry : props.entrySet()) {
propName = ClassUtil.toLowerCaseWithUnderscore(entry.getKey());
if (notNullOrEmptyIgnorePropNames && (ignoredPropNames.contains(entry.getKey()) || ignoredPropNames.contains(propName))) {
continue;
}
if (entry.getValue() == null) {
result.putNull(propName);
} else {
type = Type.valueOf(entry.getValue().getClass());
type.set(result, propName, entry.getValue());
}
}
break;
}
case UPPER_CASE_WITH_UNDERSCORE: {
String propName = null;
for (Map.Entry entry : props.entrySet()) {
propName = ClassUtil.toUpperCaseWithUnderscore(entry.getKey());
if (notNullOrEmptyIgnorePropNames && (ignoredPropNames.contains(entry.getKey()) || ignoredPropNames.contains(propName))) {
continue;
}
if (entry.getValue() == null) {
result.putNull(propName);
} else {
type = Type.valueOf(entry.getValue().getClass());
type.set(result, propName, entry.getValue());
}
}
break;
}
default:
throw new IllegalArgumentException("Unsupported NamingPolicy: " + namingPolicy);
}
} else if (ClassUtil.isEntity(obj.getClass())) {
if (obj instanceof DirtyMarker) {
final Class srCls = obj.getClass();
final Set updatePropNames = isForUpdate ? ((DirtyMarker) obj).dirtyPropNames() : ((DirtyMarker) obj).signedPropNames();
if (updatePropNames.size() == 0) {
// logger.warn("No property is signed/updated in the specified source entity: " + N.toString(entity));
} else {
Method propGetMethod = null;
Object propValue = null;
switch (namingPolicy) {
case LOWER_CAMEL_CASE: {
for (String propName : updatePropNames) {
propGetMethod = ClassUtil.getPropGetMethod(srCls, propName);
propName = ClassUtil.getPropNameByMethod(propGetMethod);
if (notNullOrEmptyIgnorePropNames && ignoredPropNames.contains(propName)) {
continue;
}
propValue = ClassUtil.getPropValue(obj, propGetMethod);
if (propValue == null) {
result.putNull(propName);
} else {
type = Type.valueOf(propValue.getClass());
type.set(result, propName, propValue);
}
}
break;
}
case LOWER_CASE_WITH_UNDERSCORE: {
for (String propName : updatePropNames) {
propGetMethod = ClassUtil.getPropGetMethod(srCls, propName);
propName = ClassUtil.getPropNameByMethod(propGetMethod);
if (notNullOrEmptyIgnorePropNames && ignoredPropNames.contains(propName)) {
continue;
}
propValue = ClassUtil.getPropValue(obj, propGetMethod);
if (propValue == null) {
result.putNull(ClassUtil.toLowerCaseWithUnderscore(propName));
} else {
type = Type.valueOf(propValue.getClass());
type.set(result, ClassUtil.toLowerCaseWithUnderscore(propName), propValue);
}
}
break;
}
case UPPER_CASE_WITH_UNDERSCORE: {
for (String propName : updatePropNames) {
propGetMethod = ClassUtil.getPropGetMethod(srCls, propName);
propName = ClassUtil.getPropNameByMethod(propGetMethod);
if (notNullOrEmptyIgnorePropNames && ignoredPropNames.contains(propName)) {
continue;
}
propValue = ClassUtil.getPropValue(obj, propGetMethod);
if (propValue == null) {
result.putNull(ClassUtil.toUpperCaseWithUnderscore(propName));
} else {
type = Type.valueOf(propValue.getClass());
type.set(result, ClassUtil.toUpperCaseWithUnderscore(propName), propValue);
}
}
break;
}
default:
throw new IllegalArgumentException("Unsupported NamingPolicy: " + namingPolicy);
}
}
} else {
final Map getterMethodList = ClassUtil.getPropGetMethodList(obj.getClass());
String propName = null;
Object propValue = null;
switch (namingPolicy) {
case LOWER_CAMEL_CASE: {
for (Map.Entry entry : getterMethodList.entrySet()) {
propName = entry.getKey();
if (notNullOrEmptyIgnorePropNames && ignoredPropNames.contains(propName)) {
continue;
}
propValue = ClassUtil.getPropValue(obj, entry.getValue());
if (propValue == null) {
continue;
}
type = Type.valueOf(propValue.getClass());
type.set(result, propName, propValue);
}
break;
}
case LOWER_CASE_WITH_UNDERSCORE: {
for (Map.Entry entry : getterMethodList.entrySet()) {
propName = entry.getKey();
if (notNullOrEmptyIgnorePropNames && ignoredPropNames.contains(propName)) {
continue;
}
propValue = ClassUtil.getPropValue(obj, entry.getValue());
if (propValue == null) {
continue;
}
type = Type.valueOf(propValue.getClass());
type.set(result, ClassUtil.toLowerCaseWithUnderscore(propName), propValue);
}
break;
}
case UPPER_CASE_WITH_UNDERSCORE: {
for (Map.Entry entry : getterMethodList.entrySet()) {
propName = entry.getKey();
if (notNullOrEmptyIgnorePropNames && ignoredPropNames.contains(propName)) {
continue;
}
propValue = ClassUtil.getPropValue(obj, entry.getValue());
if (propValue == null) {
continue;
}
type = Type.valueOf(propValue.getClass());
type.set(result, ClassUtil.toUpperCaseWithUnderscore(propName), propValue);
}
break;
}
default:
throw new IllegalArgumentException("Unsupported NamingPolicy: " + namingPolicy);
}
}
} else {
throw new IllegalArgumentException("Only entity class with getter/setter methods or Map are supported. "
+ ClassUtil.getCanonicalClassName(obj.getClass()) + " is not supported");
}
return result;
}
/**
* Insert one record into database.
* To exclude the some properties or default value, invoke {@code com.landawn.abacus.util.N#entity2Map(Object, boolean, Collection, NamingPolicy)}
*
* The target table is identified by the simple class name of the specified entity.
*
* @param entity with getter/setter methods
* @return
*
* @see com.landawn.abacus.util.Maps#entity2Map(Object, boolean, Collection, NamingPolicy)
*/
public long insert(Object entity) {
if (!ClassUtil.isEntity(entity.getClass())) {
throw new IllegalArgumentException("The specified parameter must be an entity with getter/setter methods");
}
return insert(getTableNameByEntity(entity), entity);
}
/**
* Insert one record into database.
* To exclude the some properties or default value, invoke {@code com.landawn.abacus.util.N#entity2Map(Object, boolean, Collection, NamingPolicy)}
*
* The target table is identified by the simple class name of the specified entity.
*
* @param entity with getter/setter methods
* @param conflictAlgorithm
* @return
*
* @see com.landawn.abacus.util.Maps#entity2Map(Object, boolean, Collection, NamingPolicy)
*/
public long insert(Object entity, int conflictAlgorithm) {
if (!ClassUtil.isEntity(entity.getClass())) {
throw new IllegalArgumentException("The specified parameter must be an entity with getter/setter methods");
}
return insert(getTableNameByEntity(entity), entity, conflictAlgorithm);
}
/**
* Insert one record into database.
* To exclude the some properties or default value, invoke {@code com.landawn.abacus.util.N#entity2Map(Object, boolean, Collection, NamingPolicy)}
*
* @param table
* @param record can be Map or entity with getter/setter methods
* @return
*
* @see com.landawn.abacus.util.Maps#entity2Map(Object, boolean, Collection, NamingPolicy)
*/
public long insert(String table, Object record) {
table = formatName(table);
return insert(table, record, SQLiteDatabase.CONFLICT_NONE);
}
/**
* Insert one record into database.
* To exclude the some properties or default value, invoke {@code com.landawn.abacus.util.N#entity2Map(Object, boolean, Collection, NamingPolicy)}
*
* @param table
* @param record can be Map or entity with getter/setter methods
* @param conflictAlgorithm
* @return
*
* @see com.landawn.abacus.util.Maps#entity2Map(Object, boolean, Collection, NamingPolicy)
*/
public long insert(String table, Object record, int conflictAlgorithm) {
table = formatName(table);
final ContentValues contentValues = record instanceof ContentValues ? (ContentValues) record
: toContentValues(record, readOnlyPropNamesMap.get(record.getClass()), columnNamingPolicy, false);
removeIdDefaultValue(contentValues);
return sqliteDB.insertWithOnConflict(table, null, contentValues, conflictAlgorithm);
}
private void removeIdDefaultValue(final ContentValues initialValues) {
Object value = initialValues.get(ID);
if (value != null && (value.equals(0) || value.equals(0L))) {
initialValues.remove(ID);
} else {
value = initialValues.get(_ID);
if (value != null && (value.equals(0) || value.equals(0L))) {
initialValues.remove(_ID);
}
}
}
/**
* Insert multiple records into data store.
*
* @param entities
* @param withTransaction
* @return
*
* @since 0.8.10
*/
@Deprecated
long[] insert(T[] entities, boolean withTransaction) {
return insert(this.getTableNameByEntity(entities[0]), entities, withTransaction);
}
/**
* Insert multiple records into data store.
*
* @param table
* @param records
* @param withTransaction
* @return
*/
@Deprecated
long[] insert(String table, T[] records, boolean withTransaction) {
if (N.isNullOrEmpty(records)) {
return N.EMPTY_LONG_ARRAY;
}
final long[] ret = new long[records.length];
table = formatName(table);
if (withTransaction) {
beginTransaction();
}
try {
for (int i = 0, len = records.length; i < len; i++) {
ret[i] = insert(table, records[i]);
}
if (withTransaction) {
sqliteDB.setTransactionSuccessful();
}
} finally {
if (withTransaction) {
endTransaction();
}
}
return ret;
}
// /**
// * Insert multiple records into data store.
// *
// * @param records
// * @param withTransaction
// * @return
// *
// * @since 0.8.10
// * @deprecated replaced with {@code insertAll}.
// */
// @Deprecated
// public List insert(Collection records, boolean withTransaction) {
// return insert(this.getTableNameByEntity(records.iterator().next()), records, withTransaction);
// }
//
// /**
// * Insert multiple records into data store.
// *
// * @param table
// * @param records
// * @param withTransaction
// * @return
// * @deprecated replaced with {@code insertAll}.
// */
// @Deprecated
// public List insert(String table, Collection records, boolean withTransaction) {
// if (N.isNullOrEmpty(records)) {
// return new ArrayList<>();
// }
//
// final List ret = new ArrayList<>(records.size());
//
// table = formatName(table);
//
// if (withTransaction) {
// beginTransaction();
// }
//
// try {
// for (Object e : records) {
// ret.add(insert(table, e));
// }
//
// if (withTransaction) {
// sqliteDB.setTransactionSuccessful();
// }
// } finally {
// if (withTransaction) {
// endTransaction();
// }
// }
//
// return ret;
// }
public List insertAll(Collection records, boolean withTransaction) {
return insertAll(this.getTableNameByEntity(records.iterator().next()), records, withTransaction);
}
public List insertAll(String table, Collection records, boolean withTransaction) {
if (N.isNullOrEmpty(records)) {
return new ArrayList<>();
}
final List ret = new ArrayList<>(records.size());
table = formatName(table);
if (withTransaction) {
beginTransaction();
}
try {
for (Object e : records) {
ret.add(insert(table, e));
}
if (withTransaction) {
sqliteDB.setTransactionSuccessful();
}
} finally {
if (withTransaction) {
endTransaction();
}
}
return ret;
}
// // mess up
// @Deprecated
// int update(EntityId entityId, Map props) {
// return update(entityId.entityName(), props, EntityManagerUtil.entityId2Condition(entityId));
// }
/**
* Update the records in data store with the properties which have been updated/set in the specified entity by id property in the entity.
* if the entity implements DirtyMarker interface, just update the dirty properties.
* To exclude the some properties or default value, invoke {@code com.landawn.abacus.util.N#entity2Map(Object, boolean, Collection, NamingPolicy)}
*
* @param entity with getter/setter methods
* @return
*/
public int update(Object entity) {
if (!ClassUtil.isEntity(entity.getClass())) {
throw new IllegalArgumentException("The specified parameter must be an entity with getter/setter methods");
}
Number id = ClassUtil.getPropValue(entity, ID);
if (id.longValue() == 0) {
throw new IllegalArgumentException("Please specify value for the id property");
}
return update(getTableNameByEntity(entity), entity, L.eq(ID, id));
}
/**
* Update the records in data store with the properties which have been updated/set in the specified entity by the specified condition.
* if the entity implements DirtyMarker interface, just update the dirty properties.
* To exclude the some properties or default value, invoke {@code com.landawn.abacus.util.N#entity2Map(Object, boolean, Collection, NamingPolicy)}
*
* The target table is identified by the simple class name of the specified entity.
*
* @param entity with getter/setter methods
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @return
*
* @see com.landawn.abacus.util.Maps#entity2Map(Object, boolean, Collection, NamingPolicy)
*/
public int update(Object entity, Condition whereClause) {
if (!ClassUtil.isEntity(entity.getClass())) {
throw new IllegalArgumentException("The specified parameter must be an entity with getter/setter methods");
}
return update(getTableNameByEntity(entity), entity, whereClause);
}
private String getTableNameByEntity(Object entity) {
return getTableNameByEntity(entity.getClass());
}
private String getTableNameByEntity(Class entityClass) {
return ClassUtil.getSimpleClassName(entityClass);
}
/**
* Update the records in data store with the properties which have been updated/set in the specified entity by the specified condition.
* if the entity implements DirtyMarker interface, just update the dirty properties.
* To exclude the some properties or default value, invoke {@code com.landawn.abacus.util.N#entity2Map(Object, boolean, Collection, NamingPolicy)}
*
* @param table
* @param record can be Map or entity with getter/setter methods
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @return
*
* @see com.landawn.abacus.util.Maps#entity2Map(Object, boolean, Collection, NamingPolicy)
*/
public int update(String table, Object record, Condition whereClause) {
table = formatName(table);
final ContentValues contentValues = record instanceof ContentValues ? (ContentValues) record
: toContentValues(record, readOrWriteOnlyPropNamesMap.get(record.getClass()), columnNamingPolicy, true);
removeIdDefaultValue(contentValues);
if (whereClause == null) {
return sqliteDB.update(table, contentValues, null, N.EMPTY_STRING_ARRAY);
} else {
final Command cmd = interpretCondition(whereClause);
return sqliteDB.update(table, contentValues, cmd.getSql(), cmd.getArgs());
}
}
// // mess up
// @Deprecated
// int delete(EntityId entityId) {
// return delete(entityId.entityName(), EntityManagerUtil.entityId2Condition(entityId));
// }
/**
* Delete the entity by id value in the entity.
*
* @param entity
* @return
*/
public int delete(Object entity) {
if (!ClassUtil.isEntity(entity.getClass())) {
throw new IllegalArgumentException("The specified parameter must be an entity with getter/setter methods");
}
Number id = ClassUtil.getPropValue(entity, ID);
if (id.longValue() == 0) {
throw new IllegalArgumentException("Please specify value for the id property");
}
return delete(getTableNameByEntity(entity), L.eq(ID, id));
}
/**
*
* @param table
* @param id
* @return
*/
public int delete(String table, long id) {
return delete(table, L.eq(ID, id));
}
/**
*
* @param entityClass
* @param id
* @return
*
* @since 0.8.10
*/
public int delete(Class entityClass, long id) {
return delete(entityClass, L.eq(ID, id));
}
/**
*
* @param table
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @return
*/
public int delete(String table, Condition whereClause) {
if (whereClause == null) {
return delete(table, null, N.EMPTY_STRING_ARRAY);
} else {
final Command cmd = interpretCondition(whereClause);
return delete(table, cmd.getSql(), cmd.getArgs());
}
}
/**
*
* @param entityClass
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @return
*
* @since 0.8.10
*/
public int delete(Class entityClass, Condition whereClause) {
return delete(getTableNameByEntity(entityClass), whereClause);
}
@Deprecated
int delete(String table, String whereClause, String... whereArgs) {
table = formatName(table);
return sqliteDB.delete(table, parseStringCondition(whereClause), whereArgs);
}
/**
* Execute a single SQL statement that is NOT a SELECT or any other SQL statement that returns data.
*
* @param sql
*/
@Deprecated
void execute(String sql) {
sqliteDB.execSQL(sql);
}
/**
* Execute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.
*
* @param sql
* @param parameters A Object Array/List, and Map/Entity with getter/setter methods for parameterized sql with named parameters
*/
@Deprecated
void execute(String sql, Object... parameters) {
if (N.isNullOrEmpty(parameters)) {
sqliteDB.execSQL(sql);
} else {
final NamedSQL namedSQL = parseSQL(sql);
final Object[] args = prepareArguments(namedSQL, parameters);
sqliteDB.execSQL(namedSQL.getPureSQL(), args);
}
}
// // mess up
// @Deprecated
// boolean exists(EntityId entityId) {
// final Pair2 pair = generateQuerySQL(entityId, NE._1_list);
//
// return exists(pair.sql, pair.parameters);
// }
//
// private Pair2 generateQuerySQL(EntityId entityId, Collection selectPropNames) {
// final Condition cond = EntityManagerUtil.entityId2Condition(entityId);
//
// switch (columnNamingPolicy) {
// case LOWER_CASE_WITH_UNDERSCORE: {
// return NE.select(selectPropNames).from(entityId.entityName()).where(cond).limit(2).pair();
// }
//
// case UPPER_CASE_WITH_UNDERSCORE: {
// return NE2.select(selectPropNames).from(entityId.entityName()).where(cond).limit(2).pair();
// }
//
// case CAMEL_CASE: {
// return NE3.select(selectPropNames).from(entityId.entityName()).where(cond).limit(2).pair();
// }
//
// default:
// throw new IllegalArgumentException("Unsupported naming policy");
// }
// }
public boolean exists(Class entityClass, Condition whereClause) {
return exists(getTableNameByEntity(entityClass), whereClause);
}
public boolean exists(String tableName, Condition whereClause) {
final SP sp = select(tableName, SQLBuilder._1, whereClause);
final Object[] parameters = N.isNullOrEmpty(sp.parameters) ? N.EMPTY_OBJECT_ARRAY : sp.parameters.toArray(new Object[sp.parameters.size()]);
return exists(sp.sql, parameters);
}
/**
* Remember to add {@code limit} condition if big result will be returned by the query.
*
* @param sql
* @param parameters A Object Array/List, and Map/Entity with getter/setter methods for parameterized sql with named parameters
* @return
*/
@SafeVarargs
public final boolean exists(String sql, Object... parameters) {
final Cursor cursor = rawQuery(sql, parameters);
try {
return cursor.moveToNext();
} finally {
cursor.close();
}
}
public int count(Class entityClass, Condition whereClause) {
return count(getTableNameByEntity(entityClass), whereClause);
}
public int count(String tableName, Condition whereClause) {
final SP sp = select(tableName, SQLBuilder.COUNT_ALL, whereClause);
final Object[] parameters = N.isNullOrEmpty(sp.parameters) ? N.EMPTY_OBJECT_ARRAY : sp.parameters.toArray(new Object[sp.parameters.size()]);
return count(sp.sql, parameters);
}
/**
*
* @param sql
* @param parameters
* @return
* @deprecated may be misused and it's inefficient.
*/
@Deprecated
@SafeVarargs
public final int count(String sql, Object... parameters) {
return queryForSingleResult(int.class, sql, parameters).orElse(0);
}
private SP select(String tableName, String selectColumnName, Condition whereClause) {
switch (columnNamingPolicy) {
case LOWER_CASE_WITH_UNDERSCORE:
return PSC.select(selectColumnName).from(tableName).where(whereClause).pair();
case UPPER_CASE_WITH_UNDERSCORE:
return PAC.select(selectColumnName).from(tableName).where(whereClause).pair();
case LOWER_CAMEL_CASE:
return PLC.select(selectColumnName).from(tableName).where(whereClause).pair();
default:
return PSC.select(selectColumnName).from(tableName).where(whereClause).pair();
}
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalBoolean queryForBoolean(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Boolean.class, sql, parameters);
return result.isPresent() ? OptionalBoolean.of(result.orElseIfNull(false)) : OptionalBoolean.empty();
}
/**
*
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalChar queryForChar(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Character.class, sql, parameters);
return result.isPresent() ? OptionalChar.of(result.orElseIfNull((char) 0)) : OptionalChar.empty();
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalByte queryForByte(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Byte.class, sql, parameters);
return result.isPresent() ? OptionalByte.of(result.orElseIfNull((byte) 0)) : OptionalByte.empty();
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalShort queryForShort(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Short.class, sql, parameters);
return result.isPresent() ? OptionalShort.of(result.orElseIfNull((short) 0)) : OptionalShort.empty();
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalInt queryForInt(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Integer.class, sql, parameters);
return result.isPresent() ? OptionalInt.of(result.orElseIfNull(0)) : OptionalInt.empty();
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalLong queryForLong(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Long.class, sql, parameters);
return result.isPresent() ? OptionalLong.of(result.orElseIfNull(0L)) : OptionalLong.empty();
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalFloat queryForFloat(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Float.class, sql, parameters);
return result.isPresent() ? OptionalFloat.of(result.orElseIfNull(0f)) : OptionalFloat.empty();
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final OptionalDouble queryForDouble(final String sql, final Object... parameters) {
final Nullable result = queryForSingleResult(Double.class, sql, parameters);
return result.isPresent() ? OptionalDouble.of(result.orElseIfNull(0d)) : OptionalDouble.empty();
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final Nullable queryForString(final String sql, final Object... parameters) {
return queryForSingleResult(String.class, sql, parameters);
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final Nullable queryForDate(final String sql, final Object... parameters) {
return queryForSingleResult(java.sql.Date.class, sql, parameters);
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final Nullable queryForTime(final String sql, final Object... parameters) {
return queryForSingleResult(java.sql.Time.class, sql, parameters);
}
/**
* @see SQLiteExecutor#queryForSingleResult(Class, String, Object...).
*/
@SafeVarargs
public final Nullable queryForTimestamp(final String sql, final Object... parameters) {
return queryForSingleResult(java.sql.Timestamp.class, sql, parameters);
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
*
* Special note for type conversion for {@code boolean} or {@code Boolean} type: {@code true} is returned if the
* {@code String} value of the target column is {@code "true"}, case insensitive. or it's an integer with value > 0.
* Otherwise, {@code false} is returned.
*
* Remember to add {@code limit} condition if big result will be returned by the query.
*
* @param targetClass set result type to avoid the NullPointerException if result is null and T is primitive type
* "int, long. short ... char, boolean..".
* @param sql set offset and limit in sql with format:
* SELECT * FROM account where id = ? LIMIT offsetValue , limitValue SELECT * FROM account where id = ? LIMIT limitValue Nullable queryForSingleResult(final Class targetClass, final String sql, Object... parameters) {
N.checkArgNotNull(targetClass, "targetClass");
final Cursor cursor = rawQuery(sql, parameters);
DataSet ds = null;
try {
ds = extractData(cursor, Type.arrayOf(targetClass), 0, 1);
} finally {
cursor.close();
}
return N.isNullOrEmpty(ds) ? Nullable. empty() : Nullable.of(N.convert(ds.get(0, 0), targetClass));
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
*
* @param targetClass
* @param sql
* @param parameters
* @return
*/
@SafeVarargs
public final Optional queryForSingleNonNull(final Class targetClass, final String sql, Object... parameters) {
N.checkArgNotNull(targetClass, "targetClass");
final Cursor cursor = rawQuery(sql, parameters);
DataSet ds = null;
try {
ds = extractData(cursor, Type.arrayOf(targetClass), 0, 1);
} finally {
cursor.close();
}
return N.isNullOrEmpty(ds) ? Optional. empty() : Optional.of(N.convert(ds.get(0, 0), targetClass));
}
/**
* Returns a {@code Nullable} describing the value in the first row/column if it exists, otherwise return an empty {@code Nullable}.
* And throws {@code DuplicatedResultException} if more than one record found.
*
* Special note for type conversion for {@code boolean} or {@code Boolean} type: {@code true} is returned if the
* {@code String} value of the target column is {@code "true"}, case insensitive. or it's an integer with value > 0.
* Otherwise, {@code false} is returned.
*
* Remember to add {@code limit} condition if big result will be returned by the query.
*
* @param targetClass set result type to avoid the NullPointerException if result is null and T is primitive type
* "int, long. short ... char, boolean..".
* @param sql set offset and limit in sql with format:
* SELECT * FROM account where id = ? LIMIT offsetValue , limitValue SELECT * FROM account where id = ? LIMIT limitValue Nullable queryForUniqueResult(final Class targetClass, final String sql, Object... parameters) throws DuplicatedResultException {
N.checkArgNotNull(targetClass, "targetClass");
final Cursor cursor = rawQuery(sql, parameters);
DataSet ds = null;
try {
ds = extractData(cursor, Type.arrayOf(targetClass), 0, 2);
} finally {
cursor.close();
}
if (N.isNullOrEmpty(ds)) {
return Nullable.empty();
} else if (ds.size() == 1) {
return Nullable.of(N.convert(ds.get(0, 0), targetClass));
} else {
throw new DuplicatedResultException("At least two results found: " + Strings.concat(ds.get(0, 0), ", ", ds.get(1, 0)));
}
}
/**
* Returns an {@code Optional} describing the value in the first row/column if it exists, otherwise return an empty {@code Optional}.
* And throws {@code DuplicatedResultException} if more than one record found.
*
* @param targetClass
* @param sql
* @param parameters
* @return
* @throws DuplicatedResultException if more than one record found.
*/
@SafeVarargs
public final Optional queryForUniqueNonNull(final Class targetClass, final String sql, Object... parameters) throws DuplicatedResultException {
N.checkArgNotNull(targetClass, "targetClass");
final Cursor cursor = rawQuery(sql, parameters);
DataSet ds = null;
try {
ds = extractData(cursor, Type.arrayOf(targetClass), 0, 2);
} finally {
cursor.close();
}
if (N.isNullOrEmpty(ds)) {
return Optional.empty();
} else if (ds.size() == 1) {
return Optional.of(N.convert(ds.get(0, 0), targetClass));
} else {
throw new DuplicatedResultException("At least two results found: " + Strings.concat(ds.get(0, 0), ", ", ds.get(1, 0)));
}
}
public Optional findFirst(final Class targetClass, Collection selectColumnNames, Condition whereClause) {
return findFirst(targetClass, selectColumnNames, whereClause, null);
}
/**
* Just fetch the result in the 1st row. {@code null} is returned if no result is found. This method will try to
* convert the column values to the type of mapping entity property if the mapping entity property is not assignable
* from column value.
*
* @param targetClass an entity class with getter/setter methods.
* @param selectColumnNames
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @param orderby How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
* @return
*/
public Optional findFirst(final Class targetClass, Collection selectColumnNames, Condition whereClause, String orderBy) {
final List resultList = list(targetClass, selectColumnNames, whereClause, orderBy, 0, 1);
return N.isNullOrEmpty(resultList) ? (Optional) Optional.empty() : Optional.of(resultList.get(0));
}
/**
* Just fetch the result in the 1st row. {@code null} is returned if no result is found. This method will try to
* convert the column values to the type of mapping entity property if the mapping entity property is not assignable
* from the column value.
*
* Remember to add {@code limit} condition if big result will be returned by the query.
*
* @param targetClass an entity class with getter/setter methods.
* @param sql set offset and limit in sql with format:
* SELECT * FROM account where id = ? LIMIT offsetValue , limitValue SELECT * FROM account where id = ? LIMIT limitValue Optional findFirst(final Class targetClass, final String sql, Object... parameters) {
final DataSet rs = query(targetClass, sql, 0, 1, parameters);
return N.isNullOrEmpty(rs) ? (Optional) Optional.empty() : Optional.of(rs.getRow(targetClass, 0));
}
public List list(final Class targetClass, Collection selectColumnNames, Condition whereClause) {
return list(targetClass, selectColumnNames, whereClause, null);
}
public List list(final Class targetClass, Collection selectColumnNames, Condition whereClause, String orderBy) {
return list(targetClass, selectColumnNames, whereClause, orderBy, 0, Integer.MAX_VALUE);
}
public List list(final Class targetClass, Collection selectColumnNames, Condition whereClause, String orderBy, int offset, int count) {
return list(targetClass, selectColumnNames, whereClause, null, null, orderBy, offset, count);
}
public List list(final Class targetClass, Collection selectColumnNames, Condition whereClause, String groupBy, String having,
String orderBy) {
return list(targetClass, selectColumnNames, whereClause, groupBy, having, orderBy, 0, Integer.MAX_VALUE);
}
/**
* Find the records from database with the specified whereClause, groupby, having, orderBy,
* and convert result to a list of the specified targetClass.
*
* @param targetClass an entity class with getter/setter methods.
* @param selectColumnNames
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @param groupBy A filter declaring how to group rows, formatted as an SQL GROUP BY clause (excluding the GROUP BY itself). Passing null will cause the rows to not be grouped.
* @param having A filter declare which row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all row groups to be included, and is required when row grouping is not being used.
* @param orderby How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
* @param offset
* @param count
* @return
*/
public List list(final Class targetClass, Collection selectColumnNames, Condition whereClause, String groupBy, String having,
String orderBy, int offset, int count) {
final DataSet rs = query(targetClass, selectColumnNames, whereClause, groupBy, having, orderBy, offset, count);
if (N.isNullOrEmpty(rs)) {
return new ArrayList<>();
} else {
return rs.toList(targetClass);
}
}
/**
* Find the records from database with the specified sql, parameters,
* and convert result to a list of the specified targetClass.
*
* @param targetClass an entity class with getter/setter methods.
* @param sql set offset and limit in sql with format:
* SELECT * FROM account where id = ? LIMIT offsetValue , limitValue SELECT * FROM account where id = ? LIMIT limitValue List list(final Class targetClass, final String sql, Object... parameters) {
final DataSet rs = query(targetClass, sql, 0, Integer.MAX_VALUE, parameters);
if (N.isNullOrEmpty(rs)) {
return new ArrayList<>();
} else {
return rs.toList(targetClass);
}
}
// DataSet query(final Class targetClass, String... selectColumnNames) {
// return query(targetClass, N.asList(selectColumnNames));
// }
//
// DataSet query(final Class targetClass, Collection selectColumnNames) {
// return query(targetClass, selectColumnNames, null);
// }
public DataSet query(final Class targetClass, Collection selectColumnNames, Condition whereClause) {
return query(targetClass, selectColumnNames, whereClause, null);
}
public DataSet query(final Class targetClass, Collection selectColumnNames, Condition whereClause, String orderBy) {
return query(targetClass, selectColumnNames, whereClause, orderBy, 0, Integer.MAX_VALUE);
}
public DataSet query(final Class targetClass, Collection selectColumnNames, Condition whereClause, String orderBy, int offset, int count) {
return query(targetClass, selectColumnNames, whereClause, null, null, orderBy, offset, count);
}
public DataSet query(final Class targetClass, Collection selectColumnNames, Condition whereClause, String groupBy, String having,
String orderBy) {
return query(targetClass, selectColumnNames, whereClause, groupBy, having, orderBy, 0, Integer.MAX_VALUE);
}
/**
* Find the records from database with the specified whereClause, groupby, having, orderBy and return the result set.
*
* @param targetClass an entity class with getter/setter methods.
* @param selectColumnNames
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @param groupBy A filter declaring how to group rows, formatted as an SQL GROUP BY clause (excluding the GROUP BY itself). Passing null will cause the rows to not be grouped.
* @param having A filter declare which row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all row groups to be included, and is required when row grouping is not being used.
* @param orderby How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
* @param offset
* @param count
* @return
*/
public DataSet query(final Class targetClass, Collection selectColumnNames, Condition whereClause, String groupBy, String having, String orderBy,
int offset, int count) {
if (N.isNullOrEmpty(selectColumnNames)) {
selectColumnNames = ClassUtil.getPropGetMethodList(targetClass).keySet();
}
final String[] columns = selectColumnNames.toArray(new String[selectColumnNames.size()]);
final Type[] selectColumnTypes = new Type[columns.length];
for (int i = 0, len = columns.length; i < len; i++) {
selectColumnTypes[i] = Type.valueOf(ClassUtil.getPropGetMethod(targetClass, columns[i]).getReturnType());
}
return query(ClassUtil.getSimpleClassName(targetClass), columns, selectColumnTypes, whereClause, groupBy, having, orderBy, offset, count);
}
/**
*
* @param table
* @param selectColumnNameTypeMap
* @param whereClause
* @return
*
* @since 0.8.10
*/
@SuppressWarnings("rawtypes")
public DataSet query(String table, Map selectColumnNameTypeMap, Condition whereClause) {
return query(table, selectColumnNameTypeMap, whereClause, null);
}
/**
*
* @param table
* @param selectColumnNameTypeMap
* @param whereClause
* @param orderBy
* @return
*
* @since 0.8.10
*/
@SuppressWarnings("rawtypes")
public DataSet query(String table, Map selectColumnNameTypeMap, Condition whereClause, String orderBy) {
return query(table, selectColumnNameTypeMap, whereClause, orderBy, 0, Integer.MAX_VALUE);
}
/**
*
* @param table
* @param selectColumnNameTypeMap
* @param whereClause
* @param orderBy
* @param offset
* @param count
* @return
*
* @since 0.8.10
*/
@SuppressWarnings("rawtypes")
public DataSet query(String table, Map selectColumnNameTypeMap, Condition whereClause, String orderBy, int offset, int count) {
return query(table, selectColumnNameTypeMap, whereClause, null, null, orderBy, offset, count);
}
/**
*
* @param table
* @param selectColumnNameTypeMap
* @param whereClause
* @param groupBy
* @param having
* @param orderBy
* @return
*
* @since 0.8.10
*/
@SuppressWarnings("rawtypes")
public DataSet query(String table, Map selectColumnNameTypeMap, Condition whereClause, String groupBy, String having, String orderBy) {
return query(table, selectColumnNameTypeMap, whereClause, groupBy, having, orderBy, 0, Integer.MAX_VALUE);
}
/**
* Find the records from database with the specified whereClause, groupby, having, orderBy and return the result set.
*
* @param table
* @param selectColumnNameTypeMap
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @param groupBy A filter declaring how to group rows, formatted as an SQL GROUP BY clause (excluding the GROUP BY itself). Passing null will cause the rows to not be grouped.
* @param having A filter declare which row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all row groups to be included, and is required when row grouping is not being used.
* @param orderby How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
* @param offset
* @param count
* @return
*
* @since 0.8.10
*/
@SuppressWarnings("rawtypes")
public DataSet query(String table, Map selectColumnNameTypeMap, Condition whereClause, String groupBy, String having, String orderBy,
int offset, int count) {
N.checkArgNotNullOrEmpty(selectColumnNameTypeMap, "selectColumnNameTypeMap");
final String[] selectColumnNames = new String[selectColumnNameTypeMap.size()];
final Class[] selectColumnTypes = new Class[selectColumnNameTypeMap.size()];
int i = 0;
for (Map.Entry entry : selectColumnNameTypeMap.entrySet()) {
selectColumnNames[i] = entry.getKey();
selectColumnTypes[i] = entry.getValue();
i++;
}
return this.query(table, selectColumnNames, selectColumnTypes, whereClause, groupBy, having, orderBy, offset, count);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Class[] selectColumnTypes, Condition whereClause) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, null);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Class[] selectColumnTypes, Condition whereClause, String orderBy) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, orderBy, 0, Integer.MAX_VALUE);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Class[] selectColumnTypes, Condition whereClause, String orderBy, int offset, int count) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, null, null, orderBy, offset, count);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Class[] selectColumnTypes, Condition whereClause, String groupBy, String having, String orderBy) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, groupBy, having, orderBy, 0, Integer.MAX_VALUE);
}
/**
* Find the records from database with the specified whereClause, groupby, having, orderBy and return the result set.
*
* @param table
* @param selectColumnNames
* @param selectColumnTypes
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @param groupBy A filter declaring how to group rows, formatted as an SQL GROUP BY clause (excluding the GROUP BY itself). Passing null will cause the rows to not be grouped.
* @param having A filter declare which row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all row groups to be included, and is required when row grouping is not being used.
* @param orderby How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
* @param offset
* @param count
* @return
*/
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Class[] selectColumnTypes, Condition whereClause, String groupBy, String having, String orderBy,
int offset, int count) {
if (whereClause == null) {
return executeQuery(table, selectColumnNames, Type.arrayOf(selectColumnTypes), (String) null, N.EMPTY_STRING_ARRAY, groupBy, having, orderBy,
offset, count);
} else {
final Command cmd = interpretCondition(whereClause);
return executeQuery(table, selectColumnNames, Type.arrayOf(selectColumnTypes), cmd.getSql(), cmd.getArgs(), groupBy, having, orderBy, offset,
count);
}
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, Condition whereClause) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, null);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, Condition whereClause, String orderBy) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, orderBy, 0, Integer.MAX_VALUE);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, Condition whereClause, String orderBy, int offset, int count) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, null, null, orderBy, offset, count);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, Condition whereClause, String groupBy, String having, String orderBy) {
return query(table, selectColumnNames, selectColumnTypes, whereClause, groupBy, having, orderBy, 0, Integer.MAX_VALUE);
}
/**
*
* @param table
* @param selectColumnNames
* @param selectColumnTypes
* @param whereClause Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.
* @param groupBy A filter declaring how to group rows, formatted as an SQL GROUP BY clause (excluding the GROUP BY itself). Passing null will cause the rows to not be grouped.
* @param having A filter declare which row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all row groups to be included, and is required when row grouping is not being used.
* @param orderby How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
* @param offset
* @param count
* @return
*/
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, Condition whereClause, String groupBy, String having, String orderBy,
int offset, int count) {
if (whereClause == null) {
return executeQuery(table, selectColumnNames, selectColumnTypes, (String) null, N.EMPTY_STRING_ARRAY, groupBy, having, orderBy, offset, count);
} else {
final Command cmd = interpretCondition(whereClause);
return executeQuery(table, selectColumnNames, selectColumnTypes, cmd.getSql(), cmd.getArgs(), groupBy, having, orderBy, offset, count);
}
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, String where, String[] whereArgs) {
return query(table, selectColumnNames, selectColumnTypes, where, whereArgs, null);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, String where, String[] whereArgs, String orderBy) {
return query(table, selectColumnNames, selectColumnTypes, where, whereArgs, orderBy, 0, Integer.MAX_VALUE);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, String where, String[] whereArgs, String orderBy, int offset, int count) {
return query(table, selectColumnNames, selectColumnTypes, where, whereArgs, null, null, orderBy, offset, count);
}
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, String where, String[] whereArgs, String groupBy, String having,
String orderBy) {
return query(table, selectColumnNames, selectColumnTypes, where, whereArgs, groupBy, having, orderBy, 0, Integer.MAX_VALUE);
}
/**
*
* @param table
* @param selectColumnNames
* @param selectColumnTypes
* @param where A filter declaring which rows to return, formatted as an SQL WHERE clause (excluding the WHERE itself). Passing null will return all rows for the given table.
* @param whereArgs You may include ?s in selection, which will be replaced by the values from selectionArgs, in order that they appear in the selection. The values will be bound as Strings.
* @param groupBy A filter declaring how to group rows, formatted as an SQL GROUP BY clause (excluding the GROUP BY itself). Passing null will cause the rows to not be grouped.
* @param having A filter declare which row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all row groups to be included, and is required when row grouping is not being used.
* @param orderby How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
* @param offset
* @param count
* @return
*/
@Deprecated
@SuppressWarnings("rawtypes")
DataSet query(String table, String[] selectColumnNames, Type[] selectColumnTypes, String where, String[] whereArgs, String groupBy, String having,
String orderBy, int offset, int count) {
return executeQuery(table, selectColumnNames, selectColumnTypes, parseStringCondition(where), whereArgs, groupBy, having, orderBy, offset, count);
}
@SuppressWarnings("rawtypes")
private DataSet executeQuery(String table, String[] selectColumnNames, Type[] selectColumnTypes, String where, String[] whereArgs, String groupBy,
String having, String orderBy, int offset, int count) {
if (offset < 0 || count < 0) {
throw new IllegalArgumentException("offset and count can't be negative: offset=" + offset + ", count=" + count);
}
table = formatName(table);
final String[] formattedColumnNames = new String[selectColumnNames.length];
for (int i = 0, len = selectColumnNames.length; i < len; i++) {
formattedColumnNames[i] = formatName(selectColumnNames[i]);
}
String limit = null;
if (offset > 0) {
limit = offset + " , " + count;
} else if (count < Integer.MAX_VALUE) {
limit = String.valueOf(count);
}
groupBy = groupBy == null ? null : formatName(groupBy);
having = having == null ? null : parseStringCondition(having);
orderBy = orderBy == null ? null : formatName(orderBy);
Cursor cursor = sqliteDB.query(table, formattedColumnNames, where, whereArgs, groupBy, having, orderBy, limit);
DataSet rs = null;
try {
rs = extractData(cursor, selectColumnTypes);
} finally {
cursor.close();
}
for (int i = 0, len = formattedColumnNames.length; i < len; i++) {
if (!formattedColumnNames[i].equals(selectColumnNames[i]) && rs.containsColumn(formattedColumnNames[i])) {
rs.renameColumn(formattedColumnNames[i], selectColumnNames[i]);
}
}
return rs;
}
/**
* Find the records from database with the specified sql, parameters and return the result set.
*
* @param targetClass an entity class with getter/setter methods.
* @param sql set offset and limit in sql with format:
* SELECT * FROM account where id = ? LIMIT offsetValue , limitValue SELECT * FROM account where id = ? LIMIT limitValue words = SQLParser.parse(expr);
String word = null;
for (int i = 0, len = words.size(); i < len; i++) {
word = words.get(i);
if (!StringUtil.isAsciiAlpha(word.charAt(0))) {
sb.append(word);
} else if (SQLParser.isFunctionName(words, len, i)) {
sb.append(word);
} else {
sb.append(formatName(word));
}
}
return sb.toString();
} finally {
Objectory.recycle(sb);
}
}
private Object[] prepareArguments(final NamedSQL namedSQL, final Object... parameters) {
final int parameterCount = namedSQL.getParameterCount();
if (parameterCount == 0) {
return N.EMPTY_OBJECT_ARRAY;
} else if (N.isNullOrEmpty(parameters)) {
throw new IllegalArgumentException("Null or empty parameters for parameterized query: " + namedSQL.getNamedSQL());
}
final List namedParameters = namedSQL.getNamedParameters();
Object[] result = parameters;
if (N.notNullOrEmpty(namedParameters) && parameters.length == 1 && (parameters[0] instanceof Map || ClassUtil.isEntity(parameters[0].getClass()))) {
result = new Object[parameterCount];
Object parameter_0 = parameters[0];
if (parameter_0 instanceof Map) {
@SuppressWarnings("unchecked")
Map m = (Map) parameter_0;
for (int i = 0; i < parameterCount; i++) {
result[i] = m.get(namedParameters.get(i));
if ((result[i] == null) && !m.containsKey(namedParameters.get(i))) {
throw new IllegalArgumentException("Parameter for property '" + namedParameters.get(i) + "' is missed");
}
}
} else {
Object entity = parameter_0;
Class clazz = entity.getClass();
Method propGetMethod = null;
for (int i = 0; i < parameterCount; i++) {
propGetMethod = ClassUtil.getPropGetMethod(clazz, namedParameters.get(i));
if (propGetMethod == null) {
throw new IllegalArgumentException("Parameter for property '" + namedParameters.get(i) + "' is missed");
}
result[i] = ClassUtil.invokeMethod(entity, propGetMethod);
}
}
} else {
if ((parameters.length == 1) && (parameters[0] != null)) {
if (parameters[0] instanceof Object[] && ((((Object[]) parameters[0]).length) >= parameterCount)) {
return (Object[]) parameters[0];
} else if (parameters[0] instanceof List && (((List) parameters[0]).size() >= parameterCount)) {
final Collection c = (Collection) parameters[0];
return c.toArray(new Object[c.size()]);
}
}
}
return result;
}
private Command interpretCondition(Condition condition) {
if (condition instanceof Binary) {
return interpretBinary((Binary) condition);
} else if (condition instanceof Between) {
return interpretBetween((Between) condition);
} else if (condition instanceof In) {
return interpretIn((In) condition);
} else if (condition instanceof Junction) {
return interpretJunction((Junction) condition);
} else if (condition instanceof Expression) {
return interpretExpression((Expression) condition);
} else {
throw new IllegalArgumentException("Unsupported condition type: " + condition.getOperator()
+ ". Only binary(=, <>, like, IS NULL ...)/between/junction(or, and...) are supported.");
}
}
private Command interpretBinary(Binary binary) {
final Command cmd = new Command();
cmd.setSql(formatName(binary.getPropName()) + WD.SPACE + binary.getOperator() + " ?");
cmd.setArgs(N.asArray(N.stringOf(binary.getPropValue())));
return cmd;
}
private Command interpretBetween(Between bt) {
final Command cmd = new Command();
cmd.setSql(formatName(bt.getPropName()) + WD.SPACE + bt.getOperator() + " (?, ?)");
cmd.setArgs(N.asArray(N.stringOf(bt.getMinValue()), N.stringOf(bt.getMaxValue())));
return cmd;
}
private Command interpretIn(In in) {
final Command cmd = new Command();
final List parameters = in.getParameters();
cmd.setSql(formatName(in.getPropName()) + " IN (" + SQLBuilder.repeatQM(parameters.size()) + ")");
final String[] args = new String[parameters.size()];
for (int i = 0, len = args.length; i < len; i++) {
args[i] = N.stringOf(parameters.get(i));
}
cmd.setArgs(args);
return cmd;
}
private Command interpretJunction(Junction junction) {
final List conditionList = junction.getConditions();
if (N.isNullOrEmpty(conditionList)) {
throw new IllegalArgumentException("The junction condition(" + junction.getOperator().toString() + ") doesn't include any element.");
}
if (conditionList.size() == 1) {
return interpretCondition(conditionList.get(0));
} else {
final List argList = new ArrayList<>();
final StringBuilder sb = Objectory.createStringBuilder();
try {
for (int i = 0; i < conditionList.size(); i++) {
if (i > 0) {
sb.append(WD._SPACE);
sb.append(junction.getOperator().toString());
sb.append(WD._SPACE);
}
sb.append(WD._PARENTHESES_L);
Command cmd = interpretCondition(conditionList.get(i));
sb.append(cmd.getSql());
if (N.notNullOrEmpty(cmd.getArgs())) {
for (String arg : cmd.getArgs()) {
argList.add(arg);
}
}
sb.append(WD._PARENTHESES_R);
}
Command cmd = new Command();
cmd.setSql(sb.toString());
if (N.notNullOrEmpty(argList)) {
cmd.setArgs(argList.toArray(new String[argList.size()]));
}
return cmd;
} finally {
Objectory.recycle(sb);
}
}
}
private Command interpretExpression(Expression exp) {
Command cmd = new Command();
cmd.setSql(exp.getLiteral());
return cmd;
}
private static boolean isDirtyMarkerEntity(final Class cls) {
return DirtyMarker.class.isAssignableFrom(cls) && ClassUtil.isEntity(cls);
}
private static class Command {
private String sql;
private String[] args = N.EMPTY_STRING_ARRAY;
public String getSql() {
return sql;
}
public void setSql(String sql) {
this.sql = sql;
}
public String[] getArgs() {
return args;
}
public void setArgs(String[] args) {
this.args = args;
}
@Override
public int hashCode() {
int result = 1;
result = 31 * result + Arrays.hashCode(args);
result = 31 * result + ((sql == null) ? 0 : sql.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj) {
return true;
}
if (obj instanceof Command) {
Command other = (Command) obj;
return N.equals(sql, other.sql) && N.equals(args, other.args);
}
return false;
}
@Override
public String toString() {
if (N.isNullOrEmpty(args)) {
return sql;
} else {
final StringBuilder sb = Objectory.createStringBuilder();
try {
sb.append(sql);
sb.append(_SPACE);
sb.append(_BRACE_L);
for (int i = 0, len = args.length; i < len; i++) {
if (i > 0) {
sb.append(COMMA_SPACE);
}
sb.append(i + 1);
sb.append(_EQUAL);
sb.append(args[i]);
}
sb.append(_BRACE_R);
return sb.toString();
} finally {
Objectory.recycle(sb);
}
}
}
}
static abstract class Type {
public static final Type STRING = new Type(Cursor.FIELD_TYPE_STRING, String.class) {
@Override
public String get(Cursor cursor, int columnIndex) {
return cursor.getString(columnIndex);
}
@Override
public String get(ContentValues contentValues, String key) {
return contentValues.getAsString(key);
}
@Override
public void set(ContentValues contentValues, String key, String value) {
contentValues.put(key, value);
}
};
public static final Type BOOLEAN = new Type(Cursor.FIELD_TYPE_STRING, Boolean.class) {
@Override
public Boolean get(Cursor cursor, int columnIndex) {
return Boolean.valueOf(cursor.getString(columnIndex));
}
@Override
public Boolean get(ContentValues contentValues, String key) {
return contentValues.getAsBoolean(key);
}
@Override
public void set(ContentValues contentValues, String key, Boolean value) {
contentValues.put(key, value);
}
};
public static final Type CHAR = new Type(Cursor.FIELD_TYPE_STRING, Character.class) {
@Override
public Character get(Cursor cursor, int columnIndex) {
return cursor.getString(columnIndex).charAt(0);
}
@Override
public Character get(ContentValues contentValues, String key) {
return contentValues.getAsString(key).charAt(0);
}
@Override
public void set(ContentValues contentValues, String key, Character value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type BYTE = new Type(Cursor.FIELD_TYPE_INTEGER, Byte.class) {
@Override
public Byte get(Cursor cursor, int columnIndex) {
return (byte) cursor.getShort(columnIndex);
}
@Override
public Byte get(ContentValues contentValues, String key) {
return contentValues.getAsByte(key);
}
@Override
public void set(ContentValues contentValues, String key, Byte value) {
contentValues.put(key, value);
}
};
public static final Type SHORT = new Type(Cursor.FIELD_TYPE_INTEGER, Short.class) {
@Override
public Short get(Cursor cursor, int columnIndex) {
return cursor.getShort(columnIndex);
}
@Override
public Short get(ContentValues contentValues, String key) {
return contentValues.getAsShort(key);
}
@Override
public void set(ContentValues contentValues, String key, Short value) {
contentValues.put(key, value);
}
};
public static final Type INT = new Type(Cursor.FIELD_TYPE_INTEGER, Integer.class) {
@Override
public Integer get(Cursor cursor, int columnIndex) {
return cursor.getInt(columnIndex);
}
@Override
public Integer get(ContentValues contentValues, String key) {
return contentValues.getAsInteger(key);
}
@Override
public void set(ContentValues contentValues, String key, Integer value) {
contentValues.put(key, value);
}
};
public static final Type LONG = new Type(Cursor.FIELD_TYPE_INTEGER, Long.class) {
@Override
public Long get(Cursor cursor, int columnIndex) {
return cursor.getLong(columnIndex);
}
@Override
public Long get(ContentValues contentValues, String key) {
return contentValues.getAsLong(key);
}
@Override
public void set(ContentValues contentValues, String key, Long value) {
contentValues.put(key, value);
}
};
public static final Type FLOAT = new Type(Cursor.FIELD_TYPE_FLOAT, Float.class) {
@Override
public Float get(Cursor cursor, int columnIndex) {
return cursor.getFloat(columnIndex);
}
@Override
public Float get(ContentValues contentValues, String key) {
return contentValues.getAsFloat(key);
}
@Override
public void set(ContentValues contentValues, String key, Float value) {
contentValues.put(key, value);
}
};
public static final Type DOUBLE = new Type(Cursor.FIELD_TYPE_FLOAT, Double.class) {
@Override
public Double get(Cursor cursor, int columnIndex) {
return cursor.getDouble(columnIndex);
}
@Override
public Double get(ContentValues contentValues, String key) {
return contentValues.getAsDouble(key);
}
@Override
public void set(ContentValues contentValues, String key, Double value) {
contentValues.put(key, value);
}
};
public static final Type BIG_INTEGER = new Type(Cursor.FIELD_TYPE_STRING, BigInteger.class) {
@Override
public BigInteger get(Cursor cursor, int columnIndex) {
String value = cursor.getString(columnIndex);
if (N.isNullOrEmpty(value)) {
return null;
}
return new BigInteger(value);
}
@Override
public BigInteger get(ContentValues contentValues, String key) {
String value = contentValues.getAsString(key);
if (N.isNullOrEmpty(value)) {
return null;
}
return new BigInteger(value);
}
@Override
public void set(ContentValues contentValues, String key, BigInteger value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type BIG_DECIMAL = new Type(Cursor.FIELD_TYPE_STRING, BigDecimal.class) {
@Override
public BigDecimal get(Cursor cursor, int columnIndex) {
String value = cursor.getString(columnIndex);
if (N.isNullOrEmpty(value)) {
return null;
}
return new BigDecimal(value);
}
@Override
public BigDecimal get(ContentValues contentValues, String key) {
String value = contentValues.getAsString(key);
if (N.isNullOrEmpty(value)) {
return null;
}
return new BigDecimal(value);
}
@Override
public void set(ContentValues contentValues, String key, BigDecimal value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type DATE = new Type(Cursor.FIELD_TYPE_STRING, Date.class) {
@Override
public Date get(Cursor cursor, int columnIndex) {
return DateUtil.parseDate(cursor.getString(columnIndex));
}
@Override
public Date get(ContentValues contentValues, String key) {
return DateUtil.parseDate(contentValues.getAsString(key));
}
@Override
public void set(ContentValues contentValues, String key, Date value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type TIME = new Type(Cursor.FIELD_TYPE_STRING, Time.class) {
@Override
public Time get(Cursor cursor, int columnIndex) {
return DateUtil.parseTime(cursor.getString(columnIndex));
}
@Override
public Time get(ContentValues contentValues, String key) {
return DateUtil.parseTime(contentValues.getAsString(key));
}
@Override
public void set(ContentValues contentValues, String key, Time value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type TIMESTAMP = new Type(Cursor.FIELD_TYPE_STRING, Timestamp.class) {
@Override
public Timestamp get(Cursor cursor, int columnIndex) {
return DateUtil.parseTimestamp(cursor.getString(columnIndex));
}
@Override
public Timestamp get(ContentValues contentValues, String key) {
return DateUtil.parseTimestamp(contentValues.getAsString(key));
}
@Override
public void set(ContentValues contentValues, String key, Timestamp value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type JU_DATE = new Type(Cursor.FIELD_TYPE_STRING, java.util.Date.class) {
@Override
public java.util.Date get(Cursor cursor, int columnIndex) {
return DateUtil.parseJUDate(cursor.getString(columnIndex));
}
@Override
public java.util.Date get(ContentValues contentValues, String key) {
return DateUtil.parseJUDate(contentValues.getAsString(key));
}
@Override
public void set(ContentValues contentValues, String key, java.util.Date value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type CALENDAR = new Type(Cursor.FIELD_TYPE_STRING, Calendar.class) {
@Override
public Calendar get(Cursor cursor, int columnIndex) {
return DateUtil.parseCalendar(cursor.getString(columnIndex));
}
@Override
public Calendar get(ContentValues contentValues, String key) {
return DateUtil.parseCalendar(contentValues.getAsString(key));
}
@Override
public void set(ContentValues contentValues, String key, Calendar value) {
contentValues.put(key, N.stringOf(value));
}
};
public static final Type BLOB = new Type(Cursor.FIELD_TYPE_BLOB, byte[].class) {
@Override
public byte[] get(Cursor cursor, int columnIndex) {
return cursor.getBlob(columnIndex);
}
@Override
public byte[] get(ContentValues contentValues, String key) {
return contentValues.getAsByteArray(key);
}
@Override
public void set(ContentValues contentValues, String key, byte[] value) {
contentValues.put(key, value);
}
};
private static final Map, Type> classSQLiteTypePool = new ObjectPool<>(64);
static {
classSQLiteTypePool.put(String.class, STRING);
classSQLiteTypePool.put(boolean.class, BOOLEAN);
classSQLiteTypePool.put(Boolean.class, BOOLEAN);
classSQLiteTypePool.put(char.class, CHAR);
classSQLiteTypePool.put(Character.class, CHAR);
classSQLiteTypePool.put(byte.class, BYTE);
classSQLiteTypePool.put(Byte.class, BYTE);
classSQLiteTypePool.put(short.class, SHORT);
classSQLiteTypePool.put(Short.class, SHORT);
classSQLiteTypePool.put(int.class, INT);
classSQLiteTypePool.put(Integer.class, INT);
classSQLiteTypePool.put(long.class, LONG);
classSQLiteTypePool.put(Long.class, LONG);
classSQLiteTypePool.put(float.class, FLOAT);
classSQLiteTypePool.put(Float.class, FLOAT);
classSQLiteTypePool.put(double.class, DOUBLE);
classSQLiteTypePool.put(Double.class, DOUBLE);
classSQLiteTypePool.put(BigInteger.class, BIG_INTEGER);
classSQLiteTypePool.put(BigDecimal.class, BIG_DECIMAL);
classSQLiteTypePool.put(Date.class, DATE);
classSQLiteTypePool.put(Time.class, TIME);
classSQLiteTypePool.put(Timestamp.class, TIMESTAMP);
classSQLiteTypePool.put(java.util.Date.class, JU_DATE);
classSQLiteTypePool.put(Calendar.class, CALENDAR);
classSQLiteTypePool.put(byte[].class, BLOB);
}
private final int androidSQLiteType;
private final Class typeClass;
private Type(int androidSQLiteType, Class typeClass) {
this.androidSQLiteType = androidSQLiteType;
this.typeClass = typeClass;
}
public int getAndroidSQLiteType() {
return androidSQLiteType;
}
public Class getTypeClass() {
return (Class) typeClass;
}
public abstract T get(Cursor cursor, int columnIndex);
public abstract T get(ContentValues contentValues, String key);
public abstract void set(ContentValues contentValues, String key, T value);
public static Type valueOf(final int androidSQLiteType) {
switch (androidSQLiteType) {
case Cursor.FIELD_TYPE_INTEGER:
return (Type) INT;
case Cursor.FIELD_TYPE_FLOAT:
return (Type) FLOAT;
case Cursor.FIELD_TYPE_STRING:
return (Type) STRING;
case Cursor.FIELD_TYPE_BLOB:
return (Type) BLOB;
default:
throw new IllegalArgumentException("Unsupported android sqlite type: " + androidSQLiteType);
}
}
public static Type valueOf(final Class typeClass) {
Type sqliteType = (Type) classSQLiteTypePool.get(typeClass);
if (sqliteType == null) {
sqliteType = new Type(Cursor.FIELD_TYPE_STRING, typeClass) {
private final com.landawn.abacus.type.Type ttType = N.typeOf(typeClass);
@Override
public C get(Cursor cursor, int columnIndex) {
return (C) ttType.valueOf(cursor.getString(columnIndex));
}
@Override
public C get(ContentValues contentValues, String key) {
return (C) ttType.valueOf(contentValues.getAsString(key));
}
@Override
public void set(ContentValues contentValues, String key, C value) {
contentValues.put(key, ttType.stringOf(value));
}
};
classSQLiteTypePool.put(typeClass, sqliteType);
}
return (Type) sqliteType;
}
@SafeVarargs
public static Type[] arrayOf(final int... androidSQLiteTypes) {
final Type[] types = new Type[androidSQLiteTypes.length];
for (int i = 0, len = androidSQLiteTypes.length; i < len; i++) {
types[i] = valueOf(androidSQLiteTypes[i]);
}
return types;
}
@SafeVarargs
public static Type[] arrayOf(final Class... typeClasses) {
final Type[] types = new Type[typeClasses.length];
for (int i = 0, len = typeClasses.length; i < len; i++) {
types[i] = valueOf(typeClasses[i]);
}
return types;
}
}
}
