Return to test-sqlite3.c CVS log

Up to [cvsweb.bsd.lv] / mandoc

Annotation of mandoc/test-sqlite3.c, Revision 1.2

1.2     ! schwarze    1: /*     $Id: test-sqlite3.c,v 1.1 2014/08/16 19:00:01 schwarze Exp $    */
1.1       schwarze    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));
1.2     ! schwarze   32:                return 1;
1.1       schwarze   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));
1.2     ! schwarze   39:                return 1;
1.1       schwarze   40:        }
                     41:
                     42:        if (sqlite3_close(db) != SQLITE_OK) {
                     43:                fprintf(stderr, "sqlite3_close: %s", sqlite3_errmsg(db));
1.2     ! schwarze   44:                return 1;
1.1       schwarze   45:        }
1.2     ! schwarze   46:        return 0;
1.1       schwarze   47: }