Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include "sqlite3.h"
- #include "sqliteInt.h"
- #include "vdbe.h"
- #include "vdbeInt.h"
- #include "opcodes.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(int argc,char* argv[])
- {
- sqlite3 *db;
- sqlite3_stmt *pStmt=NULL;
- char *sql,*zerrmsg=0;
- int rc,i;
- Vdbe *pVdbe;
- const unsigned char *zAns;
- //open database
- rc=sqlite3_open("d.db",&db);
- if(rc) {
- fprintf(stderr,"cant open database: %s \n",sqlite3_errmsg(db));
- exit(0);
- }
- sql="drop table student;";
- rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
- sql="drop table location;";
- rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
- //create table
- sql="create table student(id int primary key,name text,age int);"\
- "create table location(city text,country text,id int primary key);";
- rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
- //insert values
- sql="insert into student values(1,'sai',20);"\
- "insert into student values(2,'ram',25);"\
- "insert into location values('new york','usa',1);"\
- "insert into location values('london','uk',2);";
- rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
- if( rc != SQLITE_OK ) {
- fprintf(stderr, "SQL error: %s\n", zerrmsg);
- sqlite3_free(zerrmsg);
- }
- else {
- fprintf(stdout, "Records created successfully\n");
- }
- sql="select * from student,location;";
- rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
- if(rc != SQLITE_OK){
- fprintf(stderr, "SQL error: %s\n", zerrmsg);
- sqlite3_free(zerrmsg); }
- rc = sqlite3_prepare(db,sql,strlen(sql)+1,&pStmt,NULL);
- if(rc != SQLITE_OK) {
- fprintf(stderr, "SQL error: Prepare Err");
- }
- pVdbe = (Vdbe*)pStmt;
- for(i=0;i<pVdbe->nOp;i++) {
- sqlite3VdbePrintOp(stdout,i,&pVdbe->aOp[i]);
- }
- sqlite3_close(db);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement