[Product-Developers] MS SQL push to Zope
lists at zopyx.com
Thu Feb 18 06:07:03 UTC 2010
-----BEGIN PGP SIGNED MESSAGE-----
msmith64 at naz.edu wrote:
> We have Ad Astra (an enterprise calendaring system) running off an
> MS SQL Server db. When a user marks an event in Astra as "featured"
> we're supposed to create a copy of that event in Plone as an Event
> instance. The Astra DB is large and busy enough that I don't want
> to execute unnecessary queries against it. In order to avoid
> polling, I would prefer to push the data from MSSQL on a trigger,
> but I only know how to write triggers that execute SQL on an ODBC
> OK, so down to brass tacks: 1. If SQL were the only option, is
> there any way to translate SQL into something Zope can understand?
> (Like a reverse-ORM, if you will) 2. If a simple SQL push is not an
> option, how might you suggest going about this? (keeping in mind
> the need to have as few MS SQL connections and queries as
That's a pretty strange and weird idea. Put your data into the RDBMS
and let Zope pull out new information
itself out of the database ...that's the way to go.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 330 bytes
Desc: not available
More information about the Product-Developers