Log message #4199750

# At Username Text
# Aug 23rd 2019, 12:49 admad if you absolutely want to support both uuid and int then make 2 fk fields and configure which field to use in association
# Aug 23rd 2019, 12:48 slackebot2 'length' => 64, ```
# Aug 23rd 2019, 12:48 slackebot2 ->addColumn('parent_asset_id', 'integer', [ 'null' => true, 'default' => null, ]) - ->addColumn('foreign_key', 'string', [ - 'null' => true, 'default' => null, 'length' => 36, + ->addColumn('foreign_key', 'integer', [ + 'null' => true, 'default' => null, ]) ->addColumn('model', 'string', [ 'null' => true, 'default' => null,
# Aug 23rd 2019, 12:48 rchavik solved: ``` diff --git a/FileManager/config/Migrations/20131130074112_AssetsInitialMigration.php b/FileManager/config/Migrations/20131130074112_AssetsInitialMigration.php index 2be8a93f..b1a24282 100644 --- a/FileManager/config/Migrations/20131130074112_AssetsInitialMigration.php +++ b/FileManager/config/Migrations/20131130074112_AssetsInitialMigration.php @@ -64,8 +64,8 @@ class AssetsInitialMigration extends AbstractMigration {
# Aug 23rd 2019, 12:47 admad hehe, it happens, something we get too focused trying to solve things one way
# Aug 23rd 2019, 12:47 rchavik :face_palm:
# Aug 23rd 2019, 12:47 rchavik it never occured to me to change the damn schema
# Aug 23rd 2019, 12:47 rchavik you know..
# Aug 23rd 2019, 12:46 admad ah, noble cause :slightly_smiling_face:
# Aug 23rd 2019, 12:45 rchavik yeah, this was trying to support integer and char(36) for uuids
# Aug 23rd 2019, 12:45 admad not sure how db db will handle if the value isn't quoted
# Aug 23rd 2019, 12:44 admad overriding field type might creating problems when saving data
# Aug 23rd 2019, 12:44 admad but best is to avoid creating unnecessary problems which you have to solve :slightly_smiling_face:
# Aug 23rd 2019, 12:43 rchavik noted, i will try to change the field
# Aug 23rd 2019, 12:43 admad you can try overriding the field type in table table schema in Table::_initalizeSchema()
# Aug 23rd 2019, 12:41 admad *same as
# Aug 23rd 2019, 12:41 admad so don't do such wacky things, fk field type should be same and primary key field type
# Aug 23rd 2019, 12:28 slackebot2 ^ ``` which I think is because postgres does not like it when trying to compare a string field Assets.foreign_key against an integer field Attachments.id
# Aug 23rd 2019, 12:28 rchavik Eg: I have Asset table, with assets.id = integer. And the relationship is: ``` class AssetsTable extends Table { $this->belongsTo('Attachments', [ 'foreignKey' => 'foreign_key', ... ``` This errored out with ```Error: [PDOException] SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer = character varying LINE 1: ...achments ON (Assets.model = $1 AND Attachments.id = (Assets.foreign_key)
# Aug 23rd 2019, 12:22 rchavik how can i cast the type of the foreignKey in an automatic join created by belongsTo() ?
# Aug 23rd 2019, 12:00 rchavik works!
# Aug 23rd 2019, 11:41 rchavik ah... trying this now https://github.com/cakephp/migrations/issues/370
# Aug 23rd 2019, 11:38 rchavik for sqlite and postgres, mysql is fine
# Aug 23rd 2019, 11:37 rchavik hi, getting "There is no active transaction" error when running seed() for this file: https://github.com/croogo/croogo/blob/4.0/Users/config/Seeds/UsersSeed.php#L25 I found https://github.com/cakephp/migrations/issues/83 but still could not work.
# Aug 23rd 2019, 10:27 alexdd55976 anyone has experience with authenticate against a Domain Controller?
# Aug 23rd 2019, 10:06 alexdd55976 ok
# Aug 23rd 2019, 10:06 conehead did not really help. actually changed the id type of 2 entities now and wrote migrations
# Aug 23rd 2019, 10:04 alexdd55976 did you try a fulltext index on foreign id then? not the solution, but maybe a way to speed it up
# Aug 23rd 2019, 10:03 alexdd55976 yeah.. i thought so... this is why is pointed it out
# Aug 23rd 2019, 09:22 conehead just use `debug` around it
# Aug 23rd 2019, 09:20 slackebot2 'fields' => array( 'name', 'email', ) )); ```
# Aug 23rd 2019, 09:20 chan how to see log of sql query in cakephp for ``` $this->Master->find('all', array( 'conditions' => array( 'AND' => array('Master.client_id' => $client_id), 'OR' => array( array('Master.selected_main_group_id' => null), array('Master.selected_main_group_id' => 88), ), ),
# Aug 23rd 2019, 08:31 val Hi, would it be possible to have a standalone 3.x shell classes library like standalone ORM https://github.com/cakephp/orm?
# Aug 23rd 2019, 08:15 conehead I had/have one table that holds many entities which are linked to one Entity each. Lets say `Documents` and `Users` and the table `Statuses` had the fields `id, foreign_id, model, someData`. So you could link a `Status` with Documents and Users. If Documents use uuids but Users use ids, there is going to be a massive performance drain (timing out for me) when you try to access the linked data
# Aug 23rd 2019, 08:11 mehov @conehead thanks for the tip. what do you mean "do not mix ids and uuids" - as in don't use them in the same query, or maybe same database?
# Aug 23rd 2019, 08:08 lubos How do I paginate union results? I mean is it possible somehow to use `Paginator` with `Cake\Database\Query`?
# Aug 23rd 2019, 07:55 conehead With all of your help ;) But still find it a little strange
# Aug 23rd 2019, 07:54 neon1024 @conehead Good job figuring it out :thumbsup:
# Aug 23rd 2019, 07:47 conehead alex, neon and admad...and everyone else who helped me yesterday: I finally found out...do not mix uuids and ids...ever. This was the only reason everything slowed down a gazillion times
# Aug 23rd 2019, 07:47 lubos `disableHydration` is what I was looking for :slightly_smiling_face:
# Aug 23rd 2019, 07:45 lubos I am trying to do SQL union, that's why this would be useful