""" red = DARedis() red.zadd(redis_panel_emails_key, {email: datetime.now().timestamp()}) def potential_panelists() -> Iterable[Tuple[str, datetime]]: red = DARedis() return [(item, datetime.fromtimestamp(score)) for item, score in red.zrange(redis_panel_emails_key, 0, -1, withscores=True)] ################################### ## Using SQLAlchemy to save / retrieve session information that is linked ## to specific feedback issues db_url = alchemy_url("db") engine = create_engine(db_url) metadata_obj = MetaData() ## This table functions as both storage for bug report-session links, ## and for more general on-server feedback, prompted for at the end of interviews feedback_session_table = Table( "feedback_session", metadata_obj, Column("id", Integer, primary_key=True), Column("interview", String), Column("session_id", String), Column("body", Text), Column("html_url", String), )
last_name = Column(String(250)) address = Column(String(250)) unit = Column(String(250)) city = Column(String(250)) state = Column(String(250)) zip = Column(String(250)) # SQLAlchemy table definition for keeping track of which Banks have which Customers class BankCustomerModel(Base): __tablename__ = 'bank_customer' id = Column(Integer, primary_key=True) bank_id = Column(Integer, ForeignKey('bank.id', ondelete='CASCADE'), nullable=False) customer_id = Column(Integer, ForeignKey('customer.id', ondelete='CASCADE'), nullable=False) # Form the URL for connecting to the database based on the "demo db" directive in the Configuration url = alchemy_url('demo db') # Build the "engine" for connecting to the SQL server, using the URL for the database. engine = create_engine(url) # Create the tables Base.metadata.create_all(engine) # Get SQLAlchemy ready Base.metadata.bind = engine DBSession = sessionmaker(bind=engine)() # Perform any necessary database schema updates using alembic, if there is an alembic # directory and alembic.ini file in the package. upgrade_db(url, __file__, engine)
# SQLAlchemy table definition for keeping track of which Banks have which Customers class ProcessoRequeridoModel(Base): __tablename__ = 'processo_requerido' id = Column(Integer, primary_key=True) processo_id = Column(Integer, ForeignKey('processo.id', ondelete='CASCADE'), nullable=False) requerido_id = Column(Integer, ForeignKey('requerido.id', ondelete='CASCADE'), nullable=False) # Form the URL for connecting to the database based on the "demo db" directive in the Configuration url = alchemy_url('olhosdamata db') # Build the "engine" for connecting to the SQL server, using the URL for the database. engine = create_engine(url) # Create the tables Base.metadata.create_all(engine) # Get SQLAlchemy ready Base.metadata.bind = engine DBSession = sessionmaker(bind=engine)() # Perform any necessary database schema updates using alembic, if there is an alembic # directory and alembic.ini file in the package. upgrade_db(url, __file__, engine)