Log message #4160882

# At Username Text
# Jul 20th 2018, 10:10 josbeir its still a hog but it has nice features
# Jul 20th 2018, 10:10 josbeir i must admit @neon1024 mysql workbench has come a long way, just tested it again
# Jul 20th 2018, 10:10 sheraliqureshi.mhtech @neon1024
# Jul 20th 2018, 10:00 josbeir yeah
# Jul 20th 2018, 10:00 neon1024 Just in case you miss something in your codebase
# Jul 20th 2018, 10:00 neon1024 The foreign key constraints are a nice fallback for data integrity I find
# Jul 20th 2018, 10:00 neon1024 Anyway
# Jul 20th 2018, 10:00 josbeir beats phpmyadmin in the productivity part
# Jul 20th 2018, 10:00 josbeir hmm i dno i'm using it for years now, it sometimes has it quirks but for the most part it just works
# Jul 20th 2018, 10:00 neon1024 It’s the best of a bad bunch
# Jul 20th 2018, 10:00 neon1024 Don’t get me wrong, it’s one of the better tools available, however it’s a solid 4/10 and the others are 2/10
# Jul 20th 2018, 09:59 neon1024 Like the drag a tab and the sidebar goes black
# Jul 20th 2018, 09:59 neon1024 Or get patches to bug fixes
# Jul 20th 2018, 09:59 neon1024 Or see a database refresh
# Jul 20th 2018, 09:59 neon1024 Or import JSON
# Jul 20th 2018, 09:59 neon1024 Except when you want to export JSON
# Jul 20th 2018, 09:59 josbeir thats +1 for me
# Jul 20th 2018, 09:59 josbeir it starts in seconds.
# Jul 20th 2018, 09:59 josbeir its my go 2 tool for most sql stuff
# Jul 20th 2018, 09:58 josbeir :)
# Jul 20th 2018, 09:58 josbeir wuuuh?
# Jul 20th 2018, 09:58 neon1024 Utter, utter, shite.
# Jul 20th 2018, 09:58 neon1024 Sequel Pro is a pile utter shite.
# Jul 20th 2018, 09:58 josbeir sequel pro !
# Jul 20th 2018, 09:58 josbeir ah ok :slightly_smiling_face:
# Jul 20th 2018, 09:58 neon1024 I’m only using them because i built my database in MySQL Workbench, and I need the constraints to draw the lines in the ERD :P
# Jul 20th 2018, 09:57 josbeir maybe i should change that mindset
# Jul 20th 2018, 09:57 josbeir hmm i always tought that using fkey constraints in combination with framework ORM's was not a good idea
# Jul 20th 2018, 09:45 neon1024 Cool, thanks @dereuromark that’s worked for me :slightly_smiling_face:
# Jul 20th 2018, 09:34 neon1024 Why are foreign key constraints such a PITA
# Jul 20th 2018, 09:34 neon1024 Kinda shonky :s
# Jul 20th 2018, 09:34 neon1024 Ahok, so I guess I can just update the table in the migration
# Jul 20th 2018, 09:34 dereuromark if you can fix your data first, might work as 2 step.
# Jul 20th 2018, 09:33 dereuromark you add it first without constraint, then you fix your data, then you add a constraint. 3 steps usually, same for required (not null) fields.
# Jul 20th 2018, 09:33 neon1024 File uploaded https://cakesf.slack.com/files/U1BT622HW/FBTT81A9Z/-.sh / https://slack-files.com/T053DPNCM-FBTT81A9Z-75c044b96b
# Jul 20th 2018, 09:33 neon1024 ` == 20180720083451 CampaignScripts: migrating Exception: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`telecoms_call_centre`.`#sql-2ce5_a83`, CONSTRAINT `#sql-2ce5_a83_ibfk_1` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`)) in [/Users/david/Sites/TelecomsCCA/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php, line 338]`
# Jul 20th 2018, 09:32 neon1024 How do I get around adding a migration with a new foreignKey constraint?
# Jul 20th 2018, 09:08 blancessanchez30 @neon1024 yes
# Jul 20th 2018, 09:00 josbeir the new authentication/authorization plugins do a good job at that, usedata is stored in request
# Jul 20th 2018, 08:46 dereuromark I use a helper here: https://github.com/dereuromark/cakephp-tinyauth/blob/master/docs/Authorization.md#authuserhelper - this also allows for stateless and stateful approaches. Until core can fix itself to a more request driven approach :slightly_smiling_face:
# Jul 20th 2018, 08:44 dereuromark not really, is that in view template?