def post(self): data = urlparse.parse_qs(self.request.body) del data['_xsrf'] session = sessionLoader().session new = User() for k, v in data.iteritems(): setattr(new, k, v[0]) session.add(new) session.commit() session.close() self.write('Hello!')
__author__ = 'evgeniy' from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import * from sqlalchemy.orm import * from db_connectors import sessionLoader session = sessionLoader() engine = session.engine sc_session = session.sc_session Base = declarative_base() Base.query = sc_session.query_property() class User(Base): __tablename__ = 'Users' id = Column(Integer, primary_key=True, autoincrement=True) name = Column(String(128)) age = Column(String(128)) profession = Column(String(128)) sity = Column(String(128)) Base.metadata.create_all(bind=engine)