def __init__(self, config, sgdb=None):
Main._check_configuration(config)
self.cli = CLI()
self.config = config
self.log = LOG(self.config.get("log_dir", None))
self.sgdb = sgdb
if self.sgdb is None and not self.config.get("new_migration", None):
if self.config.get("database_engine") == 'mysql':
from mysql import MySQL
self.sgdb = MySQL(config)
elif self.config.get("database_engine") == 'oracle':
from oracle import Oracle
self.sgdb = Oracle(config)
elif self.config.get("database_engine") == 'mssql':
from mssql import MSSQL
self.sgdb = MSSQL(config)
elif self.config.get("database_engine") == 'postgresql':
from postgresql import PostgreSQL
self.sgdb = PostgreSQL(config)
else:
raise Exception("engine not supported '%s'" % self.config.get("database_engine"))
self.db_migrate = SimpleDBMigrate(self.config)
def init(self): #初始化mysql
if self.cj == '共济':
try:
from mysql import MYSQL
import xb_1 as cv
self.cv = cv
self.ms = MYSQL(host=self.host,
port=self.port,
user=self.user,
pwd=self.pwd,
db=self.db)
self.flag = 1
except:
self.flag = 0
self.sinOut.emit(2000)
elif self.cj == '中联':
try:
from mssql import MSSQL
import zl_1 as cv
self.cv = cv
self.ms = MSSQL(host=self.host,
port=self.port,
user=self.user,
pwd=self.pwd,
db=self.db)
self.flag = 1
except:
self.flag = 0
self.sinOut.emit(2001)
elif self.cj == '栅格':
try:
from mysql import MYSQL
import sg_1 as cv
self.cv = cv
self.ms = MYSQL(host=self.host,
port=self.port,
user=self.user,
pwd=self.pwd,
db=self.db)
self.flag = 1
except:
self.flag = 0
self.sinOut.emit(2000)
def init(self, server, port, user, passwd, db):
self.count = 1
self.ms = MSSQL(host=server, port=port, user=user, pwd=passwd, db=db)
import xlrd
import glob
import os
import csv
import json
from mssql import MSSQL
MS = MSSQL(host="localhost", user="******", pwd="Health123", db="Dfcf")
def bulk_query(csv_fn):
basename = os.path.basename(csv_fn)
data_name = basename[20:basename.index('.')]
if '1Day.zjlx' in basename:
data_name = '1DAY'
return r"""BULK INSERT [dbo].[{table}]
FROM '{csv}'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 2
)
""".format(table=data_name, csv=csv_fn)
def get_header(data_name):
table = {
'GGPM': [
'DT', 'Ordi', 'S', 'N', 'P', 'R', 'RP', 'V', 'NewV', 'BP', 'SP',
def __init__(self, driver):
self.mssql = MSSQL()
self.driver = driver
