Query

---

Object Hierarchy:

Description:

Content:

Properties:

• public Queryable queryable { get; }
  The queryable asscociated with this query
• public string sql { construct; get; }
  The SQL used to create this query
• public int sql_length { construct; }
  The maximum length of the SQL used to create this query
• public bool auto_clear { set; get; }
  When set the bindings will automatically be cleared when an associated QueryResult is destroyed.
• public int parameter_count { get; }
  The number of parameters in the query.

Creation methods:

• public Query (Queryable queryable, string sql) throws Error
  Create a new Query
• public Query.full (Queryable queryable, string sql, int sql_max_len = -1, out string? tail =null) throws Error
  Create a new Query

Methods:

• public unowned string parameter_name (int parameter) throws Error
  Return the name of the specified parameter
• public int parameter_index (string parameter) throws Error
  Return the numeric offset of the specified parameter
• public QueryResult execute (string? first_parameter =null, ...) throws Error
  Execute the query
• public async QueryResult execute_async (Cancellable? cancellable =null) throws Error
  Execute the query asynchronously
• public int64 execute_insert (string? first_parameter =null, ...) throws Error
  Execute the INSERT query
• public async int64 execute_insert_async (Cancellable? cancellable =null) throws Error
  Execute the INSERT query asynchronously
• public void bind (int parameter, Value? value) throws Error
  Bind a value to the specified parameter index
• public void set (string name, Value? value) throws Error
  Bind a value to the specified parameter
• public void bind_int (int field, int value) throws Error
  Bind an int value to the specified parameter index
• public void set_int (string field, int value) throws Error
  Bind an int value to the specified parameter
• public void bind_int64 (int field, int64 value) throws Error
  Bind an int64 value to the specified parameter index
• public void set_int64 (string field, int64 value) throws Error
  Bind an int64 value to the specified parameter
• public void bind_string (int field, string? value) throws Error
  Bind a string value to the specified parameter index
• public void set_string (string field, string? value) throws Error
  Bind a string value to the specified parameter
• public void bind_null (int field) throws Error
  Bind null to the specified parameter index
• public void set_null (string field) throws Error
  Bind null to the specified parameter
• public void bind_double (int field, double value) throws Error
  Bind a double value to the specified parameter index
• public void set_double (string field, double value) throws Error
  Bind an double value to the specified parameter
• public void bind_blob (int field, uint8[] value) throws Error
  Bind a byte array value to the specified parameter index
• public void set_blob (string field, uint8[] value) throws Error
  Bind a byte array value to the specified parameter
• public void bind_byte_array (int field, ByteArray value) throws Error
  Bind a byte array value to the specified parameter index
• public void set_byte_array (string field, ByteArray value) throws Error
  Bind a byte array value to the specified parameter
• public void clear ()
  Clear the bindings
• public GenericArray<GenericArray<Value?>> get_table () throws Error
  Retrieve the entire result set
• public void print_table (FileStream? fd =null) throws Error
  Print the result set to a file stream
• public virtual bool init (Cancellable? cancellable =null) throws Error