| # |
Mar 28th 2019, 15:21 |
 ricksaccous |
how would you have done it? |
| # |
Mar 28th 2019, 15:21 |
neon1024 |
:thinking_face: I wouldn’t have normalized the addresses by country |
| # |
Mar 28th 2019, 15:21 |
ricksaccous |
hehehe, yeah, although honestly seems that postal code is shared across all address types so i could move it to addresses table |
| # |
Mar 28th 2019, 15:20 |
neon1024 |
Wait, you’re storing the zip code in the address types table? |
| # |
Mar 28th 2019, 15:20 |
ricksaccous |
Users -> Addresses -> [UsAddress, OtherAddress, etc] |
| # |
Mar 28th 2019, 15:20 |
ricksaccous |
so |
| # |
Mar 28th 2019, 15:20 |
ricksaccous |
well they are filtering the users model essentially |
| # |
Mar 28th 2019, 15:20 |
ricksaccous |
so |
| # |
Mar 28th 2019, 15:19 |
ricksaccous |
filter the model* |
| # |
Mar 28th 2019, 15:19 |
ricksaccous |
so if any of them have a zip code like the one being searched for i want to filter the users based on that |
| # |
Mar 28th 2019, 15:19 |
ricksaccous |
the address type tables have the zip code |
| # |
Mar 28th 2019, 15:18 |
ricksaccous |
I think I'll keep it simple for now and do one matching but basically users can filter results based on zip code, and the model i have is related to addresses table which in turn is related to three different address types |
| # |
Mar 28th 2019, 15:17 |
neon1024 |
What is it you’re actually trying to achieve? |
| # |
Mar 28th 2019, 15:17 |
neon1024 |
@ricksaccous https://github.com/cakephp/cakephp/blob/master/src/Database/Query.php#L1842-L1882 |
| # |
Mar 28th 2019, 15:12 |
neon1024 |
I’m sure you can interrogate the query object |
| # |
Mar 28th 2019, 15:12 |
ricksaccous |
ok |
| # |
Mar 28th 2019, 15:12 |
neon1024 |
Check the query object api to see what methods are there though |
| # |
Mar 28th 2019, 15:12 |
ricksaccous |
oh |
| # |
Mar 28th 2019, 15:11 |
neon1024 |
It creates conditions |
| # |
Mar 28th 2019, 15:11 |
neon1024 |
Well matching isn’t a clause |
| # |
Mar 28th 2019, 15:11 |
ricksaccous |
so i can use $queryExpression->_or($query->getClause->matching(), $query->getClause()->matching() or something along those lines? |
| # |
Mar 28th 2019, 15:10 |
ricksaccous |
hmmm |
| # |
Mar 28th 2019, 15:09 |
neon1024 |
I believe that `$query->clause('where')` would get the where clause, might be `getClause()` now |
| # |
Mar 28th 2019, 15:07 |
cnizzardini |
Hmm, not sure if that has a matching |
| # |
Mar 28th 2019, 15:06 |
cnizzardini |
Can you use QueryExpression to accomplish that? |
| # |
Mar 28th 2019, 15:06 |
ricksaccous |
yeah, i'm pretty busy here, have a decent amount of nice to haves but yeah |
| # |
Mar 28th 2019, 15:05 |
cnizzardini |
Thats the trouble, getting time for these nice to haves depending on your organization |
| # |
Mar 28th 2019, 15:04 |
ricksaccous |
hmmmm |
| # |
Mar 28th 2019, 15:04 |
ricksaccous |
i'm sure there's a way to get 'OR' => [Query->matching(), Query->matching()] but not sure how to go about it |
| # |
Mar 28th 2019, 15:01 |
neon1024 |
I should open a ticket for myself to re-investigate |
| # |
Mar 28th 2019, 15:01 |
neon1024 |
Never got around to building it out properly as we had different production architecture at the time, but we’ve changed since, so might be worth re-visiting |
| # |
Mar 28th 2019, 15:01 |
neon1024 |
Nice as you can create lots of different tasks too, like if you wanted to run Rector to upgrade |
| # |
Mar 28th 2019, 15:00 |
neon1024 |
https://deployer.org/ |
| # |
Mar 28th 2019, 15:00 |
neon1024 |
..and er, PHP Deployer or something it’s called |
| # |
Mar 28th 2019, 15:00 |
neon1024 |
I’ve been looking at Rocketeer |
| # |
Mar 28th 2019, 15:00 |
neon1024 |
We still use Git here |
| # |
Mar 28th 2019, 14:59 |
neon1024 |
`apt install my-website` |
| # |
Mar 28th 2019, 14:59 |
neon1024 |
Not all deployments tools are big! ;) |
| # |
Mar 28th 2019, 14:59 |
isaiah |
ok so should i delete and upload the normal way? |
| # |
Mar 28th 2019, 14:58 |
cnizzardini |
Not everyone needs a big deployment tool, mine does what derueromarks link does, the difference is all my bash commands happen in .git/hooks/post-merge but im also lazy |
| # |
Mar 28th 2019, 14:57 |
cnizzardini |
Its a step up over FTP deployments |