s2 = StateService.add(db_users, "S2") s3 = StateService.add(db_users, "S3") u1 = UserService.add(db_users, 2013400576, "U1", "[email protected]", d1) ua1 = UserAddressService.add(db_users, a1, u1) ua2 = UserAddressService.add(db_users, a2, u1) bc = MailService.add(databases, s1, ua1, ua2) las = UserAddressService.listByUser(db_users, u1) selectedMail = MailService.selectByBarcode(databases['D1'], bc) print las print a1 print d1 print s1 print u1 print ua1 print bc print selectedMail print MailService.update(databases, bc, s2) print MailService.update(databases, bc, s3) print MailService.update(databases, bc, s1) #db1.update(Department, Department.__table__.c.idDepartment == d1.idDepartment, name = "CS") #db1.insert(UserAddress, idAddress = 1, idUser = 1) #db1.execute(db1.statement(Department, "update").where(Department.__table__.c.idDepartment == d1.idDepartment).values(name = "CS")) #db1.execute(db1.statement(UserAddress, "insert").values(idaddress = 1, iduser = 1)) #ins = db1.getStatement(UserAddress, 'insert').values(idAddress = 1, idUser = 1) #db1.execute(ins)
