Java Code Examples for com.j256.ormlite.field.FieldType#createFieldType()

The following examples show how to use com.j256.ormlite.field.FieldType#createFieldType() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: HsqldbDatabaseTypeTest.java From ormlite-jdbc with ISC License

6 votes

@Test(expected = IllegalStateException.class)
public void testBadGeneratedId() throws Exception {
	Field field = GeneratedId.class.getField("id");
	DatabaseType databaseType = createMock(DatabaseType.class);
	expect(databaseType.isIdSequenceNeeded()).andReturn(false);
	DataPersister dataPersister = createMock(DataPersister.class);
	expect(databaseType.getDataPersister(isA(DataPersister.class), isA(FieldType.class))).andReturn(dataPersister);
	expect(databaseType.getFieldConverter(isA(DataPersister.class), isA(FieldType.class))).andReturn(dataPersister);
	expect(databaseType.isEntityNamesMustBeUpCase()).andReturn(true);
	expect(databaseType.upCaseEntityName("id")).andReturn("ID");
	replay(databaseType);
	connectionSource.setDatabaseType(databaseType);
	try {
		FieldType fieldType = FieldType.createFieldType(databaseType, "foo", field, GeneratedId.class);
		verify(databaseType);
		StringBuilder sb = new StringBuilder();
		List<String> statementsBefore = new ArrayList<String>();
		databaseType.appendColumnArg(null, sb, fieldType, null, statementsBefore, null, null);
	} finally {
		connectionSource.setDatabaseType(databaseType);
	}
}

Example 2

Source File: SerializableTypeTest.java From ormlite-core with ISC License

6 votes

@Test
public void testSerializableNoValue() throws Exception {
	Class<LocalSerializable> clazz = LocalSerializable.class;
	Dao<LocalSerializable, Object> dao = createDao(clazz, true);
	LocalSerializable foo = new LocalSerializable();
	foo.serializable = null;
	assertEquals(1, dao.create(foo));
	DatabaseConnection conn = connectionSource.getReadOnlyConnection(TABLE_NAME);
	CompiledStatement stmt = null;
	try {
		stmt = conn.compileStatement("select * from " + TABLE_NAME, StatementType.SELECT, noFieldTypes,
				DatabaseConnection.DEFAULT_RESULT_FLAGS, true);
		DatabaseResults results = stmt.runQuery(null);
		assertTrue(results.next());
		FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME,
				clazz.getDeclaredField(SERIALIZABLE_COLUMN), clazz);
		assertNull(DataType.SERIALIZABLE.getDataPersister().resultToJava(fieldType, results,
				results.findColumn(SERIALIZABLE_COLUMN)));
	} finally {
		if (stmt != null) {
			stmt.close();
		}
		connectionSource.releaseConnection(conn);
	}
}

Example 3

Source File: BaseCoreStmtTest.java From ormlite-core with ISC License

6 votes

@Override
@Before
public void before() throws Exception {
	super.before();

	Field field = Foo.class.getDeclaredField("stringField");
	assertEquals(String.class, field.getType());
	stringFieldType = FieldType.createFieldType(databaseType, "BaseFoo", field, Foo.class);
	stringFieldType.configDaoInformation(connectionSource, Foo.class);
	field = Foo.class.getDeclaredField("val");
	assertEquals(int.class, field.getType());
	numberFieldType = FieldType.createFieldType(databaseType, "BaseFoo", field, Foo.class);
	numberFieldType.configDaoInformation(connectionSource, Foo.class);
	field = Foreign.class.getDeclaredField("foo");
	assertEquals(Foo.class, field.getType());
	foreignFieldType = FieldType.createFieldType(databaseType, "BaseFoo", field, Foreign.class);
	foreignFieldType.configDaoInformation(connectionSource, Foreign.class);

	baseFooTableInfo = new TableInfo<Foo, Integer>(databaseType, Foo.class);
	baseSchemaFooTableInfo = new TableInfo<SchemaFoo, Integer>(databaseType, SchemaFoo.class);
}

Example 4

Source File: OracleDatabaseTypeTest.java From ormlite-jdbc with ISC License

6 votes

