[Half-Life AMXX] / testsuite / sqlxtest.sma Repository:
ViewVC logotype

Diff of /testsuite/sqlxtest.sma

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 16, Fri Nov 16 15:12:40 2007 UTC revision 17, Fri Nov 16 15:29:57 2007 UTC
# Line 12  Line 12 
12          register_plugin("SQLX Test", "1.0", "BAILOPAN")          register_plugin("SQLX Test", "1.0", "BAILOPAN")
13          register_srvcmd("sqlx_test_normal", "SqlxTest_Normal")          register_srvcmd("sqlx_test_normal", "SqlxTest_Normal")
14          register_srvcmd("sqlx_test_thread", "SqlxTest_Thread")          register_srvcmd("sqlx_test_thread", "SqlxTest_Thread")
15            register_srvcmd("sqlx_test_proc", "SqlxTest_Proc")
16          register_srvcmd("sqlx_test_old1", "SqlxTest_Old1")          register_srvcmd("sqlx_test_old1", "SqlxTest_Old1")
17          register_srvcmd("sqlx_test_old2", "SqlxTest_Old2")          register_srvcmd("sqlx_test_old2", "SqlxTest_Old2")
18          register_srvcmd("sqlx_test_thread_end", "SqlxTest_ThreadEnd")          register_srvcmd("sqlx_test_thread_end", "SqlxTest_ThreadEnd")
19          register_srvcmd("sqlx_test_bad", "SqlxTest_Bad")          register_srvcmd("sqlx_test_bad", "SqlxTest_Bad")
20            register_srvcmd("sqlx_test_quote", "SqlxTest_Quote")
21            register_srvcmd("sqlx_test_affinity", "SqlxTest_Affinity")
22    
23          new configsDir[64]          new configsDir[64]
24          get_configsdir(configsDir, 63)          get_configsdir(configsDir, 63)
25    
26          server_cmd("exec %s/sql.cfg", configsDir)          server_cmd("exec %s/sql.cfg", configsDir)
27          server_exec()  
28            set_task(2.0, "start_map")
29  }  }
30    
31  DoBasicInfo(affinities=0)  DoBasicInfo(affinities=0)
# Line 54  Line 58 
58                          wanted_type,                          wanted_type,
59                          res ? "Success" : "Failed")                          res ? "Success" : "Failed")
60                  SQL_GetAffinity(affinity, 11)                  SQL_GetAffinity(affinity, 11)
61                  plugin_cfg()                  start_map()
62                  server_print("Verification: %s", affinity)                  server_print("Verification: %s", affinity)
63          }          }
64  }  }
65    
66  public plugin_cfg()  public start_map()
67  {  {
68          new host[64]          new host[64]
69          new user[64]          new user[64]
# Line 144  Line 148 
148          }          }
149  }  }
150    
151    public SqlxTest_Affinity()
152    {
153            server_print("[Access Manager] try SetAffinity to sqlite");
154            SQL_SetAffinity("sqlite");
155            server_print("[Access Manager] try SetAffinity to mysql");
156            SQL_SetAffinity("mysql");
157            server_print("[Access Manager] try SetAffinity to sqlite again");
158            SQL_SetAffinity("sqlite");
159    }
160    
161  /**  /**
162   * Starts a threaded query.   * Starts a threaded query.
163   */   */
# Line 164  Line 178 
178  }  }
179    
180  /**  /**
181     * Tests string quoting
182     */
183    public SqlxTest_Quote()
184    {
185            DoBasicInfo(1)
186    
187            new errno, error[255]
188    
189            new Handle:db = SQL_Connect(g_DbInfo, errno, error, sizeof(error)-1)
190            if (!db)
191            {
192                    server_print("Query failure: [%d] %s", errno, error)
193                    return
194            }
195    
196            new buffer[500], num
197            num = SQL_QuoteString(db, buffer, sizeof(buffer)-1, "Hi y'all! C\lam")
198    
199            server_print("num: %d str: %s", num, buffer)
200    
201            SQL_FreeHandle(db)
202    }
203    
204    public SqlxTest_Proc()
205    {
206            new errnum, error[255]
207    
208            DoBasicInfo(1)
209    
210            new Handle:db = SQL_Connect(g_DbInfo, errnum, error, 254)
211            if (!db)
212            {
213                    server_print("Query failure: [%d] %s", errnum, error)
214                    return
215            }
216    
217            new Handle:query = SQL_PrepareQuery(db, "CALL ExampleProc()")
218            if (!SQL_Execute(query))
219            {
220                    errnum = SQL_QueryError(query, error, 254)
221                    server_print("Query failure: [%d] %s", errnum, error)
222                    SQL_FreeHandle(query)
223                    SQL_FreeHandle(db)
224                    return
225            }
226    
227            PrintQueryData(query)
228    
229            server_print("Next result: %d", SQL_NextResultSet(query));
230    
231            PrintQueryData(query)
232    
233            SQL_FreeHandle(query)
234            SQL_FreeHandle(db)
235    }
236    
237    /**
238   * Does a normal query.   * Does a normal query.
239   */   */
240  public SqlxTest_Normal()  public SqlxTest_Normal()
# Line 191  Line 262 
262    
263          PrintQueryData(query)          PrintQueryData(query)
264    
265            server_print("Next result: %d", SQL_NextResultSet(query));
266    
267          SQL_FreeHandle(query)          SQL_FreeHandle(query)
268          SQL_FreeHandle(db)          SQL_FreeHandle(db)
269  }  }
Legend:
Removed from v.16  
changed lines
  Added in v.17
Contact
 ViewVC Help
Powered by ViewVC 1.0.4