Queryable

---

Object Hierarchy:

Description:

Content:

Properties:

• public abstract Database database { owned get; }
  Database

Methods:

• public abstract void lock ()
  Lock the queryable and refuse to run any queries against it.
• public abstract void unlock ()
  Unlock the queryable and allow queries to be run against it.
• public abstract void queue (Query query) throws Error
  Queue a query to be executed when the queryable is unlocked
• public virtual Transaction begin_transaction () throws Error
  Begin a transaction. Will lock the queryable until the transaction is resolved.
• public QueryResult execute (string sql, ...) throws Error
  Execute the supplied SQL
• public void run (string sql, ...) throws Error
  Execute the supplied SQL, iterating through multiple statements if necessary.
• public int64 execute_insert (string sql, ...) throws Error
  Execute the supplied insert statement
• public virtual Query prepare (string sql) throws Error
  Create a prepared statement.
• public virtual void run_script (string filename) throws Error
  Runs an SQL script located in a file
• public virtual void print_table (string sql, FileStream? fd =null) throws Error
  Print the result set to a file stream

Signals:

• public void query_executed (Query query)
  Signal which is emitted when a query finished executing.