sqlconn/sql_connector.h

   1 #ifndef SQL_CONN_H
   2 #define SQL_CONN_H
   3
   4 #if defined(_WIN32) || defined(__WIN32__)
   5 #       include <windows.h>
   6 #endif
   7 #include <stdio.h>
   8 #include <unistd.h>
   9 #include <mysql/mysql.h>
  10 #include <list>
  11 #include "../ui/qt/ScoreRecord.h"
  12
  13 #define CONN_CONFIG_FILE "conn_config"
  14
  15 #ifndef byte
  16 #       define byte        unsigned char
  17 #endif
  18
  19
  20 struct conn_data
  21 {
  22     const char * server_name;
  23     const char * user_name;
  24     const char * db_name;
  25     const char * db_passwd;
  26     int db_port;
  27     int db_cols;
  28     char ** table_data; // name col1 col2 col3 ...
  29 };
  30
  31 class Sql_connector
  32 {
  33     public:
  34
  35         struct conn_data * c_data;
  36         MYSQL * conn;
  37
  38         Sql_connector(void);
  39         ~Sql_connector(void);
  40
  41         int connect(void);
  42         int disconnect(void);
  43         int insertScore(const char * name,int score,byte difficulty);
  44         /** Loads top 10 results (of given level) from database.
  45          * @param difficulty Game level for which to load data.
  46          * @param recList List to store results.
  47          * @return True on success, false if loading fails. */
  48         bool getTop10(byte difficulty, std::list<ScoreRecord> &recList);
  49         void writeConfig(void);
  50         void loadConfig(void);
  51
  52 };
  53
  54 #endif