summaryrefslogtreecommitdiff
path: root/modules/dbsqlite/main.cpp
diff options
context:
space:
mode:
authorGluzskiy Alexandr <sss123next@list.ru>2010-10-13 00:17:40 +0300
committerGluzskiy Alexandr <sss123next@list.ru>2010-10-13 00:17:40 +0300
commit42992bc2c04dcfd322ead3fda1134439a2cfcf3a (patch)
tree4b825dc642cb6eb9a060e54bf8d69288fbee4904 /modules/dbsqlite/main.cpp
parent599d73442416d9bad663e4d0900265e073946600 (diff)
cleanup, switching to wxwidgets as main development framework
Diffstat (limited to 'modules/dbsqlite/main.cpp')
-rw-r--r--modules/dbsqlite/main.cpp135
1 files changed, 0 insertions, 135 deletions
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 <windows.h>
-#include <stdio.h>
-
-#include <pluginapi.h>
-#include <plugin_helper.h>
-#include <db.h>
-
-#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);
-}
-