def db_setup(app): session = app.db.session('relengapi') machines = [] for m in (("127.0.0.1", "host1.mozilla.org"), ("127.0.0.2", "host2.mozilla.org"), ("127.0.0.3", "host3.mozilla.org"), ("127.0.0.4", "host4.mozilla.org"), ("127.0.0.5", "host5.mozilla.org")): machines.append(Machines(ipaddress=m[0], fqdn=m[1])) session.add_all(machines) humans = [] for u in (("*****@*****.**", "*****@*****.**"), ("*****@*****.**", "*****@*****.**"), ("*****@*****.**", "*****@*****.**"), ("*****@*****.**", "*****@*****.**")): humans.append(Humans(ldap=u[0], bugzilla=u[1])) session.add_all(humans) loans = [] for l in ( # status, bug, machine, human ("ACTIVE", 1234001, machines[0], humans[0]), ("COMPLETE", 1234002, machines[1], humans[1]), ("PENDING", 1234003, machines[2], humans[2]), ("ACTIVE", 1234004, machines[3], humans[0]), ("ACTIVE", 1234005, machines[4], humans[1]), ("PENDING", 1234006, None, humans[0])): loans.append(Loans(status=l[0], bug_id=l[1], machine=l[2], human=l[3])) session.add_all(loans) # XXX History Tests # XXX ManualAction Tests # _ = (History, ManualActions) # silence pyflakes session.commit()