Method dump

src/database/cppsqlite3.cpp:1585–1631

}

bool CppSQLite3DB::dump(const CString& strNewFileName)
{
    FILE* fp = fopen(strNewFileName.toLocal8Bit(), "wb");
    if (!fp)
	{
        TOLOG1("Failed to open file: %1", strNewFileName);
		return false;
	}
	//
	callback_data data;
	data.db = mpDB;
	data.out = fp;
	data.writableSchema = 0;
	data.cnt = 0;
	data.pStmt = NULL;
	//
	callback_data* p = &data;
	//
    fprintf(p->out, "PRAGMA foreign_keys=OFF;\n");
    fprintf(p->out, "BEGIN TRANSACTION;\n");
    p->writableSchema = 0;
    sqlite3_exec(p->db, "PRAGMA writable_schema=ON", 0, 0, 0);

	run_schema_dump_query(p, 
		"SELECT name, type, sql FROM sqlite_master "
		"WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'", 0
		);
	run_schema_dump_query(p, 
		"SELECT name, type, sql FROM sqlite_master "
		"WHERE name=='sqlite_sequence'", 0
		);
	run_table_dump_query(p->out, p->db,
		"SELECT sql FROM sqlite_master "
		"WHERE sql NOT NULL AND type IN ('index','trigger','view')", 0
		);
	//
	if( p->writableSchema ){
		fprintf(p->out, "PRAGMA writable_schema=OFF;\n");
		p->writableSchema = 0;
	}
	sqlite3_exec(p->db, "PRAGMA writable_schema=OFF", 0, 0, 0);
	fprintf(p->out, "COMMIT;\n");
	//
	fclose(fp);

	return true;
}

bool CppSQLite3DB::read(const CString& strNewFileName)
{