Package org.apache.empire.db

Examples of org.apache.empire.db.DBSQLScript.run()

279
280
281
282
283
284
285
286
287
288
289
      DBSQLScript script = new DBSQLScript();
    db.getCreateDDLScript(driver, script);
    // Show DDL Statement
    System.out.println(script.toString());
    // Execute Script
    script.run(driver, conn, false);
    // Commit
    db.commit(conn);
  }

  /**
 
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        DBDatabaseDriver driver = dbResource.newDriver();
        CompanyDB db = new CompanyDB();
        db.open(driver, dbResource.getConnection());
        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(db.getDriver(), script);
        script.run(db.getDriver(), dbResource.getConnection(), false);
       
        DBRecord dep = new DBRecord();
        dep.create(db.DEPARTMENT);
        dep.setValue(db.DEPARTMENT.NAME, "junit");
        dep.setValue(db.DEPARTMENT.BUSINESS_UNIT, "test");
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
       
       
        script = new DBSQLScript();
        db.getDriver().getDDLScript(DBCmdType.DROP, db.EMPLOYEE, script);
        db.getDriver().getDDLScript(DBCmdType.DROP, db.DEPARTMENT, script);
        script.run(db.getDriver(), conn, true);
    }
   
   
    /**
     * See https://issues.apache.org/jira/browse/EMPIREDB-151
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
        DBDatabaseDriver driver = dbResource.newDriver();
        SeqDB db = new SeqDB();
        db.open(driver, dbResource.getConnection());
        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(db.getDriver(), script);
        script.run(db.getDriver(), dbResource.getConnection(), false);
       
        DBRecord data = new DBRecord();
        data.create(db.DATA);
        data.setValue(db.DATA.VALUE, "test");
        data.update(conn);
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
       
        assertEquals("test", read.getString(db.DATA.VALUE));
       
        script = new DBSQLScript();
        db.getDriver().getDDLScript(DBCmdType.DROP, db.DATA, script);
        script.run(db.getDriver(), conn, true);
    }
   
    /**
     * This is the basic database for testing
     *
 
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
    if(!databaseExists(conn, db)){
      DBSQLScript script = new DBSQLScript();
      db.getCreateDDLScript(db.getDriver(), script);
      System.out.println(script.toString());
      script.run(db.getDriver(), dbResource.getConnection(), false);
    }
   
    conn.close();
  }
 
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        DBDatabaseDriver driver = dbResource.newDriver();
        CompanyDB db = new CompanyDB();
        db.open(driver, dbResource.getConnection());
        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(db.getDriver(), script);
        script.run(db.getDriver(), dbResource.getConnection(), false);
       
        DBRecord dep = new DBRecord();
        dep.create(db.DEPARTMENT);
        dep.setValue(db.DEPARTMENT.NAME, "junit");
        dep.setValue(db.DEPARTMENT.BUSINESS_UNIT, "test");
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
        assertEquals("123456", emp.getString(db.EMPLOYEE.PHONE_NUMBER));
       
        script = new DBSQLScript();
        db.getDriver().getDDLScript(DBCmdType.DROP, db.EMPLOYEE, script);
        db.getDriver().getDDLScript(DBCmdType.DROP, db.DEPARTMENT, script);
        script.run(db.getDriver(), conn, true);
    }
   
   
   
    /**
 
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
        DBDatabaseDriver driver = dbResource.newDriver();
        SeqDB db = new SeqDB();
        db.open(driver, dbResource.getConnection());
        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(db.getDriver(), script);
        script.run(db.getDriver(), dbResource.getConnection(), false);
       
        DBRecord data = new DBRecord();
        data.create(db.DATA);
        data.setValue(db.DATA.VALUE, "test");
        data.update(conn);
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
       
        assertEquals("test", read.getString(db.DATA.VALUE));
       
        script = new DBSQLScript();
        db.getDriver().getDDLScript(DBCmdType.DROP, db.DATA, script);
        script.run(db.getDriver(), conn, true);
    }
   
    /**
     * This is the basic database for testing
     *
 
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.