[prev in list] [next in list] [prev in thread] [next in thread] 

List:       semsdev
Subject:    [Semsdev] r1338 - trunk/apps/dsm/mods/mod_mysql
From:       sayer () mail ! berlios ! de
Date:       2009-03-25 19:49:48
Message-ID: 200903251949.n2PJnmuF031462 () sheep ! berlios ! de
[Download RAW message or body]

Author: sayer
Date: 2009-03-25 20:49:45 +0100 (Wed, 25 Mar 2009)
New Revision: 1338

Modified:
   trunk/apps/dsm/mods/mod_mysql/ModMysql.cpp
   trunk/apps/dsm/mods/mod_mysql/ModMysql.h
   trunk/apps/dsm/mods/mod_mysql/Readme.mod_mysqlpp.txt
Log:
functions to save a result set under another name, and retrieve it later



Modified: trunk/apps/dsm/mods/mod_mysql/ModMysql.cpp
===================================================================
--- trunk/apps/dsm/mods/mod_mysql/ModMysql.cpp	2009-03-25 19:48:58 UTC (rev 1337)
+++ trunk/apps/dsm/mods/mod_mysql/ModMysql.cpp	2009-03-25 19:49:45 UTC (rev 1338)
@@ -56,6 +56,8 @@
   DEF_CMD("mysql.getResult",          SCMyGetResultAction);
   DEF_CMD("mysql.getClientVersion",   SCMyGetClientVersion);
   DEF_CMD("mysql.resolveQueryParams", SCMyResolveQueryParams);
+  DEF_CMD("mysql.saveResult",         SCMySaveResultAction);
+  DEF_CMD("mysql.useResult",          SCMyUseResultAction);
 
   return NULL;
 }
@@ -289,7 +291,6 @@
 
 CONST_ACTION_2P(SCMyQueryGetResultAction, ',', true);
 EXEC_ACTION_START(SCMyQueryGetResultAction) {
-  DBG("par1='%s', par2='%s'\n", par1.c_str(), par2.c_str());
   mysqlpp::Connection* conn = 
     getMyDSMSessionConnection(sc_sess);
   if (NULL == conn) 
@@ -410,3 +411,11 @@
   return conn->connected();
 } MATCH_CONDITION_END;
 
+
+EXEC_ACTION_START(SCMySaveResultAction) {
+  sc_sess->avar[resolveVars(arg, sess, sc_sess, event_params)] = sc_sess->avar[MY_AKEY_RESULT];
+} EXEC_ACTION_END;
+
+EXEC_ACTION_START(SCMyUseResultAction) {
+  sc_sess->avar[MY_AKEY_RESULT] = sc_sess->avar[resolveVars(arg, sess, sc_sess, event_params)];
+} EXEC_ACTION_END;

Modified: trunk/apps/dsm/mods/mod_mysql/ModMysql.h
===================================================================
--- trunk/apps/dsm/mods/mod_mysql/ModMysql.h	2009-03-25 19:48:58 UTC (rev 1337)
+++ trunk/apps/dsm/mods/mod_mysql/ModMysql.h	2009-03-25 19:49:45 UTC (rev 1338)
@@ -85,6 +85,8 @@
 DEF_ACTION_1P(SCMyResolveQueryParams);
 DEF_SCCondition(MyHasResultCondition);
 DEF_SCCondition(MyConnectedCondition);
+DEF_ACTION_1P(SCMySaveResultAction);
+DEF_ACTION_1P(SCMyUseResultAction);
 
 
 

Modified: trunk/apps/dsm/mods/mod_mysql/Readme.mod_mysqlpp.txt
===================================================================
--- trunk/apps/dsm/mods/mod_mysql/Readme.mod_mysqlpp.txt	2009-03-25 19:48:58 UTC (rev 1337)
+++ trunk/apps/dsm/mods/mod_mysql/Readme.mod_mysqlpp.txt	2009-03-25 19:49:45 UTC (rev 1338)
@@ -79,7 +79,11 @@
 -- gets client version into $db.client_version
  mysql.getClientVersion()
 
+-- save result into another name
+  mysql.saveResult(string name)
 
+-- user saved result
+  mysql.userResult(string name)
 
 Conditions
 ==========
@@ -107,6 +111,7 @@
                    | 
   Result           | avar["db.res"]
                    | 
+  Result           | avar[parameter] on mysql.saveResult
 
 Note: Due to the implementation of MySQL++, the complete result set has 
 to be copied one more time internally, if mysql.query() is used. So if

_______________________________________________
Semsdev mailing list
Semsdev@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/semsdev
[prev in list] [next in list] [prev in thread] [next in thread]