Function run_table_dump_query

src/database/cppsqlite3.cpp:1035–1058

** Execute a query statement that has a single result column. Print ** that result column on a line by itself with a semicolon terminator. ** ** This is used, for example, to show the schema of the database by ** querying the SQLITE_MASTER table. */

** querying the SQLITE_MASTER table.
*/
static int run_table_dump_query(
								FILE *out,              /* Send output here */
								sqlite3 *db,            /* Database to query */
								const char *zSelect,    /* SELECT statement to extract content */
								const char *zFirstRow   /* Print before first row, if not NULL */
								)
{
	sqlite3_stmt *pSelect;
	int rc;
	rc = sqlite3_prepare(db, zSelect, -1, &pSelect, 0);
	if( rc!=SQLITE_OK || !pSelect ){
		return rc;
	}
	rc = sqlite3_step(pSelect);
	while( rc==SQLITE_ROW ){
		if( zFirstRow ){
			fprintf(out, "%s", zFirstRow);
			zFirstRow = 0;
		}
		fprintf(out, "%s;\n", sqlite3_column_text(pSelect, 0));
		rc = sqlite3_step(pSelect);
	}
	return sqlite3_finalize(pSelect);
}

/*
** This is a different callback routine used for dumping the database.