DB

---

Object Hierarchy:

Description:

Content:

Static methods:

• public static void camel_mir_free (MIRecord? record)
  Frees the record and all of its associated data.
• public static Quark error_quark ()
• public static void free_sqlized_string (string? string)
  Frees a string previosuly returned by sqlize_string.
• public static DBKnownColumnNames get_column_ident (ref HashTable<void*,void*> hash, int index, string[] col_names)
  Traverses column name from index index into an enum DBKnownColumnNames value.
• public static string? get_column_name (string raw_name)
• 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.

Creation methods:

• public DB (string filename) throws Error

Methods:

• public int abort_transaction () throws Error
  Ends an ongoing transaction by ignoring the changes.
• public int add_to_transaction (string query) throws Error
  Adds a statement to an ongoing transaction.
• public int begin_transaction () throws Error
  Begins transaction.
• public int clear_folder_summary (string folder_name) throws Error
  Deletes the given folder from the 'folders' table and empties its message info table.
• public int command (string stmt) throws Error
  Executes an SQLite command.
• public int count_deleted_message_info (string table_name, out uint32 count) throws Error
  Counts how many deleted messages is stored in the given table.
• public int count_junk_message_info (string table_name, out uint32 count) throws Error
  Counts how many junk messages is stored in the given table.
• public int count_junk_not_deleted_message_info (string table_name, uint32 count) throws Error
• public int count_message_info (string query, out uint32 count) throws Error
  Executes a COUNT query (like "SELECT COUNT(*) FROM table" ) and provides the result of it as an unsigned 32-bit integer.
• public int count_total_message_info (string table_name, out uint32 count) throws Error
  Counts how many messages is stored in the given table.
• public int count_unread_message_info (string table_name, out uint32 count) throws Error
  Counts how many unread messages is stored in the given table.
• public int count_visible_message_info (string table_name, out uint32 count) throws Error
  Counts how many visible (not deleted and not junk) messages is stored in the given table.
• public int count_visible_unread_message_info (string table_name, out uint32 count) throws Error
  Counts how many visible (not deleted and not junk) and unread messages is stored in the given table.
• public int create_folders_table () throws Error
  Creates a 'folders' table, if it doesn't exist yet.
• public int delete_folder (string folder_name) throws Error
  Deletes the given folder from the 'folders' table and also drops its message info table.
• public int delete_uid (string folder_name, string uid) throws Error
  Deletes single mesage info in the given folder with the given UID.
• public int delete_uids (string folder_name, List<string> uids) throws Error
  Deletes a list of message UIDs as one transaction.
• public int end_transaction () throws Error
  Ends an ongoing transaction by committing the changes.
• public int flush_in_memory_transactions (string folder_name) throws Error
  A pair function for start_in_memory_transactions, to commit the changes to folder_name and free the in-memory table.
• public unowned string get_filename ()
• public GenericArray<string>? get_folder_deleted_uids (string folder_name) throws Error
• public GenericArray<string>? get_folder_junk_uids (string folder_name) throws Error
• public int get_folder_uids (string folder_name, string? sort_by, string? collate, HashTable<string,uint32> hash) throws Error
  Fills hash with uid->GUINT_TO_POINTER (flag).
• public bool maybe_run_maintenance () throws Error
  Runs a this maintenance, which includes vacuum, if necessary.
• public int prepare_message_info_table (string folder_name) throws Error
  Prepares message info table for the given folder.
• public int read_folder_info_record (string folder_name, out FIRecord record) throws Error
  reads folder information for the given folder and stores it into the record.
• public int read_message_info_record_with_uid (string folder_name, string uid, DBSelectCB callback) throws Error
  Selects single message info for the given uid in folder folder_name and calls the callback for it.
• public int read_message_info_records (string folder_name, DBSelectCB callback) throws Error
  Reads all mesasge info records for the given folder and calls callback for them.
• public int rename_folder (string old_folder_name, string new_folder_name) throws Error
  Renames tables for the old_folder_name to be used with new_folder_name.
• public int reset_folder_version (string folder_name, int reset_version) throws Error
  Sets a version number for the given folder.
• public int select (string stmt, DBSelectCB callback) throws Error
  Executes a SELECT staement and calls the callback for each selected row.
• public int 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 int start_in_memory_transactions () throws Error
  Creates an in-memory table for a batch transactions.
• public int transaction_command (List<string> qry_list) throws Error
  Runs the list of commands as a single transaction.
• public int write_folder_info_record (FIRecord record) throws Error
  Write the record to the 'folders' table.
• public int write_message_info_record (string folder_name, MIRecord record) throws Error
  Write the record to the message info table of the given folder.

Inherited Members: