odoorpc.db

Provide the DB class to manage the server databases.

class odoorpc.db.DB(odoo)

The DB class represents the database management service. It provides functionalities such as list, create, drop, dump and restore databases.

Note

This service have to be used through the odoorpc.ODOO.db property.

>>> import odoorpc
>>> odoo = odoorpc.ODOO('localhost')    
>>> odoo.db
<odoorpc.db.DB object at 0x...>

change_password(password, new_password)

Change the administrator password by new_password.

>>> odoo.db.change_password('super_admin_passwd', 'new_admin_passwd') 

The super administrator password is required to perform this method.

Python 2:

Raise

odoorpc.error.RPCError (access denied)

Raise

urllib2.URLError (connection error)

Python 3:

Raise

odoorpc.error.RPCError (access denied)

Raise

urllib.error.URLError (connection error)

create(password, db, demo=False, lang='en_US', admin_password='admin')

Request the server to create a new database named db which will have admin_password as administrator password and localized with the lang parameter. You have to set the flag demo to True in order to insert demonstration data.

>>> odoo.db.create('super_admin_passwd', 'prod', False, 'fr_FR', 'my_admin_passwd') 

If you get a timeout error, increase this one before performing the request:

>>> timeout_backup = odoo.config['timeout']
>>> odoo.config['timeout'] = 600    # Timeout set to 10 minutes
>>> odoo.db.create('super_admin_passwd', 'prod', False, 'fr_FR', 'my_admin_passwd') 
>>> odoo.config['timeout'] = timeout_backup

The super administrator password is required to perform this method.

Python 2:

Raise

odoorpc.error.RPCError (access denied)

Raise

urllib2.URLError (connection error)

Python 3:

Raise

odoorpc.error.RPCError (access denied)

Raise

urllib.error.URLError (connection error)

drop(password, db)

Drop the db database. Returns True if the database was removed, False otherwise (database did not exist):

>>> odoo.db.drop('super_admin_passwd', 'test') 
True

The super administrator password is required to perform this method.

Python 2:

Returns

True or False

Raise

odoorpc.error.RPCError (access denied)

Raise

urllib2.URLError (connection error)

Python 3:

Returns

True or False

Raise

odoorpc.error.RPCError (access denied)

Raise

urllib.error.URLError (connection error)

dump(password, db, format_='zip')

Backup the db database. Returns the dump as a binary ZIP file containing the SQL dump file alongside the filestore directory (if any).

>>> dump = odoo.db.dump('super_admin_passwd', 'prod') 

If you get a timeout error, increase this one before performing the request:

>>> timeout_backup = odoo.config['timeout']
>>> odoo.config['timeout'] = 600    # Timeout set to 10 minutes
>>> dump = odoo.db.dump('super_admin_passwd', 'prod')   
>>> odoo.config['timeout'] = timeout_backup

Write it on the file system:

>>> with open('dump.zip', 'wb') as dump_zip:
...     dump_zip.write(dump.read())
...

You can manipulate the file with the zipfile module for instance:

>>> import zipfile
>>> zipfile.ZipFile('dump.zip').namelist()
['dump.sql',
'filestore/ef/ef2c882a36dbe90fc1e7e28d816ad1ac1464cfbb',
'filestore/dc/dcf00aacce882bbfd117c0277e514f829b4c5bf0',
 ...]

The super administrator password is required to perform this method.

Python 2:

Returns

io.BytesIO

Raise

odoorpc.error.RPCError (access denied / wrong database)

Raise

urllib2.URLError (connection error)

Python 3:

Returns

io.BytesIO

Raise

odoorpc.error.RPCError (access denied / wrong database)

Raise

urllib.error.URLError (connection error)

duplicate(password, db, new_db)

Duplicate db’ as `new_db.

>>> odoo.db.duplicate('super_admin_passwd', 'prod', 'test') 

The super administrator password is required to perform this method.

Python 2:

Raise

odoorpc.error.RPCError (access denied / wrong database)

Raise

urllib2.URLError (connection error)

Python 3:

Raise

odoorpc.error.RPCError (access denied / wrong database)

Raise

urllib.error.URLError (connection error)

list()

Return the list of the databases:

>>> odoo.db.list() 
['prod', 'test']

Python 2:

Returns

list of database names

Raise

urllib2.URLError (connection error)

Python 3:

Returns

list of database names

Raise

urllib.error.URLError (connection error)

restore(password, db, dump, copy=False)

Restore the dump database into the new db database. The dump file object can be obtained with the dump method. If copy is set to True, the restored database will have a new UUID.

>>> odoo.db.restore('super_admin_passwd', 'test', dump_file) 

If you get a timeout error, increase this one before performing the request:

>>> timeout_backup = odoo.config['timeout']
>>> odoo.config['timeout'] = 7200   # Timeout set to 2 hours
>>> odoo.db.restore('super_admin_passwd', 'test', dump_file) 
>>> odoo.config['timeout'] = timeout_backup

The super administrator password is required to perform this method.

Python 2:

Raise

odoorpc.error.RPCError (access denied / database already exists)

Raise

odoorpc.error.InternalError (dump file closed)

Raise

urllib2.URLError (connection error)

Python 3:

Raise

odoorpc.error.RPCError (access denied / database already exists)

Raise

odoorpc.error.InternalError (dump file closed)

Raise

urllib.error.URLError (connection error)