| # |
Jul 22nd 2021, 15:00 |
 tyler.adam.lazenby |
Thanks @dereuromark I will have to go back the white board and figure out my logic. again |
| # |
Jul 22nd 2021, 13:23 |
paolo.bragagni |
I know I know but I need it. I'll do my own thanks. |
| # |
Jul 22nd 2021, 13:02 |
ndm |
That aside, that plugin is so basic, just do your own. |
| # |
Jul 22nd 2021, 13:00 |
ndm |
Using embedded SQL queries sounds like a terrible idea, IMHO that's a job for stored procedures and/or views. |
| # |
Jul 22nd 2021, 12:53 |
paolo.bragagni |
something similar to this https://github.com/morrislaptop/reports for cake4? |
| # |
Jul 22nd 2021, 12:17 |
paolo.bragagni |
ok thank you |
| # |
Jul 22nd 2021, 12:10 |
kevin.pfeifer |
there are many ways how you can interact with migrations |
| # |
Jul 22nd 2021, 12:10 |
dereuromark |
if you used change(), just use "migrations rollback", done |
| # |
Jul 22nd 2021, 12:10 |
kevin.pfeifer |
or use rollback https://book.cakephp.org/migrations/2/en/index.html |
| # |
Jul 22nd 2021, 12:08 |
kevin.pfeifer |
manually delete the table with SQL CLI, PHPMyAdmin or whatever DB management tool you desire |
| # |
Jul 22nd 2021, 12:07 |
paolo.bragagni |
with someting changed? |
| # |
Jul 22nd 2021, 12:04 |
paolo.bragagni |
(if I want to rerun ?) |
| # |
Jul 22nd 2021, 12:04 |
paolo.bragagni |
yes you are great |
| # |
Jul 22nd 2021, 12:01 |
paolo.bragagni |
ops not save |
| # |
Jul 22nd 2021, 12:00 |
paolo.bragagni |
something wrong in my config |
| # |
Jul 22nd 2021, 11:59 |
kevin.pfeifer |
this creates the table `checklist_types` with the columns id, name, created and modified with 3 entries |
| # |
Jul 22nd 2021, 11:59 |
paolo.bragagni |
should include checklist_types table? |
| # |
Jul 22nd 2021, 11:46 |
slackebot2 |
```bin/cake migrations migrate``` |
| # |
Jul 22nd 2021, 11:46 |
slackebot2 |
$checklist_types_table->addColumn( 'modified', 'datetime', [ 'default' => 'CURRENT_TIMESTAMP', 'null' => false, ] ); $checklist_types_table->create(); $checklist_types_table->insert( [ 'name' => 'Wordpress' ] ); $checklist_types_table->insert( [ 'name' => 'Drupal' ] ); $checklist_types_table->insert( [ 'name' => 'WooCommerce' ] ); $checklist_types_table->saveData();``` execute |
| # |
Jul 22nd 2021, 11:46 |
kevin.pfeifer |
```bin/cake bake migration MySuperMigration``` open confg/Migrations/<DATE>_MySuperMigration.php insert into `change()` function ``` $checklist_types_table = $this->table( 'checklist_types' ); $checklist_types_table->addColumn( 'name', 'string' ); $checklist_types_table->addColumn( 'created', 'datetime', [ 'default' => 'CURRENT_TIMESTAMP', 'null' => false, ] ); |
| # |
Jul 22nd 2021, 11:46 |
dereuromark |
you can execute seeds for demo data afterwards |
| # |
Jul 22nd 2021, 11:42 |
paolo.bragagni |
trying.. I'd like only to create some tables (users, roles, ..) and fill with default values.. |
| # |
Jul 22nd 2021, 11:18 |
dereuromark |
migrations? |
| # |
Jul 22nd 2021, 11:02 |
paolo.bragagni |
what is the cakephp 4 corresponding to 'cake schema' ? I'd like to insert some tables in default DB |
| # |
Jul 22nd 2021, 10:25 |
paolo.bragagni |
thanks! |
| # |
Jul 22nd 2021, 08:54 |
paolo.bragagni |
(thanks ndm) |
| # |
Jul 22nd 2021, 08:53 |
paolo.bragagni |
probably is only a theme problem |
| # |
Jul 22nd 2021, 08:45 |
ndm |
Sure, but select2 already supports that, hence your question was unclear. |
| # |
Jul 22nd 2021, 08:36 |
paolo.bragagni |
if I erroneusly select something and I want to clear it |
| # |
Jul 22nd 2021, 07:58 |
paolo.bragagni |
so probably is only a bug in Select2 bootstrap theme |
| # |
Jul 22nd 2021, 07:58 |
paolo.bragagni |
an x that 'clear' the input |
| # |
Jul 22nd 2021, 07:58 |
paolo.bragagni |
|
| # |
Jul 22nd 2021, 07:57 |
paolo.bragagni |
if I remove that I see this |
| # |
Jul 22nd 2021, 07:57 |
paolo.bragagni |
humm probably it is the 'bootstrap4' theme |
| # |
Jul 22nd 2021, 07:55 |
ndm |
@paolo.bragagni Why would the "empty" entry stay once you've made a selection? |
| # |
Jul 22nd 2021, 07:45 |
ndm |
@dpaleria Debug your values to figure what exactly they look like (`debug($id); debug($params);`), it's very likely not a type issue, but the value that you are passing is not numeric. |
| # |
Jul 22nd 2021, 07:44 |
paolo.bragagni |
no more 'Vuoto' (Empty) |
| # |
Jul 22nd 2021, 07:44 |
paolo.bragagni |
|
| # |
Jul 22nd 2021, 07:43 |
paolo.bragagni |
it shows, but if I enter something it disappares |
| # |
Jul 22nd 2021, 07:43 |
paolo.bragagni |
when it is Empty (Vuoto) |
| # |
Jul 22nd 2021, 07:40 |
ndm |
@val There's no dedicated method for it, but you can append the existing order to your input and then overwrite the order, like: ```$query->order( ['field' => 'ASC', $query->clause('order')], true );``` |