From 55636242fb42009fac80656ad5106ad2717bcd75 Mon Sep 17 00:00:00 2001 From: pepperpepperpepper Date: Tue, 6 Oct 2015 20:02:47 -0700 Subject: added some new scripts --- dumpfm/out.py | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 dumpfm/out.py (limited to 'dumpfm/out.py') diff --git a/dumpfm/out.py b/dumpfm/out.py new file mode 100644 index 0000000..32e805e --- /dev/null +++ b/dumpfm/out.py @@ -0,0 +1,23 @@ +# -*- coding: utf-8 -*- +## File autogenerated by SQLAutoCode +## see http://code.google.com/p/sqlautocode/ + +from sqlalchemy import * +from sqlalchemy.dialects.postgresql import * + +metadata = MetaData() +messages = Table('messages', metadata,*[ + Column('message_id', INTEGER(), primary_key=True, nullable=False, default=text(u'nextval(\'"public".messages_message_id_seq\'::regclass)')), + Column('user_id', INTEGER(), primary_key=False, nullable=False), + Column('room_id', INTEGER(), primary_key=False, nullable=False), + Column('content', TEXT(), primary_key=False, nullable=False), + Column('created_on', TIMESTAMP(), primary_key=False, nullable=False, default=text(u'now()')), + Column('is_image', BOOLEAN(), primary_key=False), + Column('is_text', BOOLEAN(), primary_key=False, nullable=False, default=text(u'false')), + CheckConstraint('messages.is_image IN (:param_1, :param_2)'), + ForeignKeyConstraint(['user_id'], [u'public.users.user_id'], name=u'messages_user_id_fkey'), + ForeignKeyConstraint(['room_id'], [u'public.rooms.room_id'], name=u'messages_room_id_fkey'), + CheckConstraint('messages.is_text IN (:param_1, :param_2)'),]) +Index('messages_room_id_created_on_idx', messages.c.room_id, messages.c.created_on, unique=False) +Index('messages_user_created_on_image_only_idx', messages.c.user_id, messages.c.created_on, unique=False) + -- cgit v1.2.3-70-g09d2