--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/Seafood/populateDB/main.cpp Thu Mar 25 13:55:27 2010 -0700
@@ -0,0 +1,81 @@
+#include <QtCore/QCoreApplication>
+#include <QtSql>
+
+#include "database.h"
+
+// This program is simply responsible for creating a SQLite database for the Seafood Selector
+
+void insertFish(QString name, int cat, int calories,
+ float fat, float protein, float omega3,
+ int cholesterol, int sodium)
+{
+ QSqlQuery query;
+
+ query.prepare("INSERT INTO fish (name, category, calories, fat, protein,omega3,cholesterol, sodium) "
+ "VALUES (:name,:category,:calories,:fat,:protein,:omega3,:cholesterol, :sodium) ");
+ query.bindValue(":name", name);
+ query.bindValue(":category",cat);
+ query.bindValue(":calories",calories);
+ query.bindValue(":fat",fat);
+ query.bindValue(":protein",protein);
+ query.bindValue(":omega3",omega3);
+ query.bindValue(":cholesterol",cholesterol);
+ query.bindValue(":sodium", sodium);
+ if (!query.exec())
+ {
+ qDebug() << query.lastError();
+ qFatal("Failed to add fish.");
+ }
+}
+
+int main(int argc, char *argv[])
+{
+ QCoreApplication a(argc, argv);
+ QSqlDatabase db;
+
+
+ // Find QSLite driver
+ db = QSqlDatabase::addDatabase("QSQLITE");
+
+
+ db.setDatabaseName("C:\\workspace\\qt\\populateDB\\seafood.db");
+
+ // Open databasee
+ if(!db.open())
+ {
+ qDebug() << "DB: failed to open" << endl;
+ exit (1);
+ }
+
+ qDebug() << "DB: database opened " << endl;
+
+ QSqlQuery query;
+ bool rc = true;
+
+ // rc = query.exec("drop table if exists");
+
+ QString call("create table fish "
+ "(id integer AUTO INCREMENT primary key, "
+ "name varchar(32),"
+ "category int,"
+ "calories int,"
+ "fat float,"
+ "protein float,"
+ "omega3 float,"
+ "cholesterol int,"
+ "sodium int)");
+
+ qDebug() << call << endl;
+
+ rc = query.exec(call);
+
+
+ insertFish("Crab, Dungeness",EBEST,86,0.96,17.4,0.3,59,295);
+ insertFish("Trout, rainbow (farmed)",EBEST,131,5.4,20.8,0.986,59,35);
+ insertFish("Cod, Pacific (trawl)",EOK,83,0.63,17.9,0.0,37,71);
+ insertFish("Tuna, canned light",EOK,103,1.01,22.0,0.256,47,37);
+ insertFish("Orange Roughy",EWORST,69,0.7,14.7,0.02,20,63);
+ insertFish("Salmon, farmed or Atlantic",EWORST,142,6.33,19.8,1.73,55,44);
+
+ return a.exec();
+}