| # |
Feb 1st 2018, 13:17 |
madrid998 |
Does anyone know why my FozenDateDatime object looses seconds when using it to create a DateTime object like this: $myDateTime = new DateTime($MyFrozenTime)? |
| # |
Feb 1st 2018, 11:33 |
 gaetansnl |
@hmic It's for multi tenant, I switch the database one time in a middleware but I also need to switch it somewhere in the code. // You mean instead of clearing TableRegistry, I change all tables connections inside his cache ? I think I need a custom TableLocator to do that |
| # |
Feb 1st 2018, 11:26 |
hmic |
you can tell the tableregistry to replace an alias |
| # |
Feb 1st 2018, 11:26 |
hmic |
gaetansnl: whats the usecase? |
| # |
Feb 1st 2018, 11:25 |
gaetansnl |
Hello, when I create a connection alias, I clear the table registry to clear cached tables. It works fine for new calls to TableRegistry::get. But sometimes I have models already loaded in controllers, is there a way to reload them or I need to do it manually ? |
| # |
Feb 1st 2018, 11:10 |
turkles |
Text based game, Torn |
| # |
Feb 1st 2018, 11:10 |
neon1024 |
Ah, I need a new Destiny 2 clan :P |
| # |
Feb 1st 2018, 11:10 |
turkles |
nothing interesting :$ |
| # |
Feb 1st 2018, 11:09 |
neon1024 |
What’s the game? :slightly_smiling_face: |
| # |
Feb 1st 2018, 11:09 |
neon1024 |
Oh I see, okay :thumbsup: |
| # |
Feb 1st 2018, 11:09 |
neon1024 |
Well a custom finder could do that for you when you run the query |
| # |
Feb 1st 2018, 11:09 |
turkles |
I'm ripping the data off a games API anyway which provides just the days total |
| # |
Feb 1st 2018, 11:09 |
turkles |
yes but then I would need to record each stint to know total days overall, works for the current one |
| # |
Feb 1st 2018, 11:08 |
neon1024 |
Well you could use the Timestamp behaviour to write the fields for you automagically |
| # |
Feb 1st 2018, 11:08 |
turkles |
meh, they switch between them too often to store the dates |
| # |
Feb 1st 2018, 11:07 |
neon1024 |
So you avoid the “magic join table” |
| # |
Feb 1st 2018, 11:07 |
neon1024 |
`Gamers hasMany Memberships belongsTo Clans` |
| # |
Feb 1st 2018, 11:07 |
neon1024 |
If you’re storing lots of data in the join, I’d be tempted to make a proper join table and name it something relevant |
| # |
Feb 1st 2018, 11:06 |
neon1024 |
So you can work out days in your SQL |
| # |
Feb 1st 2018, 11:06 |
neon1024 |
I’d recommend storing the `join_datetime` and `leave_datetime` |
| # |
Feb 1st 2018, 11:05 |
turkles |
there are other things in my join table which I want to track, like days in clan, which make it also fiddly to record things under an old _clan table |
| # |
Feb 1st 2018, 11:05 |
ooskar1233 |
hm, thought that self-referencing would be user hasmany users |
| # |
Feb 1st 2018, 11:05 |
ooskar1233 |
:) |
| # |
Feb 1st 2018, 11:05 |
neon1024 |
Oh, ninja edit! |
| # |
Feb 1st 2018, 11:05 |
neon1024 |
Same thing :P |
| # |
Feb 1st 2018, 11:04 |
ooskar1233 |
not that self referencing, just two associations of different type to one talbe |
| # |
Feb 1st 2018, 11:04 |
ooskar1233 |
sure, but you don't mess around bypassing association you created :slightly_smiling_face: |
| # |
Feb 1st 2018, 11:04 |
neon1024 |
Self referencing aliased tables can be a bit fiddly imho |
| # |
Feb 1st 2018, 11:04 |
ooskar1233 |
has many old_clans, belongs to clan |
| # |
Feb 1st 2018, 11:03 |
ooskar1233 |
liek |
| # |
Feb 1st 2018, 11:03 |
neon1024 |
But I think you’d have to manage a bit of that process manually |
| # |
Feb 1st 2018, 11:03 |
ooskar1233 |
or just creating two associations |
| # |
Feb 1st 2018, 11:03 |
neon1024 |
@ooskar1233 Approach would also work, by creating a row in a clan history table |
| # |
Feb 1st 2018, 11:03 |
neon1024 |
You could set the condition on the association configuration |
| # |
Feb 1st 2018, 11:02 |
turkles |
Ah indeed |
| # |
Feb 1st 2018, 11:02 |
neon1024 |
So you don’t get a list of clan members who were in the clan as well as are currently |
| # |
Feb 1st 2018, 11:02 |
neon1024 |
Do remember to filter the association on the other end as well |
| # |
Feb 1st 2018, 11:02 |
neon1024 |
..and you’ll still be able to pull all the clans they’re “in” as “was in” |
| # |
Feb 1st 2018, 11:02 |
neon1024 |
Yep |
| # |
Feb 1st 2018, 11:01 |
turkles |
ok so I flag in the join table, and then I can use conditions on that flag if I only want the current |
| # |
Feb 1st 2018, 11:01 |
neon1024 |
@turkles Then you’ll have to use a `belongsToMany` with an `active` flag in the join table |