aboutsummaryrefslogtreecommitdiff
path: root/qc_app/dbinsert.py
diff options
context:
space:
mode:
Diffstat (limited to 'qc_app/dbinsert.py')
-rw-r--r--qc_app/dbinsert.py10
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(