void ThreatQuery::query() {
	const ds::Resource::Id			cms(ds::Resource::Id::CMS_TYPE, 0);
	std::stringstream				buf;
	ds::query::Result				r;
	ds::query::Result				threatR;
	buf << "SELECT latest_threats.id, latest_threats.name FROM latest_threats ORDER BY id DESC LIMIT 10";
	if (!ds::query::Client::query(cms.getDatabasePath(), buf.str(), r, ds::query::Client::INCLUDE_COLUMN_NAMES_F)) {
		DS_LOG_WARNING("TreatQuery error querying treats");
	}
	if (r.rowsAreEmpty()) return;

	// Add the media
	ds::query::Result::RowIterator	it(r);
	while (it.hasValue()) {
		LatestThreatModel m;
		m.mThreatId =it.getInt(0);
		m.mName = it.getWString(1);

		buf.str("");
		buf << "SELECT country, startDate, infections FROM threat_data WHERE threatID = " << m.mThreatId;
		if(ds::query::Client::query(cms.getDatabasePath(), buf.str(), threatR, ds::query::Client::INCLUDE_COLUMN_NAMES_F) && !threatR.rowsAreEmpty()){
			ds::query::Result::RowIterator threatIt(threatR);
			while(threatIt.hasValue()){
				ThreatDataModel tdm;
				tdm.mCountry = threatIt.getWString(0);
				tdm.mDate = threatIt.getWString(1);
				tdm.mNumThreats = threatIt.getInt(2);
				m.mThreatData.push_back(tdm);
				++threatIt;
			}
		}
		mLatestThreats.push_back(m);
		++it;
	}
}
Esempio n. 2
0
void StoryQuery::query(AllData& output) {
	// Sample to hard-code data:
	ds::model::StoryRef newStory;
	newStory.setId(1);
	newStory.setTitle(L"Sample Story");
	newStory.setBody(L"Sample body");
	newStory.setPrimaryResource(ds::Resource(ds::Environment::expand("%APP%/data/images/temp/sample_image.png")));
	output.mStories.push_back(newStory);



	// Sample to query from a db.
	// You'll need to set resource_location and resource_db in engine.xml for this to work (or supply your own db path)
	// resource_db is a relative path to resource_location
	/* 

	*/
	const ds::Resource::Id cms(ds::Resource::Id::CMS_TYPE, 0);
	ds::query::Result result;
	ds::query::Result recResult;
	std::string dbPath = cms.getDatabasePath();
	std::string resourcesPath = cms.getResourcePath();

	std::map<int, ds::Resource> allResources;
	//									0			1				2				3				4				5					6			7
	std::string recyQuery = "SELECT resourcesid, resourcestype,resourcesduration,resourceswidth,resourcesheight,resourcesfilename,resourcespath,resourcesthumbid FROM Resources";
	if(ds::query::Client::query(dbPath, recyQuery, recResult)) {
		ds::query::Result::RowIterator	rit(recResult);
		while(rit.hasValue()) {
			ds::Resource reccy;
			int mediaId = rit.getInt(0);
			reccy.setDbId(mediaId);
			reccy.setTypeFromString(rit.getString(1));
			reccy.setDuration(rit.getFloat(2));
			reccy.setWidth(rit.getFloat(3));
			reccy.setHeight(rit.getFloat(4));
			if(reccy.getType() == ds::Resource::WEB_TYPE){
				reccy.setLocalFilePath(rit.getString(5));
			} else {
				std::stringstream loclPath;
				loclPath << resourcesPath << rit.getString(6) << rit.getString(5);
				reccy.setLocalFilePath(loclPath.str());
			}
			reccy.setThumbnailId(rit.getInt(7));
			allResources[mediaId] = reccy;
			++rit;
		}
		}

}
void NewsQuery::query() {
	const ds::Resource::Id			cms(ds::Resource::Id::CMS_TYPE, 0);
	std::stringstream				buf;
	ds::query::Result				r;
	buf << "SELECT id,year,month,day,text FROM news";
	if (!ds::query::Client::query(cms.getDatabasePath(), buf.str(), r, ds::query::Client::INCLUDE_COLUMN_NAMES_F)) {
		DS_LOG_WARNING("NewsQuery::queryType() error querying news");
	}
	if (r.rowsAreEmpty()) return;

	// Add the media
	ds::query::Result::RowIterator	it(r);
	while (it.hasValue()) {
		TickerModel m;
		m.mId =it.getInt(0);
		m.mYear = it.getInt(1);
		m.mMonth = it.getInt(2);
		m.mDay = it.getInt(3);
		m.mHeadline = it.getWString(4);
		mOutput.push_back(m);
		++it;
	}
}