Mercurial > repos > tduigou > save_to_db
diff verification.py @ 0:034686b5bc15 draft
planemo upload for repository https://github.com/brsynth commit 6ae809b563b40bcdb6be2e74fe2a84ddad5484ae
| author | tduigou |
|---|---|
| date | Thu, 24 Apr 2025 09:56:36 +0000 |
| parents | |
| children | 6854ac8c5d2b |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/verification.py Thu Apr 24 09:56:36 2025 +0000 @@ -0,0 +1,20 @@ +from sqlalchemy import create_engine, text + +db_uri = "postgresql://postgres:RK17@localhost:5432/test_fragments_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) \ No newline at end of file
