| # |
Jul 10th 2018, 10:38 |
 james.phillips |
thanks for all your help...now I have to go write some more propsal :( |
| # |
Jul 10th 2018, 10:37 |
josbeir |
^^ |
| # |
Jul 10th 2018, 10:37 |
james.phillips |
I just need her to take them for a month or two ;) |
| # |
Jul 10th 2018, 10:36 |
josbeir |
:) |
| # |
Jul 10th 2018, 10:36 |
josbeir |
:S take them to their grandma |
| # |
Jul 10th 2018, 10:36 |
james.phillips |
I dont have my own time...the kids own me lol |
| # |
Jul 10th 2018, 10:36 |
josbeir |
@james.phillips do it on your onw time ;) |
| # |
Jul 10th 2018, 10:35 |
james.phillips |
thanks...It would be easier if i could get to play with it but dont have the time to upgrade etc at the mo.... |
| # |
Jul 10th 2018, 10:35 |
neon1024 |
Yeah, there is no test case for it. So I will PR a test case |
| # |
Jul 10th 2018, 10:35 |
josbeir |
new Collection([]->first(); |
| # |
Jul 10th 2018, 10:35 |
josbeir |
@neon1024 i would think null, try it out! |
| # |
Jul 10th 2018, 10:34 |
josbeir |
haven't done/need that |
| # |
Jul 10th 2018, 10:34 |
josbeir |
altho, you can query multiple ES indexes, i'm not sure how this would translate using php api's |
| # |
Jul 10th 2018, 10:34 |
james.phillips |
I get you..on one side the results need to be merge and on another part by resource type...so its 50-50 |
| # |
Jul 10th 2018, 10:33 |
josbeir |
for instance, when you have an autocomplete field and want to show results for all stuff by a keyword across all indexes you would need to execute 3 queries and join the results, then serve it to the user |
| # |
Jul 10th 2018, 10:32 |
josbeir |
your results would not be merged too |
| # |
Jul 10th 2018, 10:32 |
josbeir |
@james.phillips thats up to you but you would need to execute queries against all your indexes |
| # |
Jul 10th 2018, 10:32 |
neon1024 |
Ooh, I should check the test suite |
| # |
Jul 10th 2018, 10:31 |
neon1024 |
Loving the use of inheritDoc here, when the class has no inheritance :face_with_rolling_eyes: |
| # |
Jul 10th 2018, 10:31 |
neon1024 |
Soo what is the return type of `first()`? Especially if the collection is empty https://github.com/cakephp/collection/blob/master/CollectionTrait.php#L365-L374 |
| # |
Jul 10th 2018, 10:28 |
james.phillips |
where are u from? |
| # |
Jul 10th 2018, 10:28 |
james.phillips |
:money_mouth_face: |
| # |
Jul 10th 2018, 10:28 |
james.phillips |
wudnt a index per "resource" type make more sense? In one way it needs to search everything but wouldn't matching it all back to the correct tables be a pain? |
| # |
Jul 10th 2018, 10:27 |
josbeir |
but maybe i'll get back to work now |
| # |
Jul 10th 2018, 10:26 |
josbeir |
np np i like to share my ES knowledge |
| # |
Jul 10th 2018, 10:26 |
josbeir |
:) i'll send you an invoice |
| # |
Jul 10th 2018, 10:26 |
james.phillips |
i feel like a leech...draining you of all your knowledge |
| # |
Jul 10th 2018, 10:25 |
josbeir |
but in maybe, in your case i'm thinking about typing out a universal document schema and use 1 index to store all your stuff |
| # |
Jul 10th 2018, 10:24 |
josbeir |
there's no specific way or 'good' way to do the indexing |
| # |
Jul 10th 2018, 10:24 |
josbeir |
uhu |
| # |
Jul 10th 2018, 10:23 |
james.phillips |
I have events, publications, podcasts etc so i wanna be able to put them in ES do keyword searches on them and match that result set back to the mysql tables |
| # |
Jul 10th 2018, 10:23 |
josbeir |
well.. maybe not a blob :) |
| # |
Jul 10th 2018, 10:23 |
josbeir |
can be an integer, a string, whatever |
| # |
Jul 10th 2018, 10:23 |
josbeir |
no real 'rules' of the type |
| # |
Jul 10th 2018, 10:23 |
josbeir |
an _id in ES must be something unique, it can be your database PK or something other |
| # |
Jul 10th 2018, 10:22 |
james.phillips |
I get u |
| # |
Jul 10th 2018, 10:22 |
josbeir |
if you add them to it :slightly_smiling_face: |
| # |
Jul 10th 2018, 10:22 |
josbeir |
sure |
| # |
Jul 10th 2018, 10:22 |
james.phillips |
and those documents can have the ID that relates to the primary key of my tables? |
| # |
Jul 10th 2018, 10:22 |
josbeir |
you can use aggregations to do more complex grouping, facetting, that sort of stuff |
| # |
Jul 10th 2018, 10:22 |
josbeir |
it returns documents you queried for |