def drop_role(ctx, role_name, **kwargs):
utils.connect(ctx)
qry = f'''
DROP ROLE {qi(role_name)};
'''
try:
ctx.obj['conn'].execute(qry)
except edgedb.EdgeDBError as e:
raise click.ClickException(str(e)) from e
def alter_role(ctx, role_name, **kwargs):
utils.connect(ctx)
attrs = ";\n".join(_process_role_options(ctx, **kwargs))
qry = f'''
ALTER ROLE {qi(role_name)} {{
{attrs}
}}
'''
try:
ctx.obj['conn'].execute(qry)
except edgedb.EdgeDBError as e:
raise click.ClickException(str(e)) from e
def create_role(ctx, role_name, **kwargs):
utils.connect(ctx)
attrs = ";\n".join(_process_role_options(ctx, allow_empty=True, **kwargs))
if attrs:
formatted_attrs = f'''
{{
{attrs}
}}
'''
else:
formatted_attrs = ''
qry = f'''
CREATE SUPERUSER ROLE {qi(role_name)} {formatted_attrs}
'''
try:
ctx.obj['conn'].execute(qry)
except edgedb.EdgeDBError as e:
raise click.ClickException(str(e)) from e
def configure(ctx):
utils.connect(ctx)
