third_party/WebKit/LayoutTests/storage/websql/sql-error-codes.js

   1 function finishTest()
   2 {
   3     if (window.testRunner)
   4         testRunner.notifyDone();
   5 }
   6
   7 var TOTAL_TESTS = 8;
   8 var testsRun = 0;
   9 function transactionErrorCallback(error, expectedErrorCodeName)
  10 {
  11     if (error.code == error[expectedErrorCodeName]) {
  12         log("PASS: expected and got error code " + expectedErrorCodeName);
  13         if (++testsRun == TOTAL_TESTS)
  14             finishTest();
  15     } else {
  16         log("FAIL: expected error code " + expectedErrorCodeName + " (" + error[expectedErrorCodeName] + "); got " + error.code);
  17         finishTest();
  18     }
  19 }
  20
  21 function transactionSuccessCallback()
  22 {
  23     log("FAIL: a transaction has completed successfully.");
  24     finishTest();
  25 }
  26
  27 function testTransaction(db, transactionCallback, expectedErrorCodeName)
  28 {
  29     db.transaction(transactionCallback,
  30                    function(error) {
  31                        transactionErrorCallback(error, expectedErrorCodeName);
  32                    }, transactionSuccessCallback);
  33 }
  34
  35 function testTransactionThrowsException(db)
  36 {
  37     testTransaction(db, function(tx) { throw "Exception thrown in transaction callback."; }, "UNKNOWN_ERR");
  38 }
  39
  40 function testTransactionFailureBecauseOfStatementFailure(db)
  41 {
  42     testTransaction(db,
  43                     function(tx) {
  44                         tx.executeSql("BAD STATEMENT", [], null, function(tx, error) { return true; });
  45                     }, "UNKNOWN_ERR");
  46 }
  47
  48 function testInvalidStatement(db)
  49 {
  50     testTransaction(db, function(tx) { tx.executeSql("BAD STATEMENT"); }, "SYNTAX_ERR");
  51 }
  52
  53 function testIncorrectNumberOfBindParameters(db)
  54 {
  55     testTransaction(db,
  56                     function(tx) {
  57                         tx.executeSql("CREATE TABLE IF NOT EXISTS BadBindNumberTest (Foo INT, Bar INT)");
  58                         tx.executeSql("INSERT INTO BadBindNumberTest VALUES (?, ?)", [1]);
  59                     }, "SYNTAX_ERR");
  60 }
  61
  62 function testBindParameterOfWrongType(db)
  63 {
  64     var badString = { };
  65     badString.toString = function() { throw "Cannot call toString() on this object." };
  66
  67     testTransaction(db, function(tx) {
  68         tx.executeSql("CREATE TABLE IF NOT EXISTS BadBindTypeTest (Foo TEXT)");
  69         tx.executeSql("INSERT INTO BadBindTypeTest VALUES (?)", [badString]);
  70     }, "UNKNOWN_ERR");
  71 }
  72
  73 function testConstraintFailure(db)
  74 {
  75     testTransaction(db,
  76                     function(tx) {
  77                         tx.executeSql("CREATE TABLE IF NOT EXISTS ConstraintTest (Foo INTEGER PRIMARY KEY)");
  78                         tx.executeSql("INSERT INTO ConstraintTest VALUES (1)");
  79                         tx.executeSql("INSERT INTO ConstraintTest VALUES (1)");
  80                     }, "CONSTRAINT_ERR");
  81 }
  82
  83 function testQuotaExceeded(db)
  84 {
  85     testTransaction(db,
  86                     function(tx) {
  87                         tx.executeSql("CREATE TABLE IF NOT EXISTS QuotaTest (Foo BLOB)");
  88                         tx.executeSql("INSERT INTO QuotaTest VALUES (ZEROBLOB(10 * 1024 * 1024))");
  89                     }, "QUOTA_ERR");
  90 }
  91
  92 function testVersionMismatch(db)
  93 {
  94     // Use another DB handle to change the version. However, in order to make sure that the DB version is not
  95     // changed before the transactions in the other tests have run, we need to do it in a transaction on 'db'.
  96     db.transaction(function(tx) {
  97         var db2 = openDatabaseWithSuffix("SQLErrorCodesTest", "1.0", "Tests the error codes.", 1);
  98         db2.changeVersion("1.0", "2.0", function(tx) { },
  99                           function(error) {
 100                               log("FAIL: could not change the DB version.");
 101                               finishTest();
 102                           }, function() { });
 103         });
 104
 105     testTransaction(db,
 106                     function(tx) {
 107                         tx.executeSql("THIS STATEMENT SHOULD NEVER GET EXECUTED");
 108                     }, "VERSION_ERR");
 109 }
 110
 111 function runTest()
 112 {
 113     if (window.testRunner)
 114         testRunner.clearAllDatabases();
 115
 116     var db = openDatabaseWithSuffix("SQLErrorCodesTest", "1.0", "Tests the error codes.", 1);
 117     testTransactionThrowsException(db);
 118     testTransactionFailureBecauseOfStatementFailure(db);
 119     testInvalidStatement(db);
 120     testIncorrectNumberOfBindParameters(db);
 121     testBindParameterOfWrongType(db);
 122     testConstraintFailure(db);
 123     testQuotaExceeded(db);
 124     testVersionMismatch(db);
 125 }