如何实现 Odoo 数据每天备份到Amazon S3存储

继承任意已有模型(例如：abc)增加如下方法
```
    @api.model
    def backup_to_s3(self):
        import os
        from datetime import datetime
        import tempfile
        import boto
        from boto.s3.key import Key
        from odoo.service import db

os.environ['S3_USE_SIGV4'] = 'True'

def _transport_backup_simple(conn, bucket_name, data, filename):
            _logger.info('Backing up via S3 simple agent')
            bucket = conn.get_bucket(bucket_name)
            k = Key(bucket)
            k.key = filename
            k.set_contents_from_string(data)
            _logger.info('Data successfully backed up to s3')

bucket_name = 'A-xxxxxxx'
        aws_access_key_id = 'B-xxxxxxxxxxxxxxxx'
        aws_secret_access_key = 'C-xxxxxxxxxxxxxxxxxxxxxx'
        conn = boto.connect_s3(aws_access_key_id, aws_secret_access_key, host='s3.D-xxxx.amazonaws.com')

db_name = self.env.cr.dbname

with tempfile.TemporaryFile() as t:
            db.dump_db(db_name, t)
            t.seek(0)
            db_dump = t.read()
            filename = "%(db_name)s_%(timestamp)s.zip" % {
                'db_name': db_name,
                'timestamp': datetime.utcnow().strftime("%Y-%m-%d_%H-%M-%SZ")
            }
            _transport_backup_simple(conn, bucket_name, db_dump, filename)
```
其中 A-xxxxxxx、B-xxxxxxxxxxxxxxxx、C-xxxxxxxxxxxxxxxxxxxxxx为S3连接信息；D-xxxx 为 S3 所在可用区名

添加Odoo Cron定时任务，设置每天凌晨n点执行，任务执行Python代码如下:
```
env['abc'].backup_to_s3()
```

Sun	Mon	Tue	Wed	Thu	Fri	Sat
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Information

Tag

March 2023

分类

官方公众号

About This Entry

About This Blog

最近发布

Friend Links