/*
* Copyright 2010-2012 Luca Garulli (l.garulli--at--orientechnologies.com)
*
* 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.orientechnologies.orient.test.database.auto;
import java.io.File;
import java.io.IOException;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.List;
import org.testng.Assert;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.Optional;
import org.testng.annotations.Parameters;
import org.testng.annotations.Test;
import com.orientechnologies.orient.client.db.ODatabaseHelper;
import com.orientechnologies.orient.client.remote.OEngineRemote;
import com.orientechnologies.orient.core.command.OCommandOutputListener;
import com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx;
import com.orientechnologies.orient.core.db.tool.ODatabaseExport;
import com.orientechnologies.orient.core.db.tool.ODatabaseImport;
import com.orientechnologies.orient.core.hook.ORecordHook;
import com.orientechnologies.orient.core.metadata.schema.OClass;
import com.orientechnologies.orient.core.metadata.schema.OProperty;
import com.orientechnologies.orient.core.metadata.schema.OType;
import com.orientechnologies.orient.core.record.impl.ODocument;
import com.orientechnologies.orient.core.sql.OCommandSQL;
import com.orientechnologies.orient.core.sql.query.OSQLSynchQuery;
import com.orientechnologies.orient.object.db.OObjectDatabaseTx;
import com.orientechnologies.orient.object.enhancement.OObjectEntitySerializer;
import com.orientechnologies.orient.object.iterator.OObjectIteratorCluster;
import com.orientechnologies.orient.test.domain.base.IdObject;
import com.orientechnologies.orient.test.domain.base.Instrument;
import com.orientechnologies.orient.test.domain.base.Musician;
import com.orientechnologies.orient.test.domain.business.Account;
import com.orientechnologies.orient.test.domain.business.Address;
import com.orientechnologies.orient.test.domain.business.City;
import com.orientechnologies.orient.test.domain.business.Company;
import com.orientechnologies.orient.test.domain.business.Country;
import com.orientechnologies.orient.test.domain.inheritance.InheritanceTestAbstractClass;
import com.orientechnologies.orient.test.domain.inheritance.InheritanceTestBaseClass;
import com.orientechnologies.orient.test.domain.inheritance.InheritanceTestClass;
import com.orientechnologies.orient.test.domain.schemageneration.JavaTestSchemaGeneration;
import com.orientechnologies.orient.test.domain.schemageneration.TestSchemaGenerationChild;
@Test(groups = { "crud", "object", "schemafull", "inheritanceSchemaFull" })
public class CRUDObjectInheritanceTestSchemaFull extends ObjectDBBaseTest {
protected static final int TOT_RECORDS = 10;
public static final String buildDirectory = System.getProperty("buildDirectory", ".");
public static final String EXPORT_DIR = buildDirectory + File.separator + "objectSchemaTest/database.export.gz";
protected long startRecordNumber;
private City redmond = new City(new Country("Washington"), "Redmond");
@Parameters(value = "url")
public CRUDObjectInheritanceTestSchemaFull(@Optional String url) {
super(url);
}
@BeforeClass
public void beforeClass() throws Exception {
super.beforeClass();
database.close();
database = new OObjectDatabaseTx(url + "_objectschema");
ODatabaseHelper.createDatabase(database, url + "_objectschema", getStorageType());
database.close();
try {
ODatabaseDocumentTx exportDatabase = new ODatabaseDocumentTx(url);
exportDatabase.open("admin", "admin");
OCommandOutputListener listener = new OCommandOutputListener() {
@Override
public void onMessage(String iText) {
}
};
ODatabaseExport export = new ODatabaseExport(exportDatabase, EXPORT_DIR, listener);
export.exportDatabase();
export.close();
exportDatabase.close();
ODatabaseDocumentTx importDatabase = new ODatabaseDocumentTx(url + "_objectschema");
importDatabase.open("admin", "admin");
ODatabaseImport impor = new ODatabaseImport(importDatabase, EXPORT_DIR, listener);
// UNREGISTER ALL THE HOOKS
for (ORecordHook hook : new ArrayList<ORecordHook>(importDatabase.getHooks().keySet())) {
importDatabase.unregisterHook(hook);
}
impor.setDeleteRIDMapping(true);
impor.importDatabase();
impor.close();
importDatabase.close();
final File importDir = new File(EXPORT_DIR);
importDir.delete();
} catch (IOException e) {
Assert.fail("Export import didn't go as expected", e);
}
database.open("admin", "admin");
if (database.getMetadata().getSchema().existsClass("Company"))
database.command(new OCommandSQL("delete from Company")).execute();
if (database.getMetadata().getSchema().existsClass("Account"))
database.command(new OCommandSQL("delete from Account")).execute();
if (database.getMetadata().getSchema().existsClass("JavaComplexTestClass"))
database.command(new OCommandSQL("delete from JavaComplexTestClass")).execute();
if (database.getMetadata().getSchema().existsClass("Profile"))
database.command(new OCommandSQL("delete from Profile")).execute();
if (database.getMetadata().getSchema().existsClass("IdentityChild"))
database.command(new OCommandSQL("delete from IdentityChild")).execute();
database.close();
}
@Test
public void create() {
database.getMetadata().getSchema().synchronizeSchema();
database.setAutomaticSchemaGeneration(true);
database.getEntityManager().registerEntityClasses("com.orientechnologies.orient.test.domain.business");
if (url.startsWith(OEngineRemote.NAME)) {
database.getMetadata().reload();
}
database.getEntityManager().registerEntityClasses("com.orientechnologies.orient.test.domain.base");
if (url.startsWith(OEngineRemote.NAME)) {
database.getMetadata().reload();
}
startRecordNumber = database.countClusterElements("Company");
Company company;
for (long i = startRecordNumber; i < startRecordNumber + TOT_RECORDS; ++i) {
company = database.newInstance(Company.class, (int) i, "Microsoft" + i);
company.setEmployees((int) (100000 + i));
company.getAddresses().add(new Address("Headquarter", redmond, "WA 98073-9717"));
database.save(company);
}
}
@Test(dependsOnMethods = "create")
public void testCreate() {
database.setAutomaticSchemaGeneration(true);
Assert.assertEquals(database.countClusterElements("Company") - startRecordNumber, TOT_RECORDS);
}
@Test(dependsOnMethods = "testCreate")
public void queryByBaseType() {
database.setAutomaticSchemaGeneration(true);
final List<Account> result = database.query(new OSQLSynchQuery<Account>("select from Company where name.length() > 0"));
Assert.assertTrue(result.size() > 0);
Assert.assertEquals(result.size() - startRecordNumber, TOT_RECORDS);
int companyRecords = 0;
Account account;
for (int i = 0; i < result.size(); ++i) {
account = result.get(i);
if (account instanceof Company)
companyRecords++;
Assert.assertNotSame(account.getName().length(), 0);
}
Assert.assertEquals(companyRecords, TOT_RECORDS);
}
@Test(dependsOnMethods = "queryByBaseType")
public void queryPerSuperType() {
database.setAutomaticSchemaGeneration(true);
final List<Company> result = database.query(new OSQLSynchQuery<ODocument>("select * from Company where name.length() > 0"));
Assert.assertTrue(result.size() == TOT_RECORDS);
Company account;
for (int i = 0; i < result.size(); ++i) {
account = result.get(i);
Assert.assertNotSame(account.getName().length(), 0);
}
}
@Test(dependsOnMethods = "queryPerSuperType")
public void deleteFirst() {
database.setAutomaticSchemaGeneration(true);
startRecordNumber = database.countClusterElements("Company");
// DELETE ALL THE RECORD IN THE CLUSTER
OObjectIteratorCluster<Company> companyClusterIterator = database.browseCluster("Company");
for (Company obj : companyClusterIterator) {
if (obj.getId() == 1) {
database.delete(obj);
break;
}
}
Assert.assertEquals(database.countClusterElements("Company"), startRecordNumber - 1);
}
@Test(dependsOnMethods = "deleteFirst")
public void testSuperclassInheritanceCreation() {
database.setAutomaticSchemaGeneration(true);
database.getEntityManager().registerEntityClasses("com.orientechnologies.orient.test.domain.inheritance");
database.close();
database.open("admin", "admin");
OClass abstractClass = database.getMetadata().getSchema().getClass(InheritanceTestAbstractClass.class);
OClass baseClass = database.getMetadata().getSchema().getClass(InheritanceTestBaseClass.class);
OClass testClass = database.getMetadata().getSchema().getClass(InheritanceTestClass.class);
Assert.assertTrue(abstractClass.isAbstract());
Assert.assertEquals(abstractClass.getDefaultClusterId(), -1);
Assert.assertEquals(abstractClass.getClusterIds().length, 1);
Assert.assertEquals(abstractClass.getClusterIds()[0], -1);
Assert.assertEquals(baseClass.getSuperClass(), abstractClass);
Assert.assertEquals(baseClass.getSuperClass().getName(), abstractClass.getName());
Assert.assertEquals(testClass.getSuperClass(), baseClass);
Assert.assertEquals(testClass.getSuperClass().getName(), baseClass.getName());
}
@Test(dependsOnMethods = "testSuperclassInheritanceCreation")
public void testIdFieldInheritance() {
database.setAutomaticSchemaGeneration(true);
database.getEntityManager().registerEntityClass(Musician.class);
database.getEntityManager().registerEntityClass(Instrument.class);
database.getEntityManager().registerEntityClass(IdObject.class);
Field idField = OObjectEntitySerializer.getIdField(IdObject.class);
Assert.assertNotNull(idField);
Field musicianIdField = OObjectEntitySerializer.getIdField(Musician.class);
Assert.assertNotNull(musicianIdField);
Assert.assertEquals(idField, musicianIdField);
Field instrumentIdField = OObjectEntitySerializer.getIdField(Instrument.class);
Assert.assertNotNull(instrumentIdField);
Assert.assertEquals(idField, instrumentIdField);
Assert.assertEquals(instrumentIdField, musicianIdField);
}
@Test(dependsOnMethods = "testIdFieldInheritance")
public void testIdFieldInheritanceFirstSubClass() {
database.setAutomaticSchemaGeneration(true);
database.command(new OCommandSQL("delete from InheritanceTestBaseClass")).execute();
database.command(new OCommandSQL("delete from InheritanceTestClass")).execute();
database.getEntityManager().registerEntityClass(InheritanceTestClass.class);
database.getEntityManager().registerEntityClass(InheritanceTestBaseClass.class);
InheritanceTestBaseClass a = database.newInstance(InheritanceTestBaseClass.class);
InheritanceTestBaseClass b = database.newInstance(InheritanceTestClass.class);
database.save(a);
database.save(b);
final List<InheritanceTestBaseClass> result1 = database.query(new OSQLSynchQuery<InheritanceTestBaseClass>(
"select from InheritanceTestBaseClass"));
Assert.assertEquals(2, result1.size());
}
@Test(dependsOnMethods = "testIdFieldInheritanceFirstSubClass")
public void testSchemaGeneration() {
database.getMetadata().getSchema().generateSchema("com.orientechnologies.orient.test.domain.base");
if (url.startsWith(OEngineRemote.NAME)) {
database.getMetadata().reload();
}
OClass musicianClass = database.getMetadata().getSchema().getClass(Musician.class);
OClass instrumentClass = database.getMetadata().getSchema().getClass(Instrument.class);
checkNotExistsProperty(musicianClass, "id");
checkNotExistsProperty(musicianClass, "version");
checkNotExistsProperty(instrumentClass, "id");
checkNotExistsProperty(instrumentClass, "version");
checkProperty(musicianClass, "name", OType.STRING);
checkProperty(musicianClass, "instruments", OType.LINKLIST, instrumentClass);
}
@Test(dependsOnMethods = "testSchemaGeneration")
public void testAutomaticSchemaGeneration() {
database.setAutomaticSchemaGeneration(true);
database.getEntityManager().registerEntityClasses("com.orientechnologies.orient.test.domain.schemageneration");
if (url.startsWith(OEngineRemote.NAME)) {
database.getMetadata().reload();
}
OClass testSchemaClass = database.getMetadata().getSchema().getClass(JavaTestSchemaGeneration.class);
OClass childClass = database.getMetadata().getSchema().getClass(TestSchemaGenerationChild.class);
checkNotExistsProperty(testSchemaClass, "id");
checkNotExistsProperty(testSchemaClass, "version");
// Test simple types
checkProperty(testSchemaClass, "text", OType.STRING);
checkProperty(testSchemaClass, "enumeration", OType.STRING);
checkProperty(testSchemaClass, "numberSimple", OType.INTEGER);
checkProperty(testSchemaClass, "longSimple", OType.LONG);
checkProperty(testSchemaClass, "doubleSimple", OType.DOUBLE);
checkProperty(testSchemaClass, "floatSimple", OType.FLOAT);
checkProperty(testSchemaClass, "byteSimple", OType.BYTE);
checkProperty(testSchemaClass, "flagSimple", OType.BOOLEAN);
checkProperty(testSchemaClass, "dateField", OType.DATETIME);
// Test complex types
checkProperty(testSchemaClass, "stringListMap", OType.EMBEDDEDMAP, OType.EMBEDDEDLIST);
checkProperty(testSchemaClass, "enumList", OType.EMBEDDEDLIST, OType.STRING);
checkProperty(testSchemaClass, "enumSet", OType.EMBEDDEDSET, OType.STRING);
checkProperty(testSchemaClass, "stringSet", OType.EMBEDDEDSET, OType.STRING);
checkProperty(testSchemaClass, "stringMap", OType.EMBEDDEDMAP, OType.STRING);
checkProperty(testSchemaClass, "enumMap", OType.EMBEDDEDMAP, OType.STRING);
// Test linked types
checkNotExistsProperty(testSchemaClass, "document");
checkNotExistsProperty(testSchemaClass, "mapObject ");
checkNotExistsProperty(testSchemaClass, "byteArray");
checkProperty(testSchemaClass, "list", OType.LINKLIST, childClass);
checkProperty(testSchemaClass, "set", OType.LINKSET, childClass);
checkProperty(testSchemaClass, "children", OType.LINKMAP, childClass);
checkProperty(testSchemaClass, "child", OType.LINK, childClass);
checkProperty(testSchemaClass, "enumMap", OType.EMBEDDEDMAP, OType.STRING);
// Test embedded types
checkNotExistsProperty(testSchemaClass, "embeddedDocument");
checkProperty(testSchemaClass, "embeddedSet", OType.EMBEDDEDSET, childClass);
checkProperty(testSchemaClass, "embeddedChildren", OType.EMBEDDEDMAP, childClass);
checkProperty(testSchemaClass, "embeddedChild", OType.EMBEDDED, childClass);
checkProperty(testSchemaClass, "embeddedList", OType.EMBEDDEDLIST, childClass);
// Test transientFields
checkNotExistsProperty(testSchemaClass, "tranisentText");
checkNotExistsProperty(testSchemaClass, "transientList ");
checkNotExistsProperty(testSchemaClass, "transientSet");
checkNotExistsProperty(testSchemaClass, "transientChildren");
checkNotExistsProperty(testSchemaClass, "transientDocument ");
checkNotExistsProperty(testSchemaClass, "transientDateField");
database.setAutomaticSchemaGeneration(false);
}
@Test(dependsOnMethods = "testAutomaticSchemaGeneration")
public void testMultipleSchemaGeneration() {
try {
database.getMetadata().getSchema().generateSchema(Musician.class);
database.getMetadata().getSchema().generateSchema(JavaTestSchemaGeneration.class);
database.getMetadata().getSchema().generateSchema(TestSchemaGenerationChild.class);
if (url.startsWith(OEngineRemote.NAME)) {
database.getMetadata().reload();
}
} catch (Exception e) {
Assert.fail("Shouldn't throw exceptions");
}
}
protected void checkNotExistsProperty(OClass iClass, String iPropertyName) {
OProperty prop = iClass.getProperty(iPropertyName);
Assert.assertNull(prop);
}
protected void checkProperty(OClass iClass, String iPropertyName, OType iType) {
OProperty prop = iClass.getProperty(iPropertyName);
Assert.assertNotNull(prop);
Assert.assertEquals(prop.getType(), iType);
}
protected void checkProperty(OClass iClass, String iPropertyName, OType iType, OClass iLinkedClass) {
OProperty prop = iClass.getProperty(iPropertyName);
Assert.assertNotNull(prop);
Assert.assertEquals(prop.getType(), iType);
Assert.assertEquals(prop.getLinkedClass(), iLinkedClass);
}
protected void checkProperty(OClass iClass, String iPropertyName, OType iType, OType iLinkedType) {
OProperty prop = iClass.getProperty(iPropertyName);
Assert.assertNotNull(prop);
Assert.assertEquals(prop.getType(), iType);
Assert.assertEquals(prop.getLinkedType(), iLinkedType);
}
protected void checkNoLinkedProperty(OClass iClass, String iPropertyName, OType iType) {
OProperty prop = iClass.getProperty(iPropertyName);
Assert.assertNotNull(prop);
Assert.assertNull(prop.getLinkedType());
Assert.assertNull(prop.getLinkedClass());
}
}