| # |
Oct 12th 2017, 18:05 |
 bravo-kernel |
@keyur.joshi https://disqus.com/home/discussion/bravo-kernel/how_to_add_jwt_authentication_to_a_cakephp_3_rest_api/ |
| # |
Oct 12th 2017, 17:51 |
keyur.joshi |
where can i get cakephp 3 rest api authentication example |
| # |
Oct 12th 2017, 17:45 |
inoas |
rrd564 yeah the ORM <3 ;) |
| # |
Oct 12th 2017, 17:30 |
keyur.joshi |
hi i had created api in cakephp 3 now i have to create component for auth how can i can you help me in this i am new to cakephp thanks in advance |
| # |
Oct 12th 2017, 17:23 |
night_wulfe |
When running the CakePHP 2 unit tests, I'm getting an invalid object name 'tblSession'. It looks like it's because the error handlinger is being tested, which is resulting in my session and template objects being used in the core unit tests. Is there a way I can prevent this, or code my application to play nice with the CakePHP tests? |
| # |
Oct 12th 2017, 17:19 |
rrd564 |
it is soo good |
| # |
Oct 12th 2017, 17:18 |
rrd564 |
the ORM is the best part of CakePHP |
| # |
Oct 12th 2017, 17:17 |
hmic |
the orm is really really powerfull :) |
| # |
Oct 12th 2017, 17:17 |
hmic |
glad you made it! |
| # |
Oct 12th 2017, 17:17 |
rrd564 |
you have saved me a lot of time |
| # |
Oct 12th 2017, 17:17 |
rrd564 |
thank you for your help |
| # |
Oct 12th 2017, 17:17 |
rrd564 |
ok thanks |
| # |
Oct 12th 2017, 17:15 |
hmic |
pass the option not to run callbacks... |
| # |
Oct 12th 2017, 17:15 |
rrd564 |
I mean beforeFind |
| # |
Oct 12th 2017, 17:07 |
rrd564 |
I found it. Is there a way to tell beforeFilter to do not fire for one find? |
| # |
Oct 12th 2017, 17:00 |
rrd564 |
but I am able to solve that my own - I hope... :) |
| # |
Oct 12th 2017, 16:59 |
rrd564 |
at least I got and SQL error what complaining about an inner part of the query, and the generated SQL seems to be the thing i want |
| # |
Oct 12th 2017, 16:59 |
rrd564 |
hm, i think it is solved like this: https://gist.github.com/rrd108/2aedefdaf28bef2919321f8e36f98e68 |
| # |
Oct 12th 2017, 16:54 |
hmic |
maybe ['da.*', 'ca.*'] could do too |
| # |
Oct 12th 2017, 16:53 |
hmic |
but listing the aliased fields should do, if thats the only problem left ;-) |
| # |
Oct 12th 2017, 16:53 |
hmic |
could work too, sure. i wonder why the * does add the alias for you, it did not with me. but then again, i did not leftjoin. so that might be it |
| # |
Oct 12th 2017, 16:52 |
hmic |
please try without leftJoin and without table alias, exactly like i did $table->find()->select('*')->from($q) |
| # |
Oct 12th 2017, 16:52 |
rrd564 |
I did not tried that ne yet |
| # |
Oct 12th 2017, 16:52 |
rrd564 |
should I manually list all fileds there from the temporary tables? |
| # |
Oct 12th 2017, 16:51 |
rrd564 |
yes |
| # |
Oct 12th 2017, 16:51 |
hmic |
oh, its the select * thats the showstopper |
| # |
Oct 12th 2017, 16:51 |
rrd564 |
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `Tetelek__*` FROM (SELECT Osztalyok.id AS `oId`, Osztalyok.nev AS `oNev`, Tar' at line 1 |
| # |
Oct 12th 2017, 16:51 |
hmic |
can you pass the query like i did to the from |
| # |
Oct 12th 2017, 16:50 |
hmic |
i'd not had the leftJoin added already, but the idea is the same, sure |
| # |
Oct 12th 2017, 16:50 |
rrd564 |
The generated SQL starts with this: SELECT Tetelek.* AS `Tetelek__*` |
| # |
Oct 12th 2017, 16:50 |
hmic |
what you get? |
| # |
Oct 12th 2017, 16:50 |
rrd564 |
like this? |
| # |
Oct 12th 2017, 16:49 |
rrd564 |
https://gist.github.com/rrd108/2aedefdaf28bef2919321f8e36f98e68 |
| # |
Oct 12th 2017, 16:49 |
rrd564 |
I updatedte ist |
| # |
Oct 12th 2017, 16:48 |
hmic |
add ->select('*') too |
| # |
Oct 12th 2017, 16:47 |
hmic |
now you create a new ORM\Query from your table and pass it like ->find()->from($debitAbstract) |
| # |
Oct 12th 2017, 16:47 |
rrd564 |
i have it, it is $debitAbstract |
| # |
Oct 12th 2017, 16:46 |
hmic |
which by itself can be executed and gives you (a) desired result |
| # |
Oct 12th 2017, 16:46 |
hmic |
so you are not able to build the query from line 4 till line 28? |
| # |
Oct 12th 2017, 16:46 |
rrd564 |
:slightly_smiling_face: that is where I stucked |
| # |
Oct 12th 2017, 16:45 |
hmic |
thats easy, is it? |