From cb4300cd23ed4af9207d23c0b437870294cb161c Mon Sep 17 00:00:00 2001 From: zlg Date: Fri, 22 Sep 2023 01:02:37 -0700 Subject: scripts: Add schema v1->v2 migration script This script adds three columns to the schema, supporting the "Purchased", "Beaten", and "Completed" note headers. They are now converted to a UNIX timestamp and stored in a separate column so queries made against that metadata are easier. The library itself still needs to support all the new columns. --- TODO.txt | 10 +--------- 1 file changed, 1 insertion(+), 9 deletions(-) (limited to 'TODO.txt') diff --git a/TODO.txt b/TODO.txt index 6f54d7f..705f65c 100644 --- a/TODO.txt +++ b/TODO.txt @@ -1,20 +1,12 @@ -* Get tests running in their own directory * Write CLI * in progress, using click - https://click.pocoo.org/ * Write GUI + * in progress (tkinter) * Write docs * How? Sphinx? Needs research --- -Consider adding a 'dates' table that matches games to dates for purchase, -beating, and completing. Currently implemented via RFC2822-style headers within -the 'notes' field. More research is needed to determine if the notes field or a -table is a better way to achieve this. If an addition to the database format is -deemed necessary, a restructuring may be in order. - ---- - One of the things curious about managing a game collection that doubles as a backlog is, you get games on systems that were originally on other systems. How do you classify those games? The original game is the actual content you're -- cgit v1.2.3-54-g00ecf t/ch1/1-19_reverse-lines.c?id=af502c08e870ea3374d9c3d20d0e195aa3658f22&follow=1'>commitdiff
path: root/ch1/1-19_reverse-lines.c (unfollow)
class='left'>Author
AgeCommit message (Collapse)AuthorFilesLines
FilesLines