Class goog.gears.Database

Marks the beginning of a database transaction using the default begin type. Does a real BEGIN operation if useTransactions is true for this database and this is the first opened transaction. This will throw an exception if this is a nested begin and is trying to elevate the begin type from the original BEGIN that was processed.

Marks the beginning of a deferred database transaction. Does a real BEGIN operation if useTransactions is true for this database and this is the first opened transaction.

Marks the beginning of an exclusive database transaction. Does a real BEGIN operation if useTransactions is true for this database and this is the first opened transaction. This will throw an exception if this is a nested begin and is trying to elevate the begin type from the original BEGIN that was processed.

Marks the beginning of an immediate database transaction. Does a real BEGIN operation if useTransactions is true for this database and this is the first opened transaction. This will throw an exception if this is a nested begin and is trying to elevate the begin type from the original BEGIN that was processed.

Marks the beginning of a database transaction. Does a real BEGIN operation if useTransactions is true for this database and the this is the first opened transaction

Closes the database.

Helper that performs either a COMMIT or ROLLBACK command and dispatches pre/post commit/rollback events.

Marks the end of a successful transaction. Will do a real COMMIT if this the last outstanding transaction unless a nested transaction was closed with a ROLLBACK in which case a real ROLLBACK will be performed.

Unattach listeners from this object. Classes that extend EventTarget may need to override this method in order to remove references to DOM Elements and additional listeners, it should be something like this:

MyClass.prototype.disposeInternal = function() {
MyClass.superClass_.disposeInternal.call(this);
// Dispose logic for MyClass
};

Ensures there is no open transaction upon return. An existing open transaction is rolled back.

Execute a sql statement with a set of arguments

This is useful to remove all the arguments juggling from inside the different helper functions.

For each row in the result set f will be called with the following parameters: row (array of values), rowIndex and columnNames. Rows will continue being processed as long as f returns true.

For each value in the result set f will be called with the following parameters; value, rowIndex, columnIndex, columnName. Values will continue being processed as long as f returns true.

Returns the time in Ms that database operations have currently consumed. This only exists in debug builds, but it still may be useful for goog.gears.Trace.

Whether transactions are used for the database

Returns whether or not we're in a transaction.

Returns whether or not the current transaction has a pending rollback. Returns false if there is no current transaction.

Opens the database.

This calls query on the database and returns the first row as an array

This calls query on the database and builds a two dimensional array containing the result.

This calls query on the database and returns the first row as a hash map where the keys are the column names.

This calls query on the database and builds an array containing hashes

Helper methods for queryArrays, queryObjectArray, queryValueArray, queryValue, queryObject.

This calls query on the database and returns the first value in the first row.

This calls query on the database and returns an array containing the values in the first column. This is useful if the result set only contains one column.

Removes the database.

Marks the end of an unsuccessful transaction. Will do a real ROLLBACK if this the last outstanding transaction, otherwise the real ROLLBACK will be deferred until the last outstanding transaction is closed.

Sets the default begin type.

Whether transactions are used for the database

Executes a function transactionally.

Determines if the exception is a locking error.

Returns an array of the first row in the result set

Returns an array of arrays, where each sub array contains the selected values for each row in the result set. result values

Returns a single hashed object from the result set (the first row), where the column names in the query are used as the members of the object.

Returns a array of hash objects, one per row in the result set, where the column names in the query are used as the members of the object.

Returns a single value from the results (first column in first row).

Returns an array containing the first item of each row in a result set. This is useful for query that returns one column