Craig, I tried in a clean Pharo-7.0.0+alpha.build.1276.sha.6c09bd43bb0d76c18958c720649aaf6834870bb5 (64 Bit). Load expression (as per https://github.com/svenvc/P3), which also loads Glorp itself: Metacello new baseline: 'P3'; repository: 'github://svenvc/P3'; load: 'glorp'. Transcript log: Fetched -> BaselineOfP3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Loaded -> BaselineOfP3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Loading baseline of BaselineOfP3... Fetched -> BaselineOfZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- git@github.com:svenvc/ztimestamp.git[master] Loaded -> BaselineOfZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- git@github.com:svenvc/ztimestamp.git[master] Fetched -> BaselineOfNeoJSON-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Loaded -> BaselineOfNeoJSON-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] ...RETRY->ConfigurationOfGlorp Fetched -> ConfigurationOfGlorp-StephanEggermont.62 --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ Loaded -> ConfigurationOfGlorp-StephanEggermont.62 --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ Project: NeoJSON baseline Fetched -> Neo-JSON-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Fetched -> Neo-JSON-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Fetched -> Neo-JSON-Pharo-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Fetched -> Neo-JSON-Pharo-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Project: ZTimestamp baseline Fetched -> ZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- git@github.com:svenvc/ztimestamp.git[master] Project: Glorp stable [2.0.1] Fetched -> Glorp-HerbyVojcik.127 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ Fetched -> Glorp-Tests-PierceNg.21 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ Fetched -> P3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Fetched -> P3-Glorp-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Loaded -> Neo-JSON-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> Neo-JSON-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> Neo-JSON-Pharo-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> Neo-JSON-Pharo-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> ZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- cache Starting atomic load MessageArchiver class>>inspectorClass (EyeProtoInspector is Undeclared) Dialect class>>reset (identitySetClass is Undeclared) DB2Sequence>>name: (DB2Platform is Undeclared) Loaded -> Glorp-HerbyVojcik.127 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- cache Loaded -> Glorp-Tests-PierceNg.21 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- cache Finished atomic load Evaluated -> 2.0.1 [ConfigurationOfGlorp] >> resetDialect Loaded -> P3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- cache Loaded -> P3-Glorp-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- cache ...finished baseline Then set the driver using: PharoDatabaseAccessor DefaultDriver: P3DatabaseDriver. Next configure the unit tests (login resource) via: GlorpDatabaseLoginResource defaultLogin: (Login new database: PostgreSQLPlatform new; username: 'sven'; password: ''; connectString: 'localhost:5432_sven'; encodingStrategy: #utf8; yourself). I now have green tests, for example GlorpTableTest, GlorpDatabaseLoginTest, GlorpDatabaseBasicTest. I know that the actual PSQL DB that I am using has all the Glorp test tables in it, I forgot whether that happened automatically or not. As for the full test suite, if I exclude GlorpReadingTest I get 804 run, 788 passes, 4 skipped, 0 expected failures, 0 failures, 16 errors, 0 unexpected passes Which is not too bad for such a complex package. HTH, Sven

On 10 Oct 2018, at 09:36, Craig <craig@hivemind.net> wrote:

Hi Sven,

Thanks for the support.

I'm using Pharo 6.1 - 32bit stable.

Craig

-----Original Message----- From: Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] On Behalf Of Sven Van Caekenberghe Sent: Wednesday, 10 October 2018 08:56 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Glorp with P3

Hi Craig,

Last time I checked, this worked fine. I'll try again later today, what version of Pharo are you using ?

Sven

...

On 9 Oct 2018, at 15:43, Craig <craig@hivemind.net> wrote:

Hi All,

I installed Glorp with P3 using the snippet on the P3 Github page.

P3 seems to be working fine. The tests are Ok. While working through the Glorp book, I got as far as “session createTables” and then got a debugger window.

It seems that the SQL is being sent to a variable in the PharoDatabaseAccessor class - “databaseDriver” which is never initialised.

Anybody able to assist with this?

Craig

On 10 Oct 2018, at 14:33, Craig <craig@hivemind.net> wrote:

Sven,

I just ported everything to Pharo 7.0 and the problem disappeared.

Craig

OK, good to know, but 6.1 should be compatible AFAIK.

-----Original Message----- From: Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] On Behalf Of Sven Van Caekenberghe Sent: Wednesday, 10 October 2018 11:13 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Glorp with P3

Craig,

I tried in a clean Pharo-7.0.0+alpha.build.1276.sha.6c09bd43bb0d76c18958c720649aaf6834870bb5 (64 Bit).

