On Thu, Jan 18, 2018 at 1:35 PM, kris <[email protected]> wrote:
>
>
> Try to create a postgres specific option while creating index , pointer
> appreciated
>
> this link
> http://alembic.zzzcomputing.com/en/latest/ops.html#alembic.operations.Operations.create_index
> suggest I can pass dialect specific options
>
> def upgrade():
> op.drop_index('ix_taggable_resource_value', 'taggable')
> op.create_index('ix_taggable_resource_value', 'taggable', [
> 'resource_value' ],
> postgresql_ops = { 'resource_value', 'text_pattern_ops'
> } )
postgresql_ops should be a dictionary, not a set
>
>
> NFO [alembic.migration] Running upgrade 2cbd9f4d11af -> 318381ec60ba,
> indexes 4 deletes
> Traceback (most recent call last):
> File "/home/kgk/Envs/bq059/bin/alembic", line 11, in <module>
> sys.exit(main())
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/config.py",
> line 298, in main
> CommandLine(prog=prog).main(argv=argv)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/config.py",
> line 293, in main
> self.run_cmd(cfg, options)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/config.py",
> line 279, in run_cmd
> **dict((k, getattr(options, k)) for k in kwarg)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/command.py",
> line 124, in upgrade
> script.run_env()
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/script.py",
> line 199, in run_env
> util.load_python_file(self.dir, 'env.py')
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/util.py",
> line 205, in load_python_file
> module = load_module_py(module_id, path)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/compat.py",
> line 58, in load_module_py
> mod = imp.load_source(module_id, path, fp)
> File "./migrations/env.py", line 76, in <module>
> run_migrations_online()
> File "./migrations/env.py", line 69, in run_migrations_online
> context.run_migrations()
> File "<string>", line 7, in run_migrations
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/environment.py",
> line 681, in run_migrations
> self.get_context().run_migrations(**kw)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/migration.py",
> line 225, in run_migrations
> change(**kw)
> File "./migrations/versions/318381ec60ba_indexes_4_deletes.py", line 22,
> in upgrade
> postgresql_ops = { 'resource_value', 'text_pattern_ops' } )
> File "<string>", line 7, in create_index
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/operations.py",
> line 698, in create_index
> self._index(name, table_name, columns, schema=schema, **kw)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/ddl/impl.py",
> line 161, in create_index
> self._exec(schema.CreateIndex(index))
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/alembic/ddl/impl.py",
> line 76, in _exec
> conn.execute(construct, *multiparams, **params)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 945, in execute
> return meth(self, multiparams, params)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py",
> line 68, in _execute_on_connection
> return connection._execute_ddl(self, multiparams, params)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
> line 996, in _execute_ddl
> if not self.schema_for_object.is_default else None)
> File "<string>", line 1, in <lambda>
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py",
> line 436, in compile
> return self._compiler(dialect, bind=bind, **kw)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py",
> line 26, in _compiler
> return dialect.ddl_compiler(dialect, self, **kw)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py",
> line 216, in __init__
> self.string = self.process(self.statement, **compile_kwargs)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py",
> line 242, in process
> return obj._compiler_dispatch(self, **kwargs)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py",
> line 81, in _compiler_dispatch
> return meth(self, **kw)
> File
> "/home/kgk/Envs/bq059/local/lib/python2.7/site-packages/sqlalchemy/dialects/postgresql/base.py",
> line 1670, in visit_create_index
> for expr in index.expressions
> TypeError: 'set' object has no attribute '__getitem__'
> An Unknown exception occured There was a problem initializing the Database
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
