aboutsummaryrefslogtreecommitdiff
path: root/src/database_sqlite.cc
diff options
context:
space:
mode:
authorfusion32 <marcopuzziello@gmail.com>2025-10-10 15:14:02 -0300
committerfusion32 <marcopuzziello@gmail.com>2025-10-10 15:22:27 -0300
commit46c653293381dcc1188013d3e2c3f7587a199dc4 (patch)
tree0b9776f73d6e2afcd9104cf400dc5e345fcdcbea /src/database_sqlite.cc
parentcc4873e33866ba86561774a7e55449d59367661e (diff)
downloadquerymanager-46c653293381dcc1188013d3e2c3f7587a199dc4.tar.gz
querymanager-46c653293381dcc1188013d3e2c3f7587a199dc4.zip
organize database configs and schema files + compilation guards
Diffstat (limited to 'src/database_sqlite.cc')
-rw-r--r--src/database_sqlite.cc19
1 files changed, 11 insertions, 8 deletions
diff --git a/src/database_sqlite.cc b/src/database_sqlite.cc
index 8a5e526..37a62e0 100644
--- a/src/database_sqlite.cc
+++ b/src/database_sqlite.cc
@@ -1,3 +1,4 @@
+#if DATABASE_SQLITE
#include "querymanager.hh"
#include "sqlite3.h"
@@ -43,8 +44,8 @@ public:
static void EnsureStatementCache(TDatabase *Database){
if(Database->CachedStatements == NULL){
- ASSERT(g_Config.MaxCachedStatements > 0);
- Database->MaxCachedStatements = g_Config.MaxCachedStatements;
+ ASSERT(g_Config.SQLite.MaxCachedStatements > 0);
+ Database->MaxCachedStatements = g_Config.SQLite.MaxCachedStatements;
Database->CachedStatements = (TCachedStatement*)calloc(
Database->MaxCachedStatements, sizeof(TCachedStatement));
}
@@ -233,8 +234,8 @@ static bool InitDatabaseSchema(TDatabase *Database){
return false;
}
- if(!ExecFile(Database, "sql/schema.sql")){
- LOG_ERR("Failed to execute \"sql/schema.sql\"");
+ if(!ExecFile(Database, "sqlite/schema.sql")){
+ LOG_ERR("Failed to execute \"sqlite/schema.sql\"");
return false;
}
@@ -255,7 +256,7 @@ static bool UpgradeDatabaseSchema(TDatabase *Database, int UserVersion){
char FileName[256];
int NewVersion = UserVersion;
while(true){
- snprintf(FileName, sizeof(FileName), "sql/upgrade-%d.sql", NewVersion);
+ snprintf(FileName, sizeof(FileName), "sqlite/upgrade-%d.sql", NewVersion);
if(FileExists(FileName)){
NewVersion += 1;
}else{
@@ -346,9 +347,9 @@ void DatabaseClose(TDatabase *Database){
TDatabase *DatabaseOpen(void){
TDatabase *Database = (TDatabase*)calloc(1, sizeof(TDatabase));
int Flags = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_NOMUTEX;
- if(sqlite3_open_v2(g_Config.DatabaseFile, &Database->Handle, Flags, NULL) != SQLITE_OK){
+ if(sqlite3_open_v2(g_Config.SQLite.File, &Database->Handle, Flags, NULL) != SQLITE_OK){
LOG_ERR("Failed to open database at \"%s\": %s\n",
- g_Config.DatabaseFile, sqlite3_errmsg(Database->Handle));
+ g_Config.SQLite.File, sqlite3_errmsg(Database->Handle));
DatabaseClose(Database);
return NULL;
}
@@ -357,7 +358,7 @@ TDatabase *DatabaseOpen(void){
LOG_ERR("Failed to open database file \"%s\" with WRITE PERMISSIONS."
" Make sure it has the appropriate permissions and is owned"
" by the same user running the query manager.",
- g_Config.DatabaseFile);
+ g_Config.SQLite.File);
DatabaseClose(Database);
return NULL;
}
@@ -2482,3 +2483,5 @@ bool CheckOnlineRecord(TDatabase *Database, int WorldID, int NumCharacters, bool
*NewRecord = sqlite3_changes(Database->Handle) > 0;
return true;
}
+
+#endif //DATABASE_SQLITE