# |
Mar 12th 2018, 11:42 |
dorxy |
in case you're interested in my issue: https://github.com/cakephp/migrations/issues/353 |
# |
Mar 12th 2018, 11:28 |
neon1024 |
Good idea :slightly_smiling_face: |
# |
Mar 12th 2018, 11:28 |
dorxy |
but perhaps it's best to create an issue on github for this, since I believe it might be a bug |
# |
Mar 12th 2018, 11:28 |
neon1024 |
Probably best to just ask an open question to the community I would think then |
# |
Mar 12th 2018, 11:28 |
dorxy |
yeah I was hoping I wouldn't have to cross reference online slack with the contributors ;) |
# |
Mar 12th 2018, 11:27 |
neon1024 |
Or you could just ask the community |
# |
Mar 12th 2018, 11:27 |
neon1024 |
I’d reckon some of these people, https://github.com/cakephp/migrations/graphs/contributors |
# |
Mar 12th 2018, 11:27 |
dorxy |
hi! anyone here who has in-depth knowledge about the migrations plugin? |
# |
Mar 12th 2018, 11:22 |
joddit |
Hi |
# |
Mar 12th 2018, 11:22 |
mansi |
helllo |
# |
Mar 12th 2018, 10:33 |
joddit |
Here is a plugin that may be useful https://github.com/dereuromark/cakephp-queue |
# |
Mar 12th 2018, 10:28 |
joddit |
Or Scheduler |
# |
Mar 12th 2018, 10:27 |
joddit |
If system is Linux, I would use batch |
# |
Mar 12th 2018, 10:26 |
pjadhav |
how to create and handle Queue on system side with Throttle |
# |
Mar 12th 2018, 10:22 |
joddit |
Ok |
# |
Mar 12th 2018, 10:22 |
joddit |
If it's working you will see "WHERE player IS NULL" |
# |
Mar 12th 2018, 10:22 |
turkles |
I am doing this in a shell :S but yes it is working great |
# |
Mar 12th 2018, 10:21 |
joddit |
Depending on your query, check the SQL in your debug kit |
# |
Mar 12th 2018, 10:21 |
turkles |
Ah, ok I will try thanks |
# |
Mar 12th 2018, 10:21 |
joddit |
'player IS' => NULL |
# |
Mar 12th 2018, 10:21 |
joddit |
not equal |
# |
Mar 12th 2018, 10:21 |
joddit |
Use IS clause |
# |
Mar 12th 2018, 10:20 |
turkles |
what is best way to find rows where a value is null? I tried where(['player' => null])->limit(5) and got a syntax error: syntax to use near 'NULL LIMIT 5' |
# |
Mar 12th 2018, 10:17 |
joddit |
And interact with that via cake |
# |
Mar 12th 2018, 10:17 |
joddit |
I would handle the queue on the system side |
# |
Mar 12th 2018, 10:16 |
pjadhav |
or component |
# |
Mar 12th 2018, 10:16 |
pjadhav |
array inside controller |
# |
Mar 12th 2018, 10:15 |
pjadhav |
problem is create Static Array which will hold this jobs |
# |
Mar 12th 2018, 10:15 |
pjadhav |
APIs defined to accept req, delete req |
# |
Mar 12th 2018, 10:14 |
joddit |
https://book.cakephp.org/2.0/en/console-and-shells.html#shell-tasks |
# |
Mar 12th 2018, 10:14 |
joddit |
Youch |
# |
Mar 12th 2018, 10:14 |
pjadhav |
i m using cakephp 2.45 |
# |
Mar 12th 2018, 10:13 |
joddit |
https://book.cakephp.org/3.0/en/console-and-shells.html#shell-tasks |
# |
Mar 12th 2018, 10:13 |
pjadhav |
only problem is putting jobs in sequence and handling queue |
# |
Mar 12th 2018, 10:12 |
pjadhav |
well |
# |
Mar 12th 2018, 10:12 |
pjadhav |
it is executing |
# |
Mar 12th 2018, 10:12 |
joddit |
Either way, I would say this is going to be your best bet https://book.cakephp.org/3.0/en/console-and-shells.html |
# |
Mar 12th 2018, 10:12 |
pjadhav |
there is no problem in creating files and processing |
# |
Mar 12th 2018, 10:11 |
joddit |
Like what kind of file |
# |
Mar 12th 2018, 10:11 |
joddit |
Creates a file how? |
# |
Mar 12th 2018, 10:10 |
pjadhav |
in cakephp how can I put throttle for Queue which hold jobs that are executing currently |