| # |
Oct 6th 2018, 22:52 |
 dereuromark |
find() and count(), all() are closing ones. after that you get a collection, not a query |
| # |
Oct 6th 2018, 22:52 |
dereuromark |
you need to understand how the orm works. |
| # |
Oct 6th 2018, 22:51 |
rightscoreanalysis |
ok so find() should be the last thing |
| # |
Oct 6th 2018, 22:51 |
dereuromark |
you cannot close a query though and then continue doing things on the resulting entity. |
| # |
Oct 6th 2018, 22:51 |
rightscoreanalysis |
Or Properties / properties |
| # |
Oct 6th 2018, 22:51 |
rightscoreanalysis |
should it be singlur Property with table named 'properties' |
| # |
Oct 6th 2018, 22:50 |
rightscoreanalysis |
I am modelling Properties |
| # |
Oct 6th 2018, 22:50 |
dereuromark |
the error message tells you that (entity vs table/query) |
| # |
Oct 6th 2018, 22:50 |
rightscoreanalysis |
I think there maybe some confusion with my model names |
| # |
Oct 6th 2018, 22:50 |
dereuromark |
where()->leftJoin()->first() |
| # |
Oct 6th 2018, 22:50 |
rightscoreanalysis |
Ok I'll take a few steps back |
| # |
Oct 6th 2018, 22:50 |
dereuromark |
also, first() closes a query, why are you doing leftJoin after a first()? |
| # |
Oct 6th 2018, 22:49 |
dereuromark |
using ->belongsTo(), ->has...() etc |
| # |
Oct 6th 2018, 22:49 |
dereuromark |
still, you could set up all the relations |
| # |
Oct 6th 2018, 22:48 |
rightscoreanalysis |
it's because I need to do some deep filtering |
| # |
Oct 6th 2018, 22:47 |
dereuromark |
why are you doing manual joins? I always set up my relations in the table classes and then can just use contain() |
| # |
Oct 6th 2018, 22:47 |
rightscoreanalysis |
similarly I am also getting: Call to undefined method App\Model\Entity\Property::innerJoinWith() |
| # |
Oct 6th 2018, 22:44 |
rightscoreanalysis |
I am unable to do any joins it seems |
| # |
Oct 6th 2018, 22:38 |
rightscoreanalysis |
leftJoin - sorry typo |
| # |
Oct 6th 2018, 22:38 |
slackebot |
<rightscoreanalysis> |
| # |
Oct 6th 2018, 22:30 |
dereuromark |
lef or left? |
| # |
Oct 6th 2018, 22:28 |
rightscoreanalysis |
why is that? |
| # |
Oct 6th 2018, 22:28 |
rightscoreanalysis |
I tried another approach and now I see: Call to undefined method App\Model\Entity\Property::lefJoin() |
| # |
Oct 6th 2018, 22:18 |
rightscoreanalysis |
do I need to specify the fields in order to see the join, I seems to remember something similar in cake2 |
| # |
Oct 6th 2018, 22:18 |
rightscoreanalysis |
hi guys, I'm doing a simple join on my query - when I debug the result it is empty |
| # |
Oct 6th 2018, 21:28 |
murat |
I haven't used that before. Thanks. |
| # |
Oct 6th 2018, 21:28 |
dereuromark |
jep |
| # |
Oct 6th 2018, 21:27 |
murat |
`Table::schema()`? |
| # |
Oct 6th 2018, 21:26 |
dereuromark |
you can make it work reading fields of schema() |
| # |
Oct 6th 2018, 21:26 |
murat |
Is it completely removed? |
| # |
Oct 6th 2018, 21:25 |
dereuromark |
not in 3.x |
| # |
Oct 6th 2018, 21:25 |
murat |
When I create a query with fields option, I can't just say `'TableName.*'` in fields array, right? |
| # |
Oct 6th 2018, 21:23 |
murat |
Thank you. |
| # |
Oct 6th 2018, 21:23 |
murat |
:,'( Yes. |
| # |
Oct 6th 2018, 21:20 |
dereuromark |
not reading it. how does your find look like? sounds like you are not querying the id. check your sql query |
| # |
Oct 6th 2018, 21:16 |
slackebot |
array (size=0) empty public '[errors]' => array (size=0) empty public '[invalid]' => array (size=0) empty public '[repository]' => string 'Type' (length=4)``` |
| # |
Oct 6th 2018, 21:16 |
murat |
``` object(App\Model\Entity\Type)[1243] public 'name' => string '.......' (length=19) public 'dept_id' => int 3 public '[new]' => boolean false public '[accessible]' => array (size=2) '*' => boolean true 'id' => boolean false public '[dirty]' => array (size=0) empty public '[original]' => array (size=0) empty public '[virtual]' => |
| # |
Oct 6th 2018, 21:15 |
murat |
What the hell am I doing to get a null from `$entity->id`? |
| # |
Oct 6th 2018, 21:13 |
murat |
I get null. |
| # |
Oct 6th 2018, 21:12 |
dereuromark |
Murat: What do you mean? each hydrated entity has ->id access |
| # |
Oct 6th 2018, 21:11 |
murat |
Is there a way to get the id of an entity? |