Function dump_callback

src/database/cppsqlite3.cpp:1066–1157

** This is a different callback routine used for dumping the database. ** Each row received by this callback consists of a table name, ** the table type ("index" or "table") and SQL to create the table. ** This routine should print text sufficient to recreate the table. */

** This routine should print text sufficient to recreate the table.
*/
static int dump_callback(void *pArg, int nArg, char **azArg, char **azCol){
	int rc;
	const char *zTable;
	const char *zType;
	const char *zSql;
	const char *zPrepStmt = 0;
	struct callback_data *p = (struct callback_data *)pArg;
        //
        Q_UNUSED(azCol);

	//UNUSED_PARAMETER(azCol);
	if( nArg!=3 ) return 1;
	zTable = azArg[0];
	zType = azArg[1];
	zSql = azArg[2];

	if( strcmp(zTable, "sqlite_sequence")==0 ){
		zPrepStmt = "DELETE FROM sqlite_sequence;\n";
	}else if( strcmp(zTable, "sqlite_stat1")==0 ){
		fprintf(p->out, "ANALYZE sqlite_master;\n");
	}else if( strncmp(zTable, "sqlite_", 7)==0 ){
		return 0;
	}else if( strncmp(zSql, "CREATE VIRTUAL TABLE", 20)==0 ){
		char *zIns;
		if( !p->writableSchema ){
			fprintf(p->out, "PRAGMA writable_schema=ON;\n");
			p->writableSchema = 1;
		}
		zIns = sqlite3_mprintf(
			"INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)"
			"VALUES('table','%q','%q',0,'%q');",
			zTable, zTable, zSql);
		fprintf(p->out, "%s\n", zIns);
		sqlite3_free(zIns);
		return 0;
	}else{
		fprintf(p->out, "%s;\n", zSql);
	}

	if( strcmp(zType, "table")==0 ){
		sqlite3_stmt *pTableInfo = 0;
		char *zSelect = 0;
		char *zTableInfo = 0;
		char *zTmp = 0;
		int nRow = 0;

		zTableInfo = appendText(zTableInfo, "PRAGMA table_info(", 0);
		zTableInfo = appendText(zTableInfo, zTable, '"');
		zTableInfo = appendText(zTableInfo, ");", 0);

		rc = sqlite3_prepare(p->db, zTableInfo, -1, &pTableInfo, 0);
		free(zTableInfo);
		if( rc!=SQLITE_OK || !pTableInfo ){
			return 1;
		}

		zSelect = appendText(zSelect, "SELECT 'INSERT INTO ' || ", 0);
		zTmp = appendText(zTmp, zTable, '"');