author | Markus Bröker <mbroeker@largo.dyndns.tv> |
Fri, 05 Mar 2010 22:04:25 +0100 | |
changeset 116 | ae784a3a45b1 |
parent 65 | 76514757b0d6 |
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 |
65
76514757b0d6
GNU Indent cannot handle C++ Source Files...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
48
diff
changeset
|
7 |
#include <postgresql_db.hpp> |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
8 |
#else |
65
76514757b0d6
GNU Indent cannot handle C++ Source Files...
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
48
diff
changeset
|
9 |
#include <mysql_db.hpp> |
12
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 |
{ |
16
2b4ef74a16aa
I extended the usage screen with help messages
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
15
diff
changeset
|
16 |
std::cout << "Benutzung: " << progname << " [-h] [-r <remotehost>] [-u <user>] [-p <password>] DATABASE\n"; |
17
b3731a25b9ec
I have improved the connection info and cleaned something up.
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
16
diff
changeset
|
17 |
std::cout << "\t\t-r <remotehost>\t\tVerbindung zu Fremdrechner <remotehost>\n"; |
b3731a25b9ec
I have improved the connection info and cleaned something up.
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
16
diff
changeset
|
18 |
std::cout << "\t\t-u <user>\t\tAnmeldung als <user>\n"; |
b3731a25b9ec
I have improved the connection info and cleaned something up.
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
16
diff
changeset
|
19 |
std::cout << "\t\t-p <password>\t\tAnmelden mit dem Passwort <password>\n"; |
b3731a25b9ec
I have improved the connection info and cleaned something up.
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
16
diff
changeset
|
20 |
std::cout << "\n"; |
b3731a25b9ec
I have improved the connection info and cleaned something up.
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
16
diff
changeset
|
21 |
std::cout << "\t\tDATABASE\t\tVerbindung zur Datenbank DATABASE herstellen\n"; |
16
2b4ef74a16aa
I extended the usage screen with help messages
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
15
diff
changeset
|
22 |
std::cout << "\nBerichten Sie Fehler oder Anregungen an mbroeker@largo.homelinux.org" << std::endl; |
48
b94d657a9acb
Policy Inonsistency on many files
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
29
diff
changeset
|
23 |
exit (EXIT_FAILURE); |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
24 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
25 |
|
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
26 |
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
|
27 |
{ |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
28 |
Abstract_DB *db; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
29 |
|
14
862d63715611
the long vector needs a typedef
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
12
diff
changeset
|
30 |
Abstract_DB::DB_ROW vec; |
862d63715611
the long vector needs a typedef
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
12
diff
changeset
|
31 |
Abstract_DB::DB_RESULT result; |
29
7abf6146898e
indent -bad changed to -nbad:
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
17
diff
changeset
|
32 |
|
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
33 |
unsigned int i, j; |
29
7abf6146898e
indent -bad changed to -nbad:
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
17
diff
changeset
|
34 |
|
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
35 |
char c; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
36 |
|
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
37 |
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
|
38 |
std::string sql_statement; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
39 |
|
16
2b4ef74a16aa
I extended the usage screen with help messages
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
15
diff
changeset
|
40 |
while ((c = getopt (argc, argv, "r:u:p:h")) >= 0) { |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
41 |
switch (c) { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
42 |
case 'r': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
43 |
host = 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 'u': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
46 |
user = optarg; |
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 |
case 'p': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
49 |
pass = optarg; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
50 |
break; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
51 |
case 'h': |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
52 |
usage (argv[0]); |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
53 |
break; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
54 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
55 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
56 |
if (optind < argc) |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
57 |
database = argv[optind]; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
58 |
else |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
59 |
usage (argv[0]); |
12
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 |
#ifdef WITH_POSTGRESQL |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
62 |
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
|
63 |
#else |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
64 |
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
|
65 |
#endif |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
66 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
67 |
if (db->connect () == false) { |
17
b3731a25b9ec
I have improved the connection info and cleaned something up.
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
16
diff
changeset
|
68 |
std::cerr << "Kann mich nicht zur Datenbank verbinden." << std::endl; |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
69 |
return EXIT_FAILURE; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
70 |
} |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
71 |
|
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
72 |
for (;;) { |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
73 |
std::cout << "DB_BRIDGE # "; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
74 |
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
|
75 |
|
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
76 |
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
|
77 |
std::cout << std::endl; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
78 |
break; |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
79 |
} |
15
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
80 |
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
|
81 |
|
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
82 |
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
|
83 |
vec = result[i]; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
84 |
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
|
85 |
std::cout << vec[j] << " "; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
86 |
} |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
87 |
std::cout << std::endl; |
5a0ca1f9a2f1
db_bridge acts as an interactive sql monitor
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
14
diff
changeset
|
88 |
} |
12
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
89 |
} |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
90 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
91 |
delete db; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
92 |
|
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
93 |
return EXIT_SUCCESS; |
9f0ce4eaa1ce
I added a small db_bridge to the repository
Markus Bröker <mbroeker@largo.dyndns.tv>
parents:
diff
changeset
|
94 |
} |