Mercurial > repos > tduigou > seq_to_db
view verification.py @ 0:9f845ccb1a9f draft
planemo upload for repository https://github.com/brsynth/galaxytools/tree/main/tools commit 3401816c949b538bd9c67e61cbe92badff6a4007-dirty
| author | tduigou |
|---|---|
| date | Wed, 11 Jun 2025 13:36:44 +0000 |
| parents | |
| children |
line wrap: on
line source
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)
