Work continuation
to do
- return school from infrastructure endpoint
- Create a new infrastructure endpoint in business that can take a payload of an array of school_uuids and return the list of schools with those uuids.
- registerUser
- jwt with token
{
"Username":"vasanth.6",
"Password":"Password@123",
"application_id":"44c5b142-6b05-4d29-98b3-5501ef71db0f",
"web_site":"WakeNC",
"roles":[
"book keeper",
"teacher"
],
"email":"",
"is_authorized":"",
"is_super_user":"",
"school_id":["",""],
user_id :"" ( guid - old db id )
}
- base url /web_site/page link/ , username , password , district ,
- copy roles
- create school table - copy [bvc_Manufacturer] and add district id + (SELECT TOP 1000 [bvin]
,[DisplayName]
,[EmailAddress]
,[Address]
,[LastUpdated]
,[SchoolExternalID]
FROM [NC183].[dbo].[bvc_Manufacturer])
- create table - user roles - (SELECT TOP 1000 [UserRoleID]
,[UserID]
,[RoleID]
,[ExpiryDate]
FROM [NC183_PORTAL].[dbo].[UserRoles])
- check and add in pgadmin - SELECT TOP 1000 [UserID]
,[Username]
,[FirstName]
,[LastName]
,[IsSuperUser]
,[AffiliateId]
,[Email]
,[DisplayName]
,[UpdatePassword]
FROM [NC183_PORTAL].[dbo].[Users]
- mapping table for school id & user id
- add in user tab
,[UserId] (guid)
[IsApproved]
,[IsLockedOut]
,[CreateDate]
,[LastLoginDate]
SELECT distinct website FROM public.district where database_code = 'CA000'
http://localhost:6100/index.html
http://localhost:6100/infrastructure/service/transactions
Transactions
status
Type
transaction_source
Comments
Post a Comment