src/http/pages/execquerypage.cpp

   1 #include "../../../include/http/pages/execquerypage.h"\r
   2 #include "../../../include/stringfunctions.h"\r
   3 \r
   4 #ifdef XMEM\r
   5         #include <xmem.h>\r
   6 #endif\r
   7 \r
   8 const std::string ExecQueryPage::GeneratePage(const std::string &method, const std::map<std::string,std::string> &queryvars)\r
   9 {\r
  10         std::string content="";\r
  11 \r
  12         if(queryvars.find("formaction")!=queryvars.end() && (*queryvars.find("formaction")).second=="execute" && queryvars.find("query")!=queryvars.end() && (*queryvars.find("query")).second!="")\r
  13         {\r
  14                 SQLite3DB::Recordset rs=m_db->Query((*queryvars.find("query")).second);\r
  15 \r
  16                 content+="<table>";\r
  17                 while(!rs.AtEnd())\r
  18                 {\r
  19                         content+="<tr>";\r
  20                         for(int i=0; i<rs.Cols(); i++)\r
  21                         {\r
  22                                 content+="<td>";\r
  23                                 if(rs.GetField(i))\r
  24                                 {\r
  25                                         content+=rs.GetField(i);\r
  26                                 }\r
  27                                 content+="</td>";\r
  28                         }\r
  29                         content+="</tr>";\r
  30                         rs.Next();\r
  31                 }\r
  32                 content+="</table>";\r
  33         }\r
  34 \r
  35         content+="<h2>Execute Query</h2>";\r
  36         content+="<form name=\"frmquery\" method=\"POST\">";\r
  37         content+="<input type=\"hidden\" name=\"formaction\" value=\"execute\">";\r
  38         content+="<textarea name=\"query\" rows=\"10\" cols=\"80\"></textarea>";\r
  39         content+="<input type=\"submit\" value=\"Execute Query\">";\r
  40         content+="</form>";\r
  41 \r
  42         return "HTTP/1.1 200 OK\r\nContent-Type: text/html\r\n\r\n"+StringFunctions::Replace(m_template,"[CONTENT]",content);\r
  43 }\r
  44 \r
  45 const bool ExecQueryPage::WillHandleURI(const std::string &uri)\r
  46 {\r
  47         if(uri.find("execquery.")!=std::string::npos)\r
  48         {\r
  49                 return true;\r
  50         }\r
  51         else\r
  52         {\r
  53                 return false;\r
  54         }\r
  55 }\r