fastdo
0.5.12
|
数据库备份器,把数据备份成SQL脚本,方便跨数据库转移 更多...
#include <eiendb_common.hpp>
类 | |
struct | BackupProgressData |
备份的进度数据 更多... | |
Public 类型 | |
enum | BackupProgressType { bptNone, bptBackupData, bptBackupStruct } |
备份进度种类 更多... | |
typedef bool(* | ProgressCallback) (SQLBackup *backup, BackupProgressData *data, void *param) |
Public 成员函数 | |
SQLBackup (IDBConnection *cnn, winux::IFile *file, IDBConnection *compatible=NULL) | |
备份器构造函数 更多... | |
void | backupTableStructure (winux::String const &tableName) |
备份表结构 更多... | |
void | backupTableData (winux::String const &tableName, bool noDeleteFrom=false, ProgressCallback progress=NULL, void *param=NULL) |
备份表数据 更多... | |
void | backupDb (bool backupStructure=true, bool noDeleteFrom=false, ProgressCallback progress=NULL, void *param=NULL) |
备份数据库 更多... | |
bool | resumeDb (bool onErrorNext=false, SQLScript::ProgressCallback progress=NULL, void *param=NULL) |
恢复数据库 更多... | |
数据库备份器,把数据备份成SQL脚本,方便跨数据库转移
在文件 eiendb_common.hpp 第 115 行定义.
typedef bool(* eiendb::SQLBackup::ProgressCallback) (SQLBackup *backup, BackupProgressData *data, void *param) |
在文件 eiendb_common.hpp 第 152 行定义.
eiendb::SQLBackup::SQLBackup | ( | IDBConnection * | cnn, |
winux::IFile * | file, | ||
IDBConnection * | compatible = NULL |
||
) |
备份器构造函数
cnn | 连接器对象 |
file | 操作的文件 |
compatible | 兼容连接用来使数据按它的规则导出 |
譬如MySQL导到SQLite. 此时cnn设为mysql, compatible设为sqlite. 数据将按照sqlite的语法规则导出sql脚本, 以便sqlite数据库执行导入.(只对数据备份有效,结构备份不行)
void eiendb::SQLBackup::backupDb | ( | bool | backupStructure = true , |
bool | noDeleteFrom = false , |
||
ProgressCallback | progress = NULL , |
||
void * | param = NULL |
||
) |
备份数据库
void eiendb::SQLBackup::backupTableData | ( | winux::String const & | tableName, |
bool | noDeleteFrom = false , |
||
ProgressCallback | progress = NULL , |
||
void * | param = NULL |
||
) |
备份表数据
noDeleteFrom | 指示要不要生成DELETE FROM语句,从而在恢复数据时保留原数据 |
void eiendb::SQLBackup::backupTableStructure | ( | winux::String const & | tableName | ) |
备份表结构
bool eiendb::SQLBackup::resumeDb | ( | bool | onErrorNext = false , |
SQLScript::ProgressCallback | progress = NULL , |
||
void * | param = NULL |
||
) |
恢复数据库