# HG changeset patch
# User John Kern <johnk@symbian.org>
# Date 1269550527 25200
# Node ID 98d749cef1a75dc3e86c9e65b4e362611870bc8f
# Parent  a154e00a44486a739b3f95ab5c7d08a19b59be29
program to populate fish db

diff -r a154e00a4448 -r 98d749cef1a7 Seafood/populateDB/database.h
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Seafood/populateDB/database.h	Thu Mar 25 13:55:27 2010 -0700
@@ -0,0 +1,6 @@
+#ifndef DATABASE_H
+#define DATABASE_H
+
+enum { EBEST=0, EOK, EWORST };
+
+#endif // DATABASE_H
diff -r a154e00a4448 -r 98d749cef1a7 Seafood/populateDB/main.cpp
--- /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();
+}
diff -r a154e00a4448 -r 98d749cef1a7 Seafood/populateDB/populateDB.pro
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Seafood/populateDB/populateDB.pro	Thu Mar 25 13:55:27 2010 -0700
@@ -0,0 +1,22 @@
+#-------------------------------------------------
+#
+# Project created by QtCreator 2010-03-22T11:11:02
+#
+#-------------------------------------------------
+
+QT       += core
+QT += sql
+
+QT       -= gui
+
+TARGET = populateDB
+CONFIG   += console
+CONFIG   -= app_bundle
+
+TEMPLATE = app
+
+
+SOURCES += main.cpp
+
+HEADERS += \
+    database.h