Donatien Garnier
NetServices Stack source
Dependents: HelloWorld ServoInterfaceBoardExample1 4180_Lab4
services/mysql/MySQLClient.h@5:dd63a1e02b1b, 2010-07-27 (annotated)
- Committer:
- donatien
- Date:
- Tue Jul 27 15:59:42 2010 +0000
- Revision:
- 5:dd63a1e02b1b
- Parent:
- 0:632c9925f013
- Child:
- 6:b7dd7cde8ad2
Who changed what in which revision?
| User | Revision | Line number | New contents of line |
|---|---|---|---|
| donatien | 0:632c9925f013 | 1 | |
| donatien | 0:632c9925f013 | 2 | /* |
| donatien | 0:632c9925f013 | 3 | Copyright (c) 2010 Donatien Garnier (donatiengar [at] gmail [dot] com) |
| donatien | 0:632c9925f013 | 4 | |
| donatien | 0:632c9925f013 | 5 | Permission is hereby granted, free of charge, to any person obtaining a copy |
| donatien | 0:632c9925f013 | 6 | of this software and associated documentation files (the "Software"), to deal |
| donatien | 0:632c9925f013 | 7 | in the Software without restriction, including without limitation the rights |
| donatien | 0:632c9925f013 | 8 | to use, copy, modify, merge, publish, distribute, sublicense, and/or sell |
| donatien | 0:632c9925f013 | 9 | copies of the Software, and to permit persons to whom the Software is |
| donatien | 0:632c9925f013 | 10 | furnished to do so, subject to the following conditions: |
| donatien | 0:632c9925f013 | 11 | |
| donatien | 0:632c9925f013 | 12 | The above copyright notice and this permission notice shall be included in |
| donatien | 0:632c9925f013 | 13 | all copies or substantial portions of the Software. |
| donatien | 0:632c9925f013 | 14 | |
| donatien | 0:632c9925f013 | 15 | THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR |
| donatien | 0:632c9925f013 | 16 | IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, |
| donatien | 0:632c9925f013 | 17 | FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE |
| donatien | 0:632c9925f013 | 18 | AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER |
| donatien | 0:632c9925f013 | 19 | LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, |
| donatien | 0:632c9925f013 | 20 | OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN |
| donatien | 0:632c9925f013 | 21 | THE SOFTWARE. |
| donatien | 0:632c9925f013 | 22 | */ |
| donatien | 0:632c9925f013 | 23 | |
| donatien | 0:632c9925f013 | 24 | #ifndef MYSQL_CLIENT_H |
| donatien | 0:632c9925f013 | 25 | #define MYSQL_CLIENT_H |
| donatien | 0:632c9925f013 | 26 | |
| donatien | 0:632c9925f013 | 27 | #include "if/net/net.h" |
| donatien | 0:632c9925f013 | 28 | #include "api/TCPSocket.h" |
| donatien | 0:632c9925f013 | 29 | #include "api/DNSRequest.h" |
| donatien | 0:632c9925f013 | 30 | #include "mbed.h" |
| donatien | 0:632c9925f013 | 31 | |
| donatien | 0:632c9925f013 | 32 | #include <string> |
| donatien | 0:632c9925f013 | 33 | using std::string; |
| donatien | 0:632c9925f013 | 34 | |
| donatien | 0:632c9925f013 | 35 | #include <map> |
| donatien | 0:632c9925f013 | 36 | using std::map; |
| donatien | 0:632c9925f013 | 37 | |
| donatien | 0:632c9925f013 | 38 | typedef unsigned char byte; |
| donatien | 0:632c9925f013 | 39 | |
| donatien | 5:dd63a1e02b1b | 40 | ///MySQL client results |
| donatien | 0:632c9925f013 | 41 | enum MySQLResult |
| donatien | 0:632c9925f013 | 42 | { |
| donatien | 0:632c9925f013 | 43 | MYSQL_OK, |
| donatien | 0:632c9925f013 | 44 | MYSQL_PROCESSING, |
| donatien | 0:632c9925f013 | 45 | MYSQL_PRTCL, |
| donatien | 5:dd63a1e02b1b | 46 | MYSQL_SETUP, ///Not properly configured |
| donatien | 5:dd63a1e02b1b | 47 | MYSQL_DNS, ///Could not resolve name |
| donatien | 5:dd63a1e02b1b | 48 | MYSQL_AUTHFAILED, ///Auth failure |
| donatien | 5:dd63a1e02b1b | 49 | MYSQL_READY, ///Ready to send commands |
| donatien | 5:dd63a1e02b1b | 50 | MYSQL_SQL, ///SQL Error |
| donatien | 5:dd63a1e02b1b | 51 | MYSQL_TIMEOUT, ///Connection timeout |
| donatien | 5:dd63a1e02b1b | 52 | MYSQL_CONN ///Connection error |
| donatien | 0:632c9925f013 | 53 | }; |
| donatien | 0:632c9925f013 | 54 | |
| donatien | 5:dd63a1e02b1b | 55 | ///A MySQL Client |
| donatien | 5:dd63a1e02b1b | 56 | /** |
| donatien | 5:dd63a1e02b1b | 57 | This MySQL client implements a limited subset of the MySQL internal client/server protocol (including authentication), for server versions 4.1 and newer. |
| donatien | 5:dd63a1e02b1b | 58 | */ |
| donatien | 0:632c9925f013 | 59 | class MySQLClient : protected NetService |
| donatien | 0:632c9925f013 | 60 | { |
| donatien | 0:632c9925f013 | 61 | public: |
| donatien | 5:dd63a1e02b1b | 62 | ///Instantiates the MySQL client |
| donatien | 0:632c9925f013 | 63 | MySQLClient(); |
| donatien | 0:632c9925f013 | 64 | virtual ~MySQLClient(); |
| donatien | 0:632c9925f013 | 65 | |
| donatien | 0:632c9925f013 | 66 | //High Level setup functions |
| donatien | 5:dd63a1e02b1b | 67 | |
| donatien | 5:dd63a1e02b1b | 68 | ///Opens a connection to a server |
| donatien | 5:dd63a1e02b1b | 69 | /** |
| donatien | 5:dd63a1e02b1b | 70 | Opens a connection to the server host using the provided username, password passowrd and selecting database |
| donatien | 5:dd63a1e02b1b | 71 | On completion of this call (and any further one), the callback set in parameter is fired with the result of that command in parameter |
| donatien | 5:dd63a1e02b1b | 72 | @param host : server |
| donatien | 5:dd63a1e02b1b | 73 | @param user : username |
| donatien | 5:dd63a1e02b1b | 74 | @param db : database to use |
| donatien | 5:dd63a1e02b1b | 75 | @param pMethod : callback to call on each request completion |
| donatien | 5:dd63a1e02b1b | 76 | */ |
| donatien | 0:632c9925f013 | 77 | MySQLResult open(Host& host, const string& user, const string& password, const string& db, void (*pMethod)(MySQLResult)); //Non blocking |
| donatien | 5:dd63a1e02b1b | 78 | |
| donatien | 5:dd63a1e02b1b | 79 | ///Opens a connection to a server |
| donatien | 5:dd63a1e02b1b | 80 | /** |
| donatien | 5:dd63a1e02b1b | 81 | Opens a connection to the server host using the provided username, password passowrd and selecting database |
| donatien | 5:dd63a1e02b1b | 82 | On completion of this call (and any further one), the callback set in parameter is fired with the result of that command in parameter |
| donatien | 5:dd63a1e02b1b | 83 | @param host : server |
| donatien | 5:dd63a1e02b1b | 84 | @param user : username |
| donatien | 5:dd63a1e02b1b | 85 | @param db : database to use |
| donatien | 5:dd63a1e02b1b | 86 | @param pItem : callback's class instance |
| donatien | 5:dd63a1e02b1b | 87 | @param pMethod : callback's method to call on each request completion |
| donatien | 5:dd63a1e02b1b | 88 | */ |
| donatien | 0:632c9925f013 | 89 | template<class T> |
| donatien | 0:632c9925f013 | 90 | MySQLResult open(Host& host, const string& user, const string& password, const string& db, T* pItem, void (T::*pMethod)(MySQLResult)) //Non blocking |
| donatien | 0:632c9925f013 | 91 | { |
| donatien | 0:632c9925f013 | 92 | setOnResult(pItem, pMethod); |
| donatien | 0:632c9925f013 | 93 | setup(host, user, password, db); |
| donatien | 0:632c9925f013 | 94 | return MYSQL_PROCESSING; |
| donatien | 0:632c9925f013 | 95 | } |
| donatien | 0:632c9925f013 | 96 | |
| donatien | 5:dd63a1e02b1b | 97 | |
| donatien | 5:dd63a1e02b1b | 98 | ///Executes an SQL command |
| donatien | 5:dd63a1e02b1b | 99 | /** |
| donatien | 5:dd63a1e02b1b | 100 | Executes an SQL request on the SQL server |
| donatien | 5:dd63a1e02b1b | 101 | This is a non-blocking function |
| donatien | 5:dd63a1e02b1b | 102 | On completion, the callback set in the open function is fired with the result of the command in parameter |
| donatien | 5:dd63a1e02b1b | 103 | @param sqlCommand SQL request to execute |
| donatien | 5:dd63a1e02b1b | 104 | */ |
| donatien | 0:632c9925f013 | 105 | MySQLResult sql(string& sqlCommand); |
| donatien | 0:632c9925f013 | 106 | |
| donatien | 5:dd63a1e02b1b | 107 | ///Closes the connection to the server |
| donatien | 0:632c9925f013 | 108 | MySQLResult exit(); |
| donatien | 0:632c9925f013 | 109 | |
| donatien | 0:632c9925f013 | 110 | void setOnResult( void (*pMethod)(MySQLResult) ); |
| donatien | 0:632c9925f013 | 111 | class CDummy; |
| donatien | 0:632c9925f013 | 112 | template<class T> |
| donatien | 0:632c9925f013 | 113 | void setOnResult( T* pItem, void (T::*pMethod)(MySQLResult) ) |
| donatien | 0:632c9925f013 | 114 | { |
| donatien | 0:632c9925f013 | 115 | m_pCb = NULL; |
| donatien | 0:632c9925f013 | 116 | m_pCbItem = (CDummy*) pItem; |
| donatien | 0:632c9925f013 | 117 | m_pCbMeth = (void (CDummy::*)(MySQLResult)) pMethod; |
| donatien | 0:632c9925f013 | 118 | } |
| donatien | 0:632c9925f013 | 119 | |
| donatien | 5:dd63a1e02b1b | 120 | ///Setups timeout |
| donatien | 5:dd63a1e02b1b | 121 | /** |
| donatien | 5:dd63a1e02b1b | 122 | @param ms : time of connection inactivity in ms after which the request should timeout |
| donatien | 5:dd63a1e02b1b | 123 | */ |
| donatien | 0:632c9925f013 | 124 | void setTimeout(int ms); |
| donatien | 0:632c9925f013 | 125 | |
| donatien | 0:632c9925f013 | 126 | virtual void poll(); //Called by NetServices |
| donatien | 0:632c9925f013 | 127 | |
| donatien | 0:632c9925f013 | 128 | protected: |
| donatien | 0:632c9925f013 | 129 | void resetTimeout(); |
| donatien | 0:632c9925f013 | 130 | |
| donatien | 0:632c9925f013 | 131 | void init(); |
| donatien | 0:632c9925f013 | 132 | void close(); |
| donatien | 0:632c9925f013 | 133 | |
| donatien | 0:632c9925f013 | 134 | void setup(Host& host, const string& user, const string& password, const string& db); //Setup connection, make DNS Req if necessary |
| donatien | 0:632c9925f013 | 135 | void connect(); //Start Connection |
| donatien | 0:632c9925f013 | 136 | |
| donatien | 0:632c9925f013 | 137 | void handleHandshake(); |
| donatien | 0:632c9925f013 | 138 | void sendAuth(); |
| donatien | 0:632c9925f013 | 139 | |
| donatien | 0:632c9925f013 | 140 | void handleAuthResult(); |
| donatien | 0:632c9925f013 | 141 | void sendAuth323(); |
| donatien | 0:632c9925f013 | 142 | |
| donatien | 0:632c9925f013 | 143 | void sendCommand(byte command, byte* arg, int len); |
| donatien | 0:632c9925f013 | 144 | void handleCommandResult(); |
| donatien | 0:632c9925f013 | 145 | |
| donatien | 0:632c9925f013 | 146 | void readData(); //Copy to buf |
| donatien | 0:632c9925f013 | 147 | void writeData(); //Copy from buf |
| donatien | 0:632c9925f013 | 148 | |
| donatien | 0:632c9925f013 | 149 | void onTCPSocketEvent(TCPSocketEvent e); |
| donatien | 0:632c9925f013 | 150 | void onDNSReply(DNSReply r); |
| donatien | 0:632c9925f013 | 151 | void onResult(MySQLResult r); //Called when exchange completed or on failure |
| donatien | 0:632c9925f013 | 152 | void onTimeout(); //Connection has timed out |
| donatien | 0:632c9925f013 | 153 | |
| donatien | 0:632c9925f013 | 154 | private: |
| donatien | 0:632c9925f013 | 155 | CDummy* m_pCbItem; |
| donatien | 0:632c9925f013 | 156 | void (CDummy::*m_pCbMeth)(MySQLResult); |
| donatien | 0:632c9925f013 | 157 | |
| donatien | 0:632c9925f013 | 158 | void (*m_pCb)(MySQLResult); |
| donatien | 0:632c9925f013 | 159 | |
| donatien | 0:632c9925f013 | 160 | TCPSocket* m_pTCPSocket; |
| donatien | 0:632c9925f013 | 161 | |
| donatien | 0:632c9925f013 | 162 | Timer m_watchdog; |
| donatien | 0:632c9925f013 | 163 | int m_timeout; |
| donatien | 0:632c9925f013 | 164 | |
| donatien | 0:632c9925f013 | 165 | DNSRequest* m_pDnsReq; |
| donatien | 0:632c9925f013 | 166 | |
| donatien | 0:632c9925f013 | 167 | bool m_closed; |
| donatien | 0:632c9925f013 | 168 | |
| donatien | 0:632c9925f013 | 169 | enum MySQLStep |
| donatien | 0:632c9925f013 | 170 | { |
| donatien | 0:632c9925f013 | 171 | // MYSQL_INIT, |
| donatien | 0:632c9925f013 | 172 | MYSQL_HANDSHAKE, |
| donatien | 0:632c9925f013 | 173 | MYSQL_AUTH, |
| donatien | 0:632c9925f013 | 174 | MYSQL_COMMANDS, |
| donatien | 0:632c9925f013 | 175 | MYSQL_CLOSED |
| donatien | 0:632c9925f013 | 176 | }; |
| donatien | 0:632c9925f013 | 177 | |
| donatien | 0:632c9925f013 | 178 | //Parameters |
| donatien | 0:632c9925f013 | 179 | Host m_host; |
| donatien | 0:632c9925f013 | 180 | |
| donatien | 0:632c9925f013 | 181 | string m_user; |
| donatien | 0:632c9925f013 | 182 | string m_password; |
| donatien | 0:632c9925f013 | 183 | string m_db; |
| donatien | 0:632c9925f013 | 184 | |
| donatien | 0:632c9925f013 | 185 | //Low-level buffers & state-machine |
| donatien | 0:632c9925f013 | 186 | MySQLStep m_state; |
| donatien | 0:632c9925f013 | 187 | |
| donatien | 0:632c9925f013 | 188 | byte* m_buf; |
| donatien | 0:632c9925f013 | 189 | byte* m_pPos; |
| donatien | 0:632c9925f013 | 190 | int m_len; |
| donatien | 0:632c9925f013 | 191 | int m_size; |
| donatien | 0:632c9925f013 | 192 | |
| donatien | 0:632c9925f013 | 193 | int m_packetId; |
| donatien | 0:632c9925f013 | 194 | |
| donatien | 0:632c9925f013 | 195 | }; |
| donatien | 0:632c9925f013 | 196 | |
| donatien | 0:632c9925f013 | 197 | #endif |