dbsettings.cpp 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. #include "dbsettings.h"
  2. #include "dbman.cpp"
  3. /*
  4. * Settings Database Related Functions
  5. */
  6. /*!
  7. * \brief storesetting Updates a stored setting in the database
  8. * \param setting_id
  9. * \param setting_value
  10. */
  11. void dbSettings::storeSetting(int setting_id, QString setting_value)
  12. {
  13. QSqlQuery query;
  14. query.prepare("UPDATE settings "
  15. "SET setting = ? "
  16. "WHERE setting_id = ?");
  17. query.addBindValue(setting_value);
  18. query.addBindValue(setting_id);
  19. query.exec();
  20. }
  21. /*!
  22. * \brief retreiveSetting Looks up a setting in the database and returns its value
  23. * \param setting_id
  24. * \return setting value
  25. */
  26. QString dbSettings::retreiveSetting(int setting_id)
  27. {
  28. QSqlQuery query;
  29. query.prepare("SELECT setting FROM settings WHERE setting_id = ?");
  30. query.addBindValue(setting_id);
  31. query.exec();
  32. QString setting = "-1";
  33. while(query.next()){
  34. setting = query.value(0).toString();
  35. }
  36. return setting;
  37. }
  38. /*!
  39. * \brief retreiveSettingInfo Looks up a setting in the database and returns its value and description
  40. * \param setting_id
  41. * \return {setting_id, setting, description}
  42. */
  43. QVector<QString> dbSettings::retreiveSettingInfo(QString setting_id)
  44. {
  45. QSqlQuery query;
  46. query.prepare("SELECT * FROM settings WHERE setting_id = ?");
  47. query.addBindValue(setting_id);
  48. query.exec();
  49. QVector<QString> setting;
  50. while(query.next()){
  51. setting.append(query.value(0).toString());
  52. setting.append(query.value(1).toString());
  53. setting.append(query.value(2).toString());
  54. }
  55. return setting;
  56. }