Skip to content

add soft deletion to cleezy #66

@evanugarte

Description

@evanugarte

instead of deleting records from sqlite, lets add a deleted_at column that we set to the current time when a row is deleted.

that way we can bring records back if needed.

game plan

  • follow fastapi and argparse tutorial
  • learn basic sqlite usage in python (see provided resources from sce discord)
  • add a deleted_at column and a partial index so that deleted records arent taking up space in the alias column
  • open a separate pr to update the readme on how to do a migration for a sqlite file
  • open the pr with the sqlite changes

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions