view verification.py @ 3:39101f8f26dd draft default tip

planemo upload for repository https://github.com/brsynth/galaxytools/tree/main/tools commit e8c8f102cab10531ed588be4ecb8a0d01e797f09

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)