richardjoy530/photocontest-backend

An ASP .Net WebApi application which hosts the backend of PhotoContest

photocontest-backend's Issues

Implement validation

Unit Test / Behavioral tests

What:

• Need to implement a testing mechanism to make database testing / controller testing / provider testing much faster/efficient
• Automate behavioral tests

Why:

• It is very time consuming to test the developments.
• Tests must be run on CI pipeline

Implement logging

• Logger can run in a separate thread
• Research on buffer/queue mechanism to implement logger efficiently

Basic stored procedures for all the relevent DB tables

Basic stored procedures

Model	GetAll	Get	Insert	Update	Delete
FileMap	✅	✅	✅	✅	✅
IdMap	✅	✅	✅	❌	✅
PhotoEntry	✅	✅	✅	✅	✅
Photographer	✅	✅	✅	✅	✅
PhotograpgerVoteDetails	✅	✅	✅	✅	✅
PhotoTheme	✅	✅	✅	✅	✅
ScoreDetail	✅	✅	✅	✅	✅

PhotographerVoteDetailsProvider

Implement Azure blob service for files

PhotoEntryProvider

ReferenceIdProvider

Authorization in middleware or attribute

PhotographerProvider

• Controller
• Provider

Research on SignalR or gRPC for event-subscription

• need a way to notify clients about the votes / new uploads
• clients request only if data is added/changed
• events for required changes

Create README.md

Implement fallback file handling keeping same abstraction (easier to switch implementation)

Tab/Space consistency

Update Wiki

Basic functionality works. If not, implement the fix

Relates to:

• #27

Basic providers for all relevant models

Implement database providers for all DBmodels

• #17
• #22
• #23
• #19
• #21
• #20
• #24

Refactor all the stored procedure

• #25
• #18
• #37

Finally

• #52

Implement caching on data access layer

• Introduce Providers.Caching.Implementation assembly which will implement all the provider interface in Provider assembly
• Implement an efficient lookup system for cached data
• Thread safe edits

FileMapProvider

Relates to

• #33

ScoreDetailProvider

Re-Design database/models

Refactor the database tables according to Wiki Tab

Mechanism to use bitmask/ignorecolumn in IProvider

PhotoThemeProvider

• Controller
• Provider

Implement Azure blob storage for uploading images

How to doc

• MS-Learn
• Azure Storage Blobs client library

Also keep a fallback implementation with file system on hosting system. incase if we need to cut down on azure services

• #33
• #34

Finalize where bit mask is needed