diff options
| author | Frederick Muriuki Muriithi | 2023-10-18 12:05:17 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2023-10-18 12:05:17 +0300 |
| commit | 5bd8b593ff1136bd76b8dc132a39d9ed3458b187 (patch) | |
| tree | 306ee90ca4e77366ac8e2818030863100b0ee756 | |
| parent | 1d3f877aadcf89f82746e4dccc8d8cf767928419 (diff) | |
| download | gn-uploader-5bd8b593ff1136bd76b8dc132a39d9ed3458b187.tar.gz | |
Explicitly specify columns
Due to possible schema differences between local small db on development computer and those on CI/CD and Production, explicitly specify the columns being operated on by the queries.
| -rw-r--r-- | qc_app/dbinsert.py | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/qc_app/dbinsert.py b/qc_app/dbinsert.py index e9dc3ff..df9a9fd 100644 --- a/qc_app/dbinsert.py +++ b/qc_app/dbinsert.py @@ -193,7 +193,9 @@ def create_study(): datetime.now().date().strftime("%Y-%m-%d"), form["inbredsetid"]) query = ( - "INSERT INTO ProbeFreeze() " + "INSERT INTO ProbeFreeze(" + "Id, ProbeFreezeId, ChipId, TissueId, Name, FullName, " + "ShortName, CreateTime, InbredSetId) " "VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s)") cursor.execute(query, values) flash("Study created successfully", "alert-success") @@ -291,7 +293,11 @@ def create_dataset(): form["datasetpublic"], form["datasetconfidentiality"], form["datasetdatascale"]) query = ( - "INSERT INTO ProbeSetFreeze VALUES" + "INSERT INTO ProbeSetFreeze(" + "Id, ProbeFreezeId, AvgID, Name, Name2, FullName, " + "ShortName, CreateTime, OrderList, public, " + "confidentiality, AuthorisedUsers, DataScale) " + "VALUES" "(%s, %s, %s, %s, %s, %s, %s, %s, NULL, %s, %s, NULL, %s)") cursor.execute(query, values) return render_template( |