def test_unique_index(self):
self.assertEqual(column_definition_syntax.parseString("INT(11) UNIQUE").null, 'implicit')
self.assertFalse(column_definition_syntax.parseString("INT(11) UNIQUE").default)
self.assertFalse(column_definition_syntax.parseString("INT(11) UNIQUE").auto_increment)
self.assertEqual(column_definition_syntax.parseString("INT(11) UNIQUE").index_type, 'unique_key')
self.assertFalse(column_definition_syntax.parseString("INT(11) UNIQUE").comment)
self.assertEqual(column_definition_syntax.parseString("INT(11) UNIQUE KEY").null, 'implicit')
self.assertFalse(column_definition_syntax.parseString("INT(11) UNIQUE KEY").default)
self.assertFalse(column_definition_syntax.parseString("INT(11) UNIQUE KEY").auto_increment)
self.assertEqual(column_definition_syntax.parseString("INT(11) UNIQUE KEY").index_type, 'unique_key')
self.assertFalse(column_definition_syntax.parseString("INT(11) UNIQUE KEY").comment)
def test_primary_key(self):
self.assertEqual(column_definition_syntax.parseString("INT(11) KEY").null, 'implicit')
self.assertFalse(column_definition_syntax.parseString("INT(11) KEY").default)
self.assertFalse(column_definition_syntax.parseString("INT(11) KEY").auto_increment)
self.assertEqual(column_definition_syntax.parseString("INT(11) KEY").index_type, 'primary_key')
self.assertFalse(column_definition_syntax.parseString("INT(11) KEY").comment)
self.assertEqual(column_definition_syntax.parseString("INT(11) PRIMARY KEY").null, 'implicit')
self.assertFalse(column_definition_syntax.parseString("INT(11) PRIMARY KEY").default)
self.assertFalse(column_definition_syntax.parseString("INT(11) PRIMARY KEY").auto_increment)
self.assertEqual(column_definition_syntax.parseString("INT(11) PRIMARY KEY").index_type, 'primary_key')
self.assertFalse(column_definition_syntax.parseString("INT(11) PRIMARY KEY").comment)
def test_comment(self):
self.assertEqual(column_definition_syntax.parseString("VARCHAR(255) COMMENT 'test'").null, 'implicit')
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) COMMENT 'test'").default)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) COMMENT 'test'").auto_increment)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) COMMENT 'test'").index_type)
self.assertEqual(column_definition_syntax.parseString("VARCHAR(255) COMMENT 'test'").comment, 'test')
def test_auto_increment(self):
self.assertEqual(column_definition_syntax.parseString("INT(11) AUTO_INCREMENT").null, 'implicit')
self.assertFalse(column_definition_syntax.parseString("INT(11) AUTO_INCREMENT").default)
self.assertTrue(column_definition_syntax.parseString("INT(11) AUTO_INCREMENT").auto_increment)
self.assertFalse(column_definition_syntax.parseString("INT(11) AUTO_INCREMENT").index_type)
self.assertFalse(column_definition_syntax.parseString("INT(11) AUTO_INCREMENT").comment)
def test_nullable(self):
self.assertEqual(column_definition_syntax.parseString("VARCHAR(255)").null, 'implicit')
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NOT NULL").null)
self.assertTrue(column_definition_syntax.parseString("VARCHAR(255) NULL").null)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NOT NULL").default)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NULL").default)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NOT NULL").auto_increment)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NULL").auto_increment)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NOT NULL").index_type)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NULL").index_type)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NOT NULL").comment)
self.assertFalse(column_definition_syntax.parseString("VARCHAR(255) NULL").comment)
def test_order_three(self):
stmt = column_definition_syntax.parseString("INT(11) NOT NULL AUTO_INCREMENT COMMENT 'test'")
self.assertFalse(stmt.null)
self.assertEqual(stmt.index_type, '')
self.assertTrue(stmt.auto_increment)
self.assertEqual(stmt.comment, 'test')
def test_order_two(self):
stmt = column_definition_syntax.parseString("INT(11) AUTO_INCREMENT UNIQUE KEY NULL")
self.assertTrue(stmt.null)
self.assertEqual(stmt.index_type, 'unique_key')
self.assertTrue(stmt.auto_increment)
def test_order_one(self):
stmt = column_definition_syntax.parseString("INT(11) PRIMARY KEY AUTO_INCREMENT NOT NULL")
self.assertFalse(stmt.null)
self.assertEqual(stmt.index_type, 'primary_key')
self.assertTrue(stmt.auto_increment)
