Re: [Pharo-users] PostgreSQL and Pharo 6

[Benoit St-Jean via Pharo-users]

--- Begin Message ---

Try this:
| sql conn connectionSpec result  |
sql := 'SELECT * FROM search_terms'.
conn := GAConnection new.
connectionSpec := GAConnectionArgs
                            hostname: 'localhost'
                            portno: 5432
                            databaseName: 'sodbxtest'
                            userName: 'sodbxtest'
                            password: 'sodbxtest'.
conn connectionArgs: connectionSpec.

"Connect to the server"
result := conn startup. 
(result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ].

"Execute your SQL stuff"
result := conn execute: sql.
(result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ] ifFalse: 
[result inspect].

"Disconnect from the server"
conn close. 

 ----------------- 
Benoît St-Jean 
Yahoo! Messenger: bstjean 
Twitter: @BenLeChialeux 
Pinterest: benoitstjean 
Instagram: Chef_Benito
IRC: lamneth 
Blogue: endormitoire.wordpress.com 
"A standpoint is an intellectual horizon of radius zero".  (A. Einstein)

      From: Dimitris Chloupis <kilon.al...@gmail.com>
 To: Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is welcome 
<pharo-users@lists.pharo.org> 
 Sent: Monday, April 17, 2017 5:24 PM
 Subject: Re: [Pharo-users] PostgreSQL and Pharo 6
   
Following the instructions here 

http://guillep.github.io/DBXTalk/garage/installation.html

I did 

Gofer it
 smalltalkhubUser: 'DBXTalk' project: 'Garage';
 configurationOf: 'Garage';
 load.


(ConfigurationOfGarage project version: '0.5')
 load: 'postgresV2'.

And it did install 


On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstj...@yahoo.com> wrote:

Tell me which exact package you loaded (or even better, the exact to load it) 
and I will test some code against my PostgreSQL server...
 ----------------- 
Benoît St-Jean 
Yahoo! Messenger: bstjean 
Twitter: @BenLeChialeux 
Pinterest: benoitstjean 
Instagram: Chef_Benito
IRC: lamneth 
Blogue: endormitoire.wordpress.com 
"A standpoint is an intellectual horizon of radius zero".  (A. Einstein)

  From: Dimitris Chloupis <kilon.al...@gmail.com>
 To: Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is welcome 
<pharo-users@lists.pharo.org> 
 Sent: Monday, April 17, 2017 4:55 PM
 Subject: Re: [Pharo-users] PostgreSQL and Pharo 6
  
no conn connect does not work because GAConnection has no such method. #connect 
exist in GAPostgresDrive but even if I go that route I get error 
#OptionAt:IfAbsent: was sent to nil . With this code
conn2 := GAPostgresDriver new .conn2 host: 
'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' port: 
'****'database:'*******'  user: '*****'  password:''***'.conn2 connect.
Is there sample code that connects to online databases ?


On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstj...@yahoo.com> wrote:

You have to #connect before executing SQL statements!
Something like (in your code):
conn connect. ----------------- 
Benoît St-Jean 
Yahoo! Messenger: bstjean 
Twitter: @BenLeChialeux 
Pinterest: benoitstjean 
Instagram: Chef_Benito
IRC: lamneth 
Blogue: endormitoire.wordpress.com 
"A standpoint is an intellectual horizon of radius zero".  (A. Einstein)

  From: Dimitris Chloupis <kilon.al...@gmail.com>
 To: Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is welcome 
<pharo-users@lists.pharo.org> 
 Sent: Monday, April 17, 2017 3:54 PM
 Subject: Re: [Pharo-users] PostgreSQL and Pharo 6
   
Installing from Catalog Browser fails
I installed it via the the website instructions, it installs fine
But if I use it this way 
conn := GAConnection new.
ca := GAConnectionArgs hostname: 
'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' portno: 
'****'databaseName:'*******'  userName: '*****'  password:''***'.
conn connectionArgs: ca.
conn execute: 'select * from search_terms'.

it fails with no connection, is there anything else i need to do ?is there a 
guide for how to use this ? 


On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis <kilon.al...@gmail.com> wrote:

thank you Benoit 
On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users 
<pharo-users@lists.pharo.org> wrote:

ODBC worked fine as well if you don't need native driver access 
----------------- 
Benoît St-Jean 
Yahoo! Messenger: bstjean 
Twitter: @BenLeChialeux 
Pinterest: benoitstjean 
Instagram: Chef_Benito
IRC: lamneth 
Blogue: endormitoire.wordpress.com 
"A standpoint is an intellectual horizon of radius zero".  (A. Einstein)

      From: Dimitris Chloupis <kilon.al...@gmail.com>
 To: Any question about pharo is welcome <pharo-users@lists.pharo.org> 
 Sent: Sunday, April 16, 2017 4:37 AM
 Subject: [Pharo-users] PostgreSQL and Pharo 6
  
Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D
I am using Python for it but I would like to give access also to Pharo to my 
database. I was informed that Garage has a driver for PostgreSQL , is there any 
other candidate ? Any advice ? 

 



 


 


   

--- End Message ---