@Test(expected = IllegalStateException.class)
public void testBadGeneratedId() throws Exception {
	Field field = GeneratedId.class.getField("id");
	DatabaseType mockDb = createMock(DatabaseType.class);
	expect(mockDb.isIdSequenceNeeded()).andReturn(false);
	DataPersister dataPersister = createMock(DataPersister.class);
	expect(mockDb.getDataPersister(isA(DataPersister.class), isA(FieldType.class))).andReturn(dataPersister);
	expect(mockDb.getFieldConverter(isA(DataPersister.class), isA(FieldType.class))).andReturn(dataPersister);
	expect(mockDb.isEntityNamesMustBeUpCase()).andReturn(false);
	replay(mockDb);
	FieldType fieldType = FieldType.createFieldType(mockDb, "foo", field, GeneratedId.class);
	verify(mockDb);
	StringBuilder sb = new StringBuilder();
	List<String> statementsBefore = new ArrayList<String>();
	databaseType.appendColumnArg(null, sb, fieldType, null, statementsBefore, null, null);
}

Example 5

Source File: BaseMappedQueryTest.java From ormlite-core with ISC License

6 votes

@Test
public void testMappedQuery() throws Exception {
	Field field = Foo.class.getDeclaredField(Foo.ID_COLUMN_NAME);
	String tableName = "basefoo";
	Dao<Foo, Integer> dao = createDao(Foo.class, false);
	FieldType[] resultFieldTypes =
			new FieldType[] { FieldType.createFieldType(databaseType, tableName, field, Foo.class) };
	BaseMappedQuery<Foo, Integer> baseMappedQuery = new BaseMappedQuery<Foo, Integer>(dao, baseFooTableInfo,
			"select * from " + tableName, new FieldType[0], resultFieldTypes) {
	};
	DatabaseResults results = createMock(DatabaseResults.class);
	int colN = 1;
	expect(results.getObjectCacheForRetrieve()).andReturn(null);
	expect(results.getObjectCacheForStore()).andReturn(null);
	expect(results.findColumn(Foo.ID_COLUMN_NAME)).andReturn(colN);
	int id = 63365;
	expect(results.getInt(colN)).andReturn(id);
	replay(results);
	Foo baseFoo = baseMappedQuery.mapRow(results);
	assertNotNull(baseFoo);
	assertEquals(id, baseFoo.id);
	verify(results);
}

Example 6

Source File: WhereTest.java From ormlite-core with ISC License

5 votes

@Test
public void testToString() throws Exception {
	Where<Foo, String> where = new Where<Foo, String>(createTableInfo(), null, databaseType);
	assertTrue(where.toString().contains("empty where clause"));
	String value = "bar";
	FieldType numberFieldType = FieldType.createFieldType(databaseType, "foo",
			Foo.class.getDeclaredField(Foo.VAL_COLUMN_NAME), Foo.class);
	SimpleComparison eq =
			new SimpleComparison(Foo.VAL_COLUMN_NAME, numberFieldType, value, SimpleComparison.EQUAL_TO_OPERATION);
	where.eq(Foo.VAL_COLUMN_NAME, value);
	assertTrue(where.toString().contains(eq.toString()));
}

Example 7

Source File: BaseCoreDatabaseTypeTest.java From ormlite-core with ISC License

5 votes

@Test
public void testBooleanConverterResultToJava() throws Exception {
	DatabaseResults results = createMock(DatabaseResults.class);
	boolean first = Boolean.TRUE;
	boolean second = Boolean.FALSE;
	expect(results.getByte(1)).andReturn((byte) 1);
	expect(results.getByte(2)).andReturn((byte) 0);
	replay(results);
	FieldType fieldType = FieldType.createFieldType(databaseType, "foo", ManyFields.class.getDeclaredField("bool"),
			ManyFields.class);
	assertEquals(first, booleanFieldConverter.resultToJava(fieldType, results, 1));
	assertEquals(second, booleanFieldConverter.resultToJava(fieldType, results, 2));
	verify(results);
}

Example 8

Source File: BaseMappedQueryTest.java From ormlite-core with ISC License

5 votes

