from integresql_client_python import IntegreSQL
integresql = IntegreSQL('template_directory')
# integresql.debug = True
with integresql as tpl:
    with tpl.initialize() as dbinfo:
        # dbinfo is None if template is already initialized
        if dbinfo:
            # connect and import fixtures
            print("initialize db with fixtures with db data:", dbinfo)
    db = tpl.get_database()
    with db as dbinfo:
        # connect and do whatever you want
        print("Do your tests with db data:", dbinfo)
    # or manually, you can use as many databases as you need or IntegreSQL will allow
    dbinfo1 = db.open()
    print("Do your tests", dbinfo1)
    dbinfo2 = db.open()
    print("Do your tests", dbinfo2)
    dbinfo3 = db.open()
    print("Do your tests", dbinfo3)
    # connect and do whatever you want
    # do not forget about closing resources:
    db.close(dbinfo1)
    db.close(dbinfo2)
    db.close(dbinfo3)