// EXEC: cjc %import-path %L %l %f
// EXEC: ./main
import mysqlclient_ffi.*
import std.unittest.*
import std.unittest.testmacro.*
import std.database.sql.*
import std.time.*
import std.math.*

main(): Int64 {
    let mysqlSqlDateTimeTest: MysqlSqlDateTimeTest = MysqlSqlDateTimeTest()

    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest01()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest02()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest03()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest04()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest05()

    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest06()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest07()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest08()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest09()
    mysqlSqlDateTimeTest.mysqlSqlDateTimeTest10()

    return 0
}

@Test
public class MysqlSqlDateTimeTest {
    @TestCase
    public func mysqlSqlDateTimeTest01(): Unit {
        let dateTime: DateTime = DateTime.nowUTC()
        let sqlDateTime: SqlDateTime = SqlDateTime(dateTime)
        @Assert("SqlTimestampWithoutTz", sqlDateTime.name)
        let dateTime1: DateTime = sqlDateTime.value
        @Assert(dateTime.year, dateTime1.year)
        @Assert(dateTime.monthValue, dateTime1.monthValue)
        @Assert(dateTime.dayOfMonth, dateTime1.dayOfMonth)
    }

    @TestCase
    public func mysqlSqlDateTimeTest02(): Unit {
        let dateTime: DateTime = DateTime.nowUTC()
        let sqlDateTime: SqlDateTime = SqlDateTime(dateTime)
        @Assert("SqlTimestampWithoutTz", sqlDateTime.name)
        sqlDateTime.value = DateTime.of(year: 2002, month: 10, dayOfMonth: 20)
        let dateTime1: DateTime = sqlDateTime.value
        @Assert(2002, dateTime1.year)
        @Assert(10, dateTime1.monthValue)
        @Assert(20, dateTime1.dayOfMonth)
    }

    @TestCase
    public func mysqlSqlDateTimeTest03(): Unit {
        let dateTime: DateTime = DateTime.of(year: 2002, month: 10, dayOfMonth: 20)
        let sqlDateTime: SqlDateTime = SqlDateTime(dateTime)
        @Assert("SqlTimestampWithoutTz", sqlDateTime.name)
        let dateTime1: DateTime = sqlDateTime.value
        @Assert(2002, dateTime1.year)
        @Assert(10, dateTime1.monthValue)
        @Assert(20, dateTime1.dayOfMonth)
    }

    @TestCase
    public func mysqlSqlDateTimeTest04(): Unit {
        let dateTime: DateTime = DateTime.of(year: 2002, month: 10, dayOfMonth: 20)
        let sqlDateTime: SqlDateTime = SqlDateTime(dateTime)
        @Assert("SqlTimestampWithoutTz", sqlDateTime.name)
        sqlDateTime.value = DateTime.of(year: 2012, month: 6, dayOfMonth: 1)
        let dateTime1: DateTime = sqlDateTime.value
        @Assert(2012, dateTime1.year)
        @Assert(6, dateTime1.monthValue)
        @Assert(1, dateTime1.dayOfMonth)
    }

    @TestCase
    public func mysqlSqlDateTimeTest05(): Unit {
        let dateTime: DateTime = DateTime.of(year: 2002, month: 10, dayOfMonth: 20, hour: 10, minute: 20, second: 30)
        let sqlDateTime: SqlDateTime = SqlDateTime(dateTime)
        @Assert("SqlTimestampWithoutTz", sqlDateTime.name)
        sqlDateTime.value = DateTime.of(year: 2012, month: 6, dayOfMonth: 1, hour: 11, minute: 21, second: 31)
        let dateTime1: DateTime = sqlDateTime.value
        @Assert(2012, dateTime1.year)
        @Assert(6, dateTime1.monthValue)
        @Assert(1, dateTime1.dayOfMonth)
        @Assert(11, dateTime1.hour)
        @Assert(21, dateTime1.minute)
        @Assert(31, dateTime1.second)
    }

    @TestCase
    public func mysqlSqlDateTimeTest06(): Unit {
        let dateTime: DateTime = DateTime.nowUTC()
        let sqlDateTime: SqlDateTime = SqlDateTime(dateTime)
        @Assert("SqlTimestampWithoutTz", sqlDateTime.name)
        let dateTime1: DateTime = sqlDateTime.value
        @Assert(dateTime.year, dateTime1.year)
        @Assert(dateTime.monthValue, dateTime1.monthValue)
        @Assert(dateTime.dayOfMonth, dateTime1.dayOfMonth)
        @Assert(dateTime.dayOfMonth, dateTime1.dayOfMonth)
        @Assert(dateTime.hour, dateTime1.hour)
        @Assert(dateTime.minute, dateTime1.minute)
        @Assert(dateTime.second, dateTime1.second)
    }

    @TestCase
    public func mysqlSqlDateTimeTest07(): Unit {
        let sqlNullableDateTime: SqlNullableDateTime = SqlNullableDateTime(None)
        @Assert("SqlNullableTimestampWithoutTz", sqlNullableDateTime.name)
        let dateTime1: ?DateTime = sqlNullableDateTime.value
        match (dateTime1) {
            case Some(_) => @Assert(0, 1)
            case None => @Assert(1, 1)
        }
    }

    @TestCase
    public func mysqlSqlDateTimeTest08(): Unit {
        let sqlNullableDateTime: SqlNullableDateTime = SqlNullableDateTime(None)
        @Assert("SqlNullableTimestampWithoutTz", sqlNullableDateTime.name)
        let dateTime1: ?DateTime = sqlNullableDateTime.value
        match (dateTime1) {
            case Some(_) => @Assert(0, 1)
            case None => @Assert(1, 1)
        }
        sqlNullableDateTime.value = DateTime.nowUTC()
        let dateTime2: ?DateTime = sqlNullableDateTime.value
        match (dateTime2) {
            case Some(_) => @Assert(1, 1)
            case None => @Assert(0, 1)
        }
    }

    @TestCase
    public func mysqlSqlDateTimeTest09(): Unit {
        let dateTime: DateTime = DateTime.nowUTC()
        let sqlNullableDateTime: SqlNullableDateTime = SqlNullableDateTime(dateTime)
        @Assert("SqlNullableTimestampWithoutTz", sqlNullableDateTime.name)
        let dateTime1: DateTime = sqlNullableDateTime.value.getOrThrow()
        @Assert(dateTime.year, dateTime1.year)
        @Assert(dateTime.monthValue, dateTime1.monthValue)
        @Assert(dateTime.dayOfMonth, dateTime1.dayOfMonth)
    }

    @TestCase
    public func mysqlSqlDateTimeTest10(): Unit {
        let dateTime: DateTime = DateTime.nowUTC()
        let sqlNullableDateTime: SqlNullableDateTime = SqlNullableDateTime(dateTime)
        @Assert("SqlNullableTimestampWithoutTz", sqlNullableDateTime.name)
        let dateTime1: DateTime = sqlNullableDateTime.value.getOrThrow()
        @Assert(dateTime.year, dateTime1.year)
        @Assert(dateTime.monthValue, dateTime1.monthValue)
        @Assert(dateTime.dayOfMonth, dateTime1.dayOfMonth)
        @Assert(dateTime.dayOfMonth, dateTime1.dayOfMonth)
        @Assert(dateTime.hour, dateTime1.hour)
        @Assert(dateTime.minute, dateTime1.minute)
        @Assert(dateTime.second, dateTime1.second)
    }
}