Database

Object Hierarchy:

Description:

public static int main (string[] args) {
	Sqlite.Database db;
	string errmsg;

	// Open a database:
	int ec = Sqlite.Database.open ("test.db", out db);
	if (ec != Sqlite.OK) {
		stderr.printf ("Can't open database: %d: %s\n", db.errcode (), db.errmsg ());
		return -1;
	}

	// Insert test data:
	string query = """
		CREATE TABLE User (
			id		INT		PRIMARY KEY		NOT NULL,
			name	TEXT					NOT NULL
		);

		INSERT INTO User (id, name) VALUES (1, 'Hesse');
		INSERT INTO User (id, name) VALUES (2, 'Frisch');
		""";
	ec = db.exec (query, null, out errmsg);
	if (ec != Sqlite.OK) {
		stderr.printf ("Error: %s\n", errmsg);
		return -1;
	}

	//
	// Create a prepared statement:
	// (db.prepare shouldn't be used anymore)
	//

	Sqlite.Statement stmt;

	const string prepared_query_str = "SELECT * FROM User WHERE id = $UID;";
	ec = db.prepare_v2 (prepared_query_str, prepared_query_str.length, out stmt);
	if (ec != Sqlite.OK) {
		stderr.printf ("Error: %d: %s\n", db.errcode (), db.errmsg ());
		return -1;
	}

	//
	// Use the prepared statement:
	//

	int param_position = stmt.bind_parameter_index ("$UID");
	assert (param_position > 0);

	stmt.bind_int (param_position, 1);


	int cols = stmt.column_count ();
	while (stmt.step () == Sqlite.ROW) {
		for (int i = 0; i < cols; i++) {
			string col_name = stmt.column_name (i) ?? "<none>";
			string val = stmt.column_text (i) ?? "<none>";
			int type_id = stmt.column_type (i);

			print ("column: %s\n", col_name);
			print ("value: %s\n", val);
			print ("type: %d\n", type_id);
		}
	}

	// Output:
	//	``column: id``
	//	``value: 1``
	//	``type: 1``
	//	``column: name``
	//	``value: Hesse``
	//	``type: 3``


	// Reset the statement to rebind parameters:
	stmt.reset ();

	// ...

	return 0;
}

valac --pkg sqlite3 prepared-statements.vala

Content:

Static methods:

• public static int complete (string sql)
• public static int open (string filename, out Database db)
• public static int open_v2 (string filename, out Database db, int flags = OPEN_READWRITE | OPEN_CREATE, string? zVfs = null)

Methods:

• public int _exec (string sql, Callback? callback = null, out unowned string? errmsg = null)
• public int _get_table (string sql, out unowned string[] resultp, out int nrow, out int ncolumn, out unowned string? errmsg = null)
• public int busy_timeout (int ms)
• public int changes ()
• public void commit_hook (CommitCallback? commit_hook)
• public int create_collation (string zName, int eTextRep, CompareCallback xCompare)
• public int create_function (string zFunctionName, int nArg, int eTextRep, void* user_data, UserFuncCallback? xFunc, UserFuncCallback? xStep, UserFuncFinishCallback? xFinal)
• public int create_function_v2 (string zFunctionName, int nArg, int eTextRep, void* user_data, UserFuncCallback? xFunc, UserFuncCallback? xStep, UserFuncFinishCallback? xFinal, DestroyNotify? destroy = null)
• public int errcode ()
• public unowned string errmsg ()
• public int exec (string sql, Callback? callback = null, out string? errmsg = null)
• public int extended_result_codes (int onoff)
• public int get_autocommit ()
• public int get_table (string sql, out string[] resultp, out int nrow, out int ncolumn, out string? errmsg = null)
• public void interrupt ()
• public int64 last_insert_rowid ()
• public int limit (Limit id, int new_val)
• public unowned Statement next_stmt (Statement? current)
• public int prepare (string sql, int n_bytes, out Statement stmt, out unowned string tail = null)
• public int prepare_v2 (string sql, int n_bytes, out Statement stmt, out unowned string tail = null)
• public void profile (ProfileCallback? xprofile)
• public void progress_handler (int n_opcodes, ProgressCallback? progress_handler)
• public void rollback_hook (RollbackCallback? rollback_hook)
• public int set_authorizer (AuthorizeCallback? auth)
• public int status (DatabaseStatus op, out int pCurrent, out int pHighwater, int resetFlag = 0)
• public int table_column_metadata (string db_name, string table_name, string column_name, out string? data_type, out string? collation_sequence, out int? not_null, out int? primary_key, out int? auto_increment)
• public int total_changes ()
• public void trace (TraceCallback? xtrace)
• public void update_hook (UpdateCallback? update_hook)
• public int wal_autocheckpoint (int N)
• public int wal_checkpoint (string zDb)
• public void* wal_hook (WALHookCallback cb)