csvzall 0.4.0
CSV command-line tool and emerging C++ library
Loading...
Searching...
No Matches
csvzall::sqlite Namespace Reference

Classes

struct  CsvLoadOptions
 
class  SqliteDb
 
struct  SqliteDbOpenOptions
 
struct  SqliteLogCallbacks
 

Enumerations

enum class  SqliteColumnAffinity { Numeric , Text }
 

Functions

std::string QuoteIdentifier (const std::string &name)
 
std::vector< SqliteColumnAffinity > InferColumnAffinities (csv::CSVReader &reader, const std::vector< std::string > &headers)
 
bool LoadCsvIntoTable (csv::CSVReader &reader, const std::vector< std::string > &headers, SQLite::Database &db, const std::string &table_name, const std::vector< SqliteColumnAffinity > &column_affinities, const CsvLoadOptions &options, const SqliteLogCallbacks &logger)
 
bool LoadCsvIntoTableWithInferredAffinities (const std::function< csv::CSVReader &()> &reader, const std::vector< std::string > &headers, SQLite::Database &db, const std::string &table_name, const std::function< bool()> &reset_reader, const CsvLoadOptions &options, const SqliteLogCallbacks &logger)
 
std::vector< std::string > StatementColumnNames (SQLite::Statement &statement)
 
std::vector< std::string > StatementRowValues (SQLite::Statement &statement)
 
std::uint64_t WriteStatementRowsAsCsv (SQLite::Statement &statement, const std::vector< std::string > &headers, std::ostream &output)
 
SqliteDb OpenSqliteDb (const SqliteDbOpenOptions &options)
 
void RegisterSqliteRegexFunctions (SQLite::Database &db)
 

Enumeration Type Documentation

◆ SqliteColumnAffinity

Enumerator
Numeric 
Text 

Function Documentation

◆ InferColumnAffinities()

std::vector< SqliteColumnAffinity > csvzall::sqlite::InferColumnAffinities ( csv::CSVReader &  reader,
const std::vector< std::string > &  headers 
)

◆ LoadCsvIntoTable()

bool csvzall::sqlite::LoadCsvIntoTable ( csv::CSVReader &  reader,
const std::vector< std::string > &  headers,
SQLite::Database &  db,
const std::string &  table_name,
const std::vector< SqliteColumnAffinity > &  column_affinities,
const CsvLoadOptions &  options,
const SqliteLogCallbacks &  logger 
)

◆ LoadCsvIntoTableWithInferredAffinities()

bool csvzall::sqlite::LoadCsvIntoTableWithInferredAffinities ( const std::function< csv::CSVReader &()> &  reader,
const std::vector< std::string > &  headers,
SQLite::Database &  db,
const std::string &  table_name,
const std::function< bool()> &  reset_reader,
const CsvLoadOptions &  options,
const SqliteLogCallbacks &  logger 
)

◆ OpenSqliteDb()

SqliteDb csvzall::sqlite::OpenSqliteDb ( const SqliteDbOpenOptions &  options)

◆ QuoteIdentifier()

std::string csvzall::sqlite::QuoteIdentifier ( const std::string &  name)

◆ RegisterSqliteRegexFunctions()

void csvzall::sqlite::RegisterSqliteRegexFunctions ( SQLite::Database &  db)

◆ StatementColumnNames()

std::vector< std::string > csvzall::sqlite::StatementColumnNames ( SQLite::Statement &  statement)

◆ StatementRowValues()

std::vector< std::string > csvzall::sqlite::StatementRowValues ( SQLite::Statement &  statement)

◆ WriteStatementRowsAsCsv()

std::uint64_t csvzall::sqlite::WriteStatementRowsAsCsv ( SQLite::Statement &  statement,
const std::vector< std::string > &  headers,
std::ostream &  output 
)