1 /* $Id: test-sqlite3.c,v 1.1 2014/08/16 19:00:01 schwarze Exp $ */
3 * Copyright (c) 2014 Ingo Schwarze <schwarze@openbsd.org>
5 * Permission to use, copy, modify, and distribute this software for any
6 * purpose with or without fee is hereby granted, provided that the above
7 * copyright notice and this permission notice appear in all copies.
9 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
10 * WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
11 * MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
12 * ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
13 * WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
14 * ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
15 * OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
27 if (sqlite3_open_v2("test.db", &db,
28 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE,
31 fprintf(stderr, "sqlite3_open_v2: %s", sqlite3_errmsg(db));
36 if (sqlite3_exec(db, "PRAGMA foreign_keys = ON",
37 NULL, NULL, NULL) != SQLITE_OK) {
38 fprintf(stderr, "sqlite3_exec: %s", sqlite3_errmsg(db));
42 if (sqlite3_close(db) != SQLITE_OK) {
43 fprintf(stderr, "sqlite3_close: %s", sqlite3_errmsg(db));