def test_db():
# INSERT
if not session.query(exists().where(User.email == '*****@*****.**')).scalar():
u1 = User()
u1.name = "Test user"
u1.email = "*****@*****.**"
a1 = Address()
a1.street = "Str 123"
a1.city = "City WTF"
u1.address = a1
session.add(a1)
session.add(u1)
session.commit()
# check if record exists in db:
# print session.query(Address).filter_by(city='City WTF').count()
# print bool( session.query(Address).filter_by(city='City WTF').count() )
# SELECT
if session.query(exists().where(Address.city == 'City WTF')).scalar():
a2 = session.query(Address).filter_by(city='City WTF').first()
print a2.city
if bool(session.query(Address).filter_by(city='City WTF').count()):
a2 = session.query(Address).filter_by(city='City WTF').first()
print a2.city
# UPDATE
if session.query(exists().where(User.email == '*****@*****.**')).scalar():
session.query(User).filter_by(email='*****@*****.**').update({"nick": "a"})
session.commit()
if session.query(exists().where(User.email == '*****@*****.**')).scalar():
u = session.query(User).filter_by(email='*****@*****.**').first()
u.nick = "b"
session.commit()
# DELETE
if session.query(exists().where(User.email == '*****@*****.**')).scalar():
session.query(User).filter_by(email='*****@*****.**').delete()
session.commit()
if session.query(exists().where(Address.city == 'City WTF')).scalar():
session.query(Address).filter_by(city='City WTF').delete()
session.commit()
def post(self):
user = users.get_current_user()
if not user:
return self.redirect('/admin/index')
formList = [
'name', 'nickname', 'email', 'age', 'sex', 'postCode', 'address',
'telFirst', 'telSecond', 'telThird', 'corporateFlg', 'corporate',
'delegate', 'chargePerson', 'capital', 'mapflg', 'recital'
]
formData = {}
for list in formList:
formData[list] = self.request.get(list)
data = User()
try:
if len(formData['name']) == 0:
raise NameError
data.name = formData['name']
if len(formData['nickname']) == 0:
raise NicknameNameError
data.nickname = formData['nickname']
data.email = formData['email']
data.age = int(formData['age'])
data.sex = int(formData['sex'])
data.post_code = formData['postCode']
data.address = formData['address']
data.telFirst = formData['telFirst']
data.telSecond = formData['telSecond']
data.telThird = formData['telThird']
data.corporateFlg = int(formData['corporateFlg'])
data.delegate = formData['delegate']
data.chargePerson = formData['chargePerson']
data.capital = int(formData['capital'])
data.corporate = formData['corporate']
data.mapflg = int(formData['mapflg'])
data.recital = formData['recital']
data.put()
fpath = os.path.join(os.path.dirname(__file__),
'template/admin/user', 'insertend.html')
html = template.render(fpath, '')
self.response.out.write(html)
except:
self.errorFunc()
