summaryrefslogtreecommitdiff
path: root/photoblaster/db/imcmd.py
blob: 1cd9fb43760ab0d817394a8a667411529ebb24c9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
# coding: utf-8
"""imcmd sqlalchemy module"""
from sqlalchemy import Column, Integer, LargeBinary, String, 
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class ImCmd(Base):
    """defines the table class"""
    __tablename__ = 'im_cmd'
    id = Column(Integer, primary_key=True)
    date = Column(Integer)
    remote_addr = Column(String(16))
    name = Column(String(16))
    url = Column(String(256))
    dir = Column(String(2))
    oldfile = Column(String(256))
    newfile = Column(String(256))
    cmd = Column(LargeBinary)
    dataobj = Column(LargeBinary)
    tag = Column(String(50))