sql_utils.hh File Reference

#include <utility/sql_database/DatabaseSessionManager.hh>
#include <utility/sql_database/types.hh>
#include <utility/tag/Tag.fwd.hh>
#include <platform/types.hh>
#include <iosfwd>
#include <vector>
#include <cppdb/frontend.h>

Namespaces
	basic
	Tags used to tag messeges sent by MPI functions used to decide whether a slave is requesting a new job id or flagging as job as being a bad input.
	basic::database

Functions
sessionOP	basic::database::get_db_session ()
	Aquire a database session using the command line options transaction type is set to standard. More...
sessionOP	basic::database::get_db_session (std::string const &db_name, std::string const &pq_schema="")
	Aquire a database session using the command line parameters For postgres databases, the pq_schema acts like a namespace in the database. Transaction type set to standard. More...
utility::sql_database::sessionOP	basic::database::get_db_session (std::string const &db_name, utility::sql_database::TransactionMode::e transaction_mode, platform::Size chunk_size, std::string const &pq_schema="")
	Aquire a database session using the command line parameters For postgres databases, the pq_schema acts like a namespace in the database. More...
utility::sql_database::sessionOP	basic::database::get_db_session (utility::sql_database::DatabaseMode::e db_mode, std::string const &db_name, std::string const &pq_schema)
utility::sql_database::sessionOP	basic::database::get_db_session (utility::sql_database::DatabaseMode::e db_mode, utility::sql_database::TransactionMode::e transaction_mode, platform::Size chunk_size, std::string const &db_name, std::string const &pq_schema="")
	Aquire a database session using the command line parameters For postgres databases, the pq_schema acts like a namespace in the database. More...
platform::SSize	basic::database::db_partition_from_options (DatabaseMode::e db_mode)
	@ More...
platform::SSize	basic::database::resolve_db_partition (bool partition_by_mpi_process, platform::SSize manual_partition=-1)
	Returns partition identifer from mpi rank if in partitioned database mode, or valid manual partition, otherwise -1. More...
cppdb::statement	basic::database::safely_prepare_statement (std::string const &statement_string, utility::sql_database::sessionOP db_session)
void	basic::database::safely_write_to_database (cppdb::statement &statement)
cppdb::result	basic::database::safely_read_from_database (cppdb::statement &statement)
void	basic::database::insert_or_ignore (std::string table_name, std::vector< std::string > column_names, std::vector< std::string > values, utility::sql_database::sessionOP db_session)
void	basic::database::check_statement_sanity (string sql)
bool	basic::database::table_exists (utility::sql_database::sessionOP db_session, std::string const &table_name)
void	basic::database::set_cache_size (utility::sql_database::sessionOP db_session, platform::Size cache_size)
	set the number of 1kb pages to use for cache More...
void	basic::database::write_schema_to_database (std::string schema, utility::sql_database::sessionOP db_session)
std::string	basic::database::make_compound_statement (std::string const &table_name, std::vector< std::string > const &column_names, platform::Size const &row_count)
utility::sql_database::sessionOP	basic::database::parse_database_connection (utility::tag::TagCOP tag)

Detailed Description

Author

Sam DeLuca