def test_determine_nonschema_privileges_for_schema_no_objects_of_objkind( cursor): dbcontext = DatabaseContext(cursor, verbose=True) actw, actr = core_generate.determine_nonschema_privileges_for_schema( 'role0', 'tables', ObjectName('schema0'), dbcontext) assert actw == set() assert actr == set()
def test_determine_nonschema_privileges_for_schema_no_writes_some_reads( cursor): dbcontext = DatabaseContext(cursor, verbose=True) actw, actr = core_generate.determine_nonschema_privileges_for_schema( 'role0', 'tables', 'schema0', dbcontext) assert actw == set() assert actr == set(['schema0."table0"'])
def test_determine_nonschema_privileges_for_schema_default_write_and_default_read( cursor): dbcontext = DatabaseContext(cursor, verbose=True) actw, actr = core_generate.determine_nonschema_privileges_for_schema( 'role0', 'tables', ObjectName('schema0'), dbcontext) assert actw == set([ObjectName('schema0', '*')]) assert actr == set()
def test_determine_nonschema_privileges_for_schema_no_objects_with_default_priv( cursor): dbcontext = DatabaseContext(cursor, verbose=True) actw, actr = core_generate.determine_nonschema_privileges_for_schema( 'role0', 'tables', 'schema0', dbcontext) assert actw == set() assert actr == set(['schema0.*'])