On Mar 27, 2008, at 12:51 AM, Vsevolod Balashov wrote: > - python code for trigger emulation (like SQLAlchemy or ActiveRecord > bad > practice)
if you're referring to SQLAlchemy's ability to specify a "default value" for an INSERT or UPDATE, this can optionally be an in-python function to provide capabilities which the database itself does not provide. This is an entirely appropriate practice and is needed for databases that either do not have good default/trigger support (for example, you cannot use a function for a DEFAULT on SQLite or MySQL) or where the value cannot be generated by the database itself, such as GUIDs and others. Here's Hibernate doing it for a JVM-originated timestamp, for example (where they also give you the option of interpreter or DB-generated values): http://www.hibernate.org/hib_docs/v3/reference/en/html/mapping.html#mapping-declaration-timestamp Otherwise SA has no kind of "trigger emulation" I can think of, and we integrate extremely well with (and encourage the use of) database- originated events including triggers, DDL level defaults, and ON UPDATE/DELETE cascades. -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
