29
29
self.assert_compile(x,
30
30
'''SELECT mysql_table.col1, mysql_table.`master_ssl_verify_server_cert` FROM mysql_table''')
32
def test_create_index_simple(self):
34
tbl = Table('testtbl', m, Column('data', String(255)))
35
idx = Index('test_idx1', tbl.c.data)
37
self.assert_compile(schema.CreateIndex(idx),
38
'CREATE INDEX test_idx1 ON testtbl (data)',
39
dialect=mysql.dialect())
32
41
def test_create_index_with_length(self):
34
43
tbl = Table('testtbl', m, Column('data', String(255)))
35
idx = Index('test_idx1', tbl.c.data,
37
idx2 = Index('test_idx2', tbl.c.data,
40
self.assert_compile(schema.CreateIndex(idx),
41
'CREATE INDEX test_idx1 ON testtbl (data(10))',
42
dialect=mysql.dialect())
43
self.assert_compile(schema.CreateIndex(idx2),
44
"CREATE INDEX test_idx2 ON testtbl (data(5))",
45
dialect=mysql.dialect())
44
idx1 = Index('test_idx1', tbl.c.data, mysql_length=10)
45
idx2 = Index('test_idx2', tbl.c.data, mysql_length=5)
47
self.assert_compile(schema.CreateIndex(idx1),
48
'CREATE INDEX test_idx1 ON testtbl (data(10))',
49
dialect=mysql.dialect())
50
self.assert_compile(schema.CreateIndex(idx2),
51
'CREATE INDEX test_idx2 ON testtbl (data(5))',
52
dialect=mysql.dialect())
54
def test_create_index_with_using(self):
56
tbl = Table('testtbl', m, Column('data', String(255)))
57
idx1 = Index('test_idx1', tbl.c.data, mysql_using='btree')
58
idx2 = Index('test_idx2', tbl.c.data, mysql_using='hash')
60
self.assert_compile(schema.CreateIndex(idx1),
61
'CREATE INDEX test_idx1 ON testtbl (data) USING btree',
62
dialect=mysql.dialect())
63
self.assert_compile(schema.CreateIndex(idx2),
64
'CREATE INDEX test_idx2 ON testtbl (data) USING hash',
65
dialect=mysql.dialect())
67
def test_create_pk_plain(self):
69
tbl = Table('testtbl', m, Column('data', String(255)),
70
PrimaryKeyConstraint('data'))
72
self.assert_compile(schema.CreateTable(tbl),
73
"CREATE TABLE testtbl (data VARCHAR(255), PRIMARY KEY (data))",
74
dialect=mysql.dialect())
76
def test_create_pk_with_using(self):
78
tbl = Table('testtbl', m, Column('data', String(255)),
79
PrimaryKeyConstraint('data', mysql_using='btree'))
81
self.assert_compile(schema.CreateTable(tbl),
82
"CREATE TABLE testtbl (data VARCHAR(255), "
83
"PRIMARY KEY (data) USING btree)",
84
dialect=mysql.dialect())
47
86
class DialectTest(fixtures.TestBase):
48
87
__only_on__ = 'mysql'