use of sqlite.feature.typeadapter.kripton180.adapters.TypeAdapterByte in project kripton by xcesco.
the class EmployeeBeanDaoImpl method selectByAllJQL.
/**
* <h2>Select SQL:</h2>
*
* <pre>SELECT id, last_name, first_name, birth_date, hire_date, address, field_boolean, field_byte, field_character, field_short, field_integer, field_long, field_float, field_double, field_string, field_byte_array FROM employees WHERE id=${bean.id} and field_byte=${bean.fieldByte} and field_byte=${bean.fieldByte} and field_character=${bean.fieldCharacter} and field_short=${bean.fieldShort} and field_integer=${bean.fieldInteger} and field_long=${bean.fieldLong} and field_float=${bean.fieldFloat} and field_double=${bean.fieldDouble} and field_string=${bean.fieldString} and field_byte_array=${bean.fieldByteArray}</pre>
*
* <h2>Projected columns:</h2>
* <dl>
* <dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
* <dt>last_name</dt><dd>is associated to bean's property <strong>lastName</strong></dd>
* <dt>first_name</dt><dd>is associated to bean's property <strong>firstName</strong></dd>
* <dt>birth_date</dt><dd>is associated to bean's property <strong>birthDate</strong></dd>
* <dt>hire_date</dt><dd>is associated to bean's property <strong>hireDate</strong></dd>
* <dt>address</dt><dd>is associated to bean's property <strong>address</strong></dd>
* <dt>field_boolean</dt><dd>is associated to bean's property <strong>fieldBoolean</strong></dd>
* <dt>field_byte</dt><dd>is associated to bean's property <strong>fieldByte</strong></dd>
* <dt>field_character</dt><dd>is associated to bean's property <strong>fieldCharacter</strong></dd>
* <dt>field_short</dt><dd>is associated to bean's property <strong>fieldShort</strong></dd>
* <dt>field_integer</dt><dd>is associated to bean's property <strong>fieldInteger</strong></dd>
* <dt>field_long</dt><dd>is associated to bean's property <strong>fieldLong</strong></dd>
* <dt>field_float</dt><dd>is associated to bean's property <strong>fieldFloat</strong></dd>
* <dt>field_double</dt><dd>is associated to bean's property <strong>fieldDouble</strong></dd>
* <dt>field_string</dt><dd>is associated to bean's property <strong>fieldString</strong></dd>
* <dt>field_byte_array</dt><dd>is associated to bean's property <strong>fieldByteArray</strong></dd>
* </dl>
*
* <h2>Query's parameters:</h2>
* <dl>
* <dt>${bean.id}</dt><dd>is binded to method's parameter <strong>bean.id</strong></dd>
* <dt>${bean.fieldByte}</dt><dd>is binded to method's parameter <strong>bean.fieldByte</strong></dd>
* <dt>${bean.fieldByte}</dt><dd>is binded to method's parameter <strong>bean.fieldByte</strong></dd>
* <dt>${bean.fieldCharacter}</dt><dd>is binded to method's parameter <strong>bean.fieldCharacter</strong></dd>
* <dt>${bean.fieldShort}</dt><dd>is binded to method's parameter <strong>bean.fieldShort</strong></dd>
* <dt>${bean.fieldInteger}</dt><dd>is binded to method's parameter <strong>bean.fieldInteger</strong></dd>
* <dt>${bean.fieldLong}</dt><dd>is binded to method's parameter <strong>bean.fieldLong</strong></dd>
* <dt>${bean.fieldFloat}</dt><dd>is binded to method's parameter <strong>bean.fieldFloat</strong></dd>
* <dt>${bean.fieldDouble}</dt><dd>is binded to method's parameter <strong>bean.fieldDouble</strong></dd>
* <dt>${bean.fieldString}</dt><dd>is binded to method's parameter <strong>bean.fieldString</strong></dd>
* <dt>${bean.fieldByteArray}</dt><dd>is binded to method's parameter <strong>bean.fieldByteArray</strong></dd>
* </dl>
*
* @param bean
* is used as ${bean}
* @return selected bean or <code>null</code>.
*/
@Override
public Employee selectByAllJQL(Employee bean) {
KriptonContentValues _contentValues = contentValues();
// query SQL is statically defined
String _sql = SELECT_BY_ALL_J_Q_L_SQL4;
// add where arguments
_contentValues.addWhereArgs(String.valueOf(bean.id));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterByte.class, bean.fieldByte));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterByte.class, bean.fieldByte));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterChar.class, bean.fieldCharacter));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterShort.class, bean.fieldShort));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterInteger.class, bean.fieldInteger));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterLong.class, bean.fieldLong));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterFloat.class, bean.fieldFloat));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterDouble.class, bean.fieldDouble));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterString.class, bean.fieldString));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterByteArray.class, bean.fieldByteArray));
String[] _sqlArgs = _contentValues.whereArgsAsArray();
// log section BEGIN
if (_context.isLogEnabled()) {
// manage log
Logger.info(_sql);
// log for where parameters -- BEGIN
int _whereParamCounter = 0;
for (String _whereParamItem : _contentValues.whereArgs()) {
Logger.info("==> param%s: '%s'", (_whereParamCounter++), StringUtils.checkSize(_whereParamItem));
}
// log for where parameters -- END
}
// log section END
try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
// log section BEGIN
if (_context.isLogEnabled()) {
Logger.info("Rows found: %s", _cursor.getCount());
}
// log section END
Employee resultBean = null;
if (_cursor.moveToFirst()) {
int index0 = _cursor.getColumnIndex("id");
int index1 = _cursor.getColumnIndex("last_name");
int index2 = _cursor.getColumnIndex("first_name");
int index3 = _cursor.getColumnIndex("birth_date");
int index4 = _cursor.getColumnIndex("hire_date");
int index5 = _cursor.getColumnIndex("address");
TypeAdapterAddress addressAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterAddress.class);
int index6 = _cursor.getColumnIndex("field_boolean");
TypeAdapterBoolean fieldBooleanAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterBoolean.class);
int index7 = _cursor.getColumnIndex("field_byte");
TypeAdapterByte fieldByteAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByte.class);
int index8 = _cursor.getColumnIndex("field_character");
TypeAdapterChar fieldCharacterAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterChar.class);
int index9 = _cursor.getColumnIndex("field_short");
TypeAdapterShort fieldShortAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterShort.class);
int index10 = _cursor.getColumnIndex("field_integer");
TypeAdapterInteger fieldIntegerAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterInteger.class);
int index11 = _cursor.getColumnIndex("field_long");
TypeAdapterLong fieldLongAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterLong.class);
int index12 = _cursor.getColumnIndex("field_float");
TypeAdapterFloat fieldFloatAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterFloat.class);
int index13 = _cursor.getColumnIndex("field_double");
TypeAdapterDouble fieldDoubleAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterDouble.class);
int index14 = _cursor.getColumnIndex("field_string");
TypeAdapterString fieldStringAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterString.class);
int index15 = _cursor.getColumnIndex("field_byte_array");
TypeAdapterByteArray fieldByteArrayAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByteArray.class);
resultBean = new Employee();
resultBean.id = _cursor.getLong(index0);
if (!_cursor.isNull(index1)) {
resultBean.lastName = _cursor.getString(index1);
}
if (!_cursor.isNull(index2)) {
resultBean.firstName = _cursor.getString(index2);
}
if (!_cursor.isNull(index3)) {
resultBean.birthDate = SQLDateUtils.read(_cursor.getString(index3));
}
if (!_cursor.isNull(index4)) {
resultBean.hireDate = SQLDateUtils.read(_cursor.getString(index4));
}
if (!_cursor.isNull(index5)) {
resultBean.address = addressAdapter.toJava(_cursor.getString(index5));
}
if (!_cursor.isNull(index6)) {
resultBean.fieldBoolean = fieldBooleanAdapter.toJava(_cursor.getInt(index6) == 0 ? false : true);
}
if (!_cursor.isNull(index7)) {
resultBean.fieldByte = fieldByteAdapter.toJava((byte) _cursor.getInt(index7));
}
if (!_cursor.isNull(index8)) {
resultBean.fieldCharacter = fieldCharacterAdapter.toJava((char) _cursor.getInt(index8));
}
if (!_cursor.isNull(index9)) {
resultBean.fieldShort = fieldShortAdapter.toJava(_cursor.getShort(index9));
}
if (!_cursor.isNull(index10)) {
resultBean.fieldInteger = fieldIntegerAdapter.toJava(_cursor.getInt(index10));
}
if (!_cursor.isNull(index11)) {
resultBean.fieldLong = fieldLongAdapter.toJava(_cursor.getLong(index11));
}
if (!_cursor.isNull(index12)) {
resultBean.fieldFloat = fieldFloatAdapter.toJava(_cursor.getFloat(index12));
}
if (!_cursor.isNull(index13)) {
resultBean.fieldDouble = fieldDoubleAdapter.toJava(_cursor.getDouble(index13));
}
if (!_cursor.isNull(index14)) {
resultBean.fieldString = fieldStringAdapter.toJava(_cursor.getString(index14));
}
if (!_cursor.isNull(index15)) {
resultBean.fieldByteArray = fieldByteArrayAdapter.toJava(_cursor.getBlob(index15));
}
}
return resultBean;
}
}
use of sqlite.feature.typeadapter.kripton180.adapters.TypeAdapterByte in project kripton by xcesco.
the class EmployeeBeanDaoImpl method selectByAll.
/**
* <h2>Select SQL:</h2>
*
* <pre>SELECT id, last_name, first_name, birth_date, hire_date, address, field_boolean, field_byte, field_character, field_short, field_integer, field_long, field_float, field_double, field_string, field_byte_array FROM employees WHERE id=${bean.id} and field_byte=${bean.fieldByte} and field_byte=${bean.fieldByte} and field_character=${bean.fieldCharacter} and field_short=${bean.fieldShort} and field_integer=${bean.fieldInteger} and field_long=${bean.fieldLong} and field_float=${bean.fieldFloat} and field_double=${bean.fieldDouble} and field_string=${bean.fieldString} and field_byte_array=${bean.fieldByteArray}</pre>
*
* <h2>Projected columns:</h2>
* <dl>
* <dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
* <dt>last_name</dt><dd>is associated to bean's property <strong>lastName</strong></dd>
* <dt>first_name</dt><dd>is associated to bean's property <strong>firstName</strong></dd>
* <dt>birth_date</dt><dd>is associated to bean's property <strong>birthDate</strong></dd>
* <dt>hire_date</dt><dd>is associated to bean's property <strong>hireDate</strong></dd>
* <dt>address</dt><dd>is associated to bean's property <strong>address</strong></dd>
* <dt>field_boolean</dt><dd>is associated to bean's property <strong>fieldBoolean</strong></dd>
* <dt>field_byte</dt><dd>is associated to bean's property <strong>fieldByte</strong></dd>
* <dt>field_character</dt><dd>is associated to bean's property <strong>fieldCharacter</strong></dd>
* <dt>field_short</dt><dd>is associated to bean's property <strong>fieldShort</strong></dd>
* <dt>field_integer</dt><dd>is associated to bean's property <strong>fieldInteger</strong></dd>
* <dt>field_long</dt><dd>is associated to bean's property <strong>fieldLong</strong></dd>
* <dt>field_float</dt><dd>is associated to bean's property <strong>fieldFloat</strong></dd>
* <dt>field_double</dt><dd>is associated to bean's property <strong>fieldDouble</strong></dd>
* <dt>field_string</dt><dd>is associated to bean's property <strong>fieldString</strong></dd>
* <dt>field_byte_array</dt><dd>is associated to bean's property <strong>fieldByteArray</strong></dd>
* </dl>
*
* <h2>Query's parameters:</h2>
* <dl>
* <dt>${bean.id}</dt><dd>is binded to method's parameter <strong>bean.id</strong></dd>
* <dt>${bean.fieldByte}</dt><dd>is binded to method's parameter <strong>bean.fieldByte</strong></dd>
* <dt>${bean.fieldByte}</dt><dd>is binded to method's parameter <strong>bean.fieldByte</strong></dd>
* <dt>${bean.fieldCharacter}</dt><dd>is binded to method's parameter <strong>bean.fieldCharacter</strong></dd>
* <dt>${bean.fieldShort}</dt><dd>is binded to method's parameter <strong>bean.fieldShort</strong></dd>
* <dt>${bean.fieldInteger}</dt><dd>is binded to method's parameter <strong>bean.fieldInteger</strong></dd>
* <dt>${bean.fieldLong}</dt><dd>is binded to method's parameter <strong>bean.fieldLong</strong></dd>
* <dt>${bean.fieldFloat}</dt><dd>is binded to method's parameter <strong>bean.fieldFloat</strong></dd>
* <dt>${bean.fieldDouble}</dt><dd>is binded to method's parameter <strong>bean.fieldDouble</strong></dd>
* <dt>${bean.fieldString}</dt><dd>is binded to method's parameter <strong>bean.fieldString</strong></dd>
* <dt>${bean.fieldByteArray}</dt><dd>is binded to method's parameter <strong>bean.fieldByteArray</strong></dd>
* </dl>
*
* @param bean
* is used as ${bean}
* @return selected bean or <code>null</code>.
*/
@Override
public Employee selectByAll(Employee bean) {
KriptonContentValues _contentValues = contentValues();
// query SQL is statically defined
String _sql = SELECT_BY_ALL_SQL3;
// add where arguments
_contentValues.addWhereArgs(String.valueOf(bean.id));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterByte.class, bean.fieldByte));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterByte.class, bean.fieldByte));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterChar.class, bean.fieldCharacter));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterShort.class, bean.fieldShort));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterInteger.class, bean.fieldInteger));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterLong.class, bean.fieldLong));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterFloat.class, bean.fieldFloat));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterDouble.class, bean.fieldDouble));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterString.class, bean.fieldString));
_contentValues.addWhereArgs(SQLTypeAdapterUtils.toString(TypeAdapterByteArray.class, bean.fieldByteArray));
String[] _sqlArgs = _contentValues.whereArgsAsArray();
// log section BEGIN
if (_context.isLogEnabled()) {
// manage log
Logger.info(_sql);
// log for where parameters -- BEGIN
int _whereParamCounter = 0;
for (String _whereParamItem : _contentValues.whereArgs()) {
Logger.info("==> param%s: '%s'", (_whereParamCounter++), StringUtils.checkSize(_whereParamItem));
}
// log for where parameters -- END
}
// log section END
try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
// log section BEGIN
if (_context.isLogEnabled()) {
Logger.info("Rows found: %s", _cursor.getCount());
}
// log section END
Employee resultBean = null;
if (_cursor.moveToFirst()) {
int index0 = _cursor.getColumnIndex("id");
int index1 = _cursor.getColumnIndex("last_name");
int index2 = _cursor.getColumnIndex("first_name");
int index3 = _cursor.getColumnIndex("birth_date");
int index4 = _cursor.getColumnIndex("hire_date");
int index5 = _cursor.getColumnIndex("address");
TypeAdapterAddress addressAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterAddress.class);
int index6 = _cursor.getColumnIndex("field_boolean");
TypeAdapterBoolean fieldBooleanAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterBoolean.class);
int index7 = _cursor.getColumnIndex("field_byte");
TypeAdapterByte fieldByteAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByte.class);
int index8 = _cursor.getColumnIndex("field_character");
TypeAdapterChar fieldCharacterAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterChar.class);
int index9 = _cursor.getColumnIndex("field_short");
TypeAdapterShort fieldShortAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterShort.class);
int index10 = _cursor.getColumnIndex("field_integer");
TypeAdapterInteger fieldIntegerAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterInteger.class);
int index11 = _cursor.getColumnIndex("field_long");
TypeAdapterLong fieldLongAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterLong.class);
int index12 = _cursor.getColumnIndex("field_float");
TypeAdapterFloat fieldFloatAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterFloat.class);
int index13 = _cursor.getColumnIndex("field_double");
TypeAdapterDouble fieldDoubleAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterDouble.class);
int index14 = _cursor.getColumnIndex("field_string");
TypeAdapterString fieldStringAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterString.class);
int index15 = _cursor.getColumnIndex("field_byte_array");
TypeAdapterByteArray fieldByteArrayAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByteArray.class);
resultBean = new Employee();
resultBean.id = _cursor.getLong(index0);
if (!_cursor.isNull(index1)) {
resultBean.lastName = _cursor.getString(index1);
}
if (!_cursor.isNull(index2)) {
resultBean.firstName = _cursor.getString(index2);
}
if (!_cursor.isNull(index3)) {
resultBean.birthDate = SQLDateUtils.read(_cursor.getString(index3));
}
if (!_cursor.isNull(index4)) {
resultBean.hireDate = SQLDateUtils.read(_cursor.getString(index4));
}
if (!_cursor.isNull(index5)) {
resultBean.address = addressAdapter.toJava(_cursor.getString(index5));
}
if (!_cursor.isNull(index6)) {
resultBean.fieldBoolean = fieldBooleanAdapter.toJava(_cursor.getInt(index6) == 0 ? false : true);
}
if (!_cursor.isNull(index7)) {
resultBean.fieldByte = fieldByteAdapter.toJava((byte) _cursor.getInt(index7));
}
if (!_cursor.isNull(index8)) {
resultBean.fieldCharacter = fieldCharacterAdapter.toJava((char) _cursor.getInt(index8));
}
if (!_cursor.isNull(index9)) {
resultBean.fieldShort = fieldShortAdapter.toJava(_cursor.getShort(index9));
}
if (!_cursor.isNull(index10)) {
resultBean.fieldInteger = fieldIntegerAdapter.toJava(_cursor.getInt(index10));
}
if (!_cursor.isNull(index11)) {
resultBean.fieldLong = fieldLongAdapter.toJava(_cursor.getLong(index11));
}
if (!_cursor.isNull(index12)) {
resultBean.fieldFloat = fieldFloatAdapter.toJava(_cursor.getFloat(index12));
}
if (!_cursor.isNull(index13)) {
resultBean.fieldDouble = fieldDoubleAdapter.toJava(_cursor.getDouble(index13));
}
if (!_cursor.isNull(index14)) {
resultBean.fieldString = fieldStringAdapter.toJava(_cursor.getString(index14));
}
if (!_cursor.isNull(index15)) {
resultBean.fieldByteArray = fieldByteArrayAdapter.toJava(_cursor.getBlob(index15));
}
}
return resultBean;
}
}
use of sqlite.feature.typeadapter.kripton180.adapters.TypeAdapterByte in project kripton by xcesco.
the class EmployeeBeanDaoImpl method selectByIdJQL.
/**
* <h2>Select SQL:</h2>
*
* <pre>SELECT id, last_name, first_name, birth_date, hire_date, address, field_boolean, field_byte, field_character, field_short, field_integer, field_long, field_float, field_double, field_string, field_byte_array FROM employees WHERE id=${bean.id}</pre>
*
* <h2>Projected columns:</h2>
* <dl>
* <dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
* <dt>last_name</dt><dd>is associated to bean's property <strong>lastName</strong></dd>
* <dt>first_name</dt><dd>is associated to bean's property <strong>firstName</strong></dd>
* <dt>birth_date</dt><dd>is associated to bean's property <strong>birthDate</strong></dd>
* <dt>hire_date</dt><dd>is associated to bean's property <strong>hireDate</strong></dd>
* <dt>address</dt><dd>is associated to bean's property <strong>address</strong></dd>
* <dt>field_boolean</dt><dd>is associated to bean's property <strong>fieldBoolean</strong></dd>
* <dt>field_byte</dt><dd>is associated to bean's property <strong>fieldByte</strong></dd>
* <dt>field_character</dt><dd>is associated to bean's property <strong>fieldCharacter</strong></dd>
* <dt>field_short</dt><dd>is associated to bean's property <strong>fieldShort</strong></dd>
* <dt>field_integer</dt><dd>is associated to bean's property <strong>fieldInteger</strong></dd>
* <dt>field_long</dt><dd>is associated to bean's property <strong>fieldLong</strong></dd>
* <dt>field_float</dt><dd>is associated to bean's property <strong>fieldFloat</strong></dd>
* <dt>field_double</dt><dd>is associated to bean's property <strong>fieldDouble</strong></dd>
* <dt>field_string</dt><dd>is associated to bean's property <strong>fieldString</strong></dd>
* <dt>field_byte_array</dt><dd>is associated to bean's property <strong>fieldByteArray</strong></dd>
* </dl>
*
* <h2>Query's parameters:</h2>
* <dl>
* <dt>${bean.id}</dt><dd>is binded to method's parameter <strong>bean.id</strong></dd>
* </dl>
*
* @param bean
* is used as ${bean}
* @return selected bean or <code>null</code>.
*/
@Override
public Employee selectByIdJQL(Employee bean) {
KriptonContentValues _contentValues = contentValues();
// query SQL is statically defined
String _sql = SELECT_BY_ID_J_Q_L_SQL2;
// add where arguments
_contentValues.addWhereArgs(String.valueOf(bean.id));
String[] _sqlArgs = _contentValues.whereArgsAsArray();
// log section BEGIN
if (_context.isLogEnabled()) {
// manage log
Logger.info(_sql);
// log for where parameters -- BEGIN
int _whereParamCounter = 0;
for (String _whereParamItem : _contentValues.whereArgs()) {
Logger.info("==> param%s: '%s'", (_whereParamCounter++), StringUtils.checkSize(_whereParamItem));
}
// log for where parameters -- END
}
// log section END
try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
// log section BEGIN
if (_context.isLogEnabled()) {
Logger.info("Rows found: %s", _cursor.getCount());
}
// log section END
Employee resultBean = null;
if (_cursor.moveToFirst()) {
int index0 = _cursor.getColumnIndex("id");
int index1 = _cursor.getColumnIndex("last_name");
int index2 = _cursor.getColumnIndex("first_name");
int index3 = _cursor.getColumnIndex("birth_date");
int index4 = _cursor.getColumnIndex("hire_date");
int index5 = _cursor.getColumnIndex("address");
TypeAdapterAddress addressAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterAddress.class);
int index6 = _cursor.getColumnIndex("field_boolean");
TypeAdapterBoolean fieldBooleanAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterBoolean.class);
int index7 = _cursor.getColumnIndex("field_byte");
TypeAdapterByte fieldByteAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByte.class);
int index8 = _cursor.getColumnIndex("field_character");
TypeAdapterChar fieldCharacterAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterChar.class);
int index9 = _cursor.getColumnIndex("field_short");
TypeAdapterShort fieldShortAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterShort.class);
int index10 = _cursor.getColumnIndex("field_integer");
TypeAdapterInteger fieldIntegerAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterInteger.class);
int index11 = _cursor.getColumnIndex("field_long");
TypeAdapterLong fieldLongAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterLong.class);
int index12 = _cursor.getColumnIndex("field_float");
TypeAdapterFloat fieldFloatAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterFloat.class);
int index13 = _cursor.getColumnIndex("field_double");
TypeAdapterDouble fieldDoubleAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterDouble.class);
int index14 = _cursor.getColumnIndex("field_string");
TypeAdapterString fieldStringAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterString.class);
int index15 = _cursor.getColumnIndex("field_byte_array");
TypeAdapterByteArray fieldByteArrayAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByteArray.class);
resultBean = new Employee();
resultBean.id = _cursor.getLong(index0);
if (!_cursor.isNull(index1)) {
resultBean.lastName = _cursor.getString(index1);
}
if (!_cursor.isNull(index2)) {
resultBean.firstName = _cursor.getString(index2);
}
if (!_cursor.isNull(index3)) {
resultBean.birthDate = SQLDateUtils.read(_cursor.getString(index3));
}
if (!_cursor.isNull(index4)) {
resultBean.hireDate = SQLDateUtils.read(_cursor.getString(index4));
}
if (!_cursor.isNull(index5)) {
resultBean.address = addressAdapter.toJava(_cursor.getString(index5));
}
if (!_cursor.isNull(index6)) {
resultBean.fieldBoolean = fieldBooleanAdapter.toJava(_cursor.getInt(index6) == 0 ? false : true);
}
if (!_cursor.isNull(index7)) {
resultBean.fieldByte = fieldByteAdapter.toJava((byte) _cursor.getInt(index7));
}
if (!_cursor.isNull(index8)) {
resultBean.fieldCharacter = fieldCharacterAdapter.toJava((char) _cursor.getInt(index8));
}
if (!_cursor.isNull(index9)) {
resultBean.fieldShort = fieldShortAdapter.toJava(_cursor.getShort(index9));
}
if (!_cursor.isNull(index10)) {
resultBean.fieldInteger = fieldIntegerAdapter.toJava(_cursor.getInt(index10));
}
if (!_cursor.isNull(index11)) {
resultBean.fieldLong = fieldLongAdapter.toJava(_cursor.getLong(index11));
}
if (!_cursor.isNull(index12)) {
resultBean.fieldFloat = fieldFloatAdapter.toJava(_cursor.getFloat(index12));
}
if (!_cursor.isNull(index13)) {
resultBean.fieldDouble = fieldDoubleAdapter.toJava(_cursor.getDouble(index13));
}
if (!_cursor.isNull(index14)) {
resultBean.fieldString = fieldStringAdapter.toJava(_cursor.getString(index14));
}
if (!_cursor.isNull(index15)) {
resultBean.fieldByteArray = fieldByteArrayAdapter.toJava(_cursor.getBlob(index15));
}
}
return resultBean;
}
}
use of sqlite.feature.typeadapter.kripton180.adapters.TypeAdapterByte in project kripton by xcesco.
the class EmployeeBeanDaoImpl method selectById.
/**
* <h2>Select SQL:</h2>
*
* <pre>SELECT id, last_name, first_name, birth_date, hire_date, address, field_boolean, field_byte, field_character, field_short, field_integer, field_long, field_float, field_double, field_string, field_byte_array FROM employees WHERE id=${bean.id}</pre>
*
* <h2>Projected columns:</h2>
* <dl>
* <dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
* <dt>last_name</dt><dd>is associated to bean's property <strong>lastName</strong></dd>
* <dt>first_name</dt><dd>is associated to bean's property <strong>firstName</strong></dd>
* <dt>birth_date</dt><dd>is associated to bean's property <strong>birthDate</strong></dd>
* <dt>hire_date</dt><dd>is associated to bean's property <strong>hireDate</strong></dd>
* <dt>address</dt><dd>is associated to bean's property <strong>address</strong></dd>
* <dt>field_boolean</dt><dd>is associated to bean's property <strong>fieldBoolean</strong></dd>
* <dt>field_byte</dt><dd>is associated to bean's property <strong>fieldByte</strong></dd>
* <dt>field_character</dt><dd>is associated to bean's property <strong>fieldCharacter</strong></dd>
* <dt>field_short</dt><dd>is associated to bean's property <strong>fieldShort</strong></dd>
* <dt>field_integer</dt><dd>is associated to bean's property <strong>fieldInteger</strong></dd>
* <dt>field_long</dt><dd>is associated to bean's property <strong>fieldLong</strong></dd>
* <dt>field_float</dt><dd>is associated to bean's property <strong>fieldFloat</strong></dd>
* <dt>field_double</dt><dd>is associated to bean's property <strong>fieldDouble</strong></dd>
* <dt>field_string</dt><dd>is associated to bean's property <strong>fieldString</strong></dd>
* <dt>field_byte_array</dt><dd>is associated to bean's property <strong>fieldByteArray</strong></dd>
* </dl>
*
* <h2>Query's parameters:</h2>
* <dl>
* <dt>${bean.id}</dt><dd>is binded to method's parameter <strong>bean.id</strong></dd>
* </dl>
*
* @param bean
* is used as ${bean}
* @return selected bean or <code>null</code>.
*/
@Override
public Employee selectById(Employee bean) {
KriptonContentValues _contentValues = contentValues();
// query SQL is statically defined
String _sql = SELECT_BY_ID_SQL1;
// add where arguments
_contentValues.addWhereArgs(String.valueOf(bean.id));
String[] _sqlArgs = _contentValues.whereArgsAsArray();
// log section BEGIN
if (_context.isLogEnabled()) {
// manage log
Logger.info(_sql);
// log for where parameters -- BEGIN
int _whereParamCounter = 0;
for (String _whereParamItem : _contentValues.whereArgs()) {
Logger.info("==> param%s: '%s'", (_whereParamCounter++), StringUtils.checkSize(_whereParamItem));
}
// log for where parameters -- END
}
// log section END
try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
// log section BEGIN
if (_context.isLogEnabled()) {
Logger.info("Rows found: %s", _cursor.getCount());
}
// log section END
Employee resultBean = null;
if (_cursor.moveToFirst()) {
int index0 = _cursor.getColumnIndex("id");
int index1 = _cursor.getColumnIndex("last_name");
int index2 = _cursor.getColumnIndex("first_name");
int index3 = _cursor.getColumnIndex("birth_date");
int index4 = _cursor.getColumnIndex("hire_date");
int index5 = _cursor.getColumnIndex("address");
TypeAdapterAddress addressAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterAddress.class);
int index6 = _cursor.getColumnIndex("field_boolean");
TypeAdapterBoolean fieldBooleanAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterBoolean.class);
int index7 = _cursor.getColumnIndex("field_byte");
TypeAdapterByte fieldByteAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByte.class);
int index8 = _cursor.getColumnIndex("field_character");
TypeAdapterChar fieldCharacterAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterChar.class);
int index9 = _cursor.getColumnIndex("field_short");
TypeAdapterShort fieldShortAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterShort.class);
int index10 = _cursor.getColumnIndex("field_integer");
TypeAdapterInteger fieldIntegerAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterInteger.class);
int index11 = _cursor.getColumnIndex("field_long");
TypeAdapterLong fieldLongAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterLong.class);
int index12 = _cursor.getColumnIndex("field_float");
TypeAdapterFloat fieldFloatAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterFloat.class);
int index13 = _cursor.getColumnIndex("field_double");
TypeAdapterDouble fieldDoubleAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterDouble.class);
int index14 = _cursor.getColumnIndex("field_string");
TypeAdapterString fieldStringAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterString.class);
int index15 = _cursor.getColumnIndex("field_byte_array");
TypeAdapterByteArray fieldByteArrayAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByteArray.class);
resultBean = new Employee();
resultBean.id = _cursor.getLong(index0);
if (!_cursor.isNull(index1)) {
resultBean.lastName = _cursor.getString(index1);
}
if (!_cursor.isNull(index2)) {
resultBean.firstName = _cursor.getString(index2);
}
if (!_cursor.isNull(index3)) {
resultBean.birthDate = SQLDateUtils.read(_cursor.getString(index3));
}
if (!_cursor.isNull(index4)) {
resultBean.hireDate = SQLDateUtils.read(_cursor.getString(index4));
}
if (!_cursor.isNull(index5)) {
resultBean.address = addressAdapter.toJava(_cursor.getString(index5));
}
if (!_cursor.isNull(index6)) {
resultBean.fieldBoolean = fieldBooleanAdapter.toJava(_cursor.getInt(index6) == 0 ? false : true);
}
if (!_cursor.isNull(index7)) {
resultBean.fieldByte = fieldByteAdapter.toJava((byte) _cursor.getInt(index7));
}
if (!_cursor.isNull(index8)) {
resultBean.fieldCharacter = fieldCharacterAdapter.toJava((char) _cursor.getInt(index8));
}
if (!_cursor.isNull(index9)) {
resultBean.fieldShort = fieldShortAdapter.toJava(_cursor.getShort(index9));
}
if (!_cursor.isNull(index10)) {
resultBean.fieldInteger = fieldIntegerAdapter.toJava(_cursor.getInt(index10));
}
if (!_cursor.isNull(index11)) {
resultBean.fieldLong = fieldLongAdapter.toJava(_cursor.getLong(index11));
}
if (!_cursor.isNull(index12)) {
resultBean.fieldFloat = fieldFloatAdapter.toJava(_cursor.getFloat(index12));
}
if (!_cursor.isNull(index13)) {
resultBean.fieldDouble = fieldDoubleAdapter.toJava(_cursor.getDouble(index13));
}
if (!_cursor.isNull(index14)) {
resultBean.fieldString = fieldStringAdapter.toJava(_cursor.getString(index14));
}
if (!_cursor.isNull(index15)) {
resultBean.fieldByteArray = fieldByteArrayAdapter.toJava(_cursor.getBlob(index15));
}
}
return resultBean;
}
}
use of sqlite.feature.typeadapter.kripton180.adapters.TypeAdapterByte in project kripton by xcesco.
the class EmployeeRawDaoImpl method selectById.
/**
* <h2>Select SQL:</h2>
*
* <pre>SELECT id, last_name, first_name, birth_date, hire_date, address, field_boolean, field_byte, field_character, field_short, field_integer, field_long, field_float, field_double, field_string, field_byte_array FROM employees WHERE id=${id}</pre>
*
* <h2>Projected columns:</h2>
* <dl>
* <dt>id</dt><dd>is associated to bean's property <strong>id</strong></dd>
* <dt>last_name</dt><dd>is associated to bean's property <strong>lastName</strong></dd>
* <dt>first_name</dt><dd>is associated to bean's property <strong>firstName</strong></dd>
* <dt>birth_date</dt><dd>is associated to bean's property <strong>birthDate</strong></dd>
* <dt>hire_date</dt><dd>is associated to bean's property <strong>hireDate</strong></dd>
* <dt>address</dt><dd>is associated to bean's property <strong>address</strong></dd>
* <dt>field_boolean</dt><dd>is associated to bean's property <strong>fieldBoolean</strong></dd>
* <dt>field_byte</dt><dd>is associated to bean's property <strong>fieldByte</strong></dd>
* <dt>field_character</dt><dd>is associated to bean's property <strong>fieldCharacter</strong></dd>
* <dt>field_short</dt><dd>is associated to bean's property <strong>fieldShort</strong></dd>
* <dt>field_integer</dt><dd>is associated to bean's property <strong>fieldInteger</strong></dd>
* <dt>field_long</dt><dd>is associated to bean's property <strong>fieldLong</strong></dd>
* <dt>field_float</dt><dd>is associated to bean's property <strong>fieldFloat</strong></dd>
* <dt>field_double</dt><dd>is associated to bean's property <strong>fieldDouble</strong></dd>
* <dt>field_string</dt><dd>is associated to bean's property <strong>fieldString</strong></dd>
* <dt>field_byte_array</dt><dd>is associated to bean's property <strong>fieldByteArray</strong></dd>
* </dl>
*
* <h2>Query's parameters:</h2>
* <dl>
* <dt>${id}</dt><dd>is binded to method's parameter <strong>id</strong></dd>
* </dl>
*
* @param id
* is binded to <code>${id}</code>
* @return selected bean or <code>null</code>.
*/
@Override
public Employee selectById(long id) {
KriptonContentValues _contentValues = contentValues();
// query SQL is statically defined
String _sql = SELECT_BY_ID_SQL1;
// add where arguments
_contentValues.addWhereArgs(String.valueOf(id));
String[] _sqlArgs = _contentValues.whereArgsAsArray();
// log section BEGIN
if (_context.isLogEnabled()) {
// manage log
Logger.info(_sql);
// log for where parameters -- BEGIN
int _whereParamCounter = 0;
for (String _whereParamItem : _contentValues.whereArgs()) {
Logger.info("==> param%s: '%s'", (_whereParamCounter++), StringUtils.checkSize(_whereParamItem));
}
// log for where parameters -- END
}
// log section END
try (Cursor _cursor = database().rawQuery(_sql, _sqlArgs)) {
// log section BEGIN
if (_context.isLogEnabled()) {
Logger.info("Rows found: %s", _cursor.getCount());
}
// log section END
Employee resultBean = null;
if (_cursor.moveToFirst()) {
int index0 = _cursor.getColumnIndex("id");
int index1 = _cursor.getColumnIndex("last_name");
int index2 = _cursor.getColumnIndex("first_name");
int index3 = _cursor.getColumnIndex("birth_date");
int index4 = _cursor.getColumnIndex("hire_date");
int index5 = _cursor.getColumnIndex("address");
TypeAdapterAddress addressAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterAddress.class);
int index6 = _cursor.getColumnIndex("field_boolean");
TypeAdapterBoolean fieldBooleanAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterBoolean.class);
int index7 = _cursor.getColumnIndex("field_byte");
TypeAdapterByte fieldByteAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByte.class);
int index8 = _cursor.getColumnIndex("field_character");
TypeAdapterChar fieldCharacterAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterChar.class);
int index9 = _cursor.getColumnIndex("field_short");
TypeAdapterShort fieldShortAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterShort.class);
int index10 = _cursor.getColumnIndex("field_integer");
TypeAdapterInteger fieldIntegerAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterInteger.class);
int index11 = _cursor.getColumnIndex("field_long");
TypeAdapterLong fieldLongAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterLong.class);
int index12 = _cursor.getColumnIndex("field_float");
TypeAdapterFloat fieldFloatAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterFloat.class);
int index13 = _cursor.getColumnIndex("field_double");
TypeAdapterDouble fieldDoubleAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterDouble.class);
int index14 = _cursor.getColumnIndex("field_string");
TypeAdapterString fieldStringAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterString.class);
int index15 = _cursor.getColumnIndex("field_byte_array");
TypeAdapterByteArray fieldByteArrayAdapter = SQLTypeAdapterUtils.getAdapter(TypeAdapterByteArray.class);
resultBean = new Employee();
resultBean.id = _cursor.getLong(index0);
if (!_cursor.isNull(index1)) {
resultBean.lastName = _cursor.getString(index1);
}
if (!_cursor.isNull(index2)) {
resultBean.firstName = _cursor.getString(index2);
}
if (!_cursor.isNull(index3)) {
resultBean.birthDate = SQLDateUtils.read(_cursor.getString(index3));
}
if (!_cursor.isNull(index4)) {
resultBean.hireDate = SQLDateUtils.read(_cursor.getString(index4));
}
if (!_cursor.isNull(index5)) {
resultBean.address = addressAdapter.toJava(_cursor.getString(index5));
}
if (!_cursor.isNull(index6)) {
resultBean.fieldBoolean = fieldBooleanAdapter.toJava(_cursor.getInt(index6) == 0 ? false : true);
}
if (!_cursor.isNull(index7)) {
resultBean.fieldByte = fieldByteAdapter.toJava((byte) _cursor.getInt(index7));
}
if (!_cursor.isNull(index8)) {
resultBean.fieldCharacter = fieldCharacterAdapter.toJava((char) _cursor.getInt(index8));
}
if (!_cursor.isNull(index9)) {
resultBean.fieldShort = fieldShortAdapter.toJava(_cursor.getShort(index9));
}
if (!_cursor.isNull(index10)) {
resultBean.fieldInteger = fieldIntegerAdapter.toJava(_cursor.getInt(index10));
}
if (!_cursor.isNull(index11)) {
resultBean.fieldLong = fieldLongAdapter.toJava(_cursor.getLong(index11));
}
if (!_cursor.isNull(index12)) {
resultBean.fieldFloat = fieldFloatAdapter.toJava(_cursor.getFloat(index12));
}
if (!_cursor.isNull(index13)) {
resultBean.fieldDouble = fieldDoubleAdapter.toJava(_cursor.getDouble(index13));
}
if (!_cursor.isNull(index14)) {
resultBean.fieldString = fieldStringAdapter.toJava(_cursor.getString(index14));
}
if (!_cursor.isNull(index15)) {
resultBean.fieldByteArray = fieldByteArrayAdapter.toJava(_cursor.getBlob(index15));
}
}
return resultBean;
}
}
Aggregations