io.jpom.service.dblog

Class BackupInfoService

java.lang.Object

io.jpom.service.h2db.BaseDbCommonService<T>

io.jpom.service.h2db.BaseDbService<BackupInfoModel>

io.jpom.service.dblog.BackupInfoService

@Service
public class BackupInfoService
extends BaseDbService<BackupInfoModel>

备份数据库 service

Since:

2021-11-18

Author:

Hotstrip

Field Summary

Fields inherited from class io.jpom.service.h2db.BaseDbCommonService

key, tableName, tClass

Constructor Summary

Constructors

Constructor and Description
BackupInfoService(DbExtConfig dbExtConfig)

Method Summary

Modifier and Type	Method and Description
Future<BackupInfoModel>	autoBackup() 自动备份
Future<BackupInfoModel>	backupToSql(List<String> tableNameList) 备份数据库 SQL 文件
void	checkAutoBackup() 检查数据库备份
int	delByKey(String keyValue) 根据主键生成
List<String>	h2TableNameList() load table name list from h2 database
boolean	restoreWithSql(String backupSqlPath) 根据 SQL 文件还原数据库 还原数据库时只能同步，防止该过程中修改数据造成数据不一致

Methods inherited from class io.jpom.service.h2db.BaseDbService

autoClear, autoLoopClear, clearTimeColumns, count, count, covetTableName, defaultOrders, executeClearImpl, fillInsert, getData, getLastTimeValue, insert, insert, insertNotFill, list, listById, listById, listPage, listPage, listPage, parsePage, update, updateById, updateById, upsert

Methods inherited from class io.jpom.service.h2db.BaseDbCommonService

count, count, dataBeanToEntity, del, delByKey, entityToBean, entityToBean, entityToBeanList, execute, exists, exists, fillSelectResult, findByCondition, getByKey, getByKey, getByKey, getKey, getTableName, insert, listByBean, listByEntity, listPageOnlyResult, query, query, queryByBean, queryList, queryList, queryList, update, warpException

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

BackupInfoService

public BackupInfoService(DbExtConfig dbExtConfig)

Method Detail

checkAutoBackup

public void checkAutoBackup()

检查数据库备份

autoBackup

public Future<BackupInfoModel> autoBackup()

自动备份

backupToSql

public Future<BackupInfoModel> backupToSql(List<String> tableNameList)

备份数据库 SQL 文件

Parameters:

tableNameList - 需要备份的表名称列表，如果是全库备份，则不需要

restoreWithSql

public boolean restoreWithSql(String backupSqlPath)

根据 SQL 文件还原数据库 还原数据库时只能同步，防止该过程中修改数据造成数据不一致

Parameters:

backupSqlPath - 备份 sql 文件地址

h2TableNameList

public List<String> h2TableNameList()

load table name list from h2 database

Returns:

list

delByKey

public int delByKey(String keyValue)

Description copied from class: BaseDbCommonService

根据主键生成

Overrides:

delByKey in class BaseDbCommonService<BackupInfoModel>

Parameters:

keyValue - 主键值

Returns:

影响行数