class EDC_SQLITE_CONNECTION
Summary
Overview
creation features
exported features
Connection management:
Session management:
Fetch direction:
Error management:
Constants:
Result codes
disconnect
effective procedure
Disconnect from the data source
is_connected: BOOLEAN
effective function
Is the data source connected?
commit
effective procedure
Commit changed data back to the data source
new_savepoint (name: STRING): EDC_SAVEPOINT
effective function
A new savepoint
rollback
effective procedure
Forgets and changed data
rollback_to (a_savepoint: EDC_SAVEPOINT)
effective procedure
Rolls the data back to the given savepoint
auto_commit: BOOLEAN
writable attribute
True if any data changed is immediately committed
set_auto_commit (a_auto_commit: BOOLEAN)
effective procedure
Sets the auto_commit mode
create_table (a_table: EDC_TABLE)
effective procedure
Create the table in the data source
drop_table (a_table: EDC_TABLE)
effective procedure
Drops the given table
has_table_name (a_table_name: STRING): BOOLEAN
effective function
Does the data source know this table?
table (a_table_name: STRING): EDC_TABLE
effective function
The table in the data source
all_table_names: FAST_ARRAY[STRING]
effective function
The names of all the known tables
set_fetch_direction (a_fetch_direction: INTEGER_32)
effective procedure
Sets the fetch_diection
fetch_direction: INTEGER_32
writable attribute
Direction in which the data is returned
is_equal (other: EDC_CONNECTION): BOOLEAN
deferred function
to freeze signature
set_error_handler (a_error_handler: PROCEDURE[TUPLE 2[STRING, STRING]])
effective procedure
error_handler: PROCEDURE[TUPLE 2[STRING, STRING]]
writable attribute
Used to emit error messages.
select_data (columns: TRAVERSABLE[EDC_COLUMN]): EDC_SELECT
effective function
Starts a select query that will return data from the data source
insert_data (columns: TRAVERSABLE[EDC_COLUMN]): EDC_INSERT
effective function
Starts an insert query that will insert data in the data source
update_data (columns: TRAVERSABLE[EDC_COLUMN]): EDC_UPDATE
effective function
Starts an update query that will modify some data in the data source
delete_data (columns: TRAVERSABLE[EDC_COLUMN]): EDC_DELETE
effective function
Starts a delete query that will remove some data from the data source
Fetch_forward: INTEGER_32
constant attribute
Fetch_backward: INTEGER_32
constant attribute
sqlite_ok: INTEGER_32
SQL error or missing database
sqlite_error: INTEGER_32
SQL error or missing database
sqlite_internal: INTEGER_32
An internal logic error in SQLite
sqlite_perm: INTEGER_32
Access permission denied
sqlite_abort: INTEGER_32
Callback routine requested an abort
sqlite_busy: INTEGER_32
The database file is locked
sqlite_locked: INTEGER_32
A table in the database is locked
sqlite_nomem: INTEGER_32
A malloc() failed
sqlite_readonly: INTEGER_32
Attempt to write a readonly database
sqlite_interrupt: INTEGER_32
Operation terminated by sqlite_interrupt()
sqlite_ioerr: INTEGER_32
Some kind of disk I/O error occurred
sqlite_corrupt: INTEGER_32
The database disk image is malformed
sqlite_notfound: INTEGER_32
(Internal Only) Table or record not found
sqlite_full: INTEGER_32
Insertion failed because database is full
sqlite_cantopen: INTEGER_32
Unable to open the database file
sqlite_protocol: INTEGER_32
Database lock protocol error
sqlite_empty: INTEGER_32
(Internal Only) Database table is empty
sqlite_schema: INTEGER_32
The database schema changed
sqlite_toobig: INTEGER_32
Too much data for one row of a table
sqlite_constraint: INTEGER_32
Abort due to constraint violation
sqlite_mismatch: INTEGER_32
Data type mismatch
sqlite_misuse: INTEGER_32
Library used incorrectly
sqlite_nolfs: INTEGER_32
Uses OS features not supported on host
sqlite_auth: INTEGER_32
Authorization denied
sqlite_row: INTEGER_32
sqlite_step() has another row ready
sqlite_done: INTEGER_32
sqlite_step() has finished executing
error_message (code: INTEGER_32): STRING
effective function