#include<stdio.h>
#include<stdlib.h>
#include<string.h>
#include "sqlite3.h"
#include "sqliteInt.h"
#include "vdbe.h"
#include "vdbeInt.h"

static int callback(void *NotUsed, int argc, char **argv, char **azColName) {
    int i;
    //printf("callback\n");
    for (i = 0; i < argc-1; i++)  printf("%s,",argv[i] ? argv[i] : "NULL");
    printf("%s.",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;
Vdbe *pVdbe;
int i;

//open database
rc=sqlite3_open("tt2.db",&db);
if(rc)
{
fprintf(stderr,"cant open database: %s \n",sqlite3_errmsg(db));
exit(0);
}
sql="drop table em;";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
sql="drop table idv;";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
sql="drop table mny;";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
sql="drop table lo;";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);

//create table
sql="create table em(name int primary key,age int);"\
    "create table idv(id int primary key,name text);"\
    "create table mny(id int primary key,sal int);"\
    "create table lo(name int primary key,addr text);";

rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
//insert values
sql="insert into em values(44,21);"\
    "insert into em values(11,20);"\
    "insert into idv values(10,44);"\
    "insert into idv values(5,11);"\
    "insert into mny values(10,10000);"\
    "insert into mny values(6,5000);"\
    "insert into lo values(44,'NY');"\
    "insert into lo values(11,'che');";

rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);
sql="select * from em,idv,mny,lo where em.name=lo.name and idv.id=mny.id";
rc=sqlite3_exec(db,sql,callback,0,&zerrmsg);


if(rc != SQLITE_OK)
   { fprintf(stderr, "SQL error: %s\n", zerrmsg);
      sqlite3_free(zerrmsg); }
sqlite3_prepare(db,sql,strlen(sql)+1,&pStmt,NULL);
pVdbe = (Vdbe*)pStmt;

   for(i=0;i<pVdbe->nOp;i++)
   sqlite3VdbePrintOp(stdout,i,&pVdbe->aOp[i]);
sqlite3_close(db);
}