dart.dom.web_sql

Typedefs
SqlStatementCallback(SqlTransaction transaction, SqlResultSet resultSet): void
SqlStatementErrorCallback(SqlTransaction transaction, SqlError error): void
SqlTransactionCallback(SqlTransaction transaction): void
SqlTransactionErrorCallback(SqlError error): void
Classes
SqlDatabase
SqlError
SqlResultSet
SqlResultSetRowList
SqlTransaction

An API for storing data in the browser that can be queried with SQL.

Caution: this specification is no longer actively maintained by the Web Applications Working Group and may be removed at any time. See the W3C Web SQL Database specification(http://www.w3.org/TR/webdatabase/) for more information.

The dart:indexed_db APIs is a recommended alternatives.

Typedefs

@ @
typedef void SqlStatementCallback(SqlTransaction transaction, SqlResultSet resultSet):
@ @
typedef void SqlStatementErrorCallback(SqlTransaction transaction, SqlError error):
@ @
typedef void SqlTransactionCallback(SqlTransaction transaction):
@ @
typedef void SqlTransactionErrorCallback(SqlError error):

@ @ @ @ @ @
Class SqlDatabase extends NativeFieldWrapperClass1

Static Fields
supported: bool
Fields
version: String
Getters and Setters
supported: bool
version: String
Constructors
SqlDatabase()
Methods
changeVersion(String oldVersion, String newVersion, SqlTransactionCallback callback, SqlTransactionErrorCallback errorCallback, VoidCallback successCallback): void
readTransaction(SqlTransactionCallback callback, SqlTransactionErrorCallback errorCallback, VoidCallback successCallback): void
transaction(SqlTransactionCallback callback, SqlTransactionErrorCallback errorCallback, VoidCallback successCallback): void

Static Fields

static final bool supported

Fields

final String version

Getters and Setters

static bool get supported

Checks if this type is supported on the current platform.

@ @
String get version

Constructors

SqlDatabase()

Methods

@ @
void changeVersion(String oldVersion, String newVersion, SqlTransactionCallback callback, SqlTransactionErrorCallback errorCallback, VoidCallback successCallback)

Atomically update the database version to newVersion, asynchronously running callback on the SqlTransaction representing this changeVersion transaction.

If callback runs successfully, then successCallback is called. Otherwise, errorCallback is called.

oldVersion should match the database's current version exactly.

  • Database.changeVersion(http://www.w3.org/TR/webdatabase/#dom-database-changeversion) from W3C.

@ @
void readTransaction(SqlTransactionCallback callback, SqlTransactionErrorCallback errorCallback, VoidCallback successCallback)
@ @
void transaction(SqlTransactionCallback callback, SqlTransactionErrorCallback errorCallback, VoidCallback successCallback)

@ @ @
Class SqlError extends NativeFieldWrapperClass1

Static Fields
CONSTRAINT_ERR: int
DATABASE_ERR: int
QUOTA_ERR: int
SYNTAX_ERR: int
TIMEOUT_ERR: int
TOO_LARGE_ERR: int
UNKNOWN_ERR: int
VERSION_ERR: int
Fields
code: int
message: String
Getters and Setters
code: int
message: String
Constructors
SqlError()

Static Fields

@ @
static const int CONSTRAINT_ERR = 6
@ @
static const int DATABASE_ERR = 1
@ @
static const int QUOTA_ERR = 4
@ @
static const int SYNTAX_ERR = 5
@ @
static const int TIMEOUT_ERR = 7
@ @
static const int TOO_LARGE_ERR = 3
@ @
static const int UNKNOWN_ERR = 0
@ @
static const int VERSION_ERR = 2

Fields

final int code
final String message

Getters and Setters

@ @
int get code
@ @
String get message

Constructors

SqlError()

@ @ @
Class SqlResultSet extends NativeFieldWrapperClass1

Fields
insertId: int
rows: SqlResultSetRowList
rowsAffected: int
Getters and Setters
insertId: int
rows: SqlResultSetRowList
rowsAffected: int
Constructors
SqlResultSet()

Fields

final int insertId
final SqlResultSetRowList rows
final int rowsAffected

Getters and Setters

@ @
int get insertId
@ @
SqlResultSetRowList get rows
@ @
int get rowsAffected

Constructors

SqlResultSet()

@ @ @
Class SqlResultSetRowList extends NativeFieldWrapperClass1 with ListMixin<Map<dynamic, dynamic>>, ImmutableListMixin<Map<dynamic, dynamic>> implements List<Map<dynamic, dynamic>>

Fields
first: Map
last: Map
length: int
single: Map
Getters and Setters
first: Map<dynamic, dynamic>
last: Map<dynamic, dynamic>
length: int
length=(int value)
single: Map<dynamic, dynamic>
Constructors
SqlResultSetRowList()
Methods
[](int index): Map<dynamic, dynamic>
[]=(int index, Map<dynamic, dynamic> value): void
elementAt(int index): Map<dynamic, dynamic>
item(int index): Map<dynamic, dynamic>

Fields

final Map first
final Map last
int length
final Map single

Getters and Setters

Map<dynamic, dynamic> get first
Map<dynamic, dynamic> get last
@ @
int get length
set length=(int value)
Map<dynamic, dynamic> get single

Constructors

SqlResultSetRowList()

Methods

Map<dynamic, dynamic> [](int index)

Returns the object at the given index in the list or throws a RangeError if index is out of bounds.

void []=(int index, Map<dynamic, dynamic> value)

Sets the value at the given index in the list to value or throws a RangeError if index is out of bounds.

Map<dynamic, dynamic> elementAt(int index)

Returns the indexth element.

If this has fewer than index elements throws a RangeError.

Note: if this does not have a deterministic iteration order then the function may simply return any element without any iteration if there are at least index elements in this.

@ @
Map<dynamic, dynamic> item(int index)

@ @ @ @ @ @deprecated
Class SqlTransaction extends NativeFieldWrapperClass1

Constructors
SqlTransaction()
Methods
executeSql(String sqlStatement, List<dynamic> arguments, SqlStatementCallback callback, SqlStatementErrorCallback errorCallback): void

Constructors

SqlTransaction()

Methods

@ @
void executeSql(String sqlStatement, List<dynamic> arguments, SqlStatementCallback callback, SqlStatementErrorCallback errorCallback)