Data Import and Export #1873
Description
Checklist
- I checked other issues already and found no answer
- I checked the documentation and found no answer
- I am running the latest version and the feature i am requesting is not implemented there
Describe the problem you are trying to solve
I want to bring my data from Steve instance A to B. A and B are in different environments using different database instances.
Describe the solution you'd like
- A simple abstraction over the database tables (like a CSV)
- One file per table, all columns and rows are read
- Maybe create an archive (ZIP) of the files
- An Import and Export section on Settings page for these functionalities
Describe alternative solutions or features you've considered
mysqldump and mysql command line tools to export and import are available.
Cons:
- Low-level, requires technical knowledge
- Cannot be integrated into Steve as feature (a binary that needs to be packaged, clunky Java to console integration)
- What if end-users do not have direct access to the database of B?
Additional context
We can offer 2 options to export/import: Master data or ALL data, which includes master and historical data as depicted below:
| DB table | Master data | Historical data |
|---|---|---|
| address | ✅ | |
| certificate | ✅ | |
| charge_box | ✅ | |
| charge_box_certificate_installed | ✅ | |
| charge_box_certificate_signed | ✅ | |
| charge_box_firmware_update_event | ✅ | |
| charge_box_firmware_update_job | ✅ | |
| charge_box_log_upload_event | ✅ | |
| charge_box_log_upload_job | ✅ | |
| charge_box_security_event | ✅ | |
| charging_profile | ✅ | |
| charging_schedule_period | ✅ | |
| connector | ✅ | |
| connector_charging_profile | ✅ | |
| connector_meter_value | ✅ | |
| connector_status | ✅ | |
| ocpp_tag | ✅ | |
| reservation | ✅ | |
| schema_version | -- | -- |
| settings | ✅ | |
| transaction_start | ✅ | |
| transaction_stop | ✅ | |
| transaction_stop_failed | ✅ | |
| user | ✅ | |
| user_ocpp_tag | ✅ | |
| web_user | ✅ |
These tables represent the status quo of the database after #1854