from sqlalchemy.engine.url import URL
from elixir import Unicode, DateTime, String, Integer, UnicodeText, Text, Boolean, Float
from elixir import Entity, Field, using_options, using_table_options
from elixir import OneToMany, ManyToOne, ManyToMany, OneToOne
from elixir import setup_all, entities, create_all
from elixir.options import using_table_options_handler #using_table_options() can only work inside Entity-inherited class.
from sqlalchemy import UniqueConstraint, create_engine
from sqlalchemy.schema import ThreadLocalMetaData
from sqlalchemy.orm import scoped_session, sessionmaker
from datetime import datetime
from pymodule.db import ElixirDB
__session__ = scoped_session(sessionmaker(autoflush=False, autocommit=True))
__metadata__ = ThreadLocalMetaData()
class README(Entity):
#2008-08-07
title = Field(String(2000))
description = Field(String(60000))
created_by = Field(String(128))
updated_by = Field(String(128))
date_created = Field(DateTime, default=datetime.now)
date_updated = Field(DateTime)
using_options(tablename='readme',
metadata=__metadata__,
session=__session__)
using_table_options(mysql_engine='InnoDB')
# -*- coding: utf-8 -*- from sqlalchemy import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import scoped_session, sessionmaker from sqlalchemy.pool import NullPool from sqlalchemy.schema import ThreadLocalMetaData from settings import SQLALCHEMY engine = create_engine(SQLALCHEMY, convert_unicode=True, echo=False, poolclass=NullPool, strategy='threadlocal') base = declarative_base(bind=engine, metadata=ThreadLocalMetaData()) session = scoped_session(sessionmaker(autocommit=False, autoflush=False, bind=engine, expire_on_commit=True))
# -*- coding: utf-8 -*-
from contextlib import closing
from datetime import timedelta, date
from bcrypt import hashpw, gensalt
from flask import current_app
from itsdangerous import TimedJSONWebSignatureSerializer
from sqlalchemy import Column, String
from sqlalchemy.ext.declarative import declarative_base, DeferredReflection
from sqlalchemy.orm import backref, relationship
from sqlalchemy.schema import ThreadLocalMetaData
base = declarative_base(cls=DeferredReflection, metadata=ThreadLocalMetaData())
class user(base):
__tablename__ = 'users'
password_ = Column('password', String(length=255), nullable=False)
@property
def password(self):
return self.password_
@password.setter
def password(self, value):
self.password_ = hashpw(value.encode('utf-8'), gensalt(10))
# The token TTL is 86,400 seconds (1 day).
def get_token(self, expires_in=86400):
if isinstance(d[column.name], date):
d[column.name] = d[column.name].isoformat()
return d
mysql = {}
mysql['engine'] = create_engine(
URL(**dictionary['MYSQL']),
convert_unicode=True,
echo=False,
pool_recycle=15,
pool_size=25,
pool_timeout=15,
strategy='threadlocal',
)
mysql['base'] = declarative_base(
bind=mysql['engine'], metadata=ThreadLocalMetaData()
)
mysql['base'].to_dictionary = to_dictionary
mysql['session'] = scoped_session(sessionmaker(
autocommit=False,
autoflush=False,
bind=mysql['engine'],
expire_on_commit=True
))
postgresql = {}
postgresql['engine'] = create_engine(
URL(**dictionary['POSTGRESQL']),
convert_unicode=True,
echo=False,
pool_recycle=15,