Dump DDL with selective data
已回答
Hi!
I wonder if it's possible to dump DDL (which I know how to do from PHPStorm) while also dumping data for some of the tables? I have a bunch of tables, that are kind of like "definitions", and I would prefer to have data from them in the same DDL files as, well, DDL themselves. But I do not see a way to do this (semi-)automatically in PHPStorm.
Any advice how to do this?
Thank you.
请先登录再写评论。
It's not possible to store data in DDL data sources.
It is better to use "export data" option to store data: https://www.jetbrains.com/help/datagrip/export-data-in-ide.html
Is there a way to automate it somehow on IDE side?
What do you mean? Call export action after "Create DDL" action automatically?
Macro could be useful here: https://stackoverflow.com/a/32949699/8203759
Yeah, that's what I meant. I guess a macro could work for me. Thank for the info.