python 处理数据库bak_python 脚本bak文件还原mssql数据库

# -*- coding=utf-8 -*-

import pyodbc

from datetime import datetime

import pymssql

import decimal

class SQLServer:

def __init__(self,server,user,password,database,autocommit):

self.server = server

self.user = user

self.password = password

self.database = database

self.autocommit = autocommit

def __GetConnect(self):

if not self.database:

raise(NameError,"没有数据库信息")

self.conn = pymssql.connect(server=self.server,user=self.user,password=self.password,database=self.database,autocommit=self.autocommit)

cur = self.conn.cursor()

if not cur:

raise(NameError,"连接数据库失败")

else:

return cur

def restoreDb(self,database,restorepath):

cur = self.__GetConnect()

restorePath = restorepath + database + datetime.now().strftime("%Y%m%d") + '.bak'

sql = "RESTORE DATABASE [{0}] FROM DISK = N'{1}' WITH FILE=1,Replace,stats = 10".format(database,restorePath)

cur.execute(sql)

self.conn.close()

def main():

msg = SQLServer(server="192.168.2.190",user="sa",password="P123",database="master",autocommit=True)

msg.restoreDb("wanghz","D:\\backup\\")

if __name__ == "__main__":

main()