sitepush icon indicating copy to clipboard operation
sitepush copied to clipboard

Tables to ignore pushing for live sites

Open Thanatermesis opened this issue 12 years ago • 4 comments

I dont know if Custom Tables is for something similar (the description is not very clear) but could be nice to have the possibility to list the tables to ignore when pushing to the live systems, live sites are the public ones with different purposes than the dev ones, for example, you dont' want to overwrite comments or newsletter databases/configs, never, not even when "importing entire database" is selected.

Thanatermesis avatar Sep 01 '13 14:09 Thanatermesis

Custom tables is for adding the ability to push custom tables, not removing the option to push tables. I'll look into adding the ability to omit things in a future release.

rowatt avatar Sep 02 '13 18:09 rowatt

Thanks, I have tested the new features in the updated version, the disabled options of sitepush is pretty nice :), the only problem now is the want/need to push the entire database with ignoring some tables (like comments, etc), where of course can exist a lot of them from own or specific plugins, for example we use a plugin which does records/logs, so if we push the entire database these logs would be overwrrited, by listing them in a "tables to ignore" feature could be something very nice. Maybe something simple as this?

IF we have tables to ignore

FOR table in LIST database_tables

IF table is not in the ignore list ; PUSH table

ELSE

PUSH entire database

FI

On this way there will be never any risk to overwrite important data from live sites

Thanks

Thanatermesis avatar Sep 18 '13 21:09 Thanatermesis

Actually I have found a case for this problem:

I have just buy the amazing plugin MyMail, for newsletters, aparently this plugin saves each suscriptor in "posts" of specific type (called suscriber if im not wrong), but yes, in the _posts table as in form of post entries. I don't know why it is made on that way but this is how it works (and this plugin is really nice so i dont understand why is designed on that way)

On this case will be needed to ignore a type (property) of entries of a table, because of course, all suscribers registers and are saved in the live database, not in dev or tests

Thanatermesis avatar Sep 28 '13 22:09 Thanatermesis

I'm not sure how omitting tables from a push would help you if you are trying to avoid pushing specific rows from a table.

Unfortunately the way that SitePush currently works, omitting specific rows from a push is not possible.

rowatt avatar Sep 29 '13 12:09 rowatt