@Test
public void testMappedQueryCached() throws Exception {
	Field field = Foo.class.getDeclaredField(Foo.ID_COLUMN_NAME);
	String tableName = "basefoo";
	FieldType[] resultFieldTypes =
			new FieldType[] { FieldType.createFieldType(databaseType, tableName, field, Foo.class) };
	Dao<Foo, Integer> dao = createDao(Foo.class, false);
	BaseMappedQuery<Foo, Integer> baseMappedQuery = new BaseMappedQuery<Foo, Integer>(dao, baseFooTableInfo,
			"select * from " + tableName, new FieldType[0], resultFieldTypes) {
	};
	DatabaseResults results = createMock(DatabaseResults.class);
	int colN = 1;
	ObjectCache objectCache = createMock(ObjectCache.class);
	expect(results.getObjectCacheForRetrieve()).andReturn(objectCache);
	int id = 63365;
	expect(results.getInt(colN)).andReturn(id);
	expect(objectCache.get(Foo.class, id)).andReturn(null);
	objectCache.put(eq(Foo.class), eq(id), isA(Foo.class));
	expect(results.getObjectCacheForStore()).andReturn(objectCache);
	expect(results.findColumn(Foo.ID_COLUMN_NAME)).andReturn(colN);
	expect(results.getInt(colN)).andReturn(id);

	replay(results, objectCache);
	Foo baseFoo = baseMappedQuery.mapRow(results);
	assertNotNull(baseFoo);
	assertEquals(id, baseFoo.id);
	verify(results, objectCache);
}

Example 9

Source File: PostgresDatabaseTypeTest.java From ormlite-jdbc with ISC License

5 votes

@Test
public void testDropSequence() throws Exception {
	if (connectionSource == null) {
		return;
	}
	Field field = GeneratedId.class.getField("id");
	FieldType fieldType = FieldType.createFieldType(databaseType, "foo", field, GeneratedId.class);
	List<String> statementsBefore = new ArrayList<String>();
	List<String> statementsAfter = new ArrayList<String>();
	databaseType.dropColumnArg(fieldType, statementsBefore, statementsAfter);
	assertEquals(0, statementsBefore.size());
	assertEquals(1, statementsAfter.size());
	assertTrue(statementsAfter.get(0).contains("DROP SEQUENCE "));
}

Example 10

Source File: BaseSqliteDatabaseTypeTest.java From ormlite-core with ISC License

5 votes

@Test(expected = IllegalArgumentException.class)
public void testConfigureGeneratedIdNotInteger() throws Exception {
	Field field = Foo.class.getField("stringField");
	FieldType fieldType = FieldType.createFieldType(databaseType, "foo", field, Foo.class);
	OurSqliteDatabaseType dbType = new OurSqliteDatabaseType();
	StringBuilder sb = new StringBuilder();
	dbType.configureGeneratedId(null, sb, fieldType, new ArrayList<String>(), null, new ArrayList<String>(),
			new ArrayList<String>());
}

Example 11

Source File: BaseCoreDatabaseTypeTest.java From ormlite-core with ISC License

5 votes

private void testFooColumn(DatabaseType databaseType, String fieldName, String expected) throws Exception {
	StringBuilder sb = new StringBuilder();
	List<String> additionalArgs = new ArrayList<String>();
	List<String> stmtsBefore = new ArrayList<String>();
	List<String> stmtsAfter = new ArrayList<String>();
	List<String> queriesAfter = new ArrayList<String>();
	FieldType fieldType = FieldType.createFieldType(databaseType, "foo",
			ManyFields.class.getDeclaredField(fieldName), ManyFields.class);
	databaseType.appendColumnArg(null, sb, fieldType, additionalArgs, stmtsBefore, stmtsAfter, queriesAfter);
	StringBuilder expectedSb = new StringBuilder();
	databaseType.appendEscapedEntityName(expectedSb, fieldName);
	expectedSb.append(' ').append(expected).append(' ');
	assertEquals(expectedSb.toString(), sb.toString());
}

Example 12

Source File: OracleDatabaseTypeTest.java From ormlite-jdbc with ISC License

5 votes