Load expression (as per https://github.com/svenvc/P3), which also loads Glorp itself:

Metacello new baseline: 'P3'; repository: 'github://svenvc/P3'; load: 'glorp'.

Transcript log:

Fetched -> BaselineOfP3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Loaded -> BaselineOfP3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Loading baseline of BaselineOfP3... Fetched -> BaselineOfZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- git@github.com:svenvc/ztimestamp.git[master] Loaded -> BaselineOfZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- git@github.com:svenvc/ztimestamp.git[master] Fetched -> BaselineOfNeoJSON-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Loaded -> BaselineOfNeoJSON-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] ...RETRY->ConfigurationOfGlorp Fetched -> ConfigurationOfGlorp-StephanEggermont.62 --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ Loaded -> ConfigurationOfGlorp-StephanEggermont.62 --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ --- http://smalltalkhub.com/mc/DBXTalk/Configurations/main/ Project: NeoJSON baseline Fetched -> Neo-JSON-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Fetched -> Neo-JSON-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Fetched -> Neo-JSON-Pharo-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Fetched -> Neo-JSON-Pharo-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- git@github.com:svenvc/NeoJSON.git[master] Project: ZTimestamp baseline Fetched -> ZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- git@github.com:svenvc/ztimestamp.git[master] Project: Glorp stable [2.0.1] Fetched -> Glorp-HerbyVojcik.127 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ Fetched -> Glorp-Tests-PierceNg.21 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ Fetched -> P3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Fetched -> P3-Glorp-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- git@github.com:svenvc/P3.git[master] Loaded -> Neo-JSON-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> Neo-JSON-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> Neo-JSON-Pharo-Core-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> Neo-JSON-Pharo-Tests-CompatibleUserName.1538429427 --- git@github.com:svenvc/NeoJSON.git[master] --- cache Loaded -> ZTimestamp-CompatibleUserName.1538577426 --- git@github.com:svenvc/ztimestamp.git[master] --- cache Starting atomic load MessageArchiver class>>inspectorClass (EyeProtoInspector is Undeclared)

Dialect class>>reset (identitySetClass is Undeclared)

DB2Sequence>>name: (DB2Platform is Undeclared)

Loaded -> Glorp-HerbyVojcik.127 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- cache Loaded -> Glorp-Tests-PierceNg.21 --- http://smalltalkhub.com/mc/DBXTalk/Glorp/main/ --- cache Finished atomic load Evaluated -> 2.0.1 [ConfigurationOfGlorp] >> resetDialect Loaded -> P3-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- cache Loaded -> P3-Glorp-CompatibleUserName.1539011881 --- git@github.com:svenvc/P3.git[master] --- cache ...finished baseline

Then set the driver using:

PharoDatabaseAccessor DefaultDriver: P3DatabaseDriver.

Next configure the unit tests (login resource) via:

GlorpDatabaseLoginResource defaultLogin: (Login new database: PostgreSQLPlatform new; username: 'sven'; password: ''; connectString: 'localhost:5432_sven'; encodingStrategy: #utf8; yourself).

I now have green tests, for example GlorpTableTest, GlorpDatabaseLoginTest, GlorpDatabaseBasicTest. I know that the actual PSQL DB that I am using has all the Glorp test tables in it, I forgot whether that happened automatically or not.

As for the full test suite, if I exclude GlorpReadingTest I get

804 run, 788 passes, 4 skipped, 0 expected failures, 0 failures, 16 errors, 0 unexpected passes

Which is not too bad for such a complex package.

HTH,

Sven

...

On 10 Oct 2018, at 09:36, Craig <craig@hivemind.net> wrote:

Hi Sven,

Thanks for the support.

I'm using Pharo 6.1 - 32bit stable.

Craig

-----Original Message----- From: Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] On Behalf Of Sven Van Caekenberghe Sent: Wednesday, 10 October 2018 08:56 To: Any question about pharo is welcome Subject: Re: [Pharo-users] Glorp with P3

Hi Craig,

Last time I checked, this worked fine. I'll try again later today, what version of Pharo are you using ?

Sven

...

On 9 Oct 2018, at 15:43, Craig <craig@hivemind.net> wrote:

Hi All,

I installed Glorp with P3 using the snippet on the P3 Github page.

P3 seems to be working fine. The tests are Ok. While working through the Glorp book, I got as far as “session createTables” and then got a debugger window.

It seems that the SQL is being sent to a variable in the PharoDatabaseAccessor class - “databaseDriver” which is never initialised.

Anybody able to assist with this?

Craig

On 11 Oct 2018, at 02:26, Pierce Ng <pierce@samadhiweb.com> wrote:

On Wed, Oct 10, 2018 at 11:12:37AM +0200, Sven Van Caekenberghe wrote:

...

I know that the actual PSQL DB that I am using has all the Glorp test tables in it, I forgot whether that happened automatically or not.

The Glorp test database is set up by "#GlorpDemoTablePopulatorResource asClass invalidateSetup". In the case of Glorp-SQLite3, that step is done by BaselineOfGlorpSQLite>>postLoadDoIt.

Pierce

Ah, thanks !