test-sqlite3.c

   1 /*      $Id: test-sqlite3.c,v 1.2 2015/10/06 18:32:20 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
  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 }