Python SQLAlchemy.FetchedValue示例

t_sitting_audit = db.Table(
    'sitting_audit',
    db.Column('audit_id', db.Integer, nullable=False),
    db.Column('sitting_id', db.Integer, nullable=False),
    db.Column('group_id', db.Integer, nullable=False),
    db.Column('session_id', db.Integer),
    db.Column('short_name', db.String(512)),
    db.Column('start_date', db.DateTime, nullable=False),
    db.Column('end_date', db.DateTime, nullable=False),
    db.Column('sitting_length', db.Integer),
    db.Column('recurring_id', db.Integer),
    db.Column('recurring_type', db.String(32)),
    db.Column('recurring_end_date', db.DateTime),
    db.Column('status', db.String(48)),
    db.Column('status_date', db.DateTime, nullable=False, server_default=db.FetchedValue()),
    db.Column('venue_id', db.Integer),
    db.Column('language', db.String(5), nullable=False),
    db.Column('activity_type', db.String(1024)),
    db.Column('meeting_type', db.String(1024)),
    db.Column('convocation_type', db.String(1024)),
    db.Column('cancel_reason', db.String(1024)),
    schema='public'
)

t_sitting_report = db.Table(
    'sitting_report',
    db.Column('report_id', db.ForeignKey('public.doc.doc_id'), primary_key=True, nullable=False),
    db.Column('sitting_id', db.ForeignKey('public.sitting.sitting_id'), primary_key=True, nullable=False),
    schema='public'
)

示例#2

显示文件

# coding: utf-8
from sqlalchemy import BigInteger, Column, Date, DateTime, Float, ForeignKey, Index, Integer, String, Table, Text, \
    VARBINARY
from sqlalchemy.schema import FetchedValue
from sqlalchemy.orm import relationship
from sqlalchemy.dialects.mysql.types import BIT
from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

t_balances_notpaid_sy19_1 = db.Table(
    'balances_notpaid_sy19_1',
    db.Column('charge_id', db.Integer, server_default=db.FetchedValue()),
    db.Column('student_id', db.String(50)),
    db.Column('tbc_description', db.String(50)),
    db.Column('amount', db.Float(8, True)),
    db.Column('balance', db.Float(8, True)),
    db.Column('amountpaid',
              db.Float(8, True),
              server_default=db.FetchedValue()),
    db.Column('description', db.String(50)),
    db.Column('amount_paid', db.Float(10, True)),
    db.Column('or_number', db.String(20)))

t_balances_view = db.Table(
    'balances_view',
    db.Column('charge_id', db.Integer, server_default=db.FetchedValue()),
    db.Column('student_id', db.String(50)),
    db.Column('description', db.String(50)),
    db.Column('AmountPayable', db.Float(8, True)),
    db.Column('TotalPaidAmountWithOR', db.Float(19, True)),