DB

---

Object Hierarchy:

Description:

Content:

Static methods:

• public static Quark error_quark ()
• public static void free_sqlized_string (string? string)
  Frees a string previously returned by sqlize_string.
• public static void release_cache_memory ()
  Instructs sqlite to release its memory, if possible.
• public static string sqlize_string (string string)
  Converts the string to be usable in the SQLite statements.
• public static void sqlize_to_statement (StringBuilder stmt, string? str, DBSqlizeFlags flags)
  Encodes the str to be safe to use as a string in an SQL statement and appends it to the stmt.

Creation methods:

• public DB (string filename) throws Error
  Creates a new DB instance and calls open to open a database file.

Methods:

• public bool abort_transaction () throws Error
  Ends an ongoing transaction by ignoring the changes.
• public bool begin_transaction () throws Error
  Begins transaction.
• public bool end_transaction () throws Error
  Ends an ongoing transaction by committing the changes.
• public bool exec_select (string stmt, DBSelectCB callback) throws Error
  Executes a SELECT statement and calls the callback for each selected row.
• public bool exec_statement (string stmt) throws Error
  Executes an SQLite statement.
• public unowned string get_filename ()
• public bool has_table (string table_name)
  Checks whether the table_name exists in the this.
• public bool has_table_with_column (string table_name, string column_name)
  Checks whether the table_name exists in the this and contains column named column_name.
• public bool maybe_run_maintenance () throws Error
  Runs a this maintenance, which includes vacuum, if necessary.
• public bool open (string filename) throws Error
  Opens the database stored as filename.
• public void reader_lock ()
  Acquires a reader lock on the this.
• public void reader_unlock ()
  Releases a reader lock on the this previously acquired by calling reader_lock.
• public bool set_collate (string col, string collate, DBCollate func)
  Defines a collation collate, which can be used in SQL ( SQLite) statement as a collation function.
• public void writer_lock ()
  Acquires a writer lock on the this.
• public void writer_unlock ()
  Releases a write lock on the this previously acquired by calling writer_lock.

Inherited Members: