This release supports SQLAlchemy 2.0 or later
get_all_parameter_aclsget_parameter_aclPgOjectType.DOMAINPgOjectType.PARAMETER
- Python 3.8 or later is required.
- The following arguments for
grantandrevokeare now keyword-only:grant_optionschemaarg_typesquote_subname
- The following arguments for
as_grant_statementsandas_revoke_statementsare now keyword-only:schemaarg_typesquote_subname
- The
type_parameter foras_grant_statementsandas_revoke_statementswas renamed totype. - Installing
pg-grant[sqlalchemy]no longer installs psycopg2. Make sure you depend on a driver likesqlalchemy[postgresql](psycopg2) orsqlalchemy[postgresql_psycopg](psycopg 3).
pg_grant.__version__, useimportlib.metadatainstead.pg_grant.__description__, useimportlib.metadatainstead.pg_grant.__license__, useimportlib.metadatainstead.pg_grant.__author__, useimportlib.metadatainstead.pg_grant.__email__, useimportlib.metadatainstead.
This release supports SQLAlchemy 1.4 and 2.0. The next release will require SQLAlchemy 2.0 or later
- Python 3.6 or later is required.
This release supports SQLAlchemy 1.3 and 1.4. The next release will require SQLAlchemy 1.4 or later
- ACLs for functions without any arguments (i.e.
arg_types=()) could not be queried usingget_function_acl.
0.3.2 - 2020-05-21
- Type annotations for
parse_aclandparse_acl_item.
0.3.1 - 2018-01-17
pg_grantcan be installed with setuptools v38.0+, which requiresinstall_requiresinsetup.pyto be ordered.
0.3.0 - 2017-10-31
parse_aclfunction to callparse_acl_itemon each item in a list.- Documentation on
parse_acl_itemabout ensuringsubnameis a valid identifier if it is to be executed. get_all_column_aclsandget_column_aclsto get column ACLs.
- Renamed singular functions like
get_table_aclstoget_table_acl. get_all_table_aclsandget_table_aclalso return views, materialized views, partitioned tables (PostgreSQL 10+), and foreign tables.grantandrevokewill quote the subname in privileges by default, to ensure it is a valid identifier. Usequote_subname=Falseto disable.Privileges.as_revoke_statementswill revoke the privileges with grant options fully.get_all_function_aclsandget_function_aclnow return canonical type names, e.g. 'integer' instead of 'int4'. Thearg_typesparameter onget_function_aclalso canonicalizes user input.
0.2.0.post0 - 2017-10-24
Minor packaging changes.
0.2.0 - 2017-10-24
First release.