Example #1
0
char * build_query(const struct WciReadParameterCollection * parameters,
		enum DataSource dataSource, enum OutputType output,
		const char * selectWhat, const char * ordering, const char * groupby)
{
	try
	{
		query::Builder builder;

		if ( dataSource == FloatTable )
			builder.from(WCI_SCHEMA".floatvalue_v v");
		else // dataSource == GridTable
			builder.from(WCI_SCHEMA".gridvalue_v v");

		builder.what(selectWhat);

		if ( parameters )
		{
			addDataProviderQuery(builder, parameters->dataProvider);
			addReferenceTimeQuery(builder, parameters->referenceTime);
			addValidTimeQuery(builder, parameters->validTime);
			addParameterQuery(builder, parameters->parameter);
			addLevelQuery(builder, parameters->level);
			addDataVersionQuery(builder, parameters->dataVersion);
			addLocationQuery(builder, parameters->location, dataSource, output);
		}
		if ( ordering )
			builder.orderBy(ordering);
		if ( groupby )
			builder.groupBy(groupby);

		//builder.debugPrint(std::cout) << std::flush;

		std::string ret = builder.str();
		return pstrdup(ret.c_str());
	}
	catch (std::exception & e)
	{
		ereport( ERROR,
				 ( errcode( ERRCODE_DATA_EXCEPTION ),
				   errmsg( "%s",  pstrdup(e.what()) ) ) );
	}
	catch ( ... )
	{
		ereport( ERROR,
						 ( errcode( ERRCODE_RAISE_EXCEPTION ),
						   errmsg( "Unrecognized error" ) ) );
	}
	// Never reached:
	return NULL;
}
Example #2
0
char * build_query(const struct WciReadParameterCollection * parameters,
		enum DataSource dataSource, enum OutputType output,
		const char * selectWhat, const char * ordering)
{
	try
	{
		std::ostringstream q;
		q << "SELECT "<< selectWhat << " FROM ";
		if ( dataSource == FloatTable )
			q << WCI_SCHEMA << ".floatvalue v ";
		else // dataSource == GridTable
			q << WCI_SCHEMA << ".gridvalue v ";

		if ( parameters )
		{
			std::ostringstream w;
			addDataProviderQuery(w, parameters->dataProvider);
			addReferenceTimeQuery(w, parameters->referenceTime);
			addValidTimeQuery(w, parameters->validTime);
			addParameterQuery(w, parameters->parameter);
			addLevelQuery(w, parameters->level);
			addDataVersionQuery(w, parameters->dataVersion);
			addLocationQuery(w, parameters->location, dataSource, output);
			q << "WHERE " << w.str();
		}
		if ( ordering )
		{
			q << ordering;
		}

		std::string ret = q.str();
		return pstrdup(ret.c_str());
	}
	catch (std::exception & e)
	{
		ereport( ERROR,
				 ( errcode( ERRCODE_DATA_EXCEPTION ),
				   errmsg( pstrdup(e.what()) ) ) );
	}
	catch ( ... )
	{
		ereport( ERROR,
						 ( errcode( ERRCODE_RAISE_EXCEPTION ),
						   errmsg( "Unrecognized error" ) ) );
	}
	// Never reached:
	return NULL;
}