# -*- coding: utf-8 -*-

import sys
from util.log import *
from util.cases import *
from util.sql import *


class TDTestCase:
    def init(self, conn):
        tdLog.debug("start to execute %s" % __file__)
        tdSql.init(conn.cursor())

    def run(self):
        tdSql.prepare()

        # TSIM: system sh/stop_dnodes.sh
        # TSIM:
        # TSIM: system sh/ip.sh -i 1 -s up
        # TSIM: system sh/deploy.sh -n dnode1 -m 192.168.0.1 -i 192.168.0.1
        # TSIM: system sh/cfg.sh -n dnode1 -c commitLog -v 0
        # TSIM: system sh/exec.sh -n dnode1 -s start
        # TSIM:
        # TSIM: sleep 3000
        # TSIM: sql connect
        # TSIM:
        # TSIM: $i = 0
        # TSIM: $dbPrefix = lm_da_db
        # TSIM: $tbPrefix = lm_da_tb
        # TSIM: $db = $dbPrefix . $i
        # TSIM: $tb = $tbPrefix . $i
        # TSIM:
        # TSIM: print =============== step1
        tdLog.info('=============== step1')
        # TSIM: sql create database $db
        # TSIM: sql use $db
        # TSIM:
        # TSIM: sql create table $tb (ts timestamp, speed int)
        tdLog.info("create table tb0 (ts timestamp, speed int)")
        tdSql.execute('create table tb0 (ts timestamp, speed int)')
        # TSIM: sql insert into $tb values ('2017-01-01 08:00:00.001', 1)
        tdLog.info("insert into tb0 values ('2017-01-01 08:00:00.001', 1)")
        tdSql.execute("insert into tb0 values ('2017-01-01 08:00:00.001', 1)")
        # TSIM: sql select ts from $tb
        tdLog.info('select ts from tb0')
        tdSql.query('select ts from tb0')
        # TSIM: if $rows != 1 then
        tdLog.info('tdSql.checkRow(1)')
        tdSql.checkRows(1)
        # TSIM: return -1
        # TSIM: endi
        # TSIM: if $data00 != @17-01-01 08:00:00.001@ then
        tdLog.info("tdSql.checkData(0, 0, 17-01-01 08:00:00.001)")
        expectedData = datetime.datetime.strptime(
            "17-01-01 08:00:00.001", "%y-%m-%d %H:%M:%S.%f")
        tdSql.checkData(0, 0, expectedData)
        # TSIM: return -1
        # TSIM: endi
        # TSIM:
        # TSIM: print =============== step2
        tdLog.info('=============== step2')
        # TSIM: sql insert into $tb values ('2017-08-28 00:23:46.429+ 1a', 2)
        tdLog.info("insert into tb0 values ('2017-08-28 00:23:46.429+ 1a', 2)")
        tdSql.execute(
            "insert into tb0 values ('2017-08-28 00:23:46.429+ 1a', 2)")
        # TSIM: #sql insert into $tb values ('2017-08-28 00:23:46cd .429', 2)
        # TSIM: sql select ts from $tb
        tdLog.info('select ts from tb0')
        tdSql.query('select ts from tb0')
        # TSIM: if $rows != 2 then
        tdLog.info('tdSql.checkRow(2)')
        tdSql.checkRows(2)
        # TSIM: return -1
        # TSIM: endi
        # TSIM:
        # TSIM: print =============== step3
        tdLog.info('=============== step3')
        # TSIM: #sql insert into $tb values ('1970-01-01 08:00:00.000', 3)
        # TSIM: #sql insert into $tb values ('1970-01-01 08:00:00.000', 3)
        # TSIM: sql select ts from $tb
        tdLog.info('select ts from tb0')
        tdSql.query('select ts from tb0')
        # TSIM: if $rows != 2 then
        tdLog.info('tdSql.checkRow(2)')
        tdSql.checkRows(2)
        # TSIM: return -1
        # TSIM: endi
        # TSIM:
        # TSIM: print =============== step4
        tdLog.info('=============== step4')
        # TSIM: sql insert into $tb values(now, 4);
        tdLog.info("insert into tb0 values(now, 4);")
        tdSql.execute("insert into tb0 values(now, 4);")
        # TSIM: sql insert into $tb values(now+1a, 5);
        tdLog.info("insert into tb0 values(now+1a, 5);")
        tdSql.execute("insert into tb0 values(now+1a, 5);")
        # TSIM: sql insert into $tb values(now+1s, 6);
        tdLog.info("insert into tb0 values(now+1s, 6);")
        tdSql.execute("insert into tb0 values(now+1s, 6);")
        # TSIM: sql insert into $tb values(now+1m, 7);
        tdLog.info("insert into tb0 values(now+1m, 7);")
        tdSql.execute("insert into tb0 values(now+1m, 7);")
        # TSIM: sql insert into $tb values(now+1h, 8);
        tdLog.info("insert into tb0 values(now+1h, 8);")
        tdSql.execute("insert into tb0 values(now+1h, 8);")
        # TSIM: sql insert into $tb values(now+1d, 9);
        tdLog.info("insert into tb0 values(now+1d, 9);")
        tdSql.execute("insert into tb0 values(now+1d, 9);")
        # TSIM: sql_error insert into $tb values(now+3w, 10);
        tdLog.info("insert into tb0 values(now+3w, 10);")
        tdSql.error("insert into tb0 values(now+3w, 10);")
        # TSIM: sql_error insert into $tb values(now+1n, 11);
        tdLog.info("insert into tb0 values(now+1n, 11);")
        tdSql.error("insert into tb0 values(now+1n, 11);")
        # TSIM: sql_error insert into $tb values(now+1y, 12);
        tdLog.info("insert into tb0 values(now+1y, 12);")
        tdSql.error("insert into tb0 values(now+1y, 12);")
        # TSIM:
        # TSIM: print =============== step5
        tdLog.info('=============== step5')
        # TSIM: sql_error insert into $tb values ('9999-12-31 213:59:59.999',
        # 13)
        tdLog.info("insert into tb0 values ('9999-12-31 213:59:59.999', 13)")
        tdSql.error("insert into tb0 values ('9999-12-31 213:59:59.999', 13)")
        # TSIM: sql select ts from $tb
        tdLog.info('select ts from tb0')
        tdSql.query('select ts from tb0')
        # TSIM: print $rows
        tdLog.info('$rows')
        # TSIM: if $rows != 8 then
        tdLog.info('tdSql.checkRow(8)')
        tdSql.checkRows(8)
        # TSIM: return -1
        # TSIM: endi
        # TSIM:
        # TSIM: print =============== step6
        tdLog.info('=============== step6')
        # TSIM: sql_error insert into $tb values ('9999-12-99 23:59:59.999',
        # 13)
        tdLog.info("insert into tb0 values ('9999-12-99 23:59:59.999', 13)")
        tdSql.error("insert into tb0 values ('9999-12-99 23:59:59.999', 13)")
        # TSIM:
        # TSIM: sql select ts from $tb
        tdLog.info('select ts from tb0')
        tdSql.query('select ts from tb0')
        # TSIM: if $rows != 8 then
        tdLog.info('tdSql.checkRow(8)')
        tdSql.checkRows(8)
        # TSIM: return -1
        # TSIM: endi
        # TSIM:
        # TSIM: print =============== step7
        tdLog.info('=============== step7')
        # TSIM: $i = 1
        # TSIM: $tb = $tbPrefix . $i
        # TSIM: sql create table $tb (ts timestamp, ts2 timestamp)
        tdLog.info("create table tb1 (ts timestamp, ts2 timestamp)")
        tdSql.execute('create table tb1 (ts timestamp, ts2 timestamp)')
        # TSIM:
        # TSIM: print =============== step8
        tdLog.info('=============== step8')
        # TSIM: sql insert into $tb values (now, now)
        tdLog.info("insert into tb1 values (now, now)")
        tdSql.execute("insert into tb1 values (now, now)")
        # TSIM: sql select * from $tb
        tdLog.info('select * from tb1')
        tdSql.query('select * from tb1')
        # TSIM: if $rows != 1 then
        tdLog.info('tdSql.checkRow(1)')
        tdSql.checkRows(1)
        # TSIM: return -1
        # TSIM: endi
        # TSIM:
        # TSIM: sql drop database $db
        tdLog.info('drop database db')
        tdSql.execute('drop database db')
        # TSIM: sql show databases
        tdLog.info('show databases')
        tdSql.query('show databases')
        # TSIM: if $rows != 0 then
        tdLog.info('tdSql.checkRow(0)')
        tdSql.checkRows(0)
        # TSIM: return -1
        # TSIM: endi
# convert end

    def stop(self):
        tdSql.close()
        tdLog.success("%s successfully executed" % __file__)


tdCases.addWindows(__file__, TDTestCase())
tdCases.addLinux(__file__, TDTestCase())
