from pydwms.runner import MysqlRunner
runner = MysqlRunner('dw_master')
sqls = '''
DELETE FROM dw_db.dm_dwms_server WHERE cal_dt = ${startDate};
INSERT INTO dw_db.dm_dwms_server
SELECT
${startDate},
server_type,
COUNT(*)
FROM dw_db.dw_dwms_server
GROUP BY server_type;
'''
runner.summary(sqls)
