src/modules/m_testclient.cpp

   1 /*       +------------------------------------+
   2  *       | Inspire Internet Relay Chat Daemon |
   3  *       +------------------------------------+
   4  *
   5  *  InspIRCd: (C) 2002-2009 InspIRCd Development Team
   6  * See: http://wiki.inspircd.org/Credits
   7  *
   8  * This program is free but copyrighted software; see
   9  *            the file COPYING for details.
  10  *
  11  * ---------------------------------------------------
  12  */
  13
  14 #include "inspircd.h"
  15 #include "m_sqlv2.h"
  16
  17 class ModuleTestClient : public Module
  18 {
  19 private:
  20
  21
  22 public:
  23         ModuleTestClient()
  24         {
  25                 Implementation eventlist[] = { I_OnBackgroundTimer };
  26                 ServerInstance->Modules->Attach(eventlist, this, 1);
  27         }
  28
  29
  30         virtual Version GetVersion()
  31         {
  32                 return Version("SQL test module", VF_VENDOR);
  33         }
  34
  35         virtual void OnBackgroundTimer(time_t)
  36         {
  37                 Module* target = ServerInstance->Modules->FindFeature("SQL");
  38
  39                 if(target)
  40                 {
  41                         SQLrequest foo = SQLrequest(this, target, "foo",
  42                                         SQLquery("UPDATE rawr SET foo = '?' WHERE bar = 42") % ServerInstance->Time());
  43
  44                         foo.Send();
  45                         if (foo.cancel)
  46                         {
  47                                 ServerInstance->Logs->Log("m_testclient.so", DEBUG, "SQLrequest failed: %s", foo.error.Str());
  48                         }
  49                         else
  50                         {
  51                                 ServerInstance->Logs->Log("m_testclient.so", DEBUG, "Sent query, got given ID %lu", foo.id);
  52                         }
  53                 }
  54         }
  55
  56         void OnRequest(Request& request)
  57         {
  58                 if(strcmp(SQLRESID, request.id) == 0)
  59                 {
  60                         ServerInstance->Logs->Log("m_testclient.so", DEBUG, "Got SQL result (%s)", request.id);
  61
  62                         SQLresult* res = (SQLresult*)&request;
  63
  64                         if (res->error.Id() == SQL_NO_ERROR)
  65                         {
  66                                 if(res->Cols())
  67                                 {
  68                                         ServerInstance->Logs->Log("m_testclient.so", DEBUG, "Got result with %d rows and %d columns", res->Rows(), res->Cols());
  69
  70                                         for (int r = 0; r < res->Rows(); r++)
  71                                         {
  72                                                 ServerInstance->Logs->Log("m_testclient.so", DEBUG, "Row %d:", r);
  73
  74                                                 for(int i = 0; i < res->Cols(); i++)
  75                                                 {
  76                                                         ServerInstance->Logs->Log("m_testclient.so", DEBUG, "\t[%s]: %s", res->ColName(i).c_str(), res->GetValue(r, i).d.c_str());
  77                                                 }
  78                                         }
  79                                 }
  80                                 else
  81                                 {
  82                                         ServerInstance->Logs->Log("m_testclient.so", DEBUG, "%d rows affected in query", res->Rows());
  83                                 }
  84                         }
  85                         else
  86                         {
  87                                 ServerInstance->Logs->Log("m_testclient.so", DEBUG, "SQLrequest failed: %s", res->error.Str());
  88                         }
  89                 }
  90
  91                 ServerInstance->Logs->Log("m_testclient.so", DEBUG, "Got unsupported API version string: %s", request.id);
  92         }
  93
  94         virtual ~ModuleTestClient()
  95         {
  96         }
  97 };
  98
  99 MODULE_INIT(ModuleTestClient)
 100