|
| begin databaseRef |
| Marks the begin of a database transaction. More...
|
|
| commit databaseRef |
| Marks the completion of a database transaction as successful. More...
|
|
| connect databaseRef databaseFileName |
| Opens a connection with a database. More...
|
|
| createIndex databaseRef indexName tableName columnNameList args |
| Creates an index. More...
|
|
| createTable databaseRef tableName columnNameTypeList args |
| Creates a table. More...
|
|
| delete databaseRef tableName whereCondition |
| Deletes one or more rows from a table. More...
|
|
| deleteIndex databaseRef indexName |
| Deletes an index. More...
|
|
| deleteTable databaseRef tableName |
| Deletes a table. More...
|
|
| disconnect databaseRef |
| Closes a connection with a database. More...
|
|
| executeSql databaseRef sqlStatement |
| Executes an SQL statement. More...
|
|
| explainSql databaseRef sqlStatement |
| Retrieves the execution plan of an SQL statement without executing the statement. More...
|
|
| export databaseRef tableName filePath |
| Exports the content of a table to a CSV (tab-separated) file. More...
|
|
| getIndexInfo databaseRef indexName |
| Retrieves meta information about an index. More...
|
|
| getIndexInfoList databaseRef |
| Retrieves meta information about all indexes in the database. More...
|
|
| getShowSql |
| Tells, if SQL statements are shown. More...
|
|
| getTableInfo databaseRef tableName |
| Retrieves meta information about a table. More...
|
|
| getTableInfoList databaseRef |
| Retrieves meta information about all tables in the database. More...
|
|
| import databaseRef tableName filePath |
| Imports the content of a CSV (tab-separated) file to a table. More...
|
|
| insert databaseRef tableName columnValueList |
| Inserts a row into a table. More...
|
|
| optimizeSpace databaseRef |
| Optimizes the database with respect to space. More...
|
|
| optimizeTime databaseRef |
| Optimizes the database with respect to time. More...
|
|
| rollback databaseRef |
| Marks the completion of a database transaction as not successful. More...
|
|
| select databaseRef columnNameList tableNameList whereCondition args |
| Retrieves one or more rows of one or more tables. More...
|
|
| setShowSql showSql |
| Changes, if SQL statements are shown. More...
|
|
| update databaseRef tableName columnNameValueList whereCondition |
| Updates one or more rows of a table. More...
|
|
SQLlite interface to the internal T4x database.
External sqlite API.