Glorp with P3

> On 9 Oct 2018, at 15:43, Craig <[hidden email]> 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 9 Oct 2018, at 15:43, Craig <[hidden email]> 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 09:36, Craig <[hidden email]> wrote:
>
> Hi Sven,
>
> Thanks for the support.
>
> I'm using Pharo 6.1 - 32bit stable.
>
> Craig
>
> -----Original Message-----
> From: Pharo-users [mailto:[hidden email]] 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 <[hidden email]> 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 09:36, Craig <[hidden email]> wrote:
>
> Hi Sven,
>
> Thanks for the support.
>
> I'm using Pharo 6.1 - 32bit stable.
>
> Craig
>
> -----Original Message-----
> From: Pharo-users [mailto:[hidden email]] 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 <[hidden email]> 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
>
>
>
>

> -----Original Message-----
> From: Pharo-users [mailto:[hidden email]] 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 --- [hidden email]:svenvc/P3.git[master] --- [hidden email]:svenvc/P3.git[master]
> Loaded -> BaselineOfP3-CompatibleUserName.1539011881 --- [hidden email]:svenvc/P3.git[master] --- [hidden email]:svenvc/P3.git[master]
> Loading baseline of BaselineOfP3...
> Fetched -> BaselineOfZTimestamp-CompatibleUserName.1538577426 --- [hidden email]:svenvc/ztimestamp.git[master] --- [hidden email]:svenvc/ztimestamp.git[master]
> Loaded -> BaselineOfZTimestamp-CompatibleUserName.1538577426 --- [hidden email]:svenvc/ztimestamp.git[master] --- [hidden email]:svenvc/ztimestamp.git[master]
> Fetched -> BaselineOfNeoJSON-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- [hidden email]:svenvc/NeoJSON.git[master]
> Loaded -> BaselineOfNeoJSON-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- [hidden email]: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 --- [hidden email]:svenvc/NeoJSON.git[master] --- [hidden email]:svenvc/NeoJSON.git[master]
> Fetched -> Neo-JSON-Tests-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- [hidden email]:svenvc/NeoJSON.git[master]
> Fetched -> Neo-JSON-Pharo-Core-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- [hidden email]:svenvc/NeoJSON.git[master]
> Fetched -> Neo-JSON-Pharo-Tests-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- [hidden email]:svenvc/NeoJSON.git[master]
> Project: ZTimestamp baseline
> Fetched -> ZTimestamp-CompatibleUserName.1538577426 --- [hidden email]:svenvc/ztimestamp.git[master] --- [hidden email]: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 --- [hidden email]:svenvc/P3.git[master] --- [hidden email]:svenvc/P3.git[master]
> Fetched -> P3-Glorp-CompatibleUserName.1539011881 --- [hidden email]:svenvc/P3.git[master] --- [hidden email]:svenvc/P3.git[master]
> Loaded -> Neo-JSON-Core-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- cache
> Loaded -> Neo-JSON-Tests-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- cache
> Loaded -> Neo-JSON-Pharo-Core-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- cache
> Loaded -> Neo-JSON-Pharo-Tests-CompatibleUserName.1538429427 --- [hidden email]:svenvc/NeoJSON.git[master] --- cache
> Loaded -> ZTimestamp-CompatibleUserName.1538577426 --- [hidden email]: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 --- [hidden email]:svenvc/P3.git[master] --- cache
> Loaded -> P3-Glorp-CompatibleUserName.1539011881 --- [hidden email]: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 <[hidden email]> wrote:
>>
>> Hi Sven,
>>
>> Thanks for the support.
>>
>> I'm using Pharo 6.1 - 32bit stable.
>>
>> Craig
>>
>> -----Original Message-----
>> From: Pharo-users [mailto:[hidden email]] 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 <[hidden email]> 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 <[hidden email]> 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