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_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_null(self):
c = sql.make_column(table.Column(0, 'test', [u'', u'', u'']))
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_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_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_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_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_name(self):
c = sql.make_column(table.Column(0, 'test', [u'1', u'-87', u'418000000', u'']))
self.assertEqual(c.key, 'test')
