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)
