Skip to content

Instantly share code, notes, and snippets.

@Zzz9194

Zzz9194/sql_alchemy_database_eg.py

Created May 20, 2020 18:03
Show Gist options
  • Save Zzz9194/b66faf327ed778b95b049f9eeb5b9544 to your computer and use it in GitHub Desktop.
Save Zzz9194/b66faf327ed778b95b049f9eeb5b9544 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_alchemy_database_eg.py
# Requirements
# - A DB
# - A venv w/ sqlalchemy & requests
from sqlalchemy import create_engine, Column, Integer, String, ForeignKey
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, relationships
import requests
Base = declarative_base()
class User(Base):
__tablename__ = "User"
roblox_id = Column('roblox_id',Integer,primary_key=True)
discord_id = Column('discord_id',Integer,unique=True)
username = Column('username',String,unique=True)
engine = create_engine('sqlite:///users.db',echo=True)
Base.metadata.create_all(bind=engine)
Session = sessionmaker(bind=engine)
session = Session()
allusers = session.query(User).all()
# Do stuff here ...
session.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment