SQLAlchemy: Create Table Column using Decimal and Tinyint

29 January 2016

Using SQLAlchemy to create table columns. To use numeric data types you have to use mysql dialects.

Source code viewer
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects.mysql import DECIMAL, TINYINT
 
op.create_table(
  'accounting',
  sa.Column('id', sa.Integer(), primary_key=True),
  sa.Column('day', TINYINT()),
  sa.Column('price', DECIMAL(5, 2)),
)
Programming Language: Python