Python sqlalchemy.sql.func.lower() Examples
The following are 6
code examples of sqlalchemy.sql.func.lower().
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example.
You may also want to check out all available functions/classes of the module
sqlalchemy.sql.func
, or try the search function
.
Example #1
Source File: api.py From zun with Apache License 2.0 | 6 votes |
def _validate_unique_container_name(self, context, name): if not CONF.compute.unique_container_name_scope: return lowername = name.lower() base_query = model_query(models.Container).\ filter(func.lower(models.Container.name) == lowername) if CONF.compute.unique_container_name_scope == 'project': container_with_same_name = base_query.\ filter_by(project_id=context.project_id).count() elif CONF.compute.unique_container_name_scope == 'global': container_with_same_name = base_query.count() else: return if container_with_same_name > 0: raise exception.ContainerAlreadyExists(field='name', value=lowername)
Example #2
Source File: models.py From fence with Apache License 2.0 | 6 votes |
def add_foreign_key_constraint_if_not_exist( table_name, column_name, fk_table_name, fk_column_name, driver, metadata ): table = Table(table_name, metadata, autoload=True, autoload_with=driver.engine) foreign_key_name = "{}_{}_fkey".format(table_name.lower(), column_name) if column_name in table.c: foreign_keys = [fk.name for fk in getattr(table.c, column_name).foreign_keys] if foreign_key_name not in foreign_keys: with driver.session as session: session.execute( 'ALTER TABLE "{}" ADD CONSTRAINT {} ' 'FOREIGN KEY({}) REFERENCES "{}" ({});'.format( table_name, foreign_key_name, column_name, fk_table_name, fk_column_name, ) ) session.commit()
Example #3
Source File: models.py From fence with Apache License 2.0 | 5 votes |
def query_for_user(session, username): return ( session.query(User) .filter(func.lower(User.username) == username.lower()) .first() )
Example #4
Source File: models.py From fence with Apache License 2.0 | 5 votes |
def set_foreign_key_constraint_on_delete( table_name, column_name, fk_table_name, fk_column_name, ondelete, driver, session, metadata, ): with warnings.catch_warnings(): warnings.filterwarnings( "ignore", message="Predicate of partial index \S+ ignored during reflection", category=sa_exc.SAWarning, ) table = Table(table_name, metadata, autoload=True, autoload_with=driver.engine) foreign_key_name = "{}_{}_fkey".format(table_name.lower(), column_name) if column_name in table.c: session.execute( 'ALTER TABLE ONLY "{}" DROP CONSTRAINT IF EXISTS {}, ' 'ADD CONSTRAINT {} FOREIGN KEY ({}) REFERENCES "{}" ({}) ON DELETE {};'.format( table_name, foreign_key_name, foreign_key_name, column_name, fk_table_name, fk_column_name, ondelete, ) )
Example #5
Source File: models.py From fence with Apache License 2.0 | 5 votes |
def drop_foreign_key_constraint_if_exist(table_name, column_name, driver, metadata): table = Table(table_name, metadata, autoload=True, autoload_with=driver.engine) foreign_key_name = "{}_{}_fkey".format(table_name.lower(), column_name) if column_name in table.c: foreign_keys = [fk.name for fk in getattr(table.c, column_name).foreign_keys] if foreign_key_name in foreign_keys: with driver.session as session: session.execute( 'ALTER TABLE "{}" DROP CONSTRAINT {};'.format( table_name, foreign_key_name ) ) session.commit()
Example #6
Source File: puppet.py From mautrix-telegram with GNU Affero General Public License v3.0 | 5 votes |
def get_by_username(cls, username: str) -> Optional['Puppet']: return cls._select_one_or_none(func.lower(cls.c.username) == username)