MythTV
master
|
Go to the source code of this file.
Functions | |
MTV_PUBLIC bool | InitializeMythSchema (void) |
command to get the the initial database layout from an empty database: More... | |
MTV_PUBLIC bool | UpgradeTVDatabaseSchema (bool upgradeAllowed=false, bool upgradeIfNoUI=false, bool informSystemd=false) |
Called from outside dbcheck.cpp to update the schema. More... | |
MTV_PUBLIC DBUpdates | getRecordingExtenderDbInfo (int version) |
MTV_PUBLIC bool InitializeMythSchema | ( | void | ) |
command to get the the initial database layout from an empty database:
mysqldump \ –skip-comments –skip-opt –compact –skip-quote-names \ –create-options –ignore-table=mythconverg.schemalock mythconverg | \ sed '/^(SET|INS).*;$/d;/^\/*!40101.*$/d;s/^.*[^;]$/"&"/;s/^).*;$/"&",/'
command to get the initial data:
mysqldump \ –skip-comments –skip-opt –compact –skip-quote-names -t \ –ignore-table=mythconverg.logging mythconverg | sed -e 's/^.*$/"&",/' -e 's#\#\\#g'
don't forget to delete host specific data
Definition at line 3976 of file dbcheck.cpp.
Referenced by doUpgradeTVDatabaseSchema(), and main().
MTV_PUBLIC bool UpgradeTVDatabaseSchema | ( | const bool | upgradeAllowed, |
const bool | upgradeIfNoUI, | ||
const bool | informSystemd | ||
) |
Called from outside dbcheck.cpp to update the schema.
If the "DBSchemaVer" property equals the currentDatabase version this returns true immediately. If not, we try to do a database backup, if interactive prompt the user for permission to do the upgrade, and if permitted or non-interactive with a successful backup do the actual update.
If the program running this function is killed while this is running then the schema may be corrupted.
Definition at line 361 of file dbcheck.cpp.
Referenced by main(), and run_backend().
MTV_PUBLIC DBUpdates getRecordingExtenderDbInfo | ( | int | version | ) |
Referenced by doUpgradeTVDatabaseSchema().