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)