Python create_view_min_biblioの例

コード例 #1

def setup_postgres_for_unittests(db, app):

    if not "localhost" in app.config["SQLALCHEMY_DATABASE_URI"]:
        assert (
            False
        ), "Not running this unittest because SQLALCHEMY_DATABASE_URI is not on localhost"

    result = db.session.execute(
        "drop view if exists doaj_issn_lookup; drop table if exists doaj cascade"
    )
    db.session.commit()

    drop_everything(db, app)

    db.create_all()

    from totalimpact import extra_schema
    extra_schema.create_view_min_biblio()
    extra_schema.create_doaj_table()
    extra_schema.create_doaj_view()

    doaj_setup_sql = """
        INSERT INTO doaj(title, publisher, issn, eissn, "cc license") VALUES ('ZooKeys', 'Pensoft Publishers', '1313-2989', '1313-2970', 'by');
        INSERT INTO doaj(title, publisher, issn, eissn, "cc license") VALUES ('PLOS comp bio', 'PLOS', '1553-7358', '', 'by');
    """
    raw_sql = text(doaj_setup_sql)
    result = db.session.execute(raw_sql)
    return db

コード例 #2

ファイル: utils.py プロジェクト: dbeucke/total-impact-core

def setup_postgres_for_unittests(db, app):
    if not "localhost" in app.config["SQLALCHEMY_DATABASE_URI"]:
        assert(False), "Not running this unittest because SQLALCHEMY_DATABASE_URI is not on localhost"

    drop_everything(db, app)
    db.create_all()

    from totalimpact import extra_schema 
    extra_schema.create_view_min_biblio()

    return db

コード例 #3

def setup_postgres_for_unittests(db, app):
    if not "localhost" in app.config["SQLALCHEMY_DATABASE_URI"]:
        assert (
            False
        ), "Not running this unittest because SQLALCHEMY_DATABASE_URI is not on localhost"

    drop_everything(db, app)
    db.create_all()

    from totalimpact import extra_schema
    extra_schema.create_view_min_biblio()

    return db

コード例 #4

ファイル: utils.py プロジェクト: Impactstory/total-impact-core

def setup_postgres_for_unittests(db, app):

    if not "localhost" in app.config["SQLALCHEMY_DATABASE_URI"]:
        assert(False), "Not running this unittest because SQLALCHEMY_DATABASE_URI is not on localhost"

    result = db.session.execute("drop view if exists doaj_issn_lookup; drop table if exists doaj cascade")
    db.session.commit()

    drop_everything(db, app)

    db.create_all()

    from totalimpact import extra_schema 
    extra_schema.create_view_min_biblio()
    extra_schema.create_doaj_table()
    extra_schema.create_doaj_view()

    doaj_setup_sql = """
        INSERT INTO doaj(title, publisher, issn, eissn, "cc license") VALUES ('ZooKeys', 'Pensoft Publishers', '1313-2989', '1313-2970', 'by');
        INSERT INTO doaj(title, publisher, issn, eissn, "cc license") VALUES ('PLOS comp bio', 'PLOS', '1553-7358', '', 'by');
    """
    raw_sql = text(doaj_setup_sql)
    result = db.session.execute(raw_sql)
    return db