Esempi in Python per MysqlRunner.load

Esempio n. 1

File: load_dw_example.py Progetto: jizhang/dwms

from pydwms.runner import MysqlRunner

runner = MysqlRunner('dw_master')

sqls = '''
TRUNCATE TABLE dw_extract.ds_dwms_server;
LOAD DATA INFILE ${dataFile} INTO TABLE dw_extract.ds_dwms_server
CHARACTER SET utf8
(
  id,
  server_name,
  server_type
);

TRUNCATE TABLE dw_db.dw_dwms_server;
INSERT INTO dw_db.dw_dwms_server
SELECT
  id,
  server_type
FROM dw_extract.ds_dwms_server;
'''

runner.load(sqls, 'dwms_server');