Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import configparser
- import string
- import random
- from sqlalchemy import *
- from sqlalchemy.ext.declarative import declarative_base
- from sqlalchemy.orm import relation, sessionmaker
- """
- Contains the db connection, cursor, and db functions
- """
- Base = declarative_base()
- class User(Base):
- __tablename__ = 'users'
- id = Column(Integer, primary_key=True)
- username = Column(String(80), unique=True, nullable=False)
- password = Column(String(80), nullable=False)
- def __init__(self, username, password):
- self.username = username
- self.password = password
- def __repr__(self):
- return '<User %r>' % self.username
- class Game(Base):
- __tablename__ = 'games'
- id = Column(Integer, primary_key=True)
- userid = Column(Integer, ForeignKey(User.id), nullable=False)
- name = Column(String(80), nullable=False)
- platform = Column(String(80))
- status = Column(String(80), nullable=False)
- description = Column(String(80))
- def __init__(self, userid, name, platform=None, status=None, description=None):
- self.id = id
- self.userid = userid
- self.name = name
- self.platform = platform
- self.status = status
- self.description = description
- def __repr__(self):
- return '<Game %r>' % self.name
- engine = create_engine('sqlite:///:memory:', echo=True)
- Base.metadata.create_all(engine)
- Session = sessionmaker(bind=engine)
- session = Session()
- users = table('users')
- games = table('games')
- metadata = MetaData()
- metadata.create_all(engine)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement