try:
logger.info('Open connection to "%s:%s" on "%s" with user "%s" ' % (opts.server, opts.port, opts.dbname, opts.user))
cnx = Connection(
server=opts.server,
dbname=opts.dbname,
login=opts.user,
password=opts.passwd,
port=opts.port)
except Exception, e:
logger.error('Fail to connect to the server')
logger.error('%s' % str(e))
sys.exit(1)
model = Object(cnx, opts.model)
mod_count = model.search_count([])
logger.info('There are %d record to export' % mod_count)
fields = model.fields_get()
fields_name = fields.keys()
result = model.read(model.search([]))
from odf.opendocument import OpenDocumentSpreadsheet
from odf.style import Style, TextProperties, ParagraphProperties, TableColumnProperties
from odf.text import P
from odf.table import Table, TableColumn, TableRow, TableCell
textdoc = OpenDocumentSpreadsheet()
tablecontents = Style(name="Table Contents", family="paragraph")
tablecontents.addElement(ParagraphProperties(numberlines="false", linenumber="0"))
if opts.id:
if not model.search([('id', '=', opts.id)], 0, 1, 0, {'active_test': False}):
print 'ID %d does not exists in the database' % opts.id
sys.exit(1)
model_ids = [opts.id]
elif opts.ids:
ids = [ int(x) for x in opts.ids.replace(' ', '').split(',')]
for id in ids:
if not model.search([('id', '=', id)], 0, 1, 0, {'active_test': False}):
print 'ID %d does not exists in the database' % id
sys.exit(1)
model_ids = []
model_ids.extend(ids)
elif opts.domain:
count = model.search_count([], {'active_test': False})
model_ids = model.search(eval(opts.domain), 0, count, 0, {'active_test': False})
elif opts.inactive:
count = model.search_count([], {'active_test': False})
model_ids = model.search([], 0, count, 0, {'active_test': False})
else:
count = model.search_count([])
model_ids = model.search([], 0, count)
root = Element('openerp')
data = SubElement(root, 'data')
for m_id in model_ids:
##
# Read the current id
{'active_test': False}):
print 'ID %d does not exists in the database' % opts.id
sys.exit(1)
model_ids = [opts.id]
elif opts.ids:
ids = [int(x) for x in opts.ids.replace(' ', '').split(',')]
for id in ids:
if not model.search([('id', '=', id)], 0, 1, 0,
{'active_test': False}):
print 'ID %d does not exists in the database' % id
sys.exit(1)
model_ids = []
model_ids.extend(ids)
elif opts.domain:
count = model.search_count([], {'active_test': False})
model_ids = model.search(eval(opts.domain), 0, count, 0,
{'active_test': False})
elif opts.inactive:
count = model.search_count([], {'active_test': False})
model_ids = model.search([], 0, count, 0, {'active_test': False})
else:
count = model.search_count([])
model_ids = model.search([], 0, count)
root = Element('openerp')
data = SubElement(root, 'data')
for m_id in model_ids:
##
# Read the current id
