/* sqlite3.vala * * Copyright (C) 2007 Jürg Billeter * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA * * Author: * Jürg Billeter */ [CCode (lower_case_cprefix = "sqlite3_", cheader_filename = "sqlite3.h")] namespace Sqlite { /* Database Connection Handle */ [Compact] [CCode (free_function = "sqlite3_close", cname = "sqlite3", cprefix = "sqlite3_")] public class Database { public int busy_timeout (int ms); public int changes (); public int exec (string sql, Callback? sqlite3_callback = null, out string errmsg = null); public int extended_result_codes (int onoff); public int get_autocommit (); public void interrupt (); public int64 last_insert_rowid (); public int total_changes (); public int complete (string sql); public int get_table (string sql, [CCode (array_length = false)] out weak string[] resultp, out int nrow, out int ncolumn, out string errmsg); public static void free_table ([CCode (array_length = false)] string[] result); 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); public int errcode (); public weak string errmsg (); public int prepare (string sql, int n_bytes, out Statement stmt, out string tail = null); public int prepare_v2 (string sql, int n_bytes, out Statement stmt, out string tail = null); public void trace (TraceCallback? xtrace); public void profile (ProfileCallback? xprofile); public void progress_handler (int n_opcodes, Sqlite.ProgressCallback? progress_handler); public void commit_hook (CommitCallback? commit_hook); public void rollback_hook (RollbackCallback? rollback_hook); } [CCode (instance_pos = 0)] public delegate void TraceCallback (string message); [CCode (instance_pos = 0)] public delegate void ProfileCallback (string sql, uint64 time); public delegate int ProgressCallback (); public delegate int CommitCallback (); public delegate void RollbackCallback (); /* Dynamically Typed Value Object */ [Compact] [CCode (cname = "sqlite3_value")] public class Value { [CCode (cname = "sqlite3_value_blob")] public void* to_blob (); [CCode (cname = "sqlite3_value_bytes")] public int to_bytes (); [CCode (cname = "sqlite3_value_double")] public double to_double (); [CCode (cname = "sqlite3_value_int")] public int to_int (); [CCode (cname = "sqlite3_value_int64")] public int64 to_int64 (); [CCode (cname = "sqlite3_value_text")] public weak string to_text (); [CCode (cname = "sqlite3_value_type")] public int to_type (); [CCode (cname = "sqlite3_value_numeric_type")] public int to_numeric_type (); } [CCode (cname = "sqlite3_callback", instance_pos = 0)] public delegate int Callback (int n_columns, [CCode (array_length = false)] string[] values, [CCode (array_length = false)] string[] column_names); [CCode (cname = "SQLITE_OK")] public const int OK; [CCode (cname = "SQLITE_ERROR")] public const int ERROR; [CCode (cname = "SQLITE_INTERNAL")] public const int INTERNAL; [CCode (cname = "SQLITE_PERM")] public const int PERM; [CCode (cname = "SQLITE_ABORT")] public const int ABORT; [CCode (cname = "SQLITE_BUSY")] public const int BUSY; [CCode (cname = "SQLITE_LOCKED")] public const int LOCKED; [CCode (cname = "SQLITE_NOMEM")] public const int NOMEM; [CCode (cname = "SQLITE_READONLY")] public const int READONLY; [CCode (cname = "SQLITE_INTERRUPT")] public const int INTERRUPT; [CCode (cname = "SQLITE_IOERR")] public const int IOERR; [CCode (cname = "SQLITE_CORRUPT")] public const int CORRUPT; [CCode (cname = "SQLITE_NOTFOUND")] public const int NOTFOUND; [CCode (cname = "SQLITE_FULL")] public const int FULL; [CCode (cname = "SQLITE_CANTOPEN")] public const int CANTOPEN; [CCode (cname = "SQLITE_PROTOCOL")] public const int PROTOCOL; [CCode (cname = "SQLITE_EMPTY")] public const int EMPTY; [CCode (cname = "SQLITE_SCHEMA")] public const int SCHEMA; [CCode (cname = "SQLITE_TOOBIG")] public const int TOOBIG; [CCode (cname = "SQLITE_CONSTRAINT")] public const int CONSTRAINT; [CCode (cname = "SQLITE_MISMATCH")] public const int MISMATCH; [CCode (cname = "SQLITE_MISUSE")] public const int MISUSE; [CCode (cname = "SQLITE_NOLFS")] public const int NOLFS; [CCode (cname = "SQLITE_AUTH")] public const int AUTH; [CCode (cname = "SQLITE_FORMAT")] public const int FORMAT; [CCode (cname = "SQLITE_RANGE")] public const int RANGE; [CCode (cname = "SQLITE_NOTADB")] public const int NOTADB; [CCode (cname = "SQLITE_ROW")] public const int ROW; [CCode (cname = "SQLITE_DONE")] public const int DONE; [CCode (cname = "SQLITE_OPEN_READONLY")] public const int OPEN_READONLY; [CCode (cname = "SQLITE_OPEN_READWRITE")] public const int OPEN_READWRITE; [CCode (cname = "SQLITE_OPEN_CREATE")] public const int OPEN_CREATE; [CCode (cname = "SQLITE_INTEGER")] public const int INTEGER; [CCode (cname = "SQLITE_FLOAT")] public const int FLOAT; [CCode (cname = "SQLITE_BLOB")] public const int BLOB; [CCode (cname = "SQLITE_NULL")] public const int NULL; [CCode (cname = "SQLITE3_TEXT")] public const int TEXT; [CCode (cname = "SQLITE_MUTEX_FAST")] public const int MUTEX_FAST; [CCode (cname = "SQLITE_MUTEX_RECURSIVE")] public const int MUTEX_RECURSIVE; /* SQL Statement Object */ [Compact] [CCode (free_function = "sqlite3_finalize", cname = "sqlite3_stmt", cprefix = "sqlite3_")] public class Statement { public int bind_parameter_count (); public int bind_parameter_index (string name); public weak string bind_parameter_name (int index); public int clear_bindings (); public int column_count (); public int data_count (); public weak Database db_handle (); public int reset (); public int step (); public int bind_blob (int index, void* value, int n, GLib.DestroyNotify destroy_notify); public int bind_double (int index, double value); public int bind_int (int index, int value); public int bind_int64 (int index, int64 value); public int bind_null (int index); public int bind_text (int index, owned string value, int n = -1, GLib.DestroyNotify destroy_notify = GLib.g_free); public int bind_value (int index, Value value); public int bind_zeroblob (int index, int n); public void* column_blob (int col); public int column_bytes (int col); public double column_double (int col); public int column_int (int col); public int64 column_int64 (int col); public weak string column_text (int col); public int column_type (int col); public weak Value column_value (int col); public weak string column_name (int index); public weak string sql (); } [Compact] [CCode (cname = "sqlite3_mutex")] public class Mutex { [CCode (cname = "sqlite3_mutex_alloc")] public Mutex (int mutex_type = MUTEX_RECURSIVE); public void enter (); public int @try (); public void leave (); } }