1 /* $Id: test-sqlite3.c,v 1.1 2014/08/16 19:00:01 schwarze Exp $ */
2 /*
3 * Copyright (c) 2014 Ingo Schwarze <schwarze@openbsd.org>
4 *
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.
8 *
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.
16 */
17
18 #include <stdio.h>
19 #include <unistd.h>
20 #include <sqlite3.h>
21
22 int
main(void)23 main(void)
24 {
25 sqlite3 *db;
26
27 if (sqlite3_open_v2("test.db", &db,
28 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE,
29 NULL) != SQLITE_OK) {
30 perror("test.db");
31 fprintf(stderr, "sqlite3_open_v2: %s", sqlite3_errmsg(db));
32 return(1);
33 }
34 unlink("test.db");
35
36 if (sqlite3_exec(db, "PRAGMA foreign_keys = ON",
37 NULL, NULL, NULL) != SQLITE_OK) {
38 fprintf(stderr, "sqlite3_exec: %s", sqlite3_errmsg(db));
39 return(1);
40 }
41
42 if (sqlite3_close(db) != SQLITE_OK) {
43 fprintf(stderr, "sqlite3_close: %s", sqlite3_errmsg(db));
44 return(1);
45 }
46 return(0);
47 }
48