Eventframe and SQLAlchemy 0.8.x

[Kiran Jonnalagadda]

Hi all,

As of SQLAlchemy 0.8.x, column names cannot be reused across joined-table polymorphic models, the sort Eventframe and Nodular use.

This is the fix for a bug I reported a few months ago. If you have an old Eventframe installation from SQLAlchemy 0.7.x, your DB will be outdated. Please drop the additional columns.

I've committed a patch to Eventframe that drops these columns from NodeMixin if you are still on 0.7.x. For those migrating, run these alter statements (on PostgreSQL; dropping columns isn't supported with SQLite):

ALTER TABLE public.data DROP COLUMN created_at;

ALTER TABLE public.data DROP COLUMN updated_at;

ALTER TABLE public.event DROP COLUMN created_at;

ALTER TABLE public.event DROP COLUMN updated_at;

ALTER TABLE public.fragment DROP COLUMN created_at;

ALTER TABLE public.fragment DROP COLUMN updated_at;

ALTER TABLE public.funnel_link DROP COLUMN created_at;

ALTER TABLE public.funnel_link DROP COLUMN updated_at;

ALTER TABLE public.list DROP COLUMN created_at;

ALTER TABLE public.list DROP COLUMN updated_at;

ALTER TABLE public.map DROP COLUMN created_at;

ALTER TABLE public.map DROP COLUMN updated_at;

ALTER TABLE public.page DROP COLUMN created_at;

ALTER TABLE public.page DROP COLUMN updated_at;

ALTER TABLE public.post DROP COLUMN created_at;

ALTER TABLE public.post DROP COLUMN updated_at;

ALTER TABLE public.redirect DROP COLUMN created_at;

ALTER TABLE public.redirect DROP COLUMN updated_at;

Kiran

-- 

Kiran Jonnalagadda

+91-99452-35123

http://hasgeek.com