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. More...

string	getCreatedDate () const
	Returns the date the database file was installed. More...

virtual bool	isConnected () const
	Returns whether or not a connection has been established to the database provider. More...

virtual void	stopSearch ()
	Provide a way to interrupt long searches. More...

virtual void	reset ()
	Set all the search parameters back to their defaults. More...

virtual void	setChemicalNames (const std::vector< string > &chemNames)
	Search Paramaters. More...

virtual void	setSpeciesNames (const std::vector< string > &speciesNames)

virtual void	setFrequencyRange (double minValue, double maxValue)
	Units are assumed to be MHz. More...

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 std::vector< string > &qns)

virtual void	setFilterTop20 (bool filter=true)
	Astronomical Filters. More...

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 std::vector< SplatResult >	doSearch (string &errorMsg, int offset)
	Performing the Search. More...

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. More...

virtual	~SearcherSQLite ()

Public Member Functions inherited from casa::Searcher
	Searcher ()

virtual	~Searcher ()

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, TEMPERATURE_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 std::vector< string > &values) const

string	getLikeClause (const string &columnName, const std::vector< string > &values) const

Private Attributes
sqlite3 *	db
	Set-up. More...

double	minValueFreq
	Search parameters. More...

double	maxValueFreq

double	minValueIntensity

double	maxValueIntensity

double	minValueSmu2

double	maxValueSmu2

double	minValueLoga

double	maxValueLoga

double	minValueEl

double	maxValueEl

double	minValueEu

double	maxValueEu

std::vector< string >	speciesNames
	bool recommendedOnly; More...

std::vector< string >	chemicalNames

std::vector< string >	qns

std::vector< bool >	filters

int	rowLimit
	Limiting the number of rows returned by a search. More...

Static Private Attributes
static std::vector< string >	filterNames

static const std::string	TABLE_MAIN
	casacore::Table Names More...

static const std::string	TABLE_SPECIES

static const std::string	FREQUENCY_COLUMN
	casacore::Table columns More...

static const std::string	TEMPERATURE_COLUMN

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. More...

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 std::string	LIKE

static const std::string	OR

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 145 of file SearcherSQLite.h.

enum casa::SearcherSQLite::TableColumns

private

Enumerator
SPECIES_ID_COL
SPECIES_NAME_COL
CHEMICAL_NAME_COL
FREQUENCY_COL
TEMPERATURE_COL
RESOLVED_QNS_COL
INTENSITY_COL
SMU2_COL
LOGA_COL
EL_COL
EU_COL
END_COL

Definition at line 167 of file SearcherSQLite.h.

Constructor & Destructor Documentation

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

virtual casa::SearcherSQLite::~SearcherSQLite ( )

virtual

Member Function Documentation

virtual std::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.

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