| # |
Apr 4th 2019, 16:18 |
 saini.vikas630 |
How can I find the articles that are common in given category Ids in cakephp3 |
| # |
Apr 4th 2019, 15:23 |
rochasmarcelo |
@weto.jc at "'host' => env('MYSQL_URL', false)," you can't call a function when defining a property, you will need to create a __construct method and set the $default property |
| # |
Apr 4th 2019, 15:05 |
xavier83ar |
it works like a charm |
| # |
Apr 4th 2019, 15:01 |
dereuromark |
may the matrix be with u |
| # |
Apr 4th 2019, 15:01 |
xavier83ar |
thanks guys! :+1::skin-tone-4: |
| # |
Apr 4th 2019, 15:01 |
berarma |
Source: I've fought the system a lot. :) |
| # |
Apr 4th 2019, 15:01 |
dereuromark |
:slightly_smiling_face: ok |
| # |
Apr 4th 2019, 15:01 |
admad |
rage against the machine :P |
| # |
Apr 4th 2019, 15:00 |
berarma |
@dereuromark It takes some experience to know when you're fighting the system or simply ignorant of some feature. :slightly_smiling_face: |
| # |
Apr 4th 2019, 15:00 |
xavier83ar |
I knew that there must be a way, thanks! |
| # |
Apr 4th 2019, 14:59 |
admad |
https://book.cakephp.org/3.0/en/orm/query-builder.html#inserting-data |
| # |
Apr 4th 2019, 14:59 |
dereuromark |
why do people always fight the system :P dont get it |
| # |
Apr 4th 2019, 14:59 |
xavier83ar |
that's the way to go I guess |
| # |
Apr 4th 2019, 14:59 |
xavier83ar |
ahhh |
| # |
Apr 4th 2019, 14:59 |
admad |
also you can directly use the db layer to do insert instead of ORM methods |
| # |
Apr 4th 2019, 14:58 |
xavier83ar |
every source remove all records from that source, ->deleteAll(['source' => 'this-source']) ...then reinsert records from that source |
| # |
Apr 4th 2019, 14:57 |
xavier83ar |
so I can't truncate it |
| # |
Apr 4th 2019, 14:57 |
xavier83ar |
the thing is that there are more that one external source that feed the table |
| # |
Apr 4th 2019, 14:56 |
admad |
and truncate the table to reset autoincrement :slightly_smiling_face: |
| # |
Apr 4th 2019, 14:54 |
gapiangco |
a primary key using UNSIGNED BIGINT data type won't worry you to reach it limits :slightly_smiling_face: |
| # |
Apr 4th 2019, 14:54 |
xavier83ar |
cakephp 3.7.4 |
| # |
Apr 4th 2019, 14:54 |
xavier83ar |
line 2080 |
| # |
Apr 4th 2019, 14:54 |
xavier83ar |
src\Cake\ORM\Table::_insert() |
| # |
Apr 4th 2019, 14:53 |
xavier83ar |
bake command generate the table object with the standard 'id' key, I've removed, but I got this error anyway 'Cannot insert row in "%s" table, it has no primary key.', |
| # |
Apr 4th 2019, 14:51 |
xavier83ar |
so I've tried to do so, remove the id and rebake model layer.. no problem so far |
| # |
Apr 4th 2019, 14:50 |
xavier83ar |
I may use other type of primary key... but I do realize that I don't need one |
| # |
Apr 4th 2019, 14:49 |
xavier83ar |
but if I use an autoincremente id, every time the table is updated, the id would keep increasing, reaching limits soons |
| # |
Apr 4th 2019, 14:48 |
xavier83ar |
no need for deleted or edit single record |
| # |
Apr 4th 2019, 14:48 |
xavier83ar |
it's a table that's like a temporal table, a cache of many others sources, everytime it gets updated by a source it removes all records from that source and insert new ones |
| # |
Apr 4th 2019, 14:47 |
dereuromark |
pretty sure it does, why would you ever want that though |
| # |
Apr 4th 2019, 14:46 |
xavier83ar |
Hi guys, does the cakephp 3 ORM support insert records to a table without a primary key? |
| # |
Apr 4th 2019, 14:46 |
this.impetus |
nvm, guess-solved that one |
| # |
Apr 4th 2019, 14:44 |
asdfgh |
i will use char 36 |
| # |
Apr 4th 2019, 14:44 |
asdfgh |
thank you dereuromark |
| # |
Apr 4th 2019, 14:44 |
this.impetus |
If I want to use Inflector in an element, how do I access it? Simply beginning with ```Inflector::<method>``` gives me "Class 'Inflector' not found" |
| # |
Apr 4th 2019, 14:43 |
dereuromark |
there are more performant solutions using binary16, but that requires custom Type classes, as in shim plugin etc |
| # |
Apr 4th 2019, 14:43 |
dereuromark |
this should be well documented - as char 36 as simple default |
| # |
Apr 4th 2019, 14:42 |
asdfgh |
guys pardon, what is the correct column type (and length) for uuid ? |
| # |
Apr 4th 2019, 14:32 |
slackebot2 |
'123456', 'database' => 'database_name', 'prefix' => '', 'encoding' => 'utf8', 'timezone' => 'UTC', ); }``` |
| # |
Apr 4th 2019, 14:32 |
weto.jc |
I'm following this tutorial, but importing the environment variable into database.php is giving the following error: ```syntax error, unexpected '(', expecting ')' in <b>/var/www/html/app/Config/database.php</b> on line <b>64</b>``` I can not continue ```class DATABASE_CONFIG { public $default = array( 'datasource' => 'Database/Mysql', 'persistent' => true, 'host' => env('MYSQL_URL', false), 'login' => 'admin', 'password' => |
| # |
Apr 4th 2019, 14:24 |
this.impetus |
gotcha, ty |