Lines Matching refs:tx
1487 function creation(tx) {
1488 _self.databaseCreated(tx);
1491 function migration1_0To1_1(tx) {
1494 tx.executeSql('ALTER TABLE tests ADD COLUMN seen BOOLEAN DEFAULT \"FALSE\"', null, function() {
1520 TestSuite.prototype.databaseCreated = function(tx)
1528 tx.executeSql('CREATE TABLE tests (test PRIMARY KEY UNIQUE, ref, title, flags, links, assertion, hstatus, hcomment, xstatus, xcomment)', null,
1529 function(tx, results) {
1545 this.db.transaction(function (tx) {
1547 tx.executeSql('UPDATE tests SET hstatus=?, hcomment=? WHERE test=?\n', [result, comment, test], null, errorHandler);
1549 tx.executeSql('UPDATE tests SET xstatus=?, xcomment=? WHERE test=?\n', [result, comment, test], null, errorHandler);
1558 this.db.transaction(function (tx) {
1569 tx.executeSql(query, [currResult.result, currResult.comment, currResult.id], null, errorHandler);
1579 this.db.transaction(function (tx) {
1585 tx.executeSql('UPDATE tests SET hstatus=NULL, hcomment=NULL WHERE test=?\n', [currResult.id], null, errorHandler);
1588 tx.executeSql('UPDATE tests SET xstatus=NULL, xcomment=NULL WHERE test=?\n', [currResult.id], null, errorHandler);
1603 this.db.transaction(function (tx) {
1607 tx.executeSql('INSERT INTO tests (test, ref, title, flags, links, assertion) VALUES (?, ?, ?, ?, ?, ?)',
1615 TestSuite.prototype.insertTest = function(tx, test)
1617 tx.executeSql('INSERT INTO tests (test, ref, title, flags, links, assertion, seen) VALUES (?, ?, ?, ?, ?, ?, ?)',
1638 this.db.transaction(function (tx) {
1641 tx.executeSql('SELECT * FROM tests', [], function(tx, results) {
1650 this.db.transaction(function (tx) {
1654 _self.insertTest(tx, currTest);
1658 this.db.transaction(function (tx) {
1660 tx.executeSql('UPDATE tests SET seen=\"TRUE\" WHERE test=?\n', [testID], null, errorHandler);
1662 tx.executeSql('SELECT * FROM tests WHERE seen=\"FALSE\"', [], function(tx, results) {
1671 tx.executeSql('DELETE FROM tests WHERE seen=\"FALSE\"', [], function(tx, results) {
1684 this.db.transaction(function (tx) {
1696 tx.executeSql(query, args, function(tx, results) {
1713 this.db.transaction(function (tx) {
1716 tx.executeSql('SELECT * FROM tests WHERE hstatus=? OR xstatus=?', [status, status], function(tx, results) {
1733 this.db.transaction(function (tx) {
1736 tx.executeSql('SELECT * FROM tests WHERE hstatus IS NOT NULL AND xstatus IS NOT NULL AND hstatus <> xstatus', [], function(tx, results) {
1753 this.db.transaction(function (tx) {
1758 tx.executeSql('SELECT * FROM tests WHERE hstatus IS NOT NULL OR xstatus IS NOT NULL', [], function(tx, results) {
1774 this.db.transaction(function (tx) {
1778 tx.executeSql('SELECT * FROM tests WHERE hstatus IS NULL OR xstatus IS NULL', [], function(tx, results) {
1817 TestSuite.prototype.countTestsWithColumnValue = function(tx, completionHandler, column, value, label)
1821 tx.executeSql('SELECT COUNT(*) FROM tests WHERE ' + column + '=?', [value], function(tx, results) {
1829 TestSuite.prototype.countTestsWithFlag = function(tx, completionHandler, flag)
1833 tx.executeSql('SELECT COUNT(*) FROM tests WHERE flags LIKE \"%' + flag + '%\"', [], function(tx, results) {
1851 this.db.transaction(function (tx) {
1857 _self.countTestsWithFlag(tx, function(count) {
1861 _self.countTestsWithFlag(tx, function(count) {
1866 this.db.transaction(function (tx) {
1874 tx.executeSql('SELECT COUNT(*), COUNT(hstatus), COUNT(xstatus) FROM tests', [], function(tx, results) {
1889 _self.countTestsWithColumnValue(tx, completionHandler, 'hstatus', 'pass', 'h-passed');
1890 _self.countTestsWithColumnValue(tx, completionHandler, 'xstatus', 'pass', 'x-passed');
1892 _self.countTestsWithColumnValue(tx, completionHandler, 'hstatus', 'fail', 'h-failed');
1893 _self.countTestsWithColumnValue(tx, completionHandler, 'xstatus', 'fail', 'x-failed');
1895 _self.countTestsWithColumnValue(tx, completionHandler, 'hstatus', 'skipped', 'h-skipped');
1896 _self.countTestsWithColumnValue(tx, completionHandler, 'xstatus', 'skipped', 'x-skipped');
1898 _self.countTestsWithColumnValue(tx, completionHandler, 'hstatus', 'invalid', 'h-invalid');
1899 _self.countTestsWithColumnValue(tx, completionHandler, 'xstatus', 'invalid', 'x-invalid');
