def test_sql_create_from_json(self):
"""
Build the column part of index
"""
idx = {'name': 'compo1',
'table': 'editors',
'columns': ['id', 'name'],
'tablespace': 'ssd1'}
res = " ".join(["CREATE INDEX CONCURRENTLY compo1",
"ON editors (id,name)",
"TABLESPACE ssd1"])
self.assertEqual(util.sql_create_from_json(idx), res)
def test_sql_create_from_json_opclass(self):
"""
Build the column part of index with an operator class
"""
idx = {'name': 'compo1',
'table': 'editors',
'columns': [{'name': 'gist_trgm_ops'},
{'species': 'gist_trgm_ops'}],
'using': 'GIST'}
res = " ".join(["CREATE INDEX CONCURRENTLY compo1",
"ON editors USING GIST",
"(name gist_trgm_ops,species gist_trgm_ops)"])
self.assertEqual(util.sql_create_from_json(idx), res)