2 /**************************************************************************
3 ** (c) Copyright 2002, Andromeda Technology & Automation
4 ** This is free software; you can redistribute it and/or modify it under the
5 ** terms of the GNU General Public License, see the file COPYING.
6 ***************************************************************************
7 ** MODULE INFORMATION *
8 ***********************
9 ** FILE NAME : database.h
11 ** VERSION NUMBER : $Revision: 1.3 $
13 ** DESCRIPTION : Classes to provide an abstract layer on the Gnucomo
19 ***************************************************************************
20 ** ADMINISTRATIVE INFORMATION *
21 ********************************
22 ** ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
23 ** CREATION DATE : Sep 10, 2002
24 ** LAST UPDATE : Nov 04, 2002
26 **************************************************************************/
28 /*****************************
30 Revision 1.3 2002-11-09 08:04:27 arjen
31 Added a reference to the GPL
33 Revision 1.2 2002/11/04 10:13:36 arjen
34 Use proper namespace for iostream classes
36 Revision 1.1 2002/10/05 10:25:49 arjen
37 Creation of gcm_input and a first approach to a web interface
39 *****************************/
41 /* static const char *RCSID = "$Id: database.h,v 1.3 2002-11-09 08:04:27 arjen Exp $"; */
43 #include <libpq++/pgdatabase.h>
44 #include "gnucomo_config.h"
47 ///////////////////////////////////////////////////////////////////////////
48 // NAME : gnucomo_database
49 // BASECLASS : configuration
52 // METHODS : Database - Obtain the database access string
58 // LAST MODIFIED : Sep 16, 2002
59 ///////////////////////////////////////////////////////////////////////////
62 class gnucomo_database
75 gnucomo_database(gnucomo_config *c); // Use the configuration to connect to the database
77 // Low-level database access functions
81 ExecStatusType result;
83 result = db->Exec(qry);
84 if (result == PGRES_TUPLES_OK || result == PGRES_COMMAND_OK)
90 std::cerr << "Database query error: " << db->ErrorMessage() << "\n";
95 String Field(int tuple, const char *fieldname)
97 return String(db->GetValue(tuple, fieldname));
100 // Return the objectid of the host given its name.
102 String find_host(const String hostname);