Electronic Books

Populating the Database
Thanks to the simplicity of the haXe database framework, you can now populate your database with
little difference in code to the previous example:
class PrePopulateDB
{
private static var dte : Date = Date.now();
private static var data : Array < Dynamic > = [{
user:???Lee???,
pass:???secret???,
email:???lee@designrealm.co.uk???,
added:Date.now().toString()
},{
user:???James???,
pass:???pass???,
email:???james@vdev.co.uk???,
added:Date.now().toString()
},{
user:???Edwin???,
pass:???letmein???,
email:???edwin@screenweaver.com???,
added:Date.now().toString()
}];
public static function main()
{
var dbLoc = ???Wrox.db3???;
var dbPop = populate( dbLoc );
}
public static function populate( loc : String )
{
// open the database
var cnx = neko.db.Sqlite.open( loc );
var sql : String;
(continued)
280
Part II: Server Side, JavaScript, and Flash: Oh My!
// for each user in the data array
for ( user in data )
{
// construct the user sql string
sql = ???INSERT INTO Author ( var_username, var_password, var_email, dte_added
) VALUES ( ???;
sql += cnx.


Pages:
525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549