@Test
public void testDropSequence() throws Exception {
	Field field = GeneratedId.class.getField("id");
	FieldType fieldType = FieldType.createFieldType(databaseType, "foo", field, GeneratedId.class);
	List<String> statementsBefore = new ArrayList<String>();
	List<String> statementsAfter = new ArrayList<String>();
	databaseType.dropColumnArg(fieldType, statementsBefore, statementsAfter);
	assertEquals(0, statementsBefore.size());
	assertEquals(1, statementsAfter.size());
	assertTrue(statementsAfter.get(0).contains("DROP SEQUENCE "));
}

Example 13

Source File: SqlDateTypeTest.java From ormlite-core with ISC License

4 votes

@Test(expected = SQLException.class)
public void testSqlDateParseInvalid() throws Exception {
	FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME,
			LocalDate.class.getDeclaredField(DATE_COLUMN), LocalDate.class);
	dataType.getDataPersister().parseDefaultString(fieldType, "not valid date string");
}

Example 14

Source File: BaseTypeTest.java From ormlite-core with ISC License

4 votes

protected <T, ID> void testType(Dao<T, ID> dao, T foo, Class<T> clazz, Object javaVal, Object defaultSqlVal,
		Object sqlArg, String defaultValStr, DataType dataType, String columnName, boolean isValidGeneratedType,
		boolean isAppropriateId, boolean isEscapedValue, boolean isPrimitive, boolean isSelectArgRequired,
		boolean isStreamType, boolean isComparable, boolean isConvertableId) throws Exception {
	DataPersister dataPersister = dataType.getDataPersister();
	DatabaseConnection conn = connectionSource.getReadOnlyConnection(TABLE_NAME);
	CompiledStatement stmt = null;
	if (sqlArg != null) {
		assertEquals(defaultSqlVal.getClass(), sqlArg.getClass());
	}
	try {
		stmt = conn.compileStatement("select * from " + TABLE_NAME, StatementType.SELECT, noFieldTypes,
				DatabaseConnection.DEFAULT_RESULT_FLAGS, true);
		DatabaseResults results = stmt.runQuery(null);
		assertTrue(results.next());
		int colNum = results.findColumn(columnName);
		Field field = clazz.getDeclaredField(columnName);
		FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME, field, clazz);
		assertEquals(dataType.getDataPersister(), fieldType.getDataPersister());
		Class<?>[] classes = fieldType.getDataPersister().getAssociatedClasses();
		if (classes.length > 0) {
			assertTrue(classes[0].isAssignableFrom(fieldType.getType()));
		}
		assertTrue(fieldType.getDataPersister().isValidForField(field));
		if (javaVal instanceof byte[]) {
			assertTrue(Arrays.equals((byte[]) javaVal,
					(byte[]) dataPersister.resultToJava(fieldType, results, colNum)));
		} else {
			Map<String, Integer> colMap = new HashMap<String, Integer>();
			colMap.put(columnName, colNum);
			Object result = fieldType.resultToJava(results, colMap);
			assertEquals(javaVal, result);
		}
		if (dataType == DataType.SERIALIZABLE) {
			try {
				dataPersister.parseDefaultString(fieldType, "");
				fail("parseDefaultString should have thrown for " + dataType);
			} catch (SQLException e) {
				// expected
			}
		} else if (defaultValStr != null) {
			Object parsedDefault = dataPersister.parseDefaultString(fieldType, defaultValStr);
			assertEquals(defaultSqlVal.getClass(), parsedDefault.getClass());
			if (dataType == DataType.BYTE_ARRAY || dataType == DataType.STRING_BYTES) {
				assertTrue(Arrays.equals((byte[]) defaultSqlVal, (byte[]) parsedDefault));
			} else {
				assertEquals(defaultSqlVal, parsedDefault);
			}
		}
		if (sqlArg == null) {
			// noop
		} else if (sqlArg instanceof byte[]) {
			assertTrue(Arrays.equals((byte[]) sqlArg, (byte[]) dataPersister.javaToSqlArg(fieldType, javaVal)));
		} else {
			assertEquals(sqlArg, dataPersister.javaToSqlArg(fieldType, javaVal));
		}
		assertEquals(isValidGeneratedType, dataPersister.isValidGeneratedType());
		assertEquals(isAppropriateId, dataPersister.isAppropriateId());
		assertEquals(isEscapedValue, dataPersister.isEscapedValue());
		assertEquals(isEscapedValue, dataPersister.isEscapedDefaultValue());
		assertEquals(isPrimitive, dataPersister.isPrimitive());
		assertEquals(isSelectArgRequired, dataPersister.isArgumentHolderRequired());
		assertEquals(isStreamType, dataPersister.isStreamType());
		assertEquals(isComparable, dataPersister.isComparable());
		if (isConvertableId) {
			assertNotNull(dataPersister.convertIdNumber(10));
		} else {
			assertNull(dataPersister.convertIdNumber(10));
		}
		List<T> list = dao.queryForAll();
		assertEquals(1, list.size());
		assertTrue(dao.objectsEqual(foo, list.get(0)));
		// if we have a value then look for it, floats don't find any results because of rounding issues
		if (javaVal != null && dataPersister.isComparable() && dataType != DataType.FLOAT
				&& dataType != DataType.FLOAT_OBJ) {
			// test for inline arguments
			list = dao.queryForMatching(foo);
			assertEquals(1, list.size());
			assertTrue(dao.objectsEqual(foo, list.get(0)));
			// test for SelectArg arguments
			list = dao.queryForMatchingArgs(foo);
			assertEquals(1, list.size());
			assertTrue(dao.objectsEqual(foo, list.get(0)));
		}
		if (dataType == DataType.STRING_BYTES || dataType == DataType.BYTE_ARRAY
				|| dataType == DataType.SERIALIZABLE) {
			// no converting from string to value
		} else {
			// test string conversion
			String stringVal = results.getString(colNum);
			Object convertedJavaVal = fieldType.convertStringToJavaField(stringVal, 0);
			assertEquals(javaVal, convertedJavaVal);
		}
	} finally {
		if (stmt != null) {
			stmt.close();
		}
		connectionSource.releaseConnection(conn);
	}
}

