FCL/interim/contrib/QtExamples: Seafood/Fishes.cpp@f3dbeee07821 (annotated)

3 e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	1
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	2	#include <QDesktopServices>
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	3	#include <QMessageBox>
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	4	#include <QtGlobal>
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	5	#include <QtSql>
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	6	#include "Fishes.h"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	7
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	8	Fishes::Fishes(QObject *parent) : QObject(parent)
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	9	{
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	10	QSqlDatabase db;
11 f3dbeee07821 instrumented with debugging output John Kern <johnk@symbian.org> parents: 10 diff changeset	11	this->dbErrString = "noErr";
3 e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	12
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	13	// Find QSLite driver
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	14	db = QSqlDatabase::addDatabase("QSQLITE");
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	15
10 79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	16	#ifdef Q_OS_SYMBIAN
3 e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	17	QString dbFile = QDesktopServices::storageLocation(QDesktopServices::DataLocation)
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	18	+ '/' // Qt Universal file separator
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	19	+ "seafood.db";
11 f3dbeee07821 instrumented with debugging output John Kern <johnk@symbian.org> parents: 10 diff changeset	20	dbFile.replace("/","\\");
10 79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	21	#else
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	22	// Windows assumed.
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	23	// unfortunately, "C:\Documents and Settings" is corrupted on my home PC. hard coding until I fix it. -jk
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	24	QString dbFile = "C:/workspace/QtExamples/Seafood/populateDB/seafood.db";
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	25	#endif
3 e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	26	QFile f(dbFile);
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	27	std::string errString(dbFile.toStdString());
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	28	if (!f.exists()) {
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	29	qWarning("db not found ");
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	30	} else {
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	31	qWarning("found db ");
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	32	}
7 7ee47a65f1ad wip John Kern <johnk@symbian.org> parents: 3 diff changeset	33	qWarning(dbFile.toStdString().c_str());
3 e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	34	db.setDatabaseName(dbFile);
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	35
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	36	// Open databasee
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	37	if(!db.open())
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	38	{
11 f3dbeee07821 instrumented with debugging output John Kern <johnk@symbian.org> parents: 10 diff changeset	39	this->dbErrString = db.lastError().databaseText();
3 e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	40
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	41	qWarning("DB: failed to open.");
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	42
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	43	this->bestFish << "Abalone (farmed)" << "Anchovy, European" << "Barramundi U.S."
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	44	<< "Capelin, smelt roe (Iceland)" << "Catfish (U.S.)" << "Clam, softshell"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	45	<< "Clams (farmed)" << "Cod, AK (longline)" << "Crab, Dungeness"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	46	<< "Crab, stone" << "Mussels" << "Oysters (farmed)"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	47	<< "Sablefish/ Black Cod (Alaska, Canada)" << "Salmon, wild (Alaska)"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	48	<< "Sardines, Pacific (U.S.)" << "Shrimp, pink (Oregon)"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	49	<< "Trout, rainbow (farmed)" << "Tuna, albacore (U.S., Canada)";
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	50	this->okFish << "Clams (wild)" << "Cod, Pacific (trawl)" << "Crab, Snow"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	51	<< "Flounder/sole (Pacific)" << "Lobster, American/Maine" << "Scallops, sea (U.S., Canada)"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	52	<< "Shrimp (U.S. wild)" << "Squid" << "Tilapia (Latin America)"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	53	<< "Tuna, canned light";
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	54	this->worstFish << "Chilean sea bass" << "Grouper" << "Orange roughy"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	55	<< "Rockfish (trawl)" << "Salmon, farmed or Atlantic" << "Shark"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	56	<< "Swordfish (imported)" << "Tilefish (Gulf of Mexico/South Atlantic)"
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	57	<< "Tuna, bigeye/yellowfin" << "Tuna, bluefin";
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	58	} else {
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	59	this->populate(EPresentBest);
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	60	this->populate(EPresentOK);
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	61	this->populate(EPresentWorst);
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	62	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	63	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	64
10 79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	65	/* given the name of a fish, return a list of eco details in html format.
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	66	*/
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	67	QString Fishes::getEcoDetails(QString name)
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	68	{
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	69	QString detailsInHtml;
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	70	QSqlQuery query;
11 f3dbeee07821 instrumented with debugging output John Kern <johnk@symbian.org> parents: 10 diff changeset	71	this->dbErrString = "noErr";
10 79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	72
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	73	query.prepare("select details from ecoDetails "
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	74	"where fid in (select fid from fish where name = :name )");
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	75	query.bindValue(":name",name);
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	76
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	77	if (!query.exec())
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	78	{
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	79	QString errCode = "failed to get eco details " + query.lastError().text();
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	80	qWarning(errCode.toStdString().c_str());
11 f3dbeee07821 instrumented with debugging output John Kern <johnk@symbian.org> parents: 10 diff changeset	81	this->dbErrString = name + " " + query.lastError().text();
10 79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	82	}
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	83
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	84	detailsInHtml.append("<html> <title>name</title> <body> <h2>Eco Details</h2> <ul> ");
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	85	while (query.next()){
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	86	detailsInHtml.append( " <li>");
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	87	detailsInHtml.append( query.value(0).toString());
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	88	detailsInHtml.append( "</li> " );
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	89	}
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	90	detailsInHtml.append("</ul> </body> </html> ");
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	91	return detailsInHtml;
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	92	}
79eeacfd15ff implement eco details with webview User@User-PC.domain_not_set.invalid parents: 7 diff changeset	93
3 e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	94	void Fishes::populate(TCATEGORIES cat)
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	95	{
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	96	QSqlQuery query;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	97
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	98	query.prepare("SELECT name FROM fish where category = :category ");
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	99	query.bindValue(":category",cat);
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	100
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	101	if (!query.exec())
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	102	{
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	103	QString errCode = "failed to populate " + query.lastError().text();
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	104	qWarning(errCode.toStdString().c_str());
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	105	//qFatal("Failed to add fish.");
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	106	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	107
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	108	while (query.next()){
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	109	switch (cat)
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	110	{
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	111	case EPresentBest:
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	112	this->bestFish << query.value(0).toString();
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	113	break;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	114	case EPresentWorst:
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	115	this->worstFish << query.value(0).toString();
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	116	break;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	117	case EPresentOK:
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	118	this->okFish << query.value(0).toString();
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	119	break;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	120	default:
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	121	qWarning("this can't happen.");
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	122	break;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	123	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	124	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	125
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	126	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	127
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	128
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	129	const QStringList Fishes::GetBest()
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	130	{
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	131
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	132	return bestFish;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	133	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	134
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	135	const QStringList Fishes::GetOK()
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	136	{
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	137	return okFish;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	138	}
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	139
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	140	const QStringList Fishes::GetWorst()
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	141	{
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	142	return worstFish;
e6d1a78b6db9 wip - start of an example for my forthcoming presentation John Kern <johnk@symbian.org> parents: diff changeset	143	}

author	John Kern <johnk@symbian.org>
	Wed, 31 Mar 2010 16:09:36 -0700
changeset 11	f3dbeee07821
parent 10	79eeacfd15ff
child 14	a16afe3df8c9
permissions	-rwxr-xr-x