SQLite is Fun!

function DatabaseInit()
{
   // create a script group to manage databases
   %databasegroup = new ScriptGroup(databaseGroup);

   // open the main database
   %maindatabase = new SQLiteObject(maindatabase);
   if(%maindatabase == 0)
   {
      echo("ERROR: Failed to create database object. maindatabase load aborted.");
      return;
   }
   // setup error function for main database
   createQueryErrorFunction("maindatabase");
   // add database to script group
   %databasegroup.add(maindatabase);

   // open database
   %dbname = ExpandFilename($database::maindatabasepath);
   if (maindatabase.openDatabase(%dbname) == 0)
   {
      echo("ERROR: Failed to open database: " @ %dbname);
      maindatabase.delete();
      return;
   }

   // create a new simple table for demonstration purposes
//    %query = "CREATE TABLE IF NOT EXISTS databases (name TEXT, path TEXT)";
//    %result = maindatabase.query(%query, 0);
//    if (%result == 0)
//    {
//       // query failed
//       echo("ERROR: Failed to create new table.  maindatabase test aborted.");
//       maindatabase.closeDatabase();
//       maindatabase.delete();
//       return;
//    }
//    // cleanup query result
//    maindatabase.clearResult(%result);

   // input data for testing
//    %query = "INSERT INTO databases (name, path) VALUES ('test value', 'test path')";
//    %result = maindatabase.query(%query, 0);
//    if(%result == 0)
//    {
//       echo("ERROR: Failed to INSERT into databases table.");
//    }
//    // cleanup query result
//    maindatabase.clearResult(%result);

   // query for additional databases
   %query = "SELECT * FROM databases";
   %result = maindatabase.query(%query, 0);
   if (%result == 0)
   {
      echo("ERROR: Failed to SELECT from databases table.");
   }
   // attempt to retrieve "result" data
   while (!maindatabase.endOfResult(%result))
   {
      %databaseindex = maindatabase.getColumn(%result, "index");
      %databasename = maindatabase.getColumn(%result, "name");
      %databasepath = maindatabase.getColumn(%result, "path");
      %databasedesc = maindatabase.getColumn(%result, "description");
      echo("database index = " @ %databaseindex);
      echo("         name = " @ %databasename);
      echo("         path = " @ %databasepath);
      echo("         description = " @ %databasedesc);

      // open additional database
      if(!isFile(%databasepath))
      {
         echo("ERROR: Database file" SPC %databasepath SPC "does not exist.");
         continue;
      }

      %newdatabase = new SQLiteObject(%databasename) {
         description = %databasedesc;
      };
      if(%newdatabase == 0)
      {
         echo("ERROR: Failed to create database object. maindatabase load aborted.");
         continue;
      }

      // open database
      %dbname = ExpandFilename(%databasepath);
      if (%newdatabase.openDatabase(%dbname) == 0)
      {
         echo("ERROR: Failed to open database: " @ %databasename);

         %newdatabase.delete();
         continue;
      }

      // setup error function for database
      createQueryErrorFunction(%databasename);

      // reference database in database group
      %databasegroup.add(%newdatabase);

      // get next row of query data
      maindatabase.nextRow(%result);
   }
   maindatabase.clearResult(%result);
}