def visit_create_index(self, create, include_schema=False, include_table_schema=True):
    index = create.element
    self._verify_index_table(index)
    preparer = self.preparer
    text = 'CREATE '
    if index.unique:
        text += 'UNIQUE '
    text += 'INDEX '
    if create.if_not_exists:
        text += 'IF NOT EXISTS '
    text += ('%s ON %s (%s)' % (self._prepared_index_name(index, include_schema=True), preparer.format_table(index.table, use_schema=False), ', '.join((self.sql_compiler.process(expr, include_table=False, literal_binds=True) for expr in index.expressions))))
    whereclause = index.dialect_options['sqlite']['where']
    if (whereclause is not None):
        where_compiled = self.sql_compiler.process(whereclause, include_table=False, literal_binds=True)
        text += (' WHERE ' + where_compiled)
    return text
def visit_create_index(self, create, include_schema=False, include_table_schema=True):
    index = create.element
    self._verify_index_table(index)
    preparer = self.preparer
    text = 'CREATE '
    if index.unique:
        text += 'UNIQUE '
    text += 'INDEX '
    if create.if_not_exists:
        text += 'IF NOT EXISTS '
    text += ('%s ON %s (%s)' % (self._prepared_index_name(index, include_schema=True), preparer.format_table(index.table, use_schema=False), ', '.join((self.sql_compiler.process(expr, include_table=False, literal_binds=True) for expr in index.expressions))))
    whereclause = index.dialect_options['sqlite']['where']
    if (whereclause is not None):
        where_compiled = self.sql_compiler.process(whereclause, include_table=False, literal_binds=True)
        text += (' WHERE ' + where_compiled)
    return text