<html>
<script>

// Open a Web SQL database.
var g_db = null;
if (typeof window.openDatabase == "undefined") {
  document.write("Error: Web SQL databases are not supported.");
}
try {
  g_db = openDatabase("test", "1.0", "test database", 1024 * 1024);
} catch(err) {
  document.write("Error: cannot open database.");
}

// Creates a table named "table1" with one text column named "data".
function createTable() {
  if (!g_db)
    return;
  g_db.transaction(
      function(tx) {
        tx.executeSql("CREATE TABLE table1 (data TEXT)");
      },
      function(error) {
        sendValueToTest(error);
      },
      function() {
        sendValueToTest("done");
      });
}

// Inserts a record into the database.
function insertRecord(text) {
  g_db.transaction(
      function(tx) {
        tx.executeSql("INSERT INTO table1 VALUES (?)", [text]);
      },
      function(error) {
        sendValueToTest(error);
      },
      function() {
        sendValueToTest("done");
      });
}


// Updates a record at the given index with the given text. The indices are
// 0-based and are ordered from oldest record, to newest record.
function updateRecord(index, text) {
  var didUpdate = false;
  findId(index, function(rowId) {
    g_db.transaction(
        function(tx) {
          tx.executeSql(
              "UPDATE table1 SET data=? WHERE ROWID=?",
              [text, rowId],
              function(tx, result) {
                if (result.rowsAffected == 1)
                  didUpdate = true;
                else if (result.rowsAffected == 0)
                  sendValueToTest("could not update index: " + index);
                else
                  sendValueToTest("multiple rows with index: " + index);
              });
        },
        function(error) {
          sendValueToTest("update error: " + error);
        },
        function() {
          if (didUpdate)
            sendValueToTest("done");
        });
  });
}

// Deletes a record at the given index.
function deleteRecord(index) {
  findId(index, function(rowId) {
    g_db.transaction(
        function(tx) {
          tx.executeSql("DELETE FROM table1 WHERE ROWID=?", [rowId]);
        },
        function(error) {
          sendValueToTest("delete error: " + error);
        },
        function() {
          sendValueToTest("done");
        });
  });
}

// Gets all the records in the database, ordered by their age.
function getRecords() {
  g_db.readTransaction(function(tx) {
    tx.executeSql(
        "SELECT data FROM table1 ORDER BY ROWID",
        [],
        function(tx, result) {
          items = "";
          for (var i = 0; i < result.rows.length; i++) {
            if (items != "")
              items += ", ";
            items += result.rows.item(i).data;
          }
          sendValueToTest(items);
        },
        function(tx, error) {
          sendValueToTest("getRecords error: " + error);
        });
  });
}

// Helper function that finds the ID for a record based on a given index.
function findId(index, callback) {
  g_db.readTransaction(function(tx) {
    // |ROWID| is a special sqlite column. It is unique and is incremented
    // automatically when a new record is created.
    // |LIMIT| is a nonstandard clause supported by sqlite that lets us pick
    // rows from the database by index. E.g., LIMIT 2,10 will give us 10 records
    // starting at offset 2.
    tx.executeSql(
        "SELECT ROWID AS id FROM table1 ORDER BY ROWID LIMIT ?,1",
        [index],
        function(tx, result) {
          if (result.rows.length >= 1)
            callback(result.rows.item(0).id);
          else
            sendValueToTest("could not find row with index: " + index);
        },
        function(tx, error) {
        sendValueToTest("findId error: " + error);
        });
  });
}

function sendValueToTest(value) {
  //alert(value);
  window.domAutomationController.send(value);
}

</script>

<body>
This page is used for testing Web SQL databases.
</body>
</html>