本文整理汇总了Python中sys2do.model.DBSession.connection方法的典型用法代码示例。如果您正苦于以下问题:Python DBSession.connection方法的具体用法?Python DBSession.connection怎么用?Python DBSession.connection使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类sys2do.model.DBSession
的用法示例。
在下文中一共展示了DBSession.connection方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: init
# 需要导入模块: from sys2do.model import DBSession [as 别名]
# 或者: from sys2do.model.DBSession import connection [as 别名]
#.........这里部分代码省略.........
DBSession.add_all([payment1, payment2, payment3])
DBSession.add(Ratio(type = "QTY", value = 10))
DBSession.add(Ratio(type = "VOL", value = 0.33))
DBSession.add(Ratio(type = "WEIGHT", value = 0.5))
DBSession.add(PickupType(name = u"自提"))
DBSession.add(PickupType(name = u"送货"))
DBSession.add(PickupType(name = u"司机直送"))
DBSession.add(PickupType(name = u"送货上门"))
DBSession.add(PickupType(name = u"送货上楼"))
DBSession.add(PackType(name = u"纸箱"))
DBSession.add(PackType(name = u"袋装"))
DBSession.add(PackType(name = u"桶装"))
DBSession.add(PackType(name = u"林架"))
DBSession.add(Item(name = u"五金"))
DBSession.add(Item(name = u"食品"))
DBSession.add(Item(name = u"器材"))
DBSession.add(Item(name = u"木料"))
DBSession.add(Item(name = u"器具"))
DBSession.add(Item(name = u"家具"))
print 'insert diqu'
province_f = open('sys2do/sql/master_province.sql')
province_sql = "".join(province_f.readlines())
province_f.close()
city_f = open('sys2do/sql/master_city.sql')
city_sql = "".join(city_f.readlines())
city_f.close()
conn = DBSession.connection()
conn.execute(province_sql)
conn.execute(city_sql)
DBSession.commit()
receiver1 = Receiver(code = u'粤BIP092', name = u'黄司机', tel = None, mobile = '15976884544',)
receiver2 = Receiver(code = u'粤BQ4225', name = '叶司机', tel = None, mobile = '13682553458',)
receiver3 = Receiver(code = u'粤BJU706', name = u'张司机', tel = None, mobile = '15813808186',)
receiver4 = Receiver(code = u'粤BJX667', name = u'李司机', tel = None, mobile = '13590435287',)
receiver5 = Receiver(code = u'粤BPY286', name = u'杨司机', tel = None, mobile = '13554881765',)
receiver6 = Receiver(code = u'粤BVQ582', name = u'杨司机', tel = None, mobile = '13724255912',)
receiver7 = Receiver(code = u'粤B2X846', name = u'巍司机', tel = None, mobile = '13410189026',)
DBSession.add_all([receiver1, receiver2, receiver3, receiver4, receiver5, receiver6, receiver7])
note1 = Note(code = '0001191-1', name = u'坚朗', province_id = 19, city_id = 290, apply_person_id = 1, apply_time = '2012-08-23',
begin_no = '1188000', end_no = '1188599', remark = u'坚朗专用二本')
note2 = Note(code = '1001191-1', name = u'味千', province_id = 19, city_id = 290, apply_person_id = 1, apply_time = '2012-08-23',
begin_no = '2188000', end_no = '2188599', remark = u'味千专用一本')
DBSession.add_all([
note1,
])
kinlong = Customer(name = u"广东坚朗五金制品股份有限公司", display_name = u'坚朗', province_id = 19, city_id = 304,
address = u"塘厦镇大坪村工业区卢地坑路3号", phone = "0769-82166666", contact_person = u'陈先生',
mobile = '12800138999', note = note1)