Esempio n. 1
0
 def test_PRIMARY_KEY_type(self):
     col = Constraint("CONSTRAINT `symbol` PRIMARY KEY USING BTREE (`index_col_name1`,`index_col_name2`),")
     self.assertTrue(isinstance(col, PrimaryKey))
     self.assertEqual(col.symbol, 'symbol')
     self.assertEqual(col.indextype, "USING BTREE")
     self.assertEqual(col.indexcols, ["index_col_name1", "index_col_name2"])
     self.assertEqual(col.sql(flavor="sqlite"), 'PRIMARY KEY ("index_col_name1", "index_col_name2")')
     self.assertIsNone(col.index("tbl_name", flavor="sqlite"))
Esempio n. 2
0
 def test_UNIQUE_KEY(self):
     col = Constraint("UNIQUE KEY `index_name` (`index_col_name`),")
     self.assertTrue(isinstance(col, Index))
     self.assertEqual(col.indexname, 'index_name')
     self.assertIsNone(col.indextype)
     self.assertEqual(col.indexcols, ["index_col_name"])
     self.assertIsNotNone(col.unique)
     self.assertEqual(col.sql(flavor="sqlite"), 'UNIQUE ("index_col_name")')
     self.assertIsNone(col.index("tbl_name", flavor="sqlite"))
Esempio n. 3
0
 def test_INDEX_2_type(self):
     col = Constraint("INDEX `index_name` USING HASH (`index_col_name1`,`index_col_name2`),")
     self.assertTrue(isinstance(col, Index))
     self.assertEqual(col.indexname, 'index_name')
     self.assertEqual(col.indextype, "USING HASH")
     self.assertEqual(col.indexcols, ["index_col_name1", "index_col_name2"])
     self.assertIsNone(col.unique)
     self.assertEqual(col.index("tbl_name", flavor="sqlite"), 'CREATE INDEX "index_name" ON "tbl_name" ("index_col_name1", "index_col_name2")')
     self.assertIsNone(col.sql(flavor="sqlite"))
Esempio n. 4
0
 def test_KEY_type(self):
     col = Constraint("KEY `index_name` USING BTREE (`index_col_name`),")
     self.assertTrue(isinstance(col, Index))
     self.assertEqual(col.indexname, 'index_name')
     self.assertEqual(col.indextype, "USING BTREE")
     self.assertEqual(col.indexcols, ["index_col_name"])
     self.assertIsNone(col.unique)
     self.assertEqual(col.index("tbl_name", flavor="sqlite"), 'CREATE INDEX "index_name" ON "tbl_name" ("index_col_name")')
     self.assertIsNone(col.sql(flavor="sqlite"))