def upgrade(migrate_engine):
meta = MetaData(bind=migrate_engine)
table = Table('user', meta, autoload=True)
col = Column('optional_attributes',
MutationDict.as_mutable(JSONEncodedDict))
col.create(table)
Column('reset_code', Unicode(255), nullable=True, unique=False),
Column('password', Unicode(80), nullable=True),
Column('locale', Unicode(10), nullable=True),
Column('create_time', DateTime, default=datetime.utcnow),
Column('access_time', DateTime, default=datetime.utcnow,
onupdate=datetime.utcnow),
Column('delete_time', DateTime),
Column('banned', Boolean, default=False),
Column('no_help', Boolean, default=False, nullable=True),
Column('page_size', Integer, default=10, nullable=True),
Column('proposal_sort_order', Unicode(50), default=None, nullable=True),
Column('gender', Unicode(1), default=None),
Column('_is_organization', Boolean, default=False),
Column('email_messages', Boolean, default=True),
Column('welcome_code', Unicode(255), nullable=True),
Column('optional_attributes', MutationDict.as_mutable(JSONEncodedDict)),
)
class User(meta.Indexable):
IMPORT_MARKER = 'i__'
def __init__(self, user_name, email, password, locale, display_name=None,
bio=None):
self.user_name = user_name
self.email = email
self.password = password
self.locale = locale
self.display_name = display_name
self.bio = bio
Column('locale', Unicode(10), nullable=True),
Column('create_time', DateTime, default=datetime.utcnow),
Column('access_time',
DateTime,
default=datetime.utcnow,
onupdate=datetime.utcnow),
Column('delete_time', DateTime),
Column('banned', Boolean, default=False),
Column('no_help', Boolean, default=False, nullable=True),
Column('page_size', Integer, default=10, nullable=True),
Column('proposal_sort_order', Unicode(50), default=None, nullable=True),
Column('gender', Unicode(1), default=None),
Column('_is_organization', Boolean, default=False),
Column('email_messages', Boolean, default=True),
Column('welcome_code', Unicode(255), nullable=True),
Column('optional_attributes', MutationDict.as_mutable(JSONEncodedDict)),
)
class User(meta.Indexable):
IMPORT_MARKER = 'i__'
def __init__(self,
user_name,
email,
password,
locale,
display_name=None,
bio=None):
self.user_name = user_name
