def test_make_column_string_length(self):
c = sql.make_column(
table.Column(
0, 'test',
[u'this', u'is', u'test', u'data', u'that', u'is', u'awesome'
]))
self.assertEqual(c.type.length, 7)
def test_make_column_datetime(self):
c = sql.make_column(
table.Column(0, 'test', [
u'Jan 1, 2008 at 4:40 AM', u'2010-01-27T03:45:00',
u'3/1/08 16:14:45', ''
]))
self.assertEqual(type(c.type), DateTime)
def test_make_column_int(self):
c = sql.make_column(
table.Column(0, 'test', ['1', '-87', '418000000', '']))
self.assertEqual(c.key, 'test')
self.assertEqual(type(c.type), Integer)
def test_make_column_name(self):
c = sql.make_column(
table.Column(0, 'test', ['1', '-87', '418000000', '']))
self.assertEqual(c.key, 'test')
def test_column_has_nulls(self):
c = sql.make_column(table.Column(0, 'test', [u'1', u'-87', u'418000000', u'']))
self.assertEqual(c.key, 'test')
self.assertEqual(type(c.type), Integer)
self.assertEqual(c.nullable, True)
def test_make_column_string(self):
c = sql.make_column(table.Column(0, 'test', [u'this', u'is', u'test', u'data']))
self.assertEqual(type(c.type), String)
def test_make_column_time(self):
c = sql.make_column(table.Column(0, 'test', [u'4:40 AM', u'03:45:00', u'16:14:45', u'']))
self.assertEqual(type(c.type), Time)
def test_make_column_bool(self):
c = sql.make_column(table.Column(0, "test", [u"True", u"True", u"False", u""]))
self.assertEqual(type(c.type), Boolean)
def test_make_column_null(self):
c = sql.make_column(table.Column(0, "test", [u"", u"", u""]))
self.assertEqual(type(c.type), String)
def test_make_column_time(self):
c = sql.make_column(table.Column(0, "test", [u"4:40 AM", u"03:45:00", u"16:14:45", u""]))
self.assertEqual(type(c.type), Time)
def test_make_column_date(self):
c = sql.make_column(table.Column(0, "test", [u"Jan 1, 2008", u"2010-01-27", u"3/1/08", u""]))
self.assertEqual(type(c.type), Date)
def test_make_column_datetime(self):
c = sql.make_column(
table.Column(0, "test", [u"Jan 1, 2008 at 4:40 AM", u"2010-01-27T03:45:00", u"3/1/08 16:14:45", u""])
)
self.assertEqual(type(c.type), DateTime)
def test_make_column_float(self):
c = sql.make_column(table.Column(0, "test", [u"1.01", u"-87.34", u"418000000.0", u""]))
self.assertEqual(type(c.type), Float)
def test_make_column_int(self):
c = sql.make_column(table.Column(0, "test", [u"1", u"-87", u"418000000", u""]))
self.assertEqual(c.key, "test")
self.assertEqual(type(c.type), Integer)
def test_make_column_time(self):
c = sql.make_column(
table.Column(0, 'test', ['4:40 AM', '03:45:00', '16:14:45', '']))
self.assertEqual(type(c.type), Time)
def test_make_column_string(self):
c = sql.make_column(
table.Column(0, 'test', ['this', 'is', 'test', 'data']))
self.assertEqual(type(c.type), String)
def test_make_column_string(self):
c = sql.make_column(table.Column(0, "test", [u"this", u"is", u"test", u"data"]))
self.assertEqual(type(c.type), String)
def test_make_column_date(self):
c = sql.make_column(table.Column(0, 'test', [u'Jan 1, 2008', u'2010-01-27', u'3/1/08', u'']))
self.assertEqual(type(c.type), Date)
def test_make_column_string_length(self):
c = sql.make_column(table.Column(0, "test", [u"this", u"is", u"test", u"data", u"that", u"is", u"awesome"]))
self.assertEqual(c.type.length, 7)
def test_make_column_null(self):
c = sql.make_column(table.Column(0, 'test', [u'', u'', u'']))
self.assertEqual(type(c.type), String)
def test_column_no_nulls(self):
c = sql.make_column(table.Column(0, "test", [u"1", u"-87", u"418000000"]))
self.assertEqual(c.key, "test")
self.assertEqual(type(c.type), Integer)
self.assertEqual(c.nullable, False)
def test_make_column_string_length(self):
c = sql.make_column(table.Column(0, 'test', [u'this', u'is', u'test', u'data', u'that', u'is', u'awesome']))
self.assertEqual(c.type.length, 7)
def test_column_nullable(self):
c = sql.make_column(table.Column(0, 'test', ['1', '-87', '418000000', '']))
self.assertEqual(c.key, 'test')
self.assertEqual(type(c.type), Integer)
self.assertEqual(c.nullable, True)
def test_column_no_nulls(self):
c = sql.make_column(table.Column(0, 'test', [u'1', u'-87', u'418000000']))
self.assertEqual(c.key, 'test')
self.assertEqual(type(c.type), Integer)
self.assertEqual(c.nullable, False)
def test_make_column_name(self):
c = sql.make_column(table.Column(0, 'test', [u'1', u'-87', u'418000000', u'']))
self.assertEqual(c.key, 'test')
def test_make_column_bool(self):
c = sql.make_column(
table.Column(0, 'test', ['True', 'True', 'False', '']))
self.assertEqual(type(c.type), Boolean)
def test_make_column_bool(self):
c = sql.make_column(table.Column(0, 'test', [u'True', u'True', u'False', u'']))
self.assertEqual(type(c.type), Boolean)
def test_make_column_float(self):
c = sql.make_column(
table.Column(0, 'test', ['1.01', '-87.34', '418000000.0', '']))
self.assertEqual(type(c.type), Float)
def test_make_column_big_int(self):
c = sql.make_column(table.Column(0, 'test', [u'1', u'-87', u'418000000', u'2147483648']))
self.assertEqual(c.key, 'test')
self.assertEqual(type(c.type), BigInteger)
def test_make_column_date(self):
c = sql.make_column(
table.Column(0, 'test',
['Jan 1, 2008', '2010-01-27', '3/1/08', '']))
self.assertEqual(type(c.type), Date)
def test_make_column_float(self):
c = sql.make_column(table.Column(0, 'test', [u'1.01', u'-87.34', u'418000000.0', u'']))
self.assertEqual(type(c.type), Float)
def test_make_column_null(self):
c = sql.make_column(table.Column(0, 'test', ['', '', '']))
self.assertEqual(type(c.type), String)
def test_make_column_datetime(self):
c = sql.make_column(table.Column(0, 'test', [u'Jan 1, 2008 at 4:40 AM', u'2010-01-27T03:45:00', u'3/1/08 16:14:45', u'']))
self.assertEqual(type(c.type), DateTime)
def test_column_not_nullable(self):
c = sql.make_column(table.Column(0, 'test', ['1', '-87', '418000000']))
self.assertEqual(c.key, 'test')
self.assertEqual(type(c.type), Integer)
self.assertEqual(c.nullable, False)
def test_make_column_name(self):
c = sql.make_column(table.Column(0, "test", [u"1", u"-87", u"418000000", u""]))
self.assertEqual(c.key, "test")
