| # |
Feb 24th 2020, 16:33 |
 neon1024 |
Knowing MySQL it’ll be “Error: Query executed successfully” |
| # |
Feb 24th 2020, 16:32 |
neon1024 |
I can see that the `Connection::query` method returns `StatementInterface` which has `errorCode()` so I guess I just check that? |
| # |
Feb 24th 2020, 16:31 |
neon1024 |
Anyone know how to tell if your query worked? |
| # |
Feb 24th 2020, 16:13 |
ricksaccous |
cool beans ;) for my latest project it was mostly just me and i kind of zoomed through portions, sometimes when i shouldn't have |
| # |
Feb 24th 2020, 16:12 |
ricksaccous |
lol |
| # |
Feb 24th 2020, 16:12 |
neon1024 |
Then again, I’ve had code merged into cakephp, so it can’t be *that* bad if i’ve made it past dereuromark and admad! 8) |
| # |
Feb 24th 2020, 16:11 |
neon1024 |
Never had colleagues on the same codebase, so my code might be total :poop: and I’d never know ;) |
| # |
Feb 24th 2020, 16:11 |
neon1024 |
@ricksaccous Can you imagine anyone wanting to work with me! :,) |
| # |
Feb 24th 2020, 16:07 |
neon1024 |
Guess I’ll use a Shell and write my schema changes in SQL and execute them on the connection |
| # |
Feb 24th 2020, 16:04 |
neon1024 |
Like Judge Dredd “I am the team!” |
| # |
Feb 24th 2020, 16:04 |
ricksaccous |
and considering the time it might take to write SQL vs using a shell command it's prob better to just write the shell command |
| # |
Feb 24th 2020, 16:03 |
ricksaccous |
honestly even if you did if you just communicated about it it would be no big deal |
| # |
Feb 24th 2020, 16:02 |
ricksaccous |
that makes sense |
| # |
Feb 24th 2020, 16:02 |
ricksaccous |
if you don't have a team then write that shell command, oh yeahhhh |
| # |
Feb 24th 2020, 15:55 |
neon1024 |
No idea if I can persist schema changes though |
| # |
Feb 24th 2020, 15:54 |
neon1024 |
A shell would be my preference as the php logic will be helpful to have |
| # |
Feb 24th 2020, 15:53 |
neon1024 |
..and I want a migration to change the schema |
| # |
Feb 24th 2020, 15:53 |
neon1024 |
I want a Shell for the ORM and PHP logic |
| # |
Feb 24th 2020, 15:53 |
neon1024 |
I don’t have a team |
| # |
Feb 24th 2020, 15:49 |
ricksaccous |
i'm only thinking like that for the sake of your team |
| # |
Feb 24th 2020, 15:49 |
ricksaccous |
whatever |
| # |
Feb 24th 2020, 15:49 |
ricksaccous |
probably |
| # |
Feb 24th 2020, 15:49 |
ricksaccous |
actually the neatest way would be in it's own migration where you write your own sql |
| # |
Feb 24th 2020, 15:48 |
ricksaccous |
i see |
| # |
Feb 24th 2020, 15:48 |
neon1024 |
Nah, it’s a one off migration, I need to refactor some associations |
| # |
Feb 24th 2020, 15:48 |
ricksaccous |
@neon1024 i'd probably just use a shell command for something like that if you don't need to do it on some page action |
| # |
Feb 24th 2020, 15:35 |
neon1024 |
This is what I would try :) |
| # |
Feb 24th 2020, 15:35 |
neon1024 |
`if ($this->getRequest()->getParam('prefix') === null) { $this->Examples->behaviors()->unload('Nifty'); }` |
| # |
Feb 24th 2020, 15:33 |
birdy247 |
Anyone have any "nifty" ideas on how to disable a behavior only on a non prefixed route? |
| # |
Feb 24th 2020, 15:31 |
neon1024 |
Or should I be using a Shell command I wonder :thinking_face: |
| # |
Feb 24th 2020, 15:30 |
neon1024 |
Can I copy data using migrations? Or do I need to write my own SQL? Ideally I’d like to use the ORM to fetch some rows, loop them and write the various foreign keys into the new table. |
| # |
Feb 24th 2020, 14:53 |
heke |
thanks |
| # |
Feb 24th 2020, 14:33 |
savant |
test from slack |
| # |
Feb 24th 2020, 14:33 |
savant3 |
test from irc |
| # |
Feb 24th 2020, 14:05 |
savant3 |
test from irc |
| # |
Feb 24th 2020, 13:57 |
admad |
@np why are you returning the query from callback? |
| # |
Feb 24th 2020, 12:56 |
kevin.pfeifer |
ok thx :+1: |
| # |
Feb 24th 2020, 12:56 |
spriz |
yeah I wouldn't worry about it |
| # |
Feb 24th 2020, 12:55 |
kevin.pfeifer |
but if you say there shouldn't be any reason to delete old migrations then i will leave them be |
| # |
Feb 24th 2020, 12:54 |
kevin.pfeifer |
i just want to clean up my repo. So the migration_snapshot command creates a migration representation of my current DB status as i see right now. |
| # |
Feb 24th 2020, 12:53 |
k4t |
I am thinking about that solution: https://github.com/Gregwar/Captcha |