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