def test_date_time_column_type_exception(self):
try:
_MySQLDateTimeColumn('abc').date_time_type(-1)
self.fail('Was able to set a date time type even though the type '
+ 'ID provided was invalid.')
except TableBuilderException as e:
self.assertEqual('the type ID provided was invalid',
e.get_message())
def test_date_time_column_type_exception(self):
try:
_MySQLDateTimeColumn('abc').date_time_type(-1)
self.fail('Was able to set a date time type even though the type '
+ 'ID provided was invalid.')
except TableBuilderException as e:
self.assertEqual('the type ID provided was invalid',
e.get_message())
def test_date_time_column_time(self):
self.assertEqual(
"abcdef time not null unique default \'1\'",
_MySQLDateTimeColumn('abcdef')
.date_time_type(_MySQLDateTimeColumn.TYPE_TIME)
.default_value(1)
.not_null()
.unique()
.get_definition())
def test_date_time_column_time(self):
self.assertEqual(
"abcdef time not null unique default \'1\'",
_MySQLDateTimeColumn('abcdef')
.date_time_type(_MySQLDateTimeColumn.TYPE_TIME)
.default_value(1)
.not_null()
.unique()
.get_definition())
def test_date_time_column_year_4(self):
self.assertEqual(
"abcdef year(4) not null unique default \'1\'",
_MySQLDateTimeColumn('abcdef')
.date_time_type(_MySQLDateTimeColumn.TYPE_YEAR)
.precision(4)
.default_value(1)
.not_null()
.unique()
.get_definition())
def test_date_time_column_year_4(self):
self.assertEqual(
"abcdef year(4) not null unique default \'1\'",
_MySQLDateTimeColumn('abcdef')
.date_time_type(_MySQLDateTimeColumn.TYPE_YEAR)
.precision(4)
.default_value(1)
.not_null()
.unique()
.get_definition())