Example 15

Source File: DateLongTypeTest.java From ormlite-core with ISC License

4 votes

@Test(expected = SQLException.class)
public void testDateLongParseInvalid() throws Exception {
	FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME,
			LocalDateLong.class.getDeclaredField(DATE_COLUMN), LocalDateLong.class);
	DataType.DATE_LONG.getDataPersister().parseDefaultString(fieldType, "not valid long number");
}

Example 16

Source File: DateIntegerTypeTest.java From ormlite-core with ISC License

4 votes

@Test(expected = SQLException.class)
public void testDateIntegerParseInvalid() throws Exception {
	FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME,
			LocalDateInteger.class.getDeclaredField(DATE_COLUMN), LocalDateInteger.class);
	DataType.DATE_INTEGER.getDataPersister().parseDefaultString(fieldType, "not valid int number");
}

Example 17

Source File: DateTypeTest.java From ormlite-core with ISC License

4 votes

@Test(expected = SQLException.class)
public void testDateParseInvalid() throws Exception {
	FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME,
			LocalDate.class.getDeclaredField(DATE_COLUMN), LocalDate.class);
	DataType.DATE.getDataPersister().parseDefaultString(fieldType, "not valid date string");
}

Example 18

Source File: DateTypeTest.java From ormlite-core with ISC License

4 votes

@Test(expected = IllegalArgumentException.class)
public void testInvalidDateField() throws Exception {
	FieldType.createFieldType(databaseType, TABLE_NAME, InvalidDate.class.getDeclaredField("notDate"),
			LocalDate.class);
}

Example 19

Source File: DateStringTypeTest.java From ormlite-core with ISC License

4 votes

@Test(expected = SQLException.class)
public void testDateStringParseInvalid() throws Exception {
	FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME,
			LocalDateString.class.getDeclaredField(DATE_COLUMN), LocalDateString.class);
	DataType.DATE_STRING.getDataPersister().parseDefaultString(fieldType, "not valid date string");
}

Example 20

Source File: TimeStampTypeTest.java From ormlite-core with ISC License

4 votes

@Test(expected = SQLException.class)
public void testTimeStampParseInvalid() throws Exception {
	FieldType fieldType = FieldType.createFieldType(databaseType, TABLE_NAME,
			LocalTimeStamp.class.getDeclaredField(TIME_STAMP_COLUMN), LocalTimeStamp.class);
	dataType.getDataPersister().parseDefaultString(fieldType, "not valid date string");
}