Scripter/Databases: Difference between revisions
(added Scripting Index) |
m (→Scripter and relational databases: SQLite added, as I may try this out) |
||
| Line 2: | Line 2: | ||
= Scripter and relational databases = | = 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. | There are no specialities with using databases in the Scribus Scripter. You could use DB as in normal standalone script or application. | ||
| Line 8: | Line 10: | ||
There are various [http://www.python.org/topics/database/modules.html modules] for database access. | There are various [http://www.python.org/topics/database/modules.html modules] for database access. | ||
Remember that the module '''must be''' | Remember that the module '''must be''' installed in/with the Python version which is used/compiled in Scribus! | ||
I've tested personaly with 100% success: DCOracle2 and | |||
I've tested personaly with 100% success: DCOracle2 and MySQL | |||
For standard use cases one may try SQLite ([http://wiki.python.org/moin/SQLite Python DBDriver], [http://www.sqlite.org/about.html 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. | 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. | You'll need to set right connection parameters in the script file. | ||
Revision as of 13:31, 22 June 2011
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.
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!
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.