# -*- 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 +