@tomei/sso

SSO Package

$3

- run npm i
- Make sure you set the environment in .sampledotenv in your project .env file
- run npm run start:dev

$3

- Make sure you have DATABASE_URL and SHADOW_DATABASE_URL in your project .env file
- create a new empty database. dont do migration on it and set the SHADOW_DATABASE_URL to it
- Create a database user
- Grant the above user privileges to alter sso tables and shadow database. The user should have access to the sso table and shadow database only. Use create-sso-user.sql as an example to create the user and grant privileges
- Make changes to the schema.prisma file
- Run npx prisma migrate dev --name --preview-feature --create-only to create the migration. The migration will be created in the migrations folder.
- open the newly created migration. review the migration and make changes if necessary.

notes:
- if you create a new table, after migration has been created, change the default character set to latin1 from utf8mb4 and remove COLLATE phrase.please also add it to the create-sso-user.sql file for references

$3

- run npx prisma migrate deploy to run the migration
- run npx prisma generate to generate the prisma client