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)