camper/revert/company_user_profile.sql

-- Revert camper:company_user_profile from pg

begin;

drop view if exists camper.company_user_profile;

commit;
Add admin page to list the users There is no way, for now, to add, edit or remove users, because currently we only need to list users. I can not give admins access to the user table, for security permissions, so i had to create a new view. I could name it also ‘user’ in ‘camper’ scheme, but then i was afraid i would have problems with unit tests and their search_path, so instead i called it ‘company_user_profile’, which is like ‘user_profile’ but for all users in ‘company_user’. I created a new Go package for it, rather than add the admin handler in ‘auth’, because ‘template’ depends on ‘auth’, and rendering from ‘auth’ would cause a dependency loop. I needed to have the roles in gettext to translate them, but there is no obvious place where to put the call to PgettextNoop. For now, there are in ‘NewAdminHandler’ because it is called once in the application’s lifetime and they actually do not matter much. 2024-01-17 18:42:47 +00:00			`-- Revert camper:company_user_profile from pg`

			`begin;`

			`drop view if exists camper.company_user_profile;`

			`commit;`