ViewVC Help
View File | Revision Log | Show Annotations | View Changeset | Root Listing
root/ns_dev/Python/NinoCode/Active_prgs/Gromulus/models.py
Revision: 988
Committed: Sun Mar 8 04:15:07 2026 UTC (2 weeks, 6 days ago) by nino.borges
Content type: text/x-python
File size: 3962 byte(s)
Log Message: 
Added a database dictionary markdown file which attempts to describe at a highlevel the database, tables, fields and the reason for these. also updaed the models.py file to reflect the updated database, since it was so out of date.  I'm currently not using it beyond documenting the schema.  also added a Projet Guidelines file and lessons learned file.  These are my attempt at tryiing out spec-driven development.  Projectguidelines is the core guide that will act as the source of truth of the application.

File Contents

# User Rev Content
1 nino.borges 988 """SQLAlchemy schema definitions for the current Gromulus SQLite database.
2 nino.borges 795
3 nino.borges 988 This module is intentionally written with SQLAlchemy Core ``Table`` objects
4     instead of ORM declarative classes so it can represent tables that do not
5     have primary keys (for example ``no_intro_main`` and ``tosec_main``).
6     """
7 nino.borges 795
8 nino.borges 988 from sqlalchemy import (
9     Column,
10     ForeignKey,
11     Index,
12     Integer,
13     MetaData,
14     Table,
15     Text,
16     UniqueConstraint,
17     )
18 nino.borges 795
19    
20 nino.borges 988 metadata = MetaData()
21 nino.borges 795
22    
23 nino.borges 988 main_app_system = Table(
24     "main_app_system",
25     metadata,
26     Column("id", Integer, primary_key=True, autoincrement=True, nullable=False),
27     Column("name", Text),
28     Column("short_name", Text),
29     Column("relative_file_path", Text),
30     )
31 nino.borges 795
32    
33 nino.borges 988 main_app = Table(
34     "main_app",
35     metadata,
36     Column("id", Integer, primary_key=True, autoincrement=True, nullable=False),
37     Column("game_name", Text),
38     Column("game_name_scraped", Text),
39     Column("container_file_name", Text),
40     Column("description", Text),
41     Column("description_scraped", Text),
42     Column("system_console", Integer),
43     Column("system_console_scraped", Text),
44     Column("path_to_screenshot_box", Text),
45     Column("path_to_screenshot_title", Text),
46     Column("path_to_screenshot_ingame", Text),
47     Column("path_to_video", Text),
48     Column("user_notes", Text),
49     Column("container_md5_hash", Text),
50     Column("version", Text),
51     )
52    
53    
54     main_app_file_hash = Table(
55     "main_app_file_hash",
56     metadata,
57     Column("id", Integer, primary_key=True, autoincrement=True, nullable=False),
58     Column("file_name", Text),
59     Column("file_md5_hash", Text),
60     Column("container_file_id", Integer, ForeignKey("main_app.id"), nullable=False),
61     )
62    
63    
64     no_intro_system = Table(
65     "no_intro_system",
66     metadata,
67     Column("id", Integer, primary_key=True, nullable=False),
68     Column("name", Text),
69     Column("description", Text),
70     Column("dat_version", Text),
71     )
72    
73    
74     no_intro_main = Table(
75     "no_intro_main",
76     metadata,
77     Column("game_name", Text),
78     Column("no_intro_id", Text),
79     Column("clone_of_id", Text),
80     Column("description", Text),
81     Column("rom_name", Text),
82     Column("crc", Text),
83     Column("md5", Text),
84     Column("sha1", Text),
85     Column("sha256", Text),
86     Column("status", Text),
87     Column("no_intro_system_id", Integer, ForeignKey("no_intro_system.id"), nullable=False),
88     Column("app_system_id", Integer),
89     )
90    
91    
92     tosec_main = Table(
93     "tosec_main",
94     metadata,
95     Column("game_name", Text),
96     Column("description", Text),
97     Column("rom_name", Text),
98     Column("crc", Text),
99     Column("md5", Text),
100     Column("sha1", Text),
101     Column("system_id", Integer, ForeignKey("no_intro_system.id"), nullable=False),
102     Column("app_system_id", Integer),
103     )
104    
105    
106     dat_import_history = Table(
107     "dat_import_history",
108     metadata,
109     Column("id", Integer, primary_key=True, autoincrement=True),
110     Column("app_system_id", Integer, ForeignKey("main_app_system.id"), nullable=False),
111     Column("source", Text, nullable=False),
112     Column("dat_name", Text),
113     Column("dat_description", Text),
114     Column("dat_version", Text),
115     Column("imported_at", Text, nullable=False),
116     Column("entry_count", Integer, nullable=False, default=0),
117     UniqueConstraint("app_system_id", "source", name="uq_dat_import_history_system_source"),
118     )
119    
120    
121     Index("idx_main_app_md5", main_app.c.container_md5_hash)
122     Index("idx_main_app_system", main_app.c.system_console)
123     Index("idx_no_intro_md5", no_intro_main.c.md5)
124     Index("idx_tosec_md5", tosec_main.c.md5)
125     Index("idx_no_intro_system_md5", no_intro_main.c.app_system_id, no_intro_main.c.md5)
126     Index("idx_tosec_system_md5", tosec_main.c.app_system_id, tosec_main.c.md5)
127     Index("idx_dat_import_system_source", dat_import_history.c.app_system_id, dat_import_history.c.source)
128    
129    
130     __all__ = [
131     "metadata",
132     "main_app_system",
133     "main_app",
134     "main_app_file_hash",
135     "no_intro_system",
136     "no_intro_main",
137     "tosec_main",
138     "dat_import_history",
139     ]