Mercurial > repos > tduigou > save_to_db
comparison verification.py @ 1:6854ac8c5d2b draft
planemo upload for repository https://github.com/brsynth commit 6ae809b563b40bcdb6be2e74fe2a84ddad5484ae
| author | tduigou |
|---|---|
| date | Thu, 24 Apr 2025 12:02:14 +0000 |
| parents | 034686b5bc15 |
| children |
comparison
equal
deleted
inserted
replaced
| 0:034686b5bc15 | 1:6854ac8c5d2b |
|---|---|
| 1 from sqlalchemy import create_engine, text | 1 from sqlalchemy import create_engine, text |
| 2 | 2 |
| 3 db_uri = "postgresql://postgres:RK17@localhost:5432/test_fragments_db" | 3 db_uri = "postgresql://postgres:RK17@localhost:5432/test_fragments_db" #adapt with your URI's DB |
| 4 engine = create_engine(db_uri) | 4 engine = create_engine(db_uri) |
| 5 | 5 |
| 6 with engine.connect() as conn: | 6 with engine.connect() as conn: |
| 7 result = conn.execute(text(""" | 7 result = conn.execute(text(""" |
| 8 SELECT fragment, sequence, annotation | 8 SELECT fragment, sequence, annotation |
