author | Markus Bröker <mbroeker@largo.dyndns.tv> |
Sat, 13 Dec 2008 17:58:07 +0100 | |
changeset 15 | 5a0ca1f9a2f1 |
parent 14 | 862d63715611 |
child 16 | 2b4ef74a16aa |
permissions | -rw-r--r-- |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
1 |
/** |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
2 |
* db_bridge/main.cpp |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
3 |
* Copyright (C) 2008 Markus Broeker |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
4 |
*/ |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
5 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
6 |
#ifdef WITH_POSTGRESQL |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
7 |
#include <postgresql_db.h> |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
8 |
#else |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
9 |
#include <mysql_db.h> |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
10 |
#endif |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
11 |
|
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
12 |
#include <cstdlib> |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
13 |
|
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
14 |
void usage (std::string progname) |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
15 |
{ |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
16 |
std::cout << "Benutzung: " << progname << " [-r <remotehost>] [-u <user>] [-p <password>] [-h] DATABASE\n" << std:: |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
17 |
endl; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
18 |
std::cout << "Berichten Sie Fehler oder Anregungen an mbroeker@largo.homelinux.org" << std::endl; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
19 |
exit (0); |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
20 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
21 |
|
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
22 |
int main (int argc, char **argv) |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
23 |
{ |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
24 |
Abstract_DB *db; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
25 |
|
14
862d63715611
the long vector needs a typedef
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
12
diff
changeset
|
26 |
Abstract_DB::DB_ROW vec; |
862d63715611
the long vector needs a typedef
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
12
diff
changeset
|
27 |
Abstract_DB::DB_RESULT result; |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
28 |
unsigned int i, j; |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
29 |
char c; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
30 |
|
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
31 |
std::string host, user, pass, database; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
32 |
std::string sql_statement; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
33 |
|
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
34 |
while ((c = getopt (argc, argv, "r:u:p:d:h")) >= 0) { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
35 |
switch (c) { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
36 |
case 'r': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
37 |
host = optarg; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
38 |
break; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
39 |
case 'u': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
40 |
user = optarg; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
41 |
break; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
42 |
case 'p': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
43 |
pass = optarg; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
44 |
break; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
45 |
case 'h': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
46 |
usage (argv[0]); |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
47 |
break; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
48 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
49 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
50 |
if (optind < argc) |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
51 |
database = argv[optind]; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
52 |
else |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
53 |
usage (argv[0]); |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
54 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
55 |
#ifdef WITH_POSTGRESQL |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
56 |
db = new PostgreSQL_DB (host, user, pass, database); |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
57 |
#else |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
58 |
db = new MySQL_DB (host, user, pass, database); |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
59 |
#endif |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
60 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
61 |
if (db->connect () == false) { |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
62 |
std::cerr << "Kann mich nicht zur Datenbank verbinden. Passwoerter falsch?" << std::endl; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
63 |
return EXIT_FAILURE; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
64 |
} |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
65 |
|
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
66 |
for (;;) { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
67 |
// std::getline(std::cin, sql_statement); |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
68 |
std::cout << "DB_BRIDGE # "; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
69 |
std::getline (std::cin, sql_statement); |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
70 |
|
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
71 |
if (sql_statement == "quit" || sql_statement == "exit" || sql_statement == "") { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
72 |
std::cout << std::endl; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
73 |
break; |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
74 |
} |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
75 |
result = db->query (sql_statement); |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
76 |
|
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
77 |
for (i = 0; i < result.size (); i++) { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
78 |
vec = result[i]; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
79 |
for (j = 0; j < vec.size (); j++) { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
80 |
std::cout << vec[j] << " "; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
81 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
82 |
std::cout << std::endl; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
83 |
} |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
84 |
} |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
85 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
86 |
delete db; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
87 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
88 |
return EXIT_SUCCESS; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
89 |
} |