Searches a local sqlite database for molecular lines meeting the specified search criteria. More...

#include <SearcherSQLite.h>

Inheritance diagram for casa::SearcherSQLite:

Public Member Functions
	SearcherSQLite (const string &databasePath)
string	tableInfo (const string &tableName, string &errorMsg) const
	Returns a string containing (columnName, columnType) information for all the columns in the table.
string	getCreatedDate () const
	Returns the date the database file was installed.
virtual bool	isConnected () const
	Returns whether or not a connection has been established to the database provider.
virtual void	stopSearch ()
	Provide a way to interrupt long searches.
virtual void	reset ()
	Set all the search parameters back to their defaults.
virtual void	setChemicalNames (const vector< string > &chemNames)
	Search Paramaters.
virtual void	setSpeciesNames (const vector< string > &speciesNames)
virtual void	setFrequencyRange (double minValue, double maxValue)
	Units are assumed to be MHz.
virtual void	setIntensityRange (double minValue, double maxValue)
virtual void	setSmu2Range (double minValue, double maxValue)
virtual void	setLogaRange (double minValue, double maxValue)
virtual void	setElRange (double minValue, double maxValue)
virtual void	setEuRange (double minValue, double maxValue)
virtual void	setQNS (const vector< string > &qns)
virtual void	setFilterTop20 (bool filter=true)
	Astronomical Filters.
virtual void	setFilterPlanetaryAtmosphere (bool filter=true)
virtual void	setFilterHotCores (bool filter=true)
virtual void	setFilterDarkClouds (bool filter=true)
virtual void	setFilterDiffuseClouds (bool filter=true)
virtual void	setFilterComets (bool filter=true)
virtual void	setFilterAgbPpnPn (bool filter=true)
virtual void	setFilterExtragalactic (bool filter=true)
virtual vector< SplatResult >	doSearch (string &errorMsg, int offset)
	Performing the Search.
virtual long	doSearchCount (string &errorMsg)
virtual void	setSearchResultLimit (int limit)
	Sets the maximum number of rows that will be returned as a result of a database search.
virtual	~SearcherSQLite ()
Private Types
enum	FILTER_LIST { FILTER_TOP_20, FILTER_PLANETARY_ATMOSPHERE, FILTER_HOT_CORES, FILTER_DARK_CLOUDS, FILTER_DIFFUSE_CLOUDS, FILTER_COMETS, FILTER_AGB_PPN_PN, FILTER_EXTRAGALACTIC, END_FILTERS }
enum	TableColumns { SPECIES_ID_COL, SPECIES_NAME_COL, CHEMICAL_NAME_COL, FREQUENCY_COL, RESOLVED_QNS_COL, INTENSITY_COL, SMU2_COL, LOGA_COL, EL_COL, EU_COL, END_COL }
Private Member Functions
bool	executeQuery (sqlite3_stmt *&statement, const string &query, string &errorMsg) const
string	prepareQuery (bool countOnly, int offset) const
std::string	getTrue () const
string	numToString (double number) const
string	getBetweenClause (const string &columnName, double low, double high) const
string	getInClause (const string &columnName, const vector< string > &values) const
Private Attributes
sqlite3 *	db
	Set-up.
double	minValueFreq
	Search parameters.
double	maxValueFreq
double	minValueIntensity
double	maxValueIntensity
double	minValueSmu2
double	maxValueSmu2
double	minValueLoga
double	maxValueLoga
double	minValueEl
double	maxValueEl
double	minValueEu
double	maxValueEu
bool	recommendedOnly
vector< string >	speciesNames
vector< string >	chemicalNames
vector< string >	qns
vector< bool >	filters
int	rowLimit
	Limiting the number of rows returned by a search.
Static Private Attributes
static vector< string >	filterNames
static const std::string	TABLE_MAIN
	Table Names.
static const std::string	TABLE_SPECIES
static const std::string	FREQUENCY_COLUMN
	Table columns.
