Xiao Yijun
b92508db3a
feat(core,schemas): support get hook recent logs ( #3859 )
2023-05-22 19:01:54 +08:00
Xiao Yijun
8fc5b78def
refactor(schemas): update hook schema ( #3788 )
2023-05-09 09:25:45 +08:00
Darcy Ye
632b8b1d84
refactor(schemas,core,console): use JsonObject instead of ArbitraryObject ( #3730 )
2023-04-24 11:11:27 +08:00
Darcy Ye
ad3611f5a0
refactor(schemas,core,toolkit): remove connector db storage and disable access ( #3505 )
2023-03-19 11:45:13 +00:00
wangsijie
47881b6d6e
feat(schemas): add service logs table ( #3390 )
2023-03-14 15:15:45 +08:00
simeng-li
57eb6ee452
feat(schemas,ui): add custom content slot ( #3369 )
2023-03-14 03:06:01 +00:00
Gao Sun
fa85b7d0eb
refactor: remove withtyped in core ( #3375 )
...
Keeping withtyped will introduce an additional database pool per tenant,
which is not good for performance and it should be more like all-or-nothing choice.
So remove it for core, but keep it in cloud.
2023-03-13 04:01:14 +00:00
Charles Zhao
9896390065
fix(core,schemas): remove sessionId usage from verification status table ( #3345 )
2023-03-13 11:20:52 +08:00
Gao Sun
c5da152ddc
refactor: hide internal roles for user tenants
...
introduce internal roles which name starts with #internal:
with RLS policies to make them read-only.
2023-03-09 00:07:33 +08:00
Gao Sun
bdd7374d31
refactor(schemas): use restrictive policies
...
for enhanced security and scalability. restrictive policies can
be combined with permissive policies for advanced use cases.
2023-03-08 19:16:42 +08:00
Charles Zhao
43470c41f1
fix(core,schemas): add new verification status table ( #3312 )
2023-03-08 15:21:59 +08:00
simeng-li
05ada94f95
feat(core,console,schemas,phrases): add privacy policy url ( #3315 )
2023-03-08 10:56:26 +08:00
Gao Sun
1ef5519e75
feat: custom css ( #3155 )
2023-02-21 10:55:44 +08:00
Darcy Ye
a13d27a018
feat: enabled connector db read and write ( #3127 )
2023-02-20 18:54:02 +08:00
Gao Sun
76a04d97b3
feat(cloud): POST /tenants
2023-02-20 00:27:12 +08:00
Gao Sun
7a7d7f9f41
refactor: add alteration scripts
2023-02-12 18:43:02 +08:00
Gao Sun
0481a450be
refactor: decouple admin tenant and user tenant
2023-02-11 14:38:16 +08:00
Gao Sun
2af6fd114a
refactor!: add admin tenant
2023-02-10 13:06:52 +08:00
Gao Sun
6b09da2f5d
refactor: fix alteration
2023-02-09 18:31:14 +08:00
Gao Sun
99837b4e48
refactor: use RLS
2023-02-08 18:58:45 +08:00
Gao Sun
d0399eb8a4
refactor!: merge settings into logto configs table
2023-01-29 19:42:19 +08:00
Gao Sun
de4b0bae16
refactor: add function and trigger to set tenant_id
2023-01-28 19:26:29 +08:00
Gao Sun
54db878760
refactor: re-org alteration scripts
2023-01-28 12:58:42 +08:00
Gao Sun
ba44eb5fc6
refactor(schemas): init tenant sqls
2023-01-28 12:58:42 +08:00
wangsijie
ece866db7c
feat!: migrate application role names to RBAC ( #2972 )
2023-01-18 15:38:36 +08:00
wangsijie
92968c49dd
fix(schemas): set scope description to required ( #2954 )
2023-01-17 18:04:49 +08:00
simeng-li
3ff6554c08
refactor(core,console,schemas): remove logDto ( #2889 )
2023-01-10 05:57:24 +00:00
wangsijie
34aab882c3
feat(core): scope name within the same resource should be unique ( #2861 )
2023-01-10 05:15:48 +00:00
Charles Zhao
0decdb796d
refactor(schemas): alter passcodes table and set jti to nullable
2023-01-06 22:47:29 +08:00
wangsijie
f371a61460
feat(core): role-scope api ( #2826 )
2023-01-06 15:37:00 +08:00
wangsijie
cf900d4aef
feat(core): resource scopes crud ( #2757 )
2023-01-05 15:24:24 +08:00
wangsijie
61f4e7fd2d
feat: add users_roles table and remove role_names ( #2525 )
2023-01-04 15:39:27 +08:00
Gao Sun
01f718b258
refactor!: align PasscodeType to MessageTypes
...
refactor: apply suggestions from code review
Co-authored-by: Darcy Ye <darcyye@silverhand.io>
refactor(core): fix type names
2022-12-27 15:29:06 +08:00
Gao Sun
c24a57f2c4
refactor: update log types in database and console
2022-12-20 13:47:12 +08:00
Xiao Yijun
bc5f4b541a
refactor: replace termsOfUse with termsOfUseUrl ( #2665 )
2022-12-15 17:04:42 +08:00
Gao Sun
93cd6a27d0
refactor(schemas): add name index on users ( #2668 )
2022-12-15 10:50:48 +08:00
Darcy Ye
7ba40a7782
feat: remove enabled from table connectors ( #2513 )
2022-11-28 18:37:24 +08:00
wangsijie
3f41278a24
feat(schemas): add roles and permissions ( #2494 )
2022-11-24 11:09:03 +08:00
Darcy Ye
8a7a9e418e
feat: update connectors table and load connector logic ( #2468 )
...
Co-authored-by: wangsijie <wangsijie@silverhand.io>
2022-11-18 12:06:53 +08:00
wangsijie
854e373b81
Merge branch 'master' into merge/suspend
2022-11-09 11:05:32 +08:00
wangsijie
e699e3fb62
fix(core,schemas): fix email and sms verification for continue route ( #2349 )
2022-11-08 22:59:43 +08:00
wangsijie
73bb938c3c
feat(schemas): add user is suspended column ( #2305 )
...
Co-authored-by: Gao Sun <gao@silverhand.io>
2022-11-04 10:10:01 +08:00
wangsijie
5e571936c9
chore: remove old sign in methods ( #2295 )
2022-11-03 18:23:12 +08:00
wangsijie
1c50efe632
feat: remove forgot password control ( #2291 )
2022-11-03 10:31:57 +08:00
wangsijie
5959372325
Merge branch master into merge/sie-v2
...
merge
2022-10-21 10:43:56 +08:00
wangsijie
06ae2aff15
Revert "chore: merge master into sie-v2 ( #2182 )" ( #2216 )
2022-10-20 17:03:18 +08:00
wangsijie
e5f8139880
chore: merge master into sie-v2 ( #2182 )
...
Co-authored-by: Xiao Yijun <xiaoyijun@silverhand.io>
Co-authored-by: IceHe <icehe@silverhand.io>
Co-authored-by: Gao Sun <gao@silverhand.io>
Co-authored-by: simeng-li <simeng@silverhand.io>
Co-authored-by: Charles Zhao <charleszhao@silverhand.io>
Co-authored-by: Mahesh Vagicherla <59088937+b4s36t4@users.noreply.github.com>
Co-authored-by: FlurryNight <47457170+FlurryNight@users.noreply.github.com>
Co-authored-by: Lukas <lukas@slucky.de>
Co-authored-by: renovate[bot] <29139614+renovate[bot]@users.noreply.github.com>
2022-10-18 15:44:49 +08:00
Gao Sun
696e7f181d
chore: merge branch 'master' into feature/manage-language
2022-10-10 15:52:06 +08:00
wangsijie
78eca37e87
feat(schemas): add sie2 schema ( #2056 )
2022-10-09 15:31:40 +08:00
IceHe
3eb44e1e56
refactor(core,console,phrases,schemas): replace language key with language tag ( #2026 )
2022-09-30 10:30:32 +08:00
IceHe
cce2d40160
refactor(core): count new users by created_at ( #2027 )
2022-09-29 15:32:43 +08:00
Gao Sun
cd9c6978a3
feat(core): machine to machine apps
2022-09-22 22:12:16 +08:00
wangsijie
577ca48c07
feat(schemas): add logto configs table ( #1940 )
2022-09-15 17:39:49 +08:00
IceHe
7242aa8c2b
feat(core,schemas): add phrases schema and GET /custom-phrases/:languageKey route ( #1905 )
2022-09-13 17:36:37 +08:00
Wang Sijie
543ee04f53
feat(core,schemas): add application secret ( #1715 )
2022-08-02 16:18:50 +08:00
simeng-li
4d7a091d24
refactor(core): adjust access token ttl ( #1430 )
...
adjust access token ttl
2022-07-06 20:33:32 +08:00
Wang Sijie
2c413341d1
feat(console): sie form reorg ( #1218 )
2022-06-24 02:26:30 +00:00
IceHe.xyz
3ac01d72f9
feat(schemas): make users.avatar URL length 2048 ( #1141 )
2022-06-17 17:04:04 +08:00
simeng-li
f640dad52f
feat(core): add sign-in-mode ( #1132 )
...
* feat(core): add sign-in-mode
add sign-in-mode
* fix(core): remove console.log
remove console.log
* fix(ui): hide secondary signin section
hide secondary signin section if is under register mode
* fix(core): ci fix
ci fix
2022-06-17 10:36:07 +08:00
IceHe.xyz
9d8ef7632b
fix(schemas): remove user foreign key on application id ( #964 )
2022-05-26 17:44:32 +08:00
IceHe.xyz
bf6e08c372
feat(schemas): create log indices on application id and user id ( #933 )
2022-05-25 12:59:35 +08:00
Darcy Ye
054b0f7b6a
feat: remove target, platform from connector schema and add id to metadata ( #930 )
...
* feat(core,schema,connectors): remove target,platform form connector schema and add id to metadata
* feat(schema,ui,console): unwrap ConnectorMetadata in ConnectorDTO
* feat(schema,ui,console): connector id use dashline instead of underscore
* feat(connector-alipay*): fix typos
* feat(connector-alipay*): remove unnecessary type declaration
2022-05-24 11:39:44 +08:00
Wang Sijie
127664a62f
feat(core,console): social connector targets ( #851 )
...
* feat(core,console): social connector targets
* fix: add test
2022-05-17 17:09:42 +08:00
Darcy Ye
8e1533a702
feat(core): update connector db schema ( #732 )
...
* feat(core): update connector db schema
* feat(core): eliminate code redundancy for UTs
* feat(core): delete insertConnector on conflict logic and fix UTs
* feat(core): fix UI according to new connector type implementation
* feat(core): removed unused getConnectorByTargetAndPlatform methods
* feat(core): deprecate the function that updateConnector by giving target and platform
* feat(core): keep SSOT on combination of connector and corresponding metadata
* feat(core): rename index name in db
2022-05-12 12:17:17 +08:00
Gao Sun
5909727ebc
refactor(core): use argon2 for password encryption ( #738 )
...
* refactor(core): use argon2 for password encryption
* refactor(core): adjust time cost
2022-05-06 16:38:38 +08:00
Wang Sijie
8a48fb6225
fix: delete custom domain ( #737 )
...
* fix: delete custom domain
* fix: use sql wrapper
2022-05-06 02:48:34 +00:00
Wang Sijie
a0b4b98c35
feat(console): add column lastSignIn in user management ( #679 )
...
* feat(core): user last sign in
* fix(core): rename last_sign_in to last_sign_in_at for updating its timestamptz value
* fix: rename column name in frontend
* fix: test
* fix: toLocaleDateString
Co-authored-by: IceHe.xyz <icehe@silverhand.io>
2022-05-05 16:22:43 +08:00
IceHe.xyz
4521c3c8d1
feat(core,schemas): save application id that the user first consented ( #688 )
...
* feat(core,schemas): save application id which the user first consented
* chore(core): fix grammatical mistake and typos
2022-05-05 06:57:20 +00:00
Darcy Ye
f669f6b657
feat(core): fix packages' dependencies
2022-04-24 20:53:34 +08:00
IceHe.xyz
4e5927a788
chore(schemas): conform sql style ( #600 )
2022-04-21 05:31:29 +00:00
IceHe.xyz
e21d8d38f3
chore(core,schemas): remove old user logs ( #597 )
...
* chore(core): remove user logs
* chore(schemas): remove user logs
2022-04-21 11:04:34 +08:00
IceHe.xyz
afaaed9f29
fix(schemas): remove wrong default values from sign-in experience schema ( #565 )
2022-04-18 17:06:13 +08:00
IceHe.xyz
5386bcee23
feat(schemas): logs schema and log payload type ( #561 )
2022-04-18 15:44:36 +08:00
IceHe.xyz
77e0b4fec6
refactor(schemas): conform id length ( #555 )
2022-04-18 15:27:58 +08:00
Gao Sun
ada4da2fbf
feat(cli): seed tables
2022-04-09 21:53:53 +08:00
Gao Sun
0499024fdf
refactor(core): remove resource scopes
2022-04-08 16:07:34 +08:00
Darcy Ye
09703896f3
fix(core): fix default enable value of new connectors ( #500 )
2022-04-06 15:34:18 +08:00
IceHe.xyz
71465ca999
feat(schemas,core,phrases)!: add type to connector schema and sync to DB ( #491 )
...
* feat(schemas,core,phrases)!: add type in connector schema and sync to DB
* chore(core): fix code about connector type
2022-04-06 12:11:06 +08:00
IceHe.xyz
9f3fc5a5cc
feat(schemas): sign-in-experiences ( #361 )
...
* chore(schemas): remove useless table sign_in_methods
* feat(schemas): sign-in-experiences
* chore(core): update mock.ts and sign-in-experience.test.ts about sign-in-experiences schema
* chore(core): fix typo in test
2022-03-15 16:46:23 +08:00
Darcy Ye
9ed146645b
revert(core): manually revert forgot password logic ( #365 )
...
* Revert "feat(core): add email forgot password flow (send/verify passcode) (#336 )"
* Revert "feat(core): post /session/forgot-password/phone/verify-passcode-and-reset-password (#334 )"
* Revert "feat(core): add forgot password send a passcode to phone route (#326 )"
2022-03-11 17:45:42 +08:00
Darcy Ye
b14c30beca
feat(core): add forgot password send a passcode to phone route ( #326 )
...
* feat(core): add forgot password send a passcode to phone route
* feat(core): add UT for forget password send passcode to phone flow
2022-03-07 15:10:36 +08:00
Xiao Yijun
76aba43ae3
refactor(core): replace arbitrary data guard type with arbitrary object guard ( #290 )
2022-02-28 11:22:48 +08:00
Xiao Yijun
861833c01a
refactor(core): add prefix for password_encryption_method ( #281 )
2022-02-24 18:01:17 +08:00
Xiao Yijun
e8cbe00d3a
feat(core): add custom_data to the user schema ( #230 )
2022-02-15 16:59:28 +08:00
simeng-li
86ce5a9640
fix(core): align resource_identifier namespace with OIDC provider ( #224 )
...
* fix(core): align resource_identifier namespace with OIDC provider
replace resource identifier name with resource_indicator
align the usage with OIDC Provider
* fix(cr): cr fix
add empty line
2022-02-15 16:13:41 +08:00
Wang Sijie
e8c2b100a3
feat: set profiles from social connector ( #226 )
2022-02-14 16:03:13 +08:00
Darcy Ye
8249493c40
feat(core): add passwordless register flow of phone ( #221 )
...
* feat(phone passwordless): add passwordless register flow of phone
* feat(phone passwordless): add userId to both sign-in and register user logs
* feat(phone passwordless): add register error descriptions
* feat(core): update error descriptions and leave redundancy error descriptions for later changes
2022-02-14 10:44:46 +08:00
Wang Sijie
66808d6d02
feat: social sign in ( #218 )
2022-02-11 07:19:18 +00:00
Darcy Ye
750ef0c3bf
feat(phone passwordless): add passwordless sign-in with phone ( #217 )
...
* feat(phone passwordless): add passwordless sign-in with phone
* feat(phone passwordless): rename phoneReg
2022-02-09 16:14:42 +08:00
Wang Sijie
e7458f8a2b
feat(schema): user identities ( #215 )
2022-02-09 12:55:06 +08:00
Wang Sijie
d14f1a8841
feat(core): sign in with email ( #209 )
...
* feat(core): sign in with email
* fix: jti comment
* refactor: move sign in methods into lib
2022-01-31 11:04:55 +08:00
Wang Sijie
ffeabbedcf
fix(passcode): use interaction_jti instead of session_id ( #207 )
2022-01-29 15:30:50 +08:00
simeng-li
0105d19d99
feat(core): add user roles related api ( #204 )
...
* feat(core): add user role related api
add user roles related api
* fix: insert array to db fix
insert array to db fix
* feat(core): add role related routes config
add role related routes config
* fix(core): update user role patch error type
update user role patch error type
* fix(core): cr fix
cr fix
* fix(core): cr fix
cr fix
* fix(core): cr fix
cr fix
2022-01-28 13:33:57 +08:00
simeng-li
9f23dbbb2a
feat(schema): add roles table ( #202 )
...
* feat(schema): add roles table
add roles table
* fix(chema): ci fix
ci fix
* fix(cr): cr fix
- rename userRoles to roleNames
- rename role table colmn name
* fix(ut): fix ut
fix ut
2022-01-27 10:48:55 +08:00
Wang Sijie
6fadd4a420
feat: passcode table ( #198 )
...
* feat: passcode table
* fix: consumed
2022-01-26 15:32:03 +08:00
simeng-li
f85b922836
feat(core): add sign-in-experiences table ( #191 )
...
* feat(core): add sign-in-experience-setting table
add sign-in-experience-setting table
* fix(core): fix typo
fix typo
* refactor: rename sign-in-experience table name
rename sign-in-experience table name
* fix(core): cr fix update sign_in_method schema
update sign_in_method schema
* fix(schema): cr fix
remove signinMethodsMetadata jsonb field
2022-01-25 11:48:47 +08:00
Darcy Ye
9dc0ea32c0
feat(connector): connector queries and APIs ( #178 )
...
* feat(connector): connector queries and APIs
* chore(connectors): remove type from DB schema design and fix code accordingly
* chore(connectors): put connector as ConnectorInstance's property
* chore(connector): put connector as optional property of ConnectorInstance
2022-01-24 14:40:15 +08:00
simeng-li
492724a575
refactor(core): resources related db query cleanup ( #179 )
...
* refactor(core): resources related db query cleanup
clean resourece & scopes db queries
* refactor(core): rename resources and scopes query file name
rename plural filename
2022-01-14 11:54:09 +08:00
simeng-li
77be675bfb
feat(application): set idToken and refreshToken ttl based on client metadata ( #176 )
...
* feat(application): set idtoken and refresh token ttl based on client metadata
add idToken and refreshToken ttl metadata
* fix(application): cr fix
cr fix add default constant & set custom client metadata not null
2022-01-13 14:15:13 +08:00
simeng-li
b9f9847ec0
feat(schema): update application db ( #169 )
...
* feat(schema): update appliaction db
update application db
* ci(schema): cr fix application table schema typo
fix application table schema typo
2022-01-11 11:58:58 +08:00
Darcy Ye
14d8b18c1d
feat: settings DB schema ( #165 )
...
* feat: fix settings design schema
2022-01-11 03:15:10 +00:00
Wang Sijie
bf165644c9
feat: connector DB schema ( #164 )
...
* chore: add boolean type for postgres
* chore: remove bool
* feat: connector DB
* fix: remove identifier
* chore: genenrate
* chore: remove data
* chore: todo
* chore: test TODO
2022-01-10 12:24:22 +08:00
simeng-li
a56d4ce026
feat: implement getResourceIndicators logic ( #146 )
...
* fix(schema): fix typo remove trailing comma
fix typo remove trailing comma
* feat(core): add resouce server query logic
add resource server & scopes query logic to oidc-provider resourceIndicator feature config
* fix(chore): scope should join with scopes.name
fix scope name join format bug
* fix(core): cr fix use pool.any replace pool.many
use pool.any replace pool.many
2021-12-02 14:08:15 +08:00
simeng-li
18a142ab65
feat(schema): add resource and scope table ( #145 )
...
* feat(schema): add resource and scope table
implement resource-servers and resource-scopes table with some basic queries
* fix(schema): remove scope update querie
not allowed to update scope once created
* feat(schema): add resourceId foreign key to the scope table
add resourceId foreign key to the scope table
* fix(schema): remove trailling comma
remove trailling comma
* fix(schema): cr fix replace resource-servers table name using resources
replace resource-servers table name using resources
2021-12-01 11:41:16 +08:00
Wang Sijie
acdbc5db56
feat(schema): user logs ( #137 )
...
* feat(schema): user logs
* fix(core): use z.object
* fix(core): add log result type
* fix: comments in sql
* fix: user_log_type and user_log_result
2021-11-29 15:47:43 +08:00
Gao Sun
f48534ed18
refactor: unify timestamp usage
2021-08-18 16:36:52 +08:00
Gao Sun
a86f57a466
refactor: remove oidc_client_id
2021-08-10 21:26:49 +08:00
Gao Sun
525fe97728
refactor(schemas): oidc_clients -> applications
2021-08-10 17:21:34 +08:00
Gao Sun
ac53f7befb
feat: add OIDC clients table
2021-07-25 17:40:51 +08:00
Gao Sun
6e7a4700d9
feat: remove redundant fields and add TS type support in generated files
2021-07-25 17:40:50 +08:00
Gao Sun
0584979dbb
refactor: user_name -> username
2021-07-25 17:40:50 +08:00
Gao Sun
efa550834a
feat: generate enum types from SQL
2021-07-25 17:40:50 +08:00
Gao Sun
70a4c6f15a
Add password encryption salt
2021-07-25 17:40:50 +08:00
Gao Sun
68d67016ae
Add user table
2021-07-25 17:40:49 +08:00
Gao Sun
7961a7fbf0
Generate table metadata
2021-07-25 17:40:49 +08:00
Gao Sun
c8721ac1f8
Init table type generation
2021-07-25 17:40:49 +08:00
