Proxy command improvements

[luya-bot]

This issue has originally been reported by @nadar at luyadev/luya#1546.
Moved here by @nadar.

---

• ask to skip large tables (more then 10k entries?)
• insert data after request, instead of save them into an array and insert after sync (slow down?)
• option to skip tables
• option to skip files

[boehsermoe]

Data sync failed while truncate a table with foreign keys from other table. While the sync the foreign key check should disabled.
FOREIGN_KEY_CHECKS=0

Maybe change unique check and sql mode too?
UNIQUE_CHECKS=0
SQL_MODE='NO_AUTO_VALUE_ON_ZERO'

[nadar]

could you make an example of what you mean?

[boehsermoe]

https://tombevers.me/2013/10/14/how-to-truncate-a-foreign-key-constrained-table/

[boehsermoe]

What do you think about extend \luya\admin\proxy\ClientBuild::$optionTable with the negated sign "!" to exclude tables from the data sync?

[nadar]

So an example could be --t=cms_*,!admin_* include all cms_* tables but exclude all admin_* tables?

Maybe create a new issue, as we should keep PRs as small as possible its better to have multiple issues withs multiples PRs.

[nadar]

@boehsermoe

*****_table has 1668138 entries. Do you want continue table sync? (yes|no) [yes]:y

Works perfect :-) But i did not skip the 1'668'138 rows and the download works without reaching memory limit! Thanks

[boehsermoe]

Nice to hear! And how long the download needed?

[nadar]

still downloading :-)