protected void setUp() throws Exception { cli = new RDBMSCli("TESTDB"); cli.createSchema("TESTDB"); if (AUTO_MANAGE_SCHEMA) { createSchema(); } emf = Persistence.createEntityManagerFactory("RdbmsDataTypeTest"); }
/** * @throws java.lang.Exception */ @Before public void setUp() throws Exception { cli = new RDBMSCli("TESTDB"); cli.createSchema("TESTDB"); createSchema(); emf = null; emf = Persistence.createEntityManagerFactory("testHibernate"); }
@Test public void test() throws Exception { cli = new RDBMSCli("testdb"); cli.createSchema("testdb"); assertInternal(true); }
db = new RDBMSCli("testdb");
cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSON (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), AGE INTEGER)");
cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSON (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), AGE INTEGER)");
/** * Sets the up. * * @throws Exception * the exception */ @Before public void setUp() throws Exception { cli = new RDBMSCli("testdb"); cli.createSchema("testdb"); // cli.update("USE testdb"); cli.update("CREATE TABLE TESTDB.STUDENT (STUDENT_ID BIGINT PRIMARY KEY,UNIQUE_ID BIGINT, STUDENT_NAME VARCHAR(256), AGE SMALLINT,IS_EXCEPTIONAL BOOLEAN,SEMESTER VARCHAR(4),DIGITAL_SIGNATURE TINYINT,CGPA SMALLINT," + "PERCENTAGE DECIMAL(10,8),HEIGHT DECIMAL(11,8) ,ENROLMENT_DATE DATE,ENROLMENT_TIME TIME,JOINING_DATE_TIME TIMESTAMP,YEARS_SPENT INTEGER,ROLL_NUMBER BIGINT" + ",MONTHLY_FEE DOUBLE,SQL_DATE DATE,SQL_TIMESTAMP TIMESTAMP , SQL_TIME TIME,BIG_INT BIGINT,BIG_DECIMAL DECIMAL,CALENDAR TIMESTAMP)"); setupInternal(persistenceUnit); }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256), PERSON_ID VARCHAR(9))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256), PERSON_ID VARCHAR(9))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256), PERSON_ID VARCHAR(9))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256), PERSON_ID VARCHAR(9))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256), ADDRESS_ID VARCHAR(9))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.TRNX_CREDIT (txId VARCHAR(255) PRIMARY KEY, amount int, txStatus VARCHAR(255), tx_type VARCHAR(255), CREDIT_BANK_IDENT VARCHAR(255), transactionDt date)"); cli.update("CREATE TABLE TESTDB.DebitTransaction (DEBIT_ID VARCHAR(255) PRIMARY KEY, amount int, DEBIT_BANK_IDENT VARCHAR(256), txStatus VARCHAR(255), TX_DT date, tx_type VARCHAR(255))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.TRNX_CREDIT"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.TRNX_CREDIT"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.TRNX_CREDIT (txId VARCHAR(255) PRIMARY KEY, amount int, txStatus VARCHAR(255), tx_type VARCHAR(255), CREDIT_BANK_IDENT VARCHAR(255), transactionDt date)"); cli.update("CREATE TABLE TESTDB.DebitTransaction (DEBIT_ID VARCHAR(255) PRIMARY KEY, amount int, DEBIT_BANK_IDENT VARCHAR(256), txStatus VARCHAR(255), TX_DT date, tx_type VARCHAR(255))"); // nothing // do } }
cli = new RDBMSCli("testdb"); cli.createSchema("testdb");
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.PERSONNEL_ADDRESS (ADDRESS_ID VARCHAR(9), PERSON_ID VARCHAR(9))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DELETE FROM TESTDB.PERSONNEL_ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL_ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSON (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.PERSONNEL_ADDRESS (ADDRESS_ID VARCHAR(9), PERSON_ID VARCHAR(9))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE MEMORY TABLE TESTDB.PERSON (PERSON_ID VARCHAR(90) PRIMARY KEY, PERSON_NAME VARCHAR(256), AGE INTEGER)"); cli.update("CREATE MEMORY TABLE TESTDB.TOKENS (TOKEN_ID VARCHAR(90) PRIMARY KEY, TOKEN_NAME VARCHAR(256), CLIENT_ID VARCHAR(256))"); cli.update("CREATE MEMORY TABLE TESTDB.CLIENT (CLIENT_ID VARCHAR(90) PRIMARY KEY, CLIENT_NAME VARCHAR(256))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSON"); cli.update("DROP TABLE TESTDB.PERSON"); cli.update("DELETE FROM TESTDB.TOKENS"); cli.update("DROP TABLE TESTDB.TOKENS"); cli.update("DELETE FROM TESTDB.CLIENT"); cli.update("DROP TABLE TESTDB.CLIENT"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE MEMORY TABLE TESTDB.PERSON (PERSON_ID VARCHAR(90) PRIMARY KEY, PERSON_NAME VARCHAR(256), AGE INTEGER)"); cli.update("CREATE MEMORY TABLE TESTDB.TOKENS (TOKEN_ID VARCHAR(90) PRIMARY KEY, TOKEN_NAME VARCHAR(256), CLIENT_ID VARCHAR(256))"); cli.update("CREATE MEMORY TABLE TESTDB.CLIENT (CLIENT_ID VARCHAR(90) PRIMARY KEY, CLIENT_NAME VARCHAR(256))"); // nothing // do } }
private void createSchema() throws SQLException { try { cli = new RDBMSCli(SCHEMA); cli.createSchema(SCHEMA); cli.update("CREATE TABLE TESTDB.PERSONNEL (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.PERSONNEL_ADDRESS (ADDRESS_ID VARCHAR(9), PERSON_ID VARCHAR(9))"); } catch (Exception e) { cli.update("DELETE FROM TESTDB.PERSONNEL"); cli.update("DELETE FROM TESTDB.ADDRESS"); cli.update("DELETE FROM TESTDB.PERSONNEL_ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL"); cli.update("DROP TABLE TESTDB.ADDRESS"); cli.update("DROP TABLE TESTDB.PERSONNEL_ADDRESS"); cli.update("DROP SCHEMA TESTDB"); cli.update("CREATE TABLE TESTDB.PERSON (PERSON_ID VARCHAR(9) PRIMARY KEY, PERSON_NAME VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.ADDRESS (ADDRESS_ID VARCHAR(9) PRIMARY KEY, STREET VARCHAR(256))"); cli.update("CREATE TABLE TESTDB.PERSONNEL_ADDRESS (ADDRESS_ID VARCHAR(9), PERSON_ID VARCHAR(9))"); // nothing // do } }