qakit / tcms

Test Case Management System (yet another)

Prerequisites

• install Dotnet SDK 5.0+ from official site

Setup project

Creating DB

• install PostgreSQL
• issue the following commands one by one: ** psql -U postgres -c "CREATE USER tcms WITH PASSWORD 'jw8s0F4' CREATEDB;" ** psql -U postgres -c "CREATE DATABASE tcms;" ** psql -U postgres -c "GRANT CREATE ON DATABASE tcms TO tcms;"
• run dotnet ef database update --project src to create a database schema

Auth (builtin logins and register your own)

You have two options: use predefined user or create your own secure one. There three buildin logins (all share the same 'Pwd)12345' password):

• admin@tcms
• testman@tcms
• tester@tcms

Or register your own user

• register yourself
• issue the psql -U postgres -c "UPDATE public.\"AspNetUsers\" SET \"EmailConfirmed\" = true;" tcms to "confirm" yourself

Step by step guide

1. project is created with dotnet new blazorserver ... command (added auth stuff)
2. removed migrations, updated provider to Postgres and generated initial migration again
3. imported dotnet ef dbcontext scaffold ... Kiwi model and excluded it from build
4. moved server source code under src folder
5. defined a Products model (some properties are defined in ApplicationDbContext) ** created migration dotnet ef migrations add Products ** update database dotnet ef database update
6. added simplistic CRUD forms for products (Pages/Products). Using the article (from the refs) but skipped API/controller part, so the form communicates Db directly
7. changed the db communication to factory/shortlived context and all discovered data issues had gone

Misc

** dotnet ef dbcontext scaffold "Host=localhost;Port=5433;Database=kiwi;Username=kiwi;Password=kiwi" Npgsql.EntityFrameworkCore.PostgreSQL -o Data/Kiwi

References

• https://docs.microsoft.com/ru-ru/ef/core/
• https://purple.telstra.com/blog/asp-net-core-identity-with-postgresql
• https://docs.microsoft.com/ru-ru/ef/core/managing-schemas/migrations/?tabs=dotnet-core-cli
• https://codewithmukesh.com/blog/blazor-crud-with-entity-framework-core/ - creating sample CRUD
• https://docs.microsoft.com/en-us/aspnet/core/blazor/blazor-server-ef-core?view=aspnetcore-5.0

tcms's Issues

Provide additional models for test run/plan

• Test Run
• Test Execution Result
• History (for test case) of changes
• smth else??

Form: test case list with filters

Provide a basic test cases list.
Provide filters/search by the following fields:

• title
• descriptions
• product/component
• type
• priority
• isAutomated
• estimate

Form: test case input form

Provide all basic fields:

• title
• description
• estimate
• component
• type
• priority
• automation

Add roles for users

E.g.:

• QA role:
  • can add test cases to system. By default they are not approved
  • can assign test plan to himself and start plan execution
  • can edit test cases
• Test Manager role:
  • this user can approve test cases. Only this role has ability change IsApproved field
  • can add projects/versions
  • create test plans
  • can manage users and assign roles (e.g. specify Project/Manager (if necessary etc...)

Create API controllers for new testcases facilities

We need a controllers for CRUD operations on:

• Products
• Versions
• Components
• test case priorities
• test case statuses
• test case types

The more complicated controllers but still the RESTful CRUD for:

• Test case
• Test case step