On Sat, 18 Feb 2017 16:31:28 -0800 (PST), Paul Henry wrote:
I have a libreoffice database consisting of 104 tables and the
developed
relationships. I would like to use these tables in sqlalchemy but
cannot
find any way to do this. I have the original csv files for the tables
but
do not really want to take a step back. Is there away to get the odb
files
into sqlalchemy?
It depends on the version of libreoffice.
in version 5.x, the odb file is actually a compressed backup of a
Firebird 3.x database.
0. install firebird-3 and fdb
1. unzip the odb
2. run gbak to restore the database
3. use the fdb driver with sqlalchemy
I use firebird-3 + sqlalchemy-1.0.x, together with some small patches
to sqlalchemy, in order to support some new features of firebird-3
I submitted these patches to the list last year.
Regards. Treeve
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.