[Scribus] MySQL / Python connection script question; attn: subik
Thu Jan 31 10:28:22 CET 2008
> We make the menus with OpenOffice, and I'm very attracted to Scribus
> because it's a desktop publishing app with the hook into the DB. We
> eventually plan on using postgesql as our db, but for the interim and for
> my sanity and testing purposes we will use MySQL for the sample python
> patch included with Scribus.
I have tested Scribus connecting to huge amount of databases: MySQL,
Postgresql, Oracle, and Sqlite. It's working fine.
> I would greatly appreciate an example Scribus document, DB tables, and
> script to get me started in the correct direction, or else a very detailed
> explaination. Something very simple would probably be good for me.
It's very hard to make an universal example - DB usage depends on what you
exactly want to do.
Create a basic template document with predefined styles.
Run a script in Scribus. This script will ask for date and location of the
restaurant. (Create a dialog with date entry and e.g. combobox with
Then perform SELECT * FROM menu WHERE location = :location AND active_from
>= :date etc.
Then take results in a loop and paste text into frame with predefined
Believe me, it is not so hard as it looks.
If you are looking for a complex scripts, take a Sjc's FontSampler (included
in the distribution) or CalendarWizard (included too).
There are *very* nice scripts at:
or a class-work of one of "my" student:
And you can read this article (It's about scribus and mysql propably - I
wish I can undesrand Spanish). But only if your restaurants offer burritos
of course ;)
anyway, you can always ask here.
And we are looking forward your results if you will share it later ;)
all the best
More information about the scribus