package data

import (
	"github.com/juju/errors"
)

// TypeTableSQL creates type table sql
func (d *GenCase) TypeTableSQL() error {
	sql := []string{`
		drop table if exists binlog_datatype;
	`,
		`
	create table  binlog_datatype (
		id int auto_increment,
		t_boolean boolean,
		t_bigint BIGINT,
		t_double DOUBLE,
		t_decimal DECIMAL(38,19),
		t_bit BIT(64),
		t_date DATE,
		t_datetime DATETIME,
		t_timestamp TIMESTAMP NULL,
		t_time TIME,
		t_year YEAR,
		t_char CHAR,
		t_varchar VARCHAR(10),
		t_blob BLOB,
		t_text TEXT,
		t_enum ENUM('enum1', 'enum2', 'enum3'),
		t_set SET('a', 'b', 'c'),
		t_json JSON,
		primary key(id)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
	`}
	err := execSQLs(d.db, sql)
	if err != nil {
		return errors.Trace(err)
	}

	return errors.Trace(execSQLs(d.db, d.typeCrud()))
}

func (d *GenCase) typeCrud() []string {
	return []string{
		`
insert into binlog_datatype(t_boolean, t_bigint, t_double, t_decimal, t_bit
	,t_date, t_datetime, t_timestamp, t_time, t_year
	,t_char, t_varchar, t_blob, t_text, t_enum
	,t_set, t_json) values
	(true, 9223372036854775807, 123.123, 123456789012.123456789012, b'1000001'
	,'1000-01-01', '9999-12-31 23:59:59', '19731230153000', '23:59:59', 1970
	,'测', '测试', 'blob', '测试text', 'enum2'
	,'a,b', NULL);
`,
		`
insert into binlog_datatype(t_boolean) values(TRUE);
`,
		`
insert into binlog_datatype(t_boolean) values(FALSE);
`,
		// minmum value of bigint
		`
insert into binlog_datatype(t_bigint) values(-9223372036854775808);
`,
		// maximum value of bigint
		`
insert into binlog_datatype(t_bigint) values(9223372036854775807);
`,
		`
insert into binlog_datatype(t_json) values('{"key1": "value1", "key2": "value2"}');
`,
	}
}