view verification.py @ 1:6854ac8c5d2b draft

planemo upload for repository https://github.com/brsynth commit 6ae809b563b40bcdb6be2e74fe2a84ddad5484ae

from sqlalchemy import create_engine, text

db_uri = "postgresql://postgres:RK17@localhost:5432/test_fragments_db" #adapt with your URI's DB
engine = create_engine(db_uri)

with engine.connect() as conn:
    result = conn.execute(text("""
        SELECT fragment, sequence, annotation
        FROM sample
        ORDER BY fragment
    """))

    print("Full contents of fragments in DB:\n")
    for row in result:
        print(f" Fragment: {row.fragment}")
        print(" Sequence:")
        print(row.sequence)
        print("\n Annotation:")
        print(row.annotation)
        print("-" * 80)