Availability |
Odoo Online
Odoo.sh
On Premise
|
Technical Name |
crontab_config |
License | AGPL-3 |
Website | http://www.ecosoft.co.th |
Repository | lp:ecosoft-addons/7.0 |
Schedule Backup and Restore Database (Crontab Configuration)
This module will be work internally as command line interface (for Linux only) through linux crontab to backup and restore database.
- Backup database <DB>
- Restore as database <DB>_TEST
- Update image (i.e., with test logo) to <DB>_TEST
Just install this module, and it should work. Setup schedule time as you need it. Note: Itself, can also be used as scheduler instead of normal scheduler in OpenERP (you will see this backup and restore as one example).
Features
- Add, Modify, Delete schedule
- Direct process through command line interface
Setup Procedure
Menu -> Setting/Technical/Scheduler/Crontab Configuration
Fields:
Crontab Name - name of crontab
Description - more information
Scheduling - crontab scheduling
3.1 Minute: 0-59
3.2 Hour: 0-23
3.3 Day: 1-31
3.4 Month: 1-12
3.5 Weekday: 0-6, where 0 = Sunday
Execute Directory - OpenERP's root path to be used for log file, Temp File, DB Backup File and etc (depends on type of program)
Command - command to run the program in command line interface pattern, require full path.
Active - when True, will create crontab scheduler in OS. When False will delete it.
Status
7.1 Draft
7.2 Confirmed
7.3 Cancelled
Attach File - Additional files, to be used in process (optional)
Note: crontab scheduler will be created only when State = Confirmed and Active = True
Technical Detail
Backup Database Script:
Use script, db_backup.py (written in Python)
db_backup.py -u <DBUser> -d <DBName> -p <BacKDir>Example:
'/home/buasri/workspace/ecosoft_official_addons/ecosoft-addons/crontab_config/db_backup.py' -u openerp -d TT -p '/home/buasri/workspace/openerp_tt'>>'/home/buasri/workspace/openerp_tt/crontab_oe.log'Process:
- Create backup database as <dbname>_dbbackup-YYYY-MM-DD hh:mm:ss.dmp
- Create file oe_db_last_bkup.txt to be used for restoration
Restore Database Process:
Use script, db_restore.py (written in Python)
db_restore.py -u <DBUser> -d <DBName> -p <BacKDir>-i id of crontab in OpenERP, from table crontab_config -c id of Company in OpenERP, from table res_company
Example:
'/home/buasri/workspace/ecosoft_official_addons/ecosoft-addons/crontab_config/db_restore.py' -u openerp -d TT_TEST -p '/home/buasri/workspace/openerp_tt'>>'/home/buasri/workspace/openerp_tt/crontab_oe.log'Process
- Disconnect database to be restored
- Delete database
- Create new database
- Restore it.
- Read attached logo file
- Resize logo file
- Update logo file
Please log in to comment on this module