class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), unique=True)
email = db.Column(db.String(120), unique=True)
password = db.Column(db.String(120))
def __init__(self, email, password):
self.email = email
self.password = password
def __repr__(self):
return '<User %r'.format(self.username)
@property
def is_authenticated(self):
return True
@property
def is_active(self):
return True
@property
def is_anonymous(self):
return False
@property
def get_id(self):
return
class ubicacion(db.Model):
__tablename__ = "ubicacion"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
codigo = db.Column(db.String, nullable=False)
ubicacion = db.Column(db.String, nullable=False)
subarea_id = db.Column(Integer, ForeignKey('subarea.id'))
class plano(db.Model):
__tablename__ = "plano"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
codigo = db.Column(db.String, nullable=False)
rev = db.Column(db.String, nullable=False)
title = db.Column(db.String, nullable=False)
id_google = db.Column(db.String, nullable=False)
class Cliente(db.Model):
__tablename__ = 'clientes'
id = db.Column(db.Integer, primary_key=True)
nome = db.Column(db.String(64))
telefone = db.Column(db.String(20), unique=True)
email = db.Column(db.String(100), unique=True)
endereco = db.Column(db.String)
def __repr__(self):
return '<cliente %r'.format(self.nome)
class f0033(db.Model):
__tablename__ = "f0033"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
area = db.Column(db.String, nullable=False)
subarea = db.Column(db.String, nullable=False)
ubicacion = db.Column(db.String, nullable=False)
plano = db.Column(db.String, nullable=False)
fecha = db.Column(db.String, nullable=False)
soldador = db.Column(db.String, nullable=False)
items = db.Column(db.String, nullable=False)
observacion = db.Column(db.String, nullable=False)
class f0033a(db.Model):
__tablename__ = "f0033a"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
id_f0033 = db.Column(db.String, nullable=False)
id_item = db.Column(db.String, nullable=False)
detalle = db.Column(db.String, nullable=False)
cable = db.Column(db.String, nullable=False)
metal = db.Column(db.String, nullable=False)
class f0005(db.Model):
__tablename__ = "f0005"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
area = db.Column(db.String, nullable=False)
subarea = db.Column(db.String, nullable=False)
ubicacion = db.Column(db.String, nullable=False)
elemento = db.Column(db.String, nullable=False)
fecha = db.Column(db.String, nullable=False)
plano = db.Column(db.String, nullable=False)
r11 = db.Column(db.String, nullable=False)
r12 = db.Column(db.String, nullable=False)
r13 = db.Column(db.String, nullable=False)
r14 = db.Column(db.String, nullable=False)
r15 = db.Column(db.String, nullable=False)
r16 = db.Column(db.String, nullable=False)
r21 = db.Column(db.String, nullable=False)
r22 = db.Column(db.String, nullable=False)
r23 = db.Column(db.String, nullable=False)
r24 = db.Column(db.String, nullable=False)
r25 = db.Column(db.String, nullable=False)
r26 = db.Column(db.String, nullable=False)
r27 = db.Column(db.String, nullable=False)
r28 = db.Column(db.String, nullable=False)
observacion = db.Column(db.String, nullable=False)
class f0016(db.Model):
__tablename__ = "f0016"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
area = db.Column(db.String, nullable=False)
subarea = db.Column(db.String, nullable=False)
elemento = db.Column(db.String, nullable=False)
ubicacion = db.Column(db.String, nullable=False)
fecha = db.Column(db.String, nullable=False)
plano = db.Column(db.String, nullable=False)
metodo = db.Column(db.String, nullable=False)
q21 = db.Column(db.String, nullable=False)
q22 = db.Column(db.String, nullable=False)
q23 = db.Column(db.String, nullable=False)
q24 = db.Column(db.String, nullable=False)
q25 = db.Column(db.String, nullable=False)
q26 = db.Column(db.String, nullable=False)
q27 = db.Column(db.String, nullable=False)
fprint = db.Column(db.String, nullable=False)
fscan = db.Column(db.String, nullable=False)
esquema = db.Column(db.String, nullable=False)
observacion = db.Column(db.String, nullable=False)
class f0006(db.Model):
__tablename__ = "f0006"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
area = db.Column(db.String, nullable=False)
subarea = db.Column(db.String, nullable=False)
ubicacion = db.Column(db.String, nullable=False)
elemento = db.Column(db.String, nullable=False)
fecha = db.Column(db.String, nullable=False)
plano = db.Column(db.String, nullable=False)
resistencia_concreto = db.Column(db.String, nullable=False)
temperatura_concreto = db.Column(db.String, nullable=False)
temperatura_ambiente = db.Column(db.String, nullable=False)
slump = db.Column(db.String, nullable=False)
aire = db.Column(db.String, nullable=False)
cilindros_muestra = db.Column(db.String, nullable=False)
muestras = db.Column(db.String, nullable=False)
limpieza_estructura = db.Column(db.String, nullable=False)
teorico = db.Column(db.String, nullable=False)
real = db.Column(db.String, nullable=False)
segregacion = db.Column(db.String, nullable=False)
junta_fria = db.Column(db.String, nullable=False)
start = db.Column(db.String, nullable=False)
finish = db.Column(db.String, nullable=False)
duracion = db.Column(db.String, nullable=False)
observacion = db.Column(db.String, nullable=False)
fprint = db.Column(db.String, nullable=False)
fscan = db.Column(db.String, nullable=False)
class f0007(db.Model):
__tablename__ = "f0007"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
area = db.Column(db.String, nullable=False)
subarea = db.Column(db.String, nullable=False)
ubicacion = db.Column(db.String, nullable=False)
elemento = db.Column(db.String, nullable=False)
plano = db.Column(db.String, nullable=False)
e11 = db.Column(db.String, nullable=False)
e12 = db.Column(db.String, nullable=False)
e13 = db.Column(db.String, nullable=False)
e14 = db.Column(db.String, nullable=False)
e15 = db.Column(db.String, nullable=False)
e16 = db.Column(db.String, nullable=False)
e17 = db.Column(db.String, nullable=False)
e18 = db.Column(db.String, nullable=False)
e19 = db.Column(db.String, nullable=False)
e110 = db.Column(db.String, nullable=False)
e111 = db.Column(db.String, nullable=False)
e21 = db.Column(db.String, nullable=False)
e22 = db.Column(db.String, nullable=False)
e23 = db.Column(db.String, nullable=False)
e24 = db.Column(db.String, nullable=False)
e25 = db.Column(db.String, nullable=False)
e26 = db.Column(db.String, nullable=False)
e27 = db.Column(db.String, nullable=False)
e28 = db.Column(db.String, nullable=False)
e29 = db.Column(db.String, nullable=False)
e210 = db.Column(db.String, nullable=False)
e211 = db.Column(db.String, nullable=False)
e212 = db.Column(db.String, nullable=False)
e213 = db.Column(db.String, nullable=False)
e31 = db.Column(db.String, nullable=False)
e32 = db.Column(db.String, nullable=False)
e33 = db.Column(db.String, nullable=False)
e34 = db.Column(db.String, nullable=False)
e35 = db.Column(db.String, nullable=False)
e36 = db.Column(db.String, nullable=False)
e37 = db.Column(db.String, nullable=False)
e38 = db.Column(db.String, nullable=False)
e39 = db.Column(db.String, nullable=False)
e41 = db.Column(db.String, nullable=False)
e42 = db.Column(db.String, nullable=False)
e43 = db.Column(db.String, nullable=False)
e44 = db.Column(db.String, nullable=False)
e45 = db.Column(db.String, nullable=False)
e46 = db.Column(db.String, nullable=False)
e47 = db.Column(db.String, nullable=False)
e48 = db.Column(db.String, nullable=False)
e49 = db.Column(db.String, nullable=False)
e410 = db.Column(db.String, nullable=False)
e411 = db.Column(db.String, nullable=False)
e412 = db.Column(db.String, nullable=False)
e413 = db.Column(db.String, nullable=False)
e51 = db.Column(db.String, nullable=False)
e52 = db.Column(db.String, nullable=False)
e53 = db.Column(db.String, nullable=False)
e54 = db.Column(db.String, nullable=False)
e55 = db.Column(db.String, nullable=False)
e56 = db.Column(db.String, nullable=False)
e57 = db.Column(db.String, nullable=False)
e58 = db.Column(db.String, nullable=False)
e59 = db.Column(db.String, nullable=False)
e59 = db.Column(db.String, nullable=False)
e510 = db.Column(db.String, nullable=False)
e511 = db.Column(db.String, nullable=False)
e512 = db.Column(db.String, nullable=False)
e513 = db.Column(db.String, nullable=False)
e61 = db.Column(db.String, nullable=False)
e62 = db.Column(db.String, nullable=False)
e63 = db.Column(db.String, nullable=False)
e64 = db.Column(db.String, nullable=False)
e65 = db.Column(db.String, nullable=False)
e66 = db.Column(db.String, nullable=False)
e67 = db.Column(db.String, nullable=False)
e68 = db.Column(db.String, nullable=False)
e69 = db.Column(db.String, nullable=False)
e610 = db.Column(db.String, nullable=False)
e611 = db.Column(db.String, nullable=False)
e612 = db.Column(db.String, nullable=False)
observacion = db.Column(db.String, nullable=False)
class f0004(db.Model):
__tablename__ = "f0004"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
area = db.Column(db.String, nullable=False)
subarea = db.Column(db.String, nullable=False)
ubicacion = db.Column(db.String, nullable=False)
elemento = db.Column(db.String, nullable=False)
fecha = db.Column(db.String, nullable=False)
plano = db.Column(db.String, nullable=False)
r1 = db.Column(db.String, nullable=False)
r2 = db.Column(db.String, nullable=False)
r3 = db.Column(db.String, nullable=False)
r4 = db.Column(db.String, nullable=False)
r5 = db.Column(db.String, nullable=False)
r6 = db.Column(db.String, nullable=False)
r7 = db.Column(db.String, nullable=False)
observacion = db.Column(db.String, nullable=False)
class ToDo(db.Model):
id = db.Column(db.Integer, primary_key=True)
task = db.Column(db.String(30), nullable=False)
complete = db.Column(db.Integer, nullable=False)
from aplication import db
from wtforms import Form, StringField, SelectField, validators, IntegerField
from sqlalchemy import Table, Column, Integer, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy import UniqueConstraint, exc
class {{name}}(db.Model):
__tablename__ = "{{name}}"
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True){%for form in dbform%}
{{form}} = db.Column(db.String, nullable=False){%endfor%}
class {{name}}_form(Form):
id = IntegerField('id'){%for form in dbform%}
{{form}} = StringField('{{form}}'){%endfor%}
def {{name}}_convert({{name}}, form):
{{name}}.id = form.id.data{%for form in dbform%}
{{name}}.{{form}} = form.{{form}}.data{%endfor%}
return {{name}}
def {{name}}_obj({{name}}, obj):
{{name}}.id = obj.id{%for form in dbform%}
{{name}}.{{form}} = obj.{{form}}{%endfor%}
return {{name}}