ma = Marshmallow(app)
profile_db = {
"success": True,
"data": {
"last_updated": "2/3/2021, 8:48:51 PM",
"username": "******",
"role": "Electronics Engineer",
"color": "Burgundy"
class Tank(db.model):
__tablename__ = "tanks"
id = db.Column(db.Integer, primary_key = True)
location = db.Column(db.String(), nullable=False)
lat = db.Column(db.Float(), nullable=False)
long = db.Column(db.Float(), nullable=False)
percent_full = db.Column(db.Integer(), nullable=False)
class TankSchema(ma.SQLAlchemySchema):
class Meta:
model = Tank
fields = ("id", "location", "lat", "long", "percent_full")
db.init_app(app)
migrate = Migrate(app, db)
@app.route("/data", methods=["GET", "POST"])
def data():
if request.method == "POST":
newTank = Tank(
db.Column('数据处理地', db.Unicode(255)),
db.Column('单位详细名称', db.Unicode(255)),
db.Column('期别(年)', db.Unicode(255)),
db.Column('统一社会信用代码', db.Unicode(255)),
db.Column('主要业务活动(或主要产品)1', db.Unicode(255)),
db.Column('主要业务活动(或主要产品)2', db.Unicode(255)),
db.Column('主要业务活动(或主要产品)3', db.Unicode(255)),
db.Column('行业代码(GB/T4754-2017)', db.Unicode(255)),
db.Column('经济活动名称1', db.Unicode(255)),
db.Column('经济活动名称2', db.Unicode(255)),
db.Column('经济活动名称3', db.Unicode(255)),
db.Column('报表类别', db.Unicode(255)),
db.Column('行政区划代码', db.Unicode(255)),
db.Column('单位注册地址所在行政区划代码', db.Unicode(255)),
db.Column('单位规模', db.Unicode(255)),
db.Column('从业人员期末人数;人', db.Float(53)),
db.Column('女性;人', db.Float(53)),
db.Column('营业收入;千元', db.Float(53)),
db.Column('主营业务收入;千元', db.Float(53)),
db.Column('资产总计;千元', db.Float(53)),
db.Column('税金及附加;千元', db.Float(53)),
db.Column('开业(成立)时间(年)', db.Unicode(255)),
db.Column('开业(成立)时间(月)', db.Unicode(255)),
db.Column('登记注册类型', db.Unicode(255)),
db.Column('企业控股情况', db.Unicode(255)),
db.Column('隶属关系', db.Unicode(255)),
db.Column('运营状态', db.Unicode(255)),
db.Column('是否港商投资', db.Unicode(255)),
db.Column('是否澳商投资', db.Unicode(255)),
db.Column('是否台商投资', db.Unicode(255)),
db.Column('执行会计标准类别', db.Unicode(255)),
hora = db.Column(db.String(8), nullable=False)
monto = db.Column(db.Float(10), nullable=False)
tags = db.Table(
'inscritos',
db.Column('id_e',
db.Integer,
db.ForeignKey('eventos.id'),
primary_key=True),
db.Column('id_p',
db.String,
db.ForeignKey('participantes.dni'),
primary_key=True),
db.Column('fecha', db.String(10), nullable=False),
db.Column('monto', db.Float(10), nullable=False))
class User(db.Model):
__tablename__ = 'usuarios'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(25), nullable=False, unique=True)
password = db.Column(db.String(200), nullable=False)
def __repr__(self):
return f'<User {self.username}>'
def set_password(self, password):
self.password = generate_password_hash(password, method='sha256')
def check_password(self, password):
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
db = SQLAlchemy(app) # Create database connection object with SQLAlchemy
"""
# Models for Database.
"""
roles_users = db.Table(
'roles_users', db.Column('user_id', db.Integer(),
db.ForeignKey('user.id')),
db.Column('role_id', db.Integer(), db.ForeignKey('role.id')))
users_currencies = db.Table(
'users_currencies',
db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),
db.Column('amount', db.Integer()), db.Column('ticker', db.String(255)),
db.Column('last', db.Float()), db.Column('bid', db.Float()),
db.Column('ask', db.Float()))
# This class is used to model the table which will hold Users
# Contains a backreference to the Role class for User/Admin role possiblities
class Role(db.Model, RoleMixin):
__tablename__ = "role"
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(80), unique=True)
description = db.Column(db.String(255))
# This class is used to model the table which will hold Users
# Contains a backreference to the Role class for User/Admin role possiblities
# 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)),
t_accountAccessRecord = db.Table(
'accountAccessRecord',
db.Column('clientID',
db.ForeignKey('client.ID',
ondelete='CASCADE',
onupdate='CASCADE'),
nullable=False,
index=True),
db.Column('savingsAccount',
db.ForeignKey('savings_account.account', ondelete='CASCADE'),
index=True),
db.Column('checkAccount',
db.ForeignKey('check_account.account', ondelete='CASCADE'),
index=True), db.Column('depositDate', db.Date),
db.Column('depositAmount', db.Float(15)),
db.Column('withdrawalDate', db.Date),
db.Column('withdrawalAmount', db.Float(15)))
class Branch(db.Model):
__tablename__ = 'branch'
name = db.Column(db.String(15, 'utf8mb4_0900_ai_ci'),
nullable=False,
index=True)
assets = db.Column(db.Float(15), nullable=False)
city = db.Column(db.String(10, 'utf8mb4_0900_ai_ci'), nullable=False)
num = db.Column(db.Integer, primary_key=True)
province = db.Column(db.Text)
city = db.Column(db.Text)
organization_id = db.Column(db.Integer)
is_added = db.Column(db.Integer)
t_scholars_with_citation_counts = db.Table(
'scholars_with_citation_counts', db.Column('id', db.BigInteger),
db.Column('name', db.Text), db.Column('job_title', db.Text),
db.Column('address', db.Text), db.Column('email', db.Text),
db.Column('phone', db.Text), db.Column('website', db.Text),
db.Column('vita', db.Text), db.Column('created_at', db.DateTime(True)),
db.Column('updated_at', db.DateTime(True)),
db.Column('first_name', db.Text), db.Column('middle_name', db.Text),
db.Column('last_name', db.Text), db.Column('state', db.String),
db.Column('latitude', db.Float(53)), db.Column('longitude', db.Float(53)),
db.Column('country', db.Text), db.Column('province', db.Text),
db.Column('city', db.Text), db.Column('organization_id', db.Integer),
db.Column('scholar_id', db.Integer), db.Column('sum', db.BigInteger))
t_scholars_with_cooperator_counts = db.Table(
'scholars_with_cooperator_counts', db.Column('id', db.BigInteger),
db.Column('name', db.Text), db.Column('job_title', db.Text),
db.Column('address', db.Text), db.Column('email', db.Text),
db.Column('phone', db.Text), db.Column('website', db.Text),
db.Column('vita', db.Text), db.Column('created_at', db.DateTime(True)),
db.Column('updated_at', db.DateTime(True)),
db.Column('first_name', db.Text), db.Column('middle_name', db.Text),
db.Column('last_name', db.Text), db.Column('state', db.String),
db.Column('latitude', db.Float(53)), db.Column('longitude', db.Float(53)),
db.Column('country', db.Text), db.Column('province', db.Text),
__tablename__ = 'crime_hour_class'
__table_args__ = {'schema': 'crimemgr'}
lower_bound = db.Column(db.Integer)
upper_bound = db.Column(db.Integer)
classification = db.Column('class', db.Integer, primary_key=True)
description = db.Column(db.Text)
CrimeIncidentSimple = db.Table(
'crime_incident_simple',
db.Column('dc_key', db.Text),
db.Column('crime_type', db.Text),
db.Column('dc_dist', db.Text),
db.Column('neighborhood_id', db.Integer),
db.Column('neighborhood_name', db.String(20)),
db.Column('dispatch_month', db.Float(53)),
db.Column('dispatch_weekday', db.Float(53)),
db.Column('dispatch_time', db.Integer),
db.Column('geom', Geometry),
db.Column('dispatch_date_time', db.DateTime),
schema='crimemgr'
)
class CrimeModel(db.Model):
__tablename__ = 'crime_model'
__table_args__ = {'schema': 'crimemgr'}
classifier = db.Column(db.Text, primary_key=True, nullable=False)
area_type = db.Column(db.Text, primary_key=True, nullable=False)
model = db.Column(db.LargeBinary)
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import Column, ForeignKey, Integer, String, Enum, Float, Date
from datetime import datetime
db = SQLAlchemy()
association_table_services = db.Table(
'User_Services', db.Model.metadata,
db.Column("user_id", db.Integer, db.ForeignKey("user.id")),
db.Column("service_id", db.Integer, db.ForeignKey("services.id")),
db.Column("service", db.String(255)), db.Column("date", db.String(255)),
db.Column("price", db.Float()))
association_table_review = db.Table(
'User_Review',
db.Model.metadata,
db.Column("user_id", db.Integer, db.ForeignKey("user.id")),
db.Column("review_id", db.Integer, db.ForeignKey("review.id")),
)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(80), nullable=False)
is_active = db.Column(db.Boolean(False), nullable=False)
name = db.Column(db.String(200), nullable=False)
last_name = db.Column(db.String(200), nullable=False)
phone = db.Column(db.String(30), unique=True, nullable=False)
location = db.Column(db.String(255), nullable=False)
biografy = db.Column(db.Text())
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(255), unique=True)
email = db.Column(db.String(255), unique=True)
password = db.Column(db.String(255))
active = db.Column(db.Boolean())
confirmed_at = db.Column(db.DateTime())
roles = db.relationship('Role', secondary=roles_users,
backref=db.backref('users', lazy='dynamic'))
user_wallet = db.Table('user_wallet',
db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),
db.Column('game_week', db.Integer()),
db.Column('points_available', db.Integer()),
db.Column('points_won', db.Float()))
user_bets = db.Table('user_bets',
db.Column('user_id', db.Integer(), db.ForeignKey('user.id')),
db.Column('game_week', db.Integer(), db.ForeignKey('role.id')),
db.Column('match_id', db.Integer(), db.ForeignKey('game_week.match_id')),
db.Column('points_won', db.Float()),
db.Column('bet', db.String(1)),
db.Column('points_bet', db.Integer()))
teams = db.Table('teams',
db.Column('team_id', db.Integer(), primary_key=True),
db.Column('team_name', db.String(255)),
db.Column('stadium', db.String(255)))
team_statistics = db.Table('team_statistics',
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
user_movie = db.Table(
"user_movie",
db.Column("user_id",
db.Integer,
db.ForeignKey("user.user_id"),
primary_key=True),
db.Column("title",
db.String(255),
db.ForeignKey("movie.title"),
primary_key=True),
db.Column("user_rating", db.Float(10), nullable=True))
movie_genre = db.Table(
"movie_genre",
db.Column("title",
db.String(255),
db.ForeignKey("movie.title"),
primary_key=True),
db.Column("genre_id",
db.Integer,
db.ForeignKey("genre.genre_id"),
primary_key=True))
class Genre(db.Model):
__tablename__ = "genre"
genre_id = db.Column(db.Integer, primary_key=True)
