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)