def test_create_index_with_length(self):
m = MetaData()
tbl = Table('testtbl', m, Column('data', String(255)))
idx1 = Index('test_idx1', tbl.c.data, length=10)
idx2 = Index('test_idx2', tbl.c.data, length=5)
self.assert_compile(schema.CreateIndex(idx1),
'CREATE INDEX test_idx1 ON testtbl ([data](10))',
dialect=cubrid.dialect())
self.assert_compile(schema.CreateIndex(idx2),
'CREATE INDEX test_idx2 ON testtbl ([data](5))',
dialect=cubrid.dialect())
def test_create_index_with_desc(self):
m = MetaData()
tbl = Table('testtbl', m, Column('data', String(255)))
idx1 = Index('test_idx1', tbl.c.data, desc=True)
idx2 = Index('test_idx2', tbl.c.data, desc=False)
self.assert_compile(schema.CreateIndex(idx1),
'CREATE INDEX test_idx1 ON testtbl ([data]) DESC',
dialect=cubrid.dialect())
self.assert_compile(schema.CreateIndex(idx2),
'CREATE INDEX test_idx2 ON testtbl ([data])',
dialect=cubrid.dialect())
def test_create_pk_plain(self):
m = MetaData()
tbl = Table('testtbl', m, Column('pk_data', String(255)),
PrimaryKeyConstraint('pk_data'))
self.assert_compile(schema.CreateTable(tbl),
"CREATE TABLE testtbl (pk_data VARCHAR(255), PRIMARY KEY (pk_data))",
dialect=cubrid.dialect())
def test_create_index_simple(self):
m = MetaData()
tbl = Table('testtbl', m, Column('data', String(255)))
idx = Index('test_idx1', tbl.c.data)
self.assert_compile(schema.CreateIndex(idx),
'CREATE INDEX test_idx1 ON testtbl ([data])',
dialect=cubrid.dialect())