FilesExpand file tree

 add_python2_warning

/

test.c

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

52 lines (47 loc) · 1.31 KB

 add_python2_warning

/

test.c

Top

File metadata and controls

• Code
• Blame

52 lines (47 loc) · 1.31 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

/*

* Copyright 2011 The Emscripten Authors. All rights reserved.

* Emscripten is available under two separate licenses, the MIT license and the

* University of Illinois/NCSA Open Source License. Both these licenses can be

* found in the LICENSE file.

*/

#include <stdio.h>

#include <stdlib.h>

#include <sqlite3.h>

static int callback(void *NotUsed, int argc, char **argv, char **azColName){

int i;

for(i=0; i<argc; i++){

printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");

}

printf("\n");

return 0;

}

int main(){

sqlite3 *db;

char *zErrMsg = 0;

int rc;

int i;

const char *commands[] = {

"CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));",

"INSERT INTO t1 VALUES(1,13153,'thirteen thousand one hundred fifty three');",

"INSERT INTO t1 VALUES(1,987,'some other number');",

"SELECT count(*) FROM t1;",

"SELECT a, b, c FROM t1;",

NULL

};

rc = sqlite3_open(":memory:", &db);

if( rc ){

fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));

sqlite3_close(db);

exit(1);

}

for (i = 0; commands[i]; i++) {

rc = sqlite3_exec(db, commands[i], callback, 0, &zErrMsg);

if( rc!=SQLITE_OK ){

fprintf(stderr, "SQL error on %d: %s\n", i, zErrMsg);

sqlite3_free(zErrMsg);

exit(1);

}

}

sqlite3_close(db);

return 0;

}