Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Make the database server, username and password dynamic on database connection string template #92

Closed
6 tasks done
RoiJS opened this issue Jul 28, 2021 · 0 comments
Closed
6 tasks done
Assignees
Labels
enhancement New feature or request

Comments

@RoiJS
Copy link
Owner

RoiJS commented Jul 28, 2021

I just found out the the database server offered by the hosting server is changing and this causes a problem on the connection string template declared on the app settings file on the web api as it statically provide the server, username and password for the connection string except for the database name which is dynamic.

To resolve this issue, we will make the server, username and password dynamic as well.

TODO:

  • Introduced new columns DBServer, DBUsername and DBPassword on table Clients.
  • Introduce new settings on the appSettings.Development.json and appSettings.Production.json which contains the default server, username and password that the system will use when registering new database.
  • Update the connection string template on the appSettings.json
  • Modify Startup.cs. Provide the server, username and password dynamically on the current connection string for every request.
  • Modify the function that registers client and demo databases
  • Test and verify
@RoiJS RoiJS added the enhancement New feature or request label Jul 28, 2021
@RoiJS RoiJS added this to the July Update Improvements milestone Jul 28, 2021
@RoiJS RoiJS self-assigned this Jul 28, 2021
RoiJS pushed a commit that referenced this issue Jul 29, 2021
@RoiJS RoiJS closed this as completed Jul 29, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant