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

org.apache.empire.db.DBSQLScript.run()
Runs all SQL Statements using the supplied driver and connection. @param driver the driver used for statement execution @param conn the connection

        // Now extend the size of the field from 20 to 40 characters
        System.out.println("Extending size of column FOO to 40 characters:");
        C_FOO.setSize(40); 
        script.clear();
        db.getDriver().getDDLScript(DBCmdType.ALTER, C_FOO, script);
        script.run(db.getDriver(), conn, false);


        // Now set a longer value for the record
        System.out.println("Changing the value for the FOO field for the above employee to a longer string:");
        rec.setValue(C_FOO, "This is a very long field value!");
        rec.update(conn);

View Full Code Here


        // Finally, drop the column again
        System.out.println("Dropping the FOO column from the employee table:");
        script.clear();
        db.getDriver().getDDLScript(DBCmdType.DROP, C_FOO, script);
        script.run(db.getDriver(), conn, false);
    }


    /**
     * This function demostrates the use of the DBQuery object.<BR>
     * First a DBQuery is used to define a subquery that gets the latest employee department history record.<BR>

View Full Code Here

    DBSQLScript script = new DBSQLScript();
    sampleDB.getCreateDDLScript(driver, script);
    // Show DLL Statements
    System.out.println(script.toString());
    // Execute Script
    script.run(driver, conn, false);
    sampleDB.commit(conn);
    // Open again
    if (!sampleDB.isOpen()) {
      sampleDB.open(driver, conn);
    }

View Full Code Here

      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

        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(driver, script);
        // Show DLL Statement
        System.out.println(script.toString());
        // Execute Script
        script.run(driver, conn, false);
    }


    public void initializeDatabase() {
        try {
            if (!databaseExists()) {

View Full Code Here

      DBSQLScript script = new DBSQLScript();
    db.getCreateDDLScript(driver, script);
    // Show DLL Statement
    System.out.println(script.toString());
    // Execute Script
    script.run(driver, conn, false);
    // Commit
    db.commit(conn);
  }


  /**

View Full Code Here

        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(driver, script);
        // Show DLL Statements
        System.out.println(script.toString());
        // Execute Script
        script.run(driver, conn, false);
        db.commit(conn);
        // Open again
        if (!db.isOpen() && !db.open(driver, conn)){
            throw new RuntimeException(driver.getErrorMessage());
        }

View Full Code Here

        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(driver, script);
        // Show DLL Statements
        System.out.println(script.toString());
        // Execute Script
        script.run(driver, conn, false);
        db.commit(conn);
        // Open again
        if (!db.isOpen() && !db.open(driver, conn)){
            throw new RuntimeException(driver.getErrorMessage());
        }

View Full Code Here

        DBDatabaseDriver driver = new DBDatabaseDriverHSql();
        CompanyDB db = new CompanyDB();
        db.open(driver, hsqldb.getConnection());
        DBSQLScript script = new DBSQLScript();
        db.getCreateDDLScript(db.getDriver(), script);
        script.run(db.getDriver(), hsqldb.getConnection(), false);
        
        DBRecord dep = new DBRecord();
        dep.create(db.DEPARTMENT);
        dep.setValue(db.DEPARTMENT.NAME, "junit");
        dep.setValue(db.DEPARTMENT.BUSINESS_UNIT, "testers");

View Full Code Here

        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

0 1 2 3 4 5 6 7 8

TOP

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.