static const std::string	SPECIES_ID_COLUMN
static const std::string	SPECIES_COLUMN
static const std::string	SMU2_COLUMN
static const std::string	EL_COLUMN
static const std::string	EU_COLUMN
static const std::string	LOGA_COLUMN
static const std::string	INTENSITY_COLUMN
static const std::string	RESOLVED_QNS_COLUMN
static const std::string	CHEMICAL_NAME_COLUMN
static std::vector< string >	resultColumns
static const std::string	FILTER_KNOWN_AST_COLUMN
static const std::string	FILTER_PLANET_COLUMN
static const std::string	FILTER_HOTCORE_COLUMN
static const std::string	FILTER_DIFFUSECLOUD_COLUMN
static const std::string	FILTER_DARKCLOUD_COLUMN
static const std::string	FILTER_COMET_COLUMN
static const std::string	FILTER_EXTRAGALACTIC_COLUMN
static const std::string	FILTER_AGB_PPN_PN_COLUMN
static const std::string	FILTER_TOP20_COLUMN
static const std::string	FROM
	SQL Constants.
static const std::string	SELECT
static const std::string	BETWEEN
static const std::string	AND
static const std::string	OPEN_PAREN
static const std::string	CLOSE_PAREN
static const std::string	SINGLE_QUOTE
static const std::string	COMMA
static const std::string	PERIOD
static const std::string	EQUALS
static const std::string	IN
static const int	DEFAULT_VALUE

Detailed Description

Searches a local sqlite database for molecular lines meeting the specified search criteria.

Definition at line 41 of file SearcherSQLite.h.

Member Enumeration Documentation

enum casa::SearcherSQLite::FILTER_LIST [private]

Enumerator:

FILTER_TOP_20
FILTER_PLANETARY_ATMOSPHERE
FILTER_HOT_CORES
FILTER_DARK_CLOUDS
FILTER_DIFFUSE_CLOUDS
FILTER_COMETS
FILTER_AGB_PPN_PN
FILTER_EXTRAGALACTIC
END_FILTERS

Definition at line 144 of file SearcherSQLite.h.

enum casa::SearcherSQLite::TableColumns [private]

Enumerator:

SPECIES_ID_COL
SPECIES_NAME_COL
CHEMICAL_NAME_COL
FREQUENCY_COL
RESOLVED_QNS_COL
INTENSITY_COL
SMU2_COL
LOGA_COL
EL_COL
EU_COL
END_COL

Definition at line 165 of file SearcherSQLite.h.

Constructor & Destructor Documentation

casa::SearcherSQLite::SearcherSQLite ( const string & databasePath )

virtual casa::SearcherSQLite::~SearcherSQLite ( ) [virtual]

Member Function Documentation

virtual vector<SplatResult> casa::SearcherSQLite::doSearch	(	string &	errorMsg,
		int	offset
	)		`[virtual]`

Performing the Search.

The offset is used when there is a limit on the number of rows that will be returned from the database. In the case that the number of rows that meet the search criteria exceeds the search limit, the offset indicates the starting index of the rows that are returned.

bool casa::SearcherSQLite::executeQuery	(	sqlite3_stmt *&	statement,
		const string &	query,
		string &	errorMsg
	)		const `[private]`

string casa::SearcherSQLite::getBetweenClause	(	const string &	columnName,
		double	low,
		double	high
	)		const `[private]`

string casa::SearcherSQLite::getInClause	(	const string &	columnName,
		const vector< string > &	values
	)		const `[private]`

string casa::SearcherSQLite::prepareQuery	(	bool	countOnly,
		int	offset
	)		const `[private]`

virtual void casa::SearcherSQLite::setElRange	(	double	minValue,
		double	maxValue
	)		`[virtual]`

virtual void casa::SearcherSQLite::setEuRange	(	double	minValue,
		double	maxValue
	)		`[virtual]`

virtual void casa::SearcherSQLite::setFrequencyRange	(	double	minValue,
		double	maxValue
	)		`[virtual]`

virtual void casa::SearcherSQLite::setIntensityRange	(	double	minValue,
		double	maxValue
	)		`[virtual]`

virtual void casa::SearcherSQLite::setLogaRange	(	double	minValue,
		double	maxValue
	)		`[virtual]`

virtual void casa::SearcherSQLite::setSmu2Range	(	double	minValue,
		double	maxValue
	)		`[virtual]`

string casa::SearcherSQLite::tableInfo	(	const string &	tableName,
		string &	errorMsg
	)		const `[virtual]`

Public Member Functions

Private Types

Private Member Functions

Private Attributes

Static Private Attributes

Detailed Description

Member Enumeration Documentation

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation