Re: Getting to learn libpqxx - Mailing list pgsql-interfaces

From Michiel Lange
Subject Re: Getting to learn libpqxx
Date
Msg-id 5.1.0.14.0.20030410225357.00b5f4c8@192.168.1.3
Whole thread Raw
In response to Re: Getting to learn libpqxx  ("Matt Fitzgerald" <mfitzgerald75@optushome.com.au>)
Responses Re: Getting to learn libpqxx
List pgsql-interfaces
Ok... here are some answers:

Yes, pqxx/connection.h is in the include path, the errormessage I would get 
would be very different...

I compile the source with gcc: gcc source.cpp -o source
the libraries should be in place, I placed them in /usr/local/lib (and ran 
ldconfig)

I will try the #include <sstream.h> (I believe you forgot the .h), but from 
what I remember the
char foo[234];

foo = bar << "blah" << bla;

would be perfectly valid... but I can be mistaken... I will try your 
suggestion and see if it will help...
yet, the problem that the declaration (Connstring *db;) is not valid...

Michiel
At 17:32 10-4-2003 +1000, Matt Fitzgerald wrote:
>Ok... some stupid questions:
>
>1. I take it pqxx/connection.h is in the include path?
>2. If so, what command are you using to compile the source?
>
>Also, your connection string is not built correctly, 'connstring' is not a
>class, thus it doesn't support any overloaded operators such as '<<' & '+'
>etc.
>
>Do some thing like this:
>
>#include <sstream>
>
>std::stringstream connstring;
>
>connstring << "host=" << host << "database=" << dbase << "username=" <<
>uname << "password=" << passwd;
>
>// call connection constructor something like this:
>Connection *db = new Connection(connstring.str().c_str());
>
>
>Etc.. etc.. also, as 'bool Immediate' defaults to 'true' you don't have to
>specify it.
>
>Regards,
>   -Matt
>
>
>
>
>-----Original Message-----
>From: pgsql-interfaces-owner@postgresql.org
>[mailto:pgsql-interfaces-owner@postgresql.org] On Behalf Of Michiel Lange
>Sent: Thursday, 10 April 2003 8:31 AM
>To: pgsql-interfaces@postgresql.org
>Subject: [INTERFACES] Getting to learn libpqxx
>
>Hello everybody again,
>
>I went out to investigate and try if I could master libpqxx, for libpq++
>works not at all. Seeing it is discontinued, and people are encouraged to
>use libpqxx, I was so bold as to try that ;-)
>
>Only to discover that there is hardly any documentation on how to access
>stuff... now I, myself am more a C-programmer, and I know C++ is pretty
>much different... it is really hard for me to think in classes and stuff,
>to think object-oriented...
>
>So, now you know I am an earthling :P
>
>I tried this kind of approach, the idea was to start out simple... so don't
>laugh at the attempt ...
>
>#include <pqxx/connection.h>
>
>int main(int argc, char *argv[])
>{
>         Connection *db;
>         char uname[250]; // username
>         char passwd[250]; // password
>         char host[250]; //hostname
>         char passwd[250]; //password
>         char dbase[250]; //database name
>         char connstring[1264];
>         ... some output and input to get values for all these char arrays...
>
>         connstring = "host=" >> host >> "database=" >> dbase >> "username="
> >>
>uname >> "password=" >> passwd;
>         db = new Connection(connstring,true);
>
>         if(db->is_open())
>         {
>                 cout << "Connection succesful!" << endl;
>                 cout << db->Options();
>         }
>         else
>         {
>                 cout << "Something went wrong... oops" << endl;
>         }
>         delete db;
>         return 0;
>}
>
>I get my first errors at "Connection *db" declaration... there is no
>Connection defined...
>Can anyone point out how to reference the classes libpqxx has?
>
>Also I was curious if my connstring was correctly built, but that is
>another subject I think... One other very important thing would be: how can
>I find out the error PostgreSQL will throw at me when I did something ugly?
>At least I can find out the problem, when I make one then...
>
>Michiel
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster



pgsql-interfaces by date:

Previous
From: Ian Barwick
Date:
Subject: Re: Memory leak!!
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] More thoughts about FE/BE protocol