From 42992bc2c04dcfd322ead3fda1134439a2cfcf3a Mon Sep 17 00:00:00 2001 From: Gluzskiy Alexandr Date: Wed, 13 Oct 2010 00:17:40 +0300 Subject: cleanup, switching to wxwidgets as main development framework --- modules/dbsqlite/main.cpp | 135 ---------------------------------------------- 1 file changed, 135 deletions(-) delete mode 100644 modules/dbsqlite/main.cpp (limited to 'modules/dbsqlite/main.cpp') diff --git a/modules/dbsqlite/main.cpp b/modules/dbsqlite/main.cpp deleted file mode 100644 index 35ec873..0000000 --- a/modules/dbsqlite/main.cpp +++ /dev/null @@ -1,135 +0,0 @@ -#include -#include - -#include -#include -#include - -#include "sqlite3.h" - -PLUGINLINK *pluginLink; -sqlite3* db; -char* db_err = 0; - -SERVICE svc_dbWriteSetting(WPARAM w, LPARAM l); -SERVICE svc_dbGetSetting(WPARAM w, LPARAM l); -SERVICE svc_dbDeleteSetting(WPARAM w, LPARAM l); - -HINSTANCE hInst; -BOOL WINAPI DllMain( HINSTANCE hinstDLL, DWORD fdwReason, LPVOID lpvReserved ) -{ - hInst = hinstDLL; - return TRUE; -} - -PLUGININFO pluginInfo = -{ - sizeof(PLUGININFO), - (char*)"SQLite database support plugin", - (char*)"Support for data storage in local sql database through libsqlite", - (char*)"sss", - (char*)"sss123next@list.ru", - PLUGIN_MAKE_VERSION(0,0,0,1), - F_DB_PLUGIN -}; - -extern "C" __declspec(dllexport) PLUGININFO* SetPluginInfo() -{ - return &pluginInfo; -} - -static int callback(void *NotUsed, int argc, char **argv, char **azColName) -{ - for(int i = 0; i < argc; i++) - { - MessageBoxA(0, argv[i], azColName[i], MB_OK); - } - return 0; -} - - -extern "C" int __declspec(dllexport) Load(PLUGINLINK *link) -{ - pluginLink = link; - CreateServiceFunction("Db/WriteSetting", (SERVICE)svc_dbWriteSetting); - CreateServiceFunction("Db/GetSetting", (SERVICE)svc_dbGetSetting); - CreateServiceFunction("Db/DeleteSetting", (SERVICE)svc_dbDeleteSetting); - if(!sqlite3_open_v2(".\\database.sql3", &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL)) - MessageBoxA(0, "dbsqlite plugin loaded", "INFO", MB_OK); - return 0; -} - -extern "C" int __declspec(dllexport) OnModulesLoaded() -{ - sqlite3_exec(db, "CREATE TABLE 'data' (id INTEGER PRYMARY KEY, module TEXT, setting TEXT, string TEXT, number INT, binary BLOB);", callback, 0, &db_err); - //some autoindexing code here - sqlite3_exec(db, "SELECT * FROM data;", callback, 0, &db_err); - MessageBoxA(0, db_err, "INFO", MB_OK); - for(;;) - Sleep(1000); - return 0; -} -extern "C" int __declspec(dllexport) Unload() -{ - while(sqlite3_close(db) == SQLITE_BUSY) - Sleep(1000); - MessageBoxA(0, "Database succesfuly unloaded", "INFO", MB_OK); - return 0; -} - -SERVICE svc_dbWriteSetting(WPARAM w, LPARAM l) -{ - PLUGININFO *info = (PLUGININFO*)w; - DATA *data = (DATA*)l; - switch (data->wType) - { - char buf[512], tmp[32]; - case D_INT: - itoa((int&)data->pData, tmp, 10); - strcpy(buf, "INSERT INTO 'data' (module, setting, number) VALUES ('"); - strcat(buf, info->shortName); - strcat(buf, "', '"); - strcat(buf, data->szSetting); - strcat(buf, "', "); - strcat(buf, tmp); - strcat(buf, ");"); - sqlite3_exec(db, buf, callback, 0, &db_err); - MessageBoxA(0, db_err, "INFO", MB_OK); - break; - case D_STRING: - strcpy(buf, "INSERT INTO 'data' (module, setting, string) VALUES ('"); - strcat(buf, info->shortName); - strcat(buf, "', '"); - strcat(buf, data->szSetting); - strcat(buf, "', '"); - strcat(buf, (char*)data->pData); - strcat(buf, "');"); - sqlite3_exec(db, buf, callback, 0, &db_err); - MessageBoxA(0, db_err, "INFO", MB_OK); - break; - case D_BLOB: - break; - default: - break; - } -} -SERVICE svc_dbGetSetting(WPARAM w, LPARAM l) -{ - PLUGININFO *info = (PLUGININFO*)w; - DATA *data = (DATA*)l; -} - -SERVICE svc_dbDeleteSetting(WPARAM w, LPARAM l) -{ - PLUGININFO *info = (PLUGININFO*)w; - DATA *data = (DATA*)l; - char buf[512]; - strcpy(buf, "DELETE FROM data WHERE module = '"); - strcat(buf, info->shortName); - strcat(buf, "' AND setting = '"); - strcat(buf, data->szSetting); - strcat(buf, "';"); - sqlite3_exec(db, buf, callback, 0, &db_err); - MessageBoxA(0, db_err, "INFO", MB_OK); -} - -- cgit v1.2.3