| # |
Feb 4th 2018, 23:44 |
SUPERNETS |
IRC.SUPERNETS.ORG #SUPERBOWL BEST IRC NETWORK FUCK YOUR NETWORK |
| # |
Feb 4th 2018, 22:55 |
 waspinator |
I can't seem to get translated strings to show up. I have a `src/Locale/fr_FR/default.po` file with the `msgid` and translated `msgstr` and I call `I18n::setLocale('fr_FR');`. Right next to the element I call `debug(I18n::getLocale());` and I get `fr_FR`, but the message is still in English. I ran `bin/cake cache clear_all` but it still shows up in English. What's the best way to debug? |
| # |
Feb 4th 2018, 19:27 |
itamer |
this is in findAuth |
| # |
Feb 4th 2018, 19:27 |
itamer |
@turkles no results are duplicated. I can repeate the results if I remove the second join statement from the query - yet when I see the sql statement the second join is clearly in there. Is there any way I can see the actual query that gets run? |
| # |
Feb 4th 2018, 18:06 |
bedo2991 |
And with the same technique I have realized " <= NOW()", without fighting with any php datetime function. |
| # |
Feb 4th 2018, 18:06 |
bedo2991 |
They both work :slightly_smiling_face: |
| # |
Feb 4th 2018, 18:05 |
hmic |
['field IS' => null] actually |
| # |
Feb 4th 2018, 17:58 |
chris-andre |
‘MyControlle.dateTimeAttribute IS NULL’ |
| # |
Feb 4th 2018, 17:53 |
bedo2991 |
I am currently using: $this->MyController->find('all', [ 'conditions'=>['MyController.dateTimeAttribute'=> null]]); |
| # |
Feb 4th 2018, 17:52 |
bedo2991 |
Hi, how do I make cakephp3 generate "IS null" instead of "= null"? |
| # |
Feb 4th 2018, 16:26 |
birdy247 |
or si there a better buzz word for this type of "software" |
| # |
Feb 4th 2018, 16:25 |
birdy247 |
would you describe them as developing software? |
| # |
Feb 4th 2018, 16:25 |
birdy247 |
If a company specialises in building cake php projects |
| # |
Feb 4th 2018, 16:25 |
birdy247 |
off topic question |
| # |
Feb 4th 2018, 15:31 |
kitcat711 |
trying to create a search form: when the user types several keywords, how do I create my query to get the results matching all the words (in a post title)? |
| # |
Feb 4th 2018, 11:12 |
kitcat711 |
when matchning, the relation is based on the belongsToMany => I dont retrieve the authors |
| # |
Feb 4th 2018, 11:11 |
kitcat711 |
Users hasMany ForumPosts (as an Author) and Users belongsToMany ForumPosts (as subscribers) |
| # |
Feb 4th 2018, 11:10 |
kitcat711 |
help with matching not workinas expected |
| # |
Feb 4th 2018, 10:35 |
turkles |
Are the results duplicated in any way? Not much to go on there.. |
| # |
Feb 4th 2018, 07:26 |
itamer |
I have two tables in the join array, both get displayed in the sql but it's as if the second join and the order() get stripped off the query. |
| # |
Feb 4th 2018, 07:22 |
itamer |
I've got a findAuth function so that the login function applies the correct rules. Within that function I have some debugging. If I run the query sql I get 3 results, if I look in the results of toArray() I have about 20 results. Any ideas what might be happening or how to debug? ob_start(); debug($query); debug($query->toArray()); $str = ob_get_contents(); ob_end_clean(); |
| # |
Feb 4th 2018, 03:56 |
turkles |
a class outside of cakephp? |
| # |
Feb 4th 2018, 03:52 |
admad |
I would suggest moving the fetch and processing logic in separate class. |
| # |
Feb 4th 2018, 03:50 |
turkles |
at the moment I have a behaviour that handles the data grab in a generic fashion which I can then use in various models. I am struggling more with where I put the logic side, ie. initiate a fetch, process, and save, so that I can use in both a controller and a shell |
| # |
Feb 4th 2018, 03:45 |
admad |
Checkout muffin/webservice plugin if you want to implement ORM type access to the webservice |
| # |
Feb 4th 2018, 03:45 |
admad |
@turkles you can ake your own classes under a custom App\Webservice namespace. |
| # |
Feb 4th 2018, 02:49 |
turkles |
Hi all, where would I keep code which fetches external API data, processes and stores the response in my database? I want to perform this from either a shell or a controller - as in some cases it will be cron driven, and in others a user on my website may request it? |
| # |
Feb 4th 2018, 01:55 |
itamer |
Either way, the sql that gets shown when I debug isn't the sql that's getting run |
| # |
Feb 4th 2018, 01:54 |
itamer |
I find contain works well for belongsTo but not hasMany |
| # |
Feb 4th 2018, 01:50 |
ricksaccous |
table class* |
| # |
Feb 4th 2018, 01:50 |
ricksaccous |
and then use contain |
| # |
Feb 4th 2018, 01:50 |
ricksaccous |
i always just define associations in the table model itself |
| # |
Feb 4th 2018, 01:50 |
ricksaccous |
to be honest i've never used the join method |
| # |
Feb 4th 2018, 01:49 |
itamer |
aah, no, scratch that, toArray() also shows the wrong data, as if the joins are being ignored at run time even though the sql shows it |
| # |
Feb 4th 2018, 01:47 |
itamer |
even though I see the sql when I debug $query somehow the records that get returned have the joins stripped off. Does that sound right? |
| # |
Feb 4th 2018, 01:46 |
itamer |
@ricksaccous, if you're still around. I'm running findAuth to extend the rules on the records that get returned |
| # |
Feb 4th 2018, 01:19 |
ricksaccous |
I had no idea where to begin debugging, was going to suggest possible foul play in the callback methods |
| # |
Feb 4th 2018, 01:19 |
ricksaccous |
@itamer nice, glad you got it working |
| # |
Feb 4th 2018, 01:18 |
itamer |
@ricksaccous somehow I just fixed it, been chasing my tail on this for hours. very frustrating. |
| # |
Feb 4th 2018, 01:16 |
slackebot |
DESC', |
| # |
Feb 4th 2018, 01:16 |
itamer |
'sql' => 'SELECT Individuals.id AS `Individuals__id`, Individuals.email AS `Individuals__email`, Individuals.password AS `Individuals__password` FROM individuals Individuals INNER JOIN memberships Memberships ON Individuals.membership_id = Memberships.id INNER JOIN finances Finances ON Finances.membership_id = :c0 WHERE (Individuals.email = :c1 AND Individuals.status in (:c2,:c3) AND Memberships.softdelete = :c4) ORDER BY Finances.enddate |