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.

Sign up for GitHub

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

Jump to bottom

Create db queries #13

Open
5 of 36 tasks
JollyRen opened this issue Jan 4, 2024 · 0 comments
Open
5 of 36 tasks

Create db queries #13

JollyRen opened this issue Jan 4, 2024 · 0 comments
Assignees
@JollyRen
Labels
New New feature or request

Comments

@JollyRen
Copy link
Member

JollyRen commented Jan 4, 2024 •
edited
Loading

Todo

User DB Functions

  • createUser
  • getUserById
  • getUserByIdAuth (authorized users only, has all data; backend use only)
  • getUserByUsername (authorized users only, has all data, no subs; backend use only)
  • verifyUser (uses getUserByUsername)
  • getAllUsers
  • updateUser
  • deleteUser (changes active state)
  • createSub
  • getSubByUserId
  • getSubsByStatus
  • updateSub
  • cancelSub

Item DB Functions

  • createColor
  • getColorByName
  • getColorByCode
  • editColor
  • deleteColor
  • addItem
  • getItemByName
  • getItemByType
  • getItemBySubtype
  • editItem
  • deleteItem
  • addPattern
  • editPattern
  • deletePattern

Client DB Functions

  • createClient
  • updateClient
  • deleteClient
  • createChoice
  • getChoice
  • updateChoice
  • deleteChoice
  • getClientsByUser
  • getclientById
@JollyRen JollyRen added the New New feature or request label Jan 4, 2024
@JollyRen JollyRen self-assigned this Jan 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@JollyRen JollyRen

Labels
New New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@JollyRen