Okay, i fixated on this tonight & i think i got it to work. i put
CaptchasTable back in App/Model/Table, and behold the class loads correctly
(i forgot to adjust the namespace in the previous message).
However, before i do a happy dance, i'd like to know if it's *POSSIBLE* to
organize my Models into subdirectories as i was attempting to do:
Model/Table/* : My project's main DB Table classes
Model/Table/Websites/* : Table classes from the Websites database, so
they're not cluttering up my project's main tables...
Model/Table/____/* : Similar if i need to connect to any other databases...
Can this be done at all?
On Tuesday, 22 July 2014 21:26:20 UTC-4, Joe Theuerkauf wrote:
>
> José:
>
> Sorry for the delayed response. i've been getting burned out (and burned
> up with the weather), so i took a day to breathe.
>
> i called $this->Captchas->defaultConnectionName() from inside the
> ContactsController:
>
> public function index() {
> $this->loadModel('Captchas');
> // PS: i'm using the LogTrait in the class...
> $this->log('defaultConnectionName: ' .
> $this->Captchas->defaultConnectionName());
>
> // ...
> }
>
>
> Output in error.log:
>
> 2014-07-23 01:16:55 Error: defaultConnectionName: default
>
>
> Obviously, not what i was expecting. And that's the value whether i have
> CaptchasTable in the main Model/Table or in Model/Table/Website.
>
> If you have further suggestions, please let me know. i know 3.0 is alpha
> so i do expect some breakage. But when the documentation is so brief &
> doesn't seem to work, it can be frustrating.
> -joe
>
>
> On Monday, 21 July 2014 04:08:18 UTC-4, José Lorenzo wrote:
>>
>> what is returned if you call $this->Captchas->defaultConnectionName() ?
>>
>> On Sunday, July 20, 2014 6:29:33 PM UTC+2, Joe Theuerkauf wrote:
>>>
>>> i tried this topic before, but the only response was for an older
>>> version of Cake...
>>>
>>> i'm following this documentation:
>>>
>>> http://book.cakephp.org/3.0/en/orm/table-objects.html#configuring-connections
>>>
>>> i'm trying to keep a few tables that would be application-agnostic in a
>>> different database. i'm not trying to create associations as mentioned in
>>> #3463. i just need to query independent records from these tables.
>>>
>>> Here's what i have so far:
>>> // Config/app.php
>>> $config = [
>>> // ...
>>> 'Datasources' => [
>>> 'default' => [
>>> // Connection to this DB works.
>>> 'database' => 'kodiak',
>>> ],
>>> 'websites' => [
>>> // Connection is identical, except different 'database' value
>>> 'database' => 'websites',
>>> ]
>>> ]
>>> // ...
>>> ];
>>>
>>> // Model/Table/Websites/CapchasTable.php
>>> class CaptchasTable extends Table {
>>> public static function defaultConnectionName () {
>>> return 'websites';
>>> }
>>> }
>>>
>>> // Controller/ContactsController.php
>>> public function index () {
>>> $this->loadModel('Captchas');
>>>
>>> $captcha = $this->Captchas->find('all', [
>>> 'conditions' => [],
>>> 'order' => 'RAND()',
>>> 'limit' => 1
>>> ]);
>>>
>>> // etc.
>>> }
>>>
>>> Here's the error output:
>>>
>>> SQLSTATE[42S02]: Base table or view not found: 1146 Table
>>> *'kodiak.captchas'* doesn't exist
>>>
>>> Error: An Internal Error Has Occurred.
>>> Stack Trace
>>>
>>> ROOT\vendor\cakephp\cakephp\src\Database\Schema\Collection.php line
>>> 113 → Cake\Database\Schema\Collection->_executeSql(string, array)
>>> ROOT\vendor\cakephp\cakephp\src\ORM\Table.php line 323 →
>>> Cake\Database\Schema\Collection->describe(string)
>>> ROOT\vendor\cakephp\cakephp\src\ORM\Query.php line 127 →
>>> Cake\ORM\Table->schema()
>>> ROOT\vendor\cakephp\cakephp\src\ORM\Query.php line 110 →
>>> Cake\ORM\Query->addDefaultTypes(Cake\ORM\Table)
>>> ROOT\vendor\cakephp\cakephp\src\ORM\Table.php line 927 →
>>> Cake\ORM\Query->__construct(Cake\Database\Connection, Cake\ORM\Table)
>>> ROOT\vendor\cakephp\cakephp\src\ORM\Table.php line 724 →
>>> Cake\ORM\Table->query()
>>> APP/Controller\ContactsController.php line 36 →
>>> Cake\ORM\Table->find(string, array)
>>> [internal function] → App\Controller\ContactsController->index()
>>> ROOT\vendor\cakephp\cakephp\src\Controller\Controller.php line 373 →
>>> ReflectionMethod->invokeArgs(App\Controller\ContactsController, array)
>>> ROOT\vendor\cakephp\cakephp\src\Routing\Dispatcher.php line 115 →
>>> Cake\Controller\Controller->invokeAction()
>>> ROOT\vendor\cakephp\cakephp\src\Routing\Dispatcher.php line 87 →
>>> Cake\Routing\Dispatcher->_invoke(App\Controller\ContactsController)
>>> ROOT\webroot\index.php line 37 →
>>> Cake\Routing\Dispatcher->dispatch(Cake\Network\Request,
>>> Cake\Network\Response)
>>>
>>> It doesn't seem to matter if CaptchasTable is in Model/Table or
>>> Model/Table/Websites; loadModel('Captchas') doesn't throw errors either
>>> way. But the find() call is throwing the error - *regardless where *
>>> CaptchasTable* is placed*. When it's commented, the page loads fine
>>> (since i'm hitting this error, i haven't actually tried to USE any of the
>>> Captcha data in my form yet).
>>>
>>> So the question is: why isn't defaultConnectionName setting up the
>>> connection to the `websites` DB? What's missing? Is it missing
>>> documentation & i need to do something more, or is this a bug?
>>>
>>> i'd appreciate any help before i post this to the Github issues. Thanks.
>>>
>>>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
