author | Markus Bröker <mbroeker@largo.dyndns.tv> |
Thu, 16 Apr 2009 12:49:11 +0200 | |
changeset 39 | 46d7ec9d63bd |
parent 29 | 7abf6146898e |
child 48 | b94d657a9acb |
permissions | -rw-r--r-- |
/** * db_bridge/main.cpp * Copyright (C) 2008 Markus Broeker */ #ifdef WITH_POSTGRESQL #include <postgresql_db.h> #else #include <mysql_db.h> #endif #include <cstdlib> void usage (std::string progname) { std::cout << "Benutzung: " << progname << " [-h] [-r <remotehost>] [-u <user>] [-p <password>] DATABASE\n"; std::cout << "\t\t-r <remotehost>\t\tVerbindung zu Fremdrechner <remotehost>\n"; std::cout << "\t\t-u <user>\t\tAnmeldung als <user>\n"; std::cout << "\t\t-p <password>\t\tAnmelden mit dem Passwort <password>\n"; std::cout << "\n"; std::cout << "\t\tDATABASE\t\tVerbindung zur Datenbank DATABASE herstellen\n"; std::cout << "\nBerichten Sie Fehler oder Anregungen an mbroeker@largo.homelinux.org" << std::endl; exit (0); } int main (int argc, char **argv) { Abstract_DB *db; Abstract_DB::DB_ROW vec; Abstract_DB::DB_RESULT result; unsigned int i, j; char c; std::string host, user, pass, database; std::string sql_statement; while ((c = getopt (argc, argv, "r:u:p:h")) >= 0) { switch (c) { case 'r': host = optarg; break; case 'u': user = optarg; break; case 'p': pass = optarg; break; case 'h': usage (argv[0]); break; } } if (optind < argc) database = argv[optind]; else usage (argv[0]); #ifdef WITH_POSTGRESQL db = new PostgreSQL_DB (host, user, pass, database); #else db = new MySQL_DB (host, user, pass, database); #endif if (db->connect () == false) { std::cerr << "Kann mich nicht zur Datenbank verbinden." << std::endl; return EXIT_FAILURE; } for (;;) { std::cout << "DB_BRIDGE # "; std::getline (std::cin, sql_statement); if (sql_statement == "quit" || sql_statement == "exit" || sql_statement == "") { std::cout << std::endl; break; } result = db->query (sql_statement); for (i = 0; i < result.size (); i++) { vec = result[i]; for (j = 0; j < vec.size (); j++) { std::cout << vec[j] << " "; } std::cout << std::endl; } } delete db; return EXIT_SUCCESS; }