#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();

}