forked from reminder-bot/autoclear-bot
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmodels.py
34 lines (25 loc) · 832 Bytes
/
models.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, BigInteger
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
import configparser
Base = declarative_base()
c = configparser.SafeConfigParser()
c.read('config.ini')
url = c.get('DEFAULT', 'sql')
class Deletes(Base):
__tablename__ = 'deletes'
map_id = Column(Integer, primary_key=True)
message = Column(BigInteger)
channel = Column(BigInteger)
time = Column(BigInteger)
class Autoclears(Base):
__tablename__ = 'autoclears'
id = Column(Integer, primary_key=True)
channel = Column(BigInteger)
user = Column(BigInteger)
time = Column(Integer)
engine = create_engine(url)
Base.metadata.create_all(bind=engine)
Session = sessionmaker(bind=engine)
session = Session()