Scripter/Databases: Difference between revisions
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
== Example == | == Example == | ||
There is an common database example since 1.2.2 and 1.3cvs versions - see. SCRIBUSROOT/share/scribus/samples/sample_db_usage.py docstring (e.g. via ''Script/About Script...'' menu) or script content. | * There is an common database example since 1.2.2 and 1.3cvs versions - see. SCRIBUSROOT/share/scribus/samples/sample_db_usage.py docstring (e.g. via ''Script/About Script...'' menu) or script content. You'll need to set right connection parameters in the script file. | ||
* Alternatively, you can import csv data. See http://wiki.scribus.net/canvas/Import_CSV_Data | |||
Latest revision as of 13:57, 27 November 2014
Scripter and relational databases
You can use Scribus scripting to populate documents with content from a database.
There are no specialities with using databases in the Scribus Scripter. You could use DB as in normal standalone script or application.
PEP-0249 - Python database API v.2.
Python Database Module
There are various modules for database access. Remember that the module must be installed in/with the Python version which is used/compiled in Scribus!
Available Database Engines
I've tested personaly with 100% success: DCOracle2 and MySQL
For standard use cases one may try SQLite (Python DBDriver, About SQLite), a self-contained, serverless, zero-configuration, transactional SQL database engine. It may simplify your script development.
Example
- There is an common database example since 1.2.2 and 1.3cvs versions - see. SCRIBUSROOT/share/scribus/samples/sample_db_usage.py docstring (e.g. via Script/About Script... menu) or script content. You'll need to set right connection parameters in the script file.
- Alternatively, you can import csv data. See http://wiki.scribus.net/canvas/Import_CSV_Data