Active_prgs/Gromulus/models.py

from sqlalchemy import Column, Integer, String, ForeignKey, Table
from sqlalchemy.orm import relationship, backref
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class No_Intro(Base):
    __tablename__ = "no_intro"
    game_name = Column(String)
    no_intro_game_id = Column(Integer, primary_key=True)
    clone_of_id = Column(Integer)
    description = Column(String)
    rom_name = Column(String)
    crc = Column(String)
    md5 = Column(String)
    sha1 = Column(String)
    sha256 = Column(String)
    status = Column(String)


class Main_App(Base):
    __tablename__ = "main_app"
    game_id = Column(Integer, primary_key=True)
    game_name = Column(String)
    game_name_scraped = Column(String)
    file_name = Column(String)
    relative_file_path = Column(String)
    description = Column(String)
    description_scraped = Column(String)
    path_to_schreenshot = Column(String)
    path_to_video = Column(String)
    user_notes = Column(String)
    md5 = Column(String)
    version = Column(String)

Revision:	795
Committed:	Fri Sep 8 15:11:11 2023 UTC (2 years, 6 months ago) by nino.borges
Content type:	text/x-python
File size:	1053 byte(s)
Log Message:	Gromulus, which is a catalog inventory for roms, games and maybe one day applications.
#	User	Rev	Content
1	nino.borges	795	from sqlalchemy import Column, Integer, String, ForeignKey, Table
2			from sqlalchemy.orm import relationship, backref
3			from sqlalchemy.ext.declarative import declarative_base
4
5			Base = declarative_base()
6
7
8
9			class No_Intro(Base):
10			__tablename__ = "no_intro"
11			game_name = Column(String)
12			no_intro_game_id = Column(Integer, primary_key=True)
13			clone_of_id = Column(Integer)
14			description = Column(String)
15			rom_name = Column(String)
16			crc = Column(String)
17			md5 = Column(String)
18			sha1 = Column(String)
19			sha256 = Column(String)
20			status = Column(String)
21
22
23
24			class Main_App(Base):
25			__tablename__ = "main_app"
26			game_id = Column(Integer, primary_key=True)
27			game_name = Column(String)
28			game_name_scraped = Column(String)
29			file_name = Column(String)
30			relative_file_path = Column(String)
31			description = Column(String)
32			description_scraped = Column(String)
33			path_to_schreenshot = Column(String)
34			path_to_video = Column(String)
35			user_notes = Column(String)
36			md5 = Column(String)
37			version = Column(String)
38