From 87218eadcdeac5ba86a035edfd079958405cb24f Mon Sep 17 00:00:00 2001
From: Machiavelli <none@none>
Date: Wed, 18 Aug 2010 02:25:52 +0200
Subject: * HIGHLY EXPERIMENTAL - USE AT OWN RISK * Database Layer: - Implement
 connection pooling: Instead of 1 delay thread per database, you can configure
 between 1 and 32 worker threads that have a seperate thread in the core and
 have a seperate connection to the MySQL server (based on raczman/Albator´s
 database layer for Trinitycore3) - Implement a configurable thread bundle for
 synchroneous requests from seperate core threads (see worldserver.conf.dist
 for more info) - Every mapupdate thread now has its seperate MySQL connection
 to the world and characters database - Drop inconsistent PExecuteLog function
 - query logging will be implemented CONSISTENTLY later - Drop current
 prepared statement interface - this will be done *properly* later - You´ll
 need to update your worldserver.conf and authserver.conf - You´re recommended
 to make a backup of your databases before using this. * HIGHLY EXPERIMENTAL -
 USE AT OWN RISK * * HIGHLY EXPERIMENTAL - USE AT OWN RISK * etc.
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

--HG--
branch : trunk
---
 src/server/shared/Database/PreparedStatements.cpp | 93 -----------------------
 1 file changed, 93 deletions(-)
 delete mode 100644 src/server/shared/Database/PreparedStatements.cpp

(limited to 'src/server/shared/Database/PreparedStatements.cpp')

diff --git a/src/server/shared/Database/PreparedStatements.cpp b/src/server/shared/Database/PreparedStatements.cpp
deleted file mode 100644
index ec57a0f90e8..00000000000
--- a/src/server/shared/Database/PreparedStatements.cpp
+++ /dev/null
@@ -1,93 +0,0 @@
-#include "PreparedStatements.h"
-
-void PreparedStatementHolder::_prepareStatement(const char* name, const char* sql, Database *db, uint32 &count)
-{
-    const char prefix[] = "PREPARE ";
-    size_t querySize = 8 + strlen(name) + 6 + strlen(sql) + 2 + 1;
-    char* query = new char[querySize];
-    strcpy(query, prefix);
-    strcat(query, name);
-    strcat(query, " FROM ");
-    strcat(query, "'");
-    strcat(query, sql);
-    strcat(query, "'");
-
-    DEBUG_LOG("Preparing statement: %s", query);
-    db->Execute(query);
-
-    delete[] query;
-    ++count;
-}
-
-void PreparedStatementHolder::LoadAuthserver(Database *db, uint32 &count)
-{
-    _prepareStatement("auth_ping", "SELECT 1 FROM realmlist LIMIT 1", db, count);
-};
-
-void PreparedStatementHolder::Execute(Database *db, const char *name)
-{
-    const char prefix[] = "EXECUTE ";
-    size_t querySize = 8 + strlen(name) + 1;
-    char* query = new char[querySize];
-    strcpy(query, prefix);
-    strcat(query, name);
-
-    DEBUG_LOG("Prepared statement: %s", query);
-    db->Execute(query);
-    delete[] query;
-}
-
-void PreparedStatementHolder::PExecute(Database *db, const char *name, const char* args)
-{
-    // NOTE: if args == NULL, we're crashing here. No need to waste performance on checking;
-    // devs must make sure they use PExecute for args and Execute for no args.
-
-    const char prefix[] = "EXECUTE ";
-    size_t querySize = 8 + strlen(name) + 7 + strlen(args) + 1;
-    char* query = new char[querySize];
-    strcpy(query, prefix);
-    strcat(query, name);
-    strcat(query, " USING ");
-    strcat(query, args);
-
-    DEBUG_LOG("Prepared statement (parsed args): %s", query);
-    db->Execute(query);
-    delete[] query;
-}
-
-QueryResult_AutoPtr PreparedStatementHolder::Query(Database *db, const char *name)
-{
-    QueryResult_AutoPtr _return = QueryResult_AutoPtr(NULL);
-
-    const char prefix[] = "EXECUTE ";
-    size_t querySize = 8 + strlen(name) + 1;
-    char* query = new char[querySize];
-    strcpy(query, prefix);
-    strcat(query, name);
-
-    DEBUG_LOG("Prepared statement with resultset: %s", query);
-    _return = db->Query(query);
-    delete[] query;
-    return _return;
-}
-
-QueryResult_AutoPtr PreparedStatementHolder::PQuery(Database *db, const char *name, const char *args)
-{
-    // NOTE: if args == NULL, we're crashing here. No need to waste performance on checking;
-    // devs must make sure they use PQuery for args and Query for no args.
-
-    QueryResult_AutoPtr _return = QueryResult_AutoPtr(NULL);
-
-    const char prefix[] = "EXECUTE ";
-    size_t querySize = 8 + strlen(name) + 7 + strlen(args) + 1;
-    char* query = new char[querySize];
-    strcpy(query, prefix);
-    strcat(query, name);
-    strcat(query, " USING ");
-    strcat(query, args);
-
-    DEBUG_LOG("Prepared statement with resultset (parsed args): %s", query);
-    _return = db->Query(query);
-    delete[] query;
-    return _return;
-}
\ No newline at end of file
-- 
cgit v1.2.3