Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 8760 | turbocat | 1 | #include |
| 2 | #include |
||
| 3 | #include |
||
| 4 | |||
| 5 | int main(void) { |
||
| 6 | |||
| 7 | sqlite3 *db; |
||
| 8 | sqlite3_stmt *res; |
||
| 9 | |||
| 10 | int rc = sqlite3_open(":memory:", &db); |
||
| 11 | |||
| 12 | if (rc != SQLITE_OK) { |
||
| 13 | |||
| 14 | fprintf(stderr, "Cannot open database: %s\n", sqlite3_errmsg(db)); |
||
| 15 | sqlite3_close(db); |
||
| 16 | |||
| 17 | return 1; |
||
| 18 | } |
||
| 19 | |||
| 20 | rc = sqlite3_prepare_v2(db, "SELECT SQLITE_VERSION()", -1, &res, 0); |
||
| 21 | |||
| 22 | if (rc != SQLITE_OK) { |
||
| 23 | |||
| 24 | fprintf(stderr, "Failed to fetch data: %s\n", sqlite3_errmsg(db)); |
||
| 25 | sqlite3_close(db); |
||
| 26 | |||
| 27 | return 1; |
||
| 28 | } |
||
| 29 | |||
| 30 | rc = sqlite3_step(res); |
||
| 31 | |||
| 32 | if (rc == SQLITE_ROW) { |
||
| 33 | printf("%s\n", sqlite3_column_text(res, 0)); |
||
| 34 | } |
||
| 35 | |||
| 36 | sqlite3_finalize(res); |
||
| 37 | sqlite3_close(db); |
||
| 38 | |||
| 39 | return 0; |
||
| 40 | } |