|
ret=sqlite3_exec(sqlDB->db,"ROLLBACK", NULL,NULL, &errmsg);
if(ret != SQLITE_OK)
{
gseLog(L_ERROR,"ret = %d, ROLLBACK: %s", ret, errmsg);
}
sqlite3_free(errmsg);
return ret;
}
#ifdef MAIN_TEST
void main()
{
char createva lueStr[MAX_SQLSTR]={0};
char insertString[MAX_SQLSTR]={0};
char updateSetStr[MAX_SQLSTR]={0};
char searchWhereStr[MAX_SQLSTR]={0};
char *dbFileName="lkdb";
char *tableName="tb";
char *colList[]={"ID","names","sexsex"};
int ret=0;
timeLog();
dbClass sqlDB;
sqlDB.type = SQL_SQLITE3;
DBOpen(&sqlDB, dbFileName, NULL, NULL, NULL);
// sqlDB.type = SQL_MYSQL;
// DBOpen(&sqlDB, dbFileName, "localhost", "root", "mima");
#if 1
dbAddColumn(createva lueStr, colList[0], PRIMAY_KEY);
dbAddColumn(createva lueStr, colList[1], NVARCHAR_32);
dbAddColumn(createva lueStr, colList[2], NVARCHAR_32);
DBCreate(&sqlDB, tableName, createva lueStr);
dbInsertColumn(insertString, "1");
dbInsertColumn(insertString, "'y_jg'");
dbInsertColumn(insertString, "'man'");
DBInsert(&sqlDB,tableName,insertString);
dbInsertColumn(insertString, "2");
dbInsertColumn(insertString, "'lk'");
dbInsertColumn(insertString, "'man'");
DBInsert(&sqlDB,tableName,insertString);
dbInsertColumn(insertString, "3");
dbInsertColumn(insertString, "'fqq'");
dbInsertColumn(insertString, "'woman'");
DBInsert(&sqlDB,tableName,insertString);
dbInsertColumn(insertString, "4");
dbInsertColumn(insertString, "'xf'");
dbInsertColumn(insertString, "'man'");
DBInsert(&sqlDB,tableName,insertString);
#endif
dbUpdateSet(updateSetStr,"names", "'xxxx'");
dbSearchWhere(searchWhereStr,"id","3");
DBUpdate(&sqlDB,tableName,updateSetStr,searchWhereStr);
DBClose(&sqlDB);
timeLog();
}
#endif
|