/*
* Copyright (C) 2010 Ixonos Plc.
- * Copyright (C) 2011-2017 Philipp Spitzer, gregor herrmann, Stefan Stahl
+ * Copyright (C) 2011-2024 Philipp Spitzer, gregor herrmann, Stefan Stahl
*
* This file is part of ConfClerk.
*
int Track::insert()
{
QSqlQuery query;
- query.prepare("INSERT INTO " + sTableName + " (" + CONFERENCEID + "," + NAME + ")" + " VALUES " + "(\"" + QString::number(conferenceid()) + "\",\"" + name() + "\")");
+ QString trackname = name();
+ query.prepare(
+ QString("INSERT INTO %1 (%2, %3) VALUES (:xid_conference, :name)")
+ .arg(sTableName, CONFERENCEID, NAME));
+ query.bindValue(":xid_conference", conferenceid());
+ query.bindValue(":name", trackname);
if (!query.exec())
{
- throw TrackInsertException("Exec Error");
+ throw TrackInsertException(
+ "Inserting track '" + trackname + "' into database failed: " +
+ query.lastError().text());
}
QVariant variant = query.lastInsertId();
if (variant.isValid())