| # |
May 5th 2021, 16:05 |
 kevin.pfeifer |
but i was happy just with the table definitions and the realtions |
| # |
May 5th 2021, 16:05 |
me1367 |
aye |
| # |
May 5th 2021, 16:05 |
kevin.pfeifer |
like index and what else |
| # |
May 5th 2021, 16:05 |
kevin.pfeifer |
sure you can add more stuff as well |
| # |
May 5th 2021, 16:05 |
erwane |
Hi. Suddenly my `composer install` create a `Plugin` directory in project root and Plugin was not found due to invalid path :S `'WyriHaximus\\MinifyHtml\\' => array($vendorDir . '/wyrihaximus/minify-html/src'),` Bu plugin is in ./Plugin/MinifyHtml dir |
| # |
May 5th 2021, 16:05 |
me1367 |
that looks neat |
| # |
May 5th 2021, 16:04 |
me1367 |
I currently use Datagrip but it's not really typer friendly. Most of the stuff you have to click, enter something, click a few times, more clicks, type something and so on. Which is inefficient :anguished: |
| # |
May 5th 2021, 16:04 |
kevin.pfeifer |
https://dbdocs.io/LordSimal/Alfred |
| # |
May 5th 2021, 16:04 |
kevin.pfeifer |
you can even generate something like this |
| # |
May 5th 2021, 16:04 |
kevin.pfeifer |
its really nice to adjust and add new things |
| # |
May 5th 2021, 16:04 |
kevin.pfeifer |
and after you have it |
| # |
May 5th 2021, 16:04 |
kevin.pfeifer |
but i really like it |
| # |
May 5th 2021, 16:04 |
me1367 |
yikes |
| # |
May 5th 2021, 16:03 |
kevin.pfeifer |
so i had to manually transform my 60 tables which was...... fun |
| # |
May 5th 2021, 16:03 |
me1367 |
:P |
| # |
May 5th 2021, 16:03 |
kevin.pfeifer |
but nah, it was really working for me |
| # |
May 5th 2021, 16:03 |
kevin.pfeifer |
which "should" let you generate SQL => DBML |
| # |
May 5th 2021, 16:02 |
kevin.pfeifer |
i can tell you there is a tool |
| # |
May 5th 2021, 16:02 |
me1367 |
yea. Atleast the syntax looks nice and similar-ish. It's not like some completely arbitrary language that only starts to make sense when you work with it for a while. |
| # |
May 5th 2021, 16:02 |
kevin.pfeifer |
their query language is called DBML https://www.dbml.org/home/ |
| # |
May 5th 2021, 16:02 |
kevin.pfeifer |
as you see, thats not really SQL |
| # |
May 5th 2021, 16:01 |
slackebot |
"created" datetime [default: `current_timestamp()`] "modified" datetime [default: `current_timestamp()`] } Ref: dns_records.dns_domain_id > dns_domains.id Ref: dns_records.dns_subdomain_id > dns_subdomains.id Ref: dns_records.dns_type_id > dns_types.id``` |
| # |
May 5th 2021, 16:01 |
slackebot |
[not null] "created" datetime [default: `current_timestamp()`] "modified" datetime [default: `current_timestamp()`] } Table "dns_subdomains" { "id" int(10) [pk, not null] "name" varchar(255) [not null] "created" datetime [default: `current_timestamp()`] "modified" datetime [default: `current_timestamp()`] } Table "dns_types" { "id" int(10) [pk, not null] "name" varchar(255) [not null] "php_ident" int(11) [not null] |
| # |
May 5th 2021, 16:01 |
kevin.pfeifer |
```Table "dns_domains" { "id" int(10) [pk, not null] "name" varchar(255) [not null] "created" datetime [default: `current_timestamp()`] "modified" datetime [default: `current_timestamp()`] } Table "dns_records" { "id" int(10) [pk, not null] "dns_domain_id" int(10) [not null] "dns_subdomain_id" int(10) [not null] "dns_type_id" int(10) [not null] "record" text [default: NULL] "bundle_ident" int(10) |
| # |
May 5th 2021, 16:01 |
me1367 |
ahhh. That's a bummer but well, if it's only a few simple clicks to generate the SQL? Eh, that's acceptable. |
| # |
May 5th 2021, 16:00 |
kevin.pfeifer |
but you can't put SQL in there and it looks like that |
| # |
May 5th 2021, 16:00 |
kevin.pfeifer |
well yeah you can generate SQL from their own Query Language |
| # |
May 5th 2021, 16:00 |
me1367 |
That's odd since it does claim so... |
| # |
May 5th 2021, 15:59 |
kevin.pfeifer |
but the conversion isn't that bad |
| # |
May 5th 2021, 15:59 |
kevin.pfeifer |
unfortunately its not directly compatible with SQL and needs its own language |
| # |
May 5th 2021, 15:59 |
me1367 |
Thanks : > |
| # |
May 5th 2021, 15:58 |
kevin.pfeifer |
https://dbdiagram.io/home |
| # |
May 5th 2021, 15:58 |
kevin.pfeifer |
sure |
| # |
May 5th 2021, 15:58 |
me1367 |
We have progress <3 |
| # |
May 5th 2021, 15:58 |
kevin.pfeifer |
:) |
| # |
May 5th 2021, 15:58 |
me1367 |
May I ask what software you're using for that? |
| # |
May 5th 2021, 15:53 |
kevin.pfeifer |
did you create all your files with `bin/cake bake all tablename`? |
| # |
May 5th 2021, 15:51 |
kevin.pfeifer |
well if you have more data you need to store in that junction table then the id is need anyways |
| # |
May 5th 2021, 15:50 |
kevin.pfeifer |
:) |
| # |
May 5th 2021, 15:49 |
devito |
feels dirty not doing it the “right way” |
| # |
May 5th 2021, 15:48 |
kevin.pfeifer |
sure you can do it like that as well |