bool Connection::table_exists( const string &table_name ) { AttributeList parameters; parameters.push_back( table_name ); RowSet rows = select_all( "SELECT name FROM sqlite_master WHERE type='table' AND name = ?;", parameters ); return ( rows.size() ? true : false ); }
string table_definition( Connection &connection, const string &table_name ) { stringstream query; query << "SELECT sql FROM sqlite_master "; query << "WHERE type='table'"; query << "AND name='" << table_name << "'"; RowSet rows = connection.select_all( query.str() ); if( rows.size() == 0 ) return ""; return rows.front().get_text( "sql" ); }