kernelci / kernelci/dashboard

Add easy way to delete an sqlite database only once on docker startup

Open
#1,214 0 comments 0 reactions 0 assignees View on GitHub
enhancement technical debt
Dominant language
Python
Stars
9
Forks
31
Avg merge
3d 19h
Merged PRs (30d)
16

Description

Once in a while, it might be useful to refresh the sqlite database (as seen by the migrations in the repository). There should be a way to delete a specific table before running the usual migrations, such that it will be recreated.

A possible solution would be to have a flag file telling docker if it should delete the database before running the migrations. If that file has a True flag, then the database gets deleted and the flags gets set down to False again, avoiding multiple deletions.

There should be considerations on how this would be used, how the files would be synchronized, and how automated the process would be.

Contributor guide

Open the contributing guide

Research direction

The issue mentions Docker startup, the SQLite database, and repository migrations, but names no files or tests. First inspect the Docker startup and migration entry points, then determine how a one-time deletion flag should be synchronized and reset. Done means the selected database or table is deleted once before migrations without repeated deletions.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, python, sqlite
Domain
database, devops
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.