/* * An example of how to use the DBScript object to populate a database. * This will be done as a single transaction and is transactionally safe. * This means that all changes will be rolled back if any * database error happens. */ //create or connect to the in-UIWebView database var database = new DataAccessObject("WelcomeExample", "1.0″, "Welcome example", 20); //create the script object var bulkInsertScript = new DBScript(database); //add all statements to the script object bulkInsertScript.addStatement("CREATE TABLE IF NOT EXISTS names (id INTEGER UNIQUE, name TEXT)"); bulkInsertScript.addStatement("INSERT INTO names VALUES(1,’Bob’)"); bulkInsertScript.addStatement("INSERT INTO names VALUES(2,’Sue’)"); //and example of using a prepared statement bulkInsertScript.addStatement("INSERT INTO names VALUES(?,?)",[3,"Jose"]); bulkInsertScript.addStatement("INSERT INTO names VALUES(4,’Bjorn’)"); bulkInsertScript.addStatement("INSERT INTO names VALUES(5,’Jean’)"); bulkInsertScript.addStatement("INSERT INTO names VALUES(6,’Gustav’)"); //execute all statements within a transaction bulkInsertScript.executeSetDataScript();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)