[sqlalchemy] Re: Alembic or SQLAlchemy-Migrate

2017-03-07 Thread John Robson
Hi Mike, you did an awesome tool, thank you very much!!! I started to use Alembic today, excellent tool, tutorial and "autogenerate" option ;) Up to now, everything is working well, except by this very small problem: class: created = Column(DateTime, server_default=func.now()) updated =

[sqlalchemy] Alembic or SQLAlchemy-Migrate

2017-03-06 Thread John Robson
For Migrations (in PostgreSQL), what you guys recommend? Alembic or SQLAlchemy-Migrate ? Thank you. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See

[sqlalchemy] One Class Mapping Multiple Tables

2016-07-21 Thread John Robson
Hi everyone, I want to store the minute price of all 500 stocks from S 500. This means more than 500 million of rows + almost 200K updates per day + (sometimes) past values must be updated (to adjust ex-dividend, splits). Instead of creating a BIG table, I would like to create 500 tables