blob: eddc34e74c047f58a5d725c09d3727aa91fd85c3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
/*!
* \file mg_mysql.h
* \brief A capsule around MySql database access
*
* \version $Revision: 1.2 $
* \date $Date: 2005-02-10 17:42:54 +0100 (Thu, 10 Feb 2005) $
* \author Ralf Klueber, Lars von Wedel, Andreas Kellner, Wolfgang Rohdewald
* \author Responsible author: $Author: LarsAC $
*/
#ifndef __MG_MYSQL_H
#define __MG_MYSQL_H
#include <string>
#include <mysql/mysql.h>
using namespace std;
void database_end(); // must be done explicitly
void set_datadir(char *datadir);
/*!
* \brief an abstract database class
*
*/
class mgmySql
{
public:
/*! \brief default constructor
*/
mgmySql( );
~mgmySql();
/*!
* \brief helper function to execute queries
*
*/
MYSQL_RES* exec_sql( const string query);
/*!
* \brief escape arguments to be contained in a query
*/
string sql_string( string s );
char* sql_Cstring( const string s,char *buf=0);
char* sql_Cstring( const char *s,char *buf=0);
string get_col0( const string query);
/*! \brief executes a query and returns the integer value from
* the first column in the first row. The query shold be a COUNT query
* returning only one row.
* \param query the SQL query to be executed
*/
unsigned long exec_count (string query);
long thread_id() { return mysql_thread_id(m_db);}
long affected_rows() { return mysql_affected_rows(m_db);}
bool ServerConnected() const;
bool Connected() const;
bool HasFolderFields() const { return m_hasfolderfields;}
void Connect();
void Use();
//! \brief create database and tables
void Create();
void FillTables();
void CreateFolderFields();
private:
MYSQL *m_db;
bool m_database_found;
bool m_hasfolderfields;
};
#endif
|
