| # |
Jul 20th 2018, 11:16 |
 josbeir |
bookmarked |
| # |
Jul 20th 2018, 11:16 |
josbeir |
hey that looks nice |
| # |
Jul 20th 2018, 11:12 |
neon1024 |
@josbeir RE: Database design tools. I was curious and had a search to see if an application was event needed. It seems not. https://app.sqldbm.com/MySQL/Draft/ |
| # |
Jul 20th 2018, 10:51 |
neon1024 |
Or if you’re using an association, don’t forget you can define the sort in the association as well |
| # |
Jul 20th 2018, 10:50 |
neon1024 |
Or as @dereuromark suggests. Add a field to your Table class and process it with a behaviour which hooks queries and appends the sorting |
| # |
Jul 20th 2018, 10:49 |
neon1024 |
@lubos This is how I’ve tackled it. Not very clean, but it works. I’m sure you can adapt the technique to suit your use-case |
| # |
Jul 20th 2018, 10:48 |
neon1024 |
File uploaded https://cakesf.slack.com/files/U1BT622HW/FBU6U8G5T/default_ordering_using_crud.sh / https://slack-files.com/T053DPNCM-FBU6U8G5T-8efb7797da |
| # |
Jul 20th 2018, 10:48 |
hmic |
sorry, beforeFind |
| # |
Jul 20th 2018, 10:46 |
lubos |
hmic, you said in a beforeFilter call back, that's the controller callback or am I wrong? :slightly_smiling_face: |
| # |
Jul 20th 2018, 10:45 |
asdfgh |
:D |
| # |
Jul 20th 2018, 10:45 |
asdfgh |
neon1024 too long |
| # |
Jul 20th 2018, 10:44 |
neon1024 |
Just curious asdfgh, why not jkl as well? |
| # |
Jul 20th 2018, 10:43 |
hmic |
asdfgh: return response withBody from the action |
| # |
Jul 20th 2018, 10:42 |
hmic |
lubos: i have not been talking about the controller. both go into zour table |
| # |
Jul 20th 2018, 10:42 |
asdfgh |
guys how can i reply with a string instead creating aview? |
| # |
Jul 20th 2018, 10:29 |
dereuromark |
successor, yes |
| # |
Jul 20th 2018, 10:28 |
birdy247 |
Are Consoles now in favour over Shells |
| # |
Jul 20th 2018, 10:27 |
lubos |
hmic: thanks, wanted to not touch controller at all (using CRUD) and wanted to set it up in model, something like setDisplayField, setOrder :slightly_smiling_face: ... I could overwrite all finder, but thought there is better way |
| # |
Jul 20th 2018, 10:25 |
hmic |
lubos: yes. in a beforeFilter callback, or by overwriting the find() method |
| # |
Jul 20th 2018, 10:24 |
lubos |
I mean in Table |
| # |
Jul 20th 2018, 10:24 |
lubos |
Is it possible to set default order in the model? |
| # |
Jul 20th 2018, 10:14 |
josbeir |
browsing, manipulating over ssh is just quicker |
| # |
Jul 20th 2018, 10:13 |
josbeir |
imo, when designing the db then workbench is probably the better bet, but for day 2 day use i think sqlpro will be more productive |
| # |
Jul 20th 2018, 10:13 |
neon1024 |
I just like MySQL Workbenches ERD diagram builder for helping design a db. Plus I like that I can forward engineer that into an actual db |
| # |
Jul 20th 2018, 10:12 |
neon1024 |
To be fair, the beta build of Sequel Pro can do that, but the build also introduces some other bugs |
| # |
Jul 20th 2018, 10:12 |
josbeir |
not a killer feature for me buts its nice 2 have |
| # |
Jul 20th 2018, 10:12 |
neon1024 |
Yeah, like being able to export and import JSON columns ;) |
| # |
Jul 20th 2018, 10:10 |
josbeir |
its still a hog but it has nice features |
| # |
Jul 20th 2018, 10:10 |
josbeir |
i must admit @neon1024 mysql workbench has come a long way, just tested it again |
| # |
Jul 20th 2018, 10:10 |
sheraliqureshi.mhtech |
@neon1024 |
| # |
Jul 20th 2018, 10:00 |
josbeir |
yeah |
| # |
Jul 20th 2018, 10:00 |
neon1024 |
Just in case you miss something in your codebase |
| # |
Jul 20th 2018, 10:00 |
neon1024 |
The foreign key constraints are a nice fallback for data integrity I find |
| # |
Jul 20th 2018, 10:00 |
neon1024 |
Anyway |
| # |
Jul 20th 2018, 10:00 |
josbeir |
beats phpmyadmin in the productivity part |
| # |
Jul 20th 2018, 10:00 |
josbeir |
hmm i dno i'm using it for years now, it sometimes has it quirks but for the most part it just works |
| # |
Jul 20th 2018, 10:00 |
neon1024 |
It’s the best of a bad bunch |
| # |
Jul 20th 2018, 10:00 |
neon1024 |
Don’t get me wrong, it’s one of the better tools available, however it’s a solid 4/10 and the others are 2/10 |
| # |
Jul 20th 2018, 09:59 |
neon1024 |
Like the drag a tab and the sidebar goes black |
| # |
Jul 20th 2018, 09:59 |
neon1024 |
Or get patches to bug fixes |
| # |
Jul 20th 2018, 09:59 |
neon1024 |
Or see a database refresh |