def InitSampleRegion(self):
try:
# 查找管理员帐户
admin = self.session.query(SQL.Account).filter(SQL.Account.username=='admin').first()
if admin is None:
admin = SQL.Account()
admin.username = '******'
admin.password = '******'
admin.comment = '超级管理员'
self.session.add(admin)
self.session.flush()
self.session.commit()
print admin.id
# 查找三个示范矿区
jincheng = self.session.query(SQL.MineRegion).filter(SQL.MineRegion.name=='晋城').first()
lianghuai = self.session.query(SQL.MineRegion).filter(SQL.MineRegion.name=='两淮').first()
songzao = self.session.query(SQL.MineRegion).filter(SQL.MineRegion.name=='松藻').first()
# 根据id依次初始化示范矿区的数据
self.InitSampleMine(jincheng.id, admin.id, "晋城")
self.InitSampleMine(lianghuai.id, admin.id, "两淮")
self.InitSampleMine(songzao.id, admin.id, "松藻")
except Exception, e:
print e
