Ejemplo n.º 1
0
class TrafficItem(db.Model):
  __tablename__ = 'traffic_item'
  id = db.Column(db.Integer(), primary_key=True)
  
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  name = db.Column(db.String(255))
  slug = db.Column(db.String(255))
  external_id = db.Column(db.String(255))
  
  item_type = db.Column(db.Integer()) # 1 Baustelle 2 Auto-Parkplatz 3 Fahrrad-Ständer 4 Verkehrszählung 5 Sperranhänger
  raw_status = db.Column(db.Integer()) # 1 komplett roh, 2 verarbeitet
  is_meta = db.Column(db.Integer())
  
  zoom_from = db.Column(db.Integer())
  zoom_till = db.Column(db.Integer())
  
  lat = db.Column(db.Numeric(precision=10,scale=7))
  lon = db.Column(db.Numeric(precision=10,scale=7))
  
  area = db.Column(db.Text())
  
  traffic_item_provider_id = db.Column(db.Integer, db.ForeignKey('traffic_item_provider.id'))
  traffic_item_meta = db.relationship("TrafficItemMeta", backref="TrafficItem", lazy='dynamic')
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<TrafficItem %r>' % self.name
Ejemplo n.º 2
0
class TenantModel(db.Model):
    #nombre tabla
    __tablename__ = 'tenant'

    #columns
    tenant_id = db.Column(db.Integer, primary_key=True)
    first_name = db.Column(db.String(50), nullable=True)
    last_name = db.Column(db.String(50), nullable=True)
    email = db.Column(db.String(100), unique=True, nullable=False)
    encrypted_password = db.Column(db.String(100), nullable=False)
    rental_unit_id = db.Column(db.Integer, nullable=True)
    lease_document_url = db.Column(db.String(100), nullable=True)
    id_document_url = db.Column(db.String(100), nullable=True)
    created_at = db.Column(db.DateTime(),
                           nullable=False,
                           default=datetime.datetime.now)
    updated_at = db.Column(db.DateTime(),
                           nullable=False,
                           default=datetime.datetime.now)

    #init data
    def __init__(self, first_name, last_name, email, encrypted_password):

        #declare data
        self.first_name = first_name
        self.last_name = last_name
        self.email = email
        self.encrypted_password = self.create_password(encrypted_password)

    #Generate Hash password
    def create_password(self, encrypted_password):
        return generate_password_hash(encrypted_password)
Ejemplo n.º 3
0
class TenantLeaseModel(db.Model):
    #nombre tabla
    __tablename__ = 'tenant_lease'

    #columns
    tenant_lease_id = db.Column(db.Integer, primary_key=True)
    lease_id = db.Column(db.Integer,
                         db.ForeignKey('tenant.tenant_id'),
                         primary_key=True)
    tenant_id = db.Column(db.Integer,
                          db.ForeignKey('lease.lease_id'),
                          primary_key=True)
    created_at = db.Column(db.DateTime(),
                           nullable=False,
                           default=datetime.datetime.now)
    updated_at = db.Column(db.DateTime(),
                           nullable=False,
                           default=datetime.datetime.now)

    #init data
    def __init__(self, lease_id, tenant_id):

        #declare data
        self.lease_id = lease_id
        self.tenant_id = tenant_id
Ejemplo n.º 4
0
class SharingStation(db.Model):
    __tablename__ = 'sharing_station'
    id = db.Column(db.Integer(), primary_key=True)

    created = db.Column(db.DateTime())
    updated = db.Column(db.DateTime())
    active = db.Column(db.Integer())

    name = db.Column(db.String(255))
    slug = db.Column(db.String(255))
    external_id = db.Column(db.String(255))

    vehicle_free = db.Column(db.Integer())
    vehicle_all = db.Column(db.Integer())
    station_type = db.Column(
        db.Integer()
    )  # 1 Fahrrad 2 Lastenrad 3 Fahrradanhänger 4 PKW 5 Transporter 6 Fahrradbox

    lat = db.Column(db.Numeric(precision=10, scale=7))
    lon = db.Column(db.Numeric(precision=10, scale=7))

    vehicle = db.relationship("Vehicle",
                              backref="SharingStation",
                              lazy='dynamic')

    sharing_provider_id = db.Column(db.Integer,
                                    db.ForeignKey('sharing_provider.id'))

    def __init__(self):
        pass

    def __repr__(self):
        return '<Region %r>' % self.name
Ejemplo n.º 5
0
class Region(db.Model):
  __tablename__ = 'region'
  
  id = db.Column(db.Integer(), primary_key=True)
  name = db.Column(db.String(255))
  slug = db.Column(db.String(255), unique=True)
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  osm_id = db.Column(db.Integer())
  geo_json = db.Column(db.Text())
  rgs = db.Column(db.String(255))
  region_level = db.Column(db.Integer())
  postalcode = db.Column(db.String(255))
  
  lat = db.Column(db.Numeric(precision=10,scale=7))
  lon = db.Column(db.Numeric(precision=10,scale=7))
  
  region_parent_id = db.Column(db.Integer, db.ForeignKey('region.id'))
  region_parent = db.relationship("Region", backref="region_children", remote_side=[id])
  service_sites = db.relationship("ServiceSite", backref="region", lazy='dynamic')
  # hosts as defined in Host
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<Hoster %r>' % self.name
Ejemplo n.º 6
0
class Service(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.String(100), index=True)
    name = db.Column(db.String(80), index=True)
    time_of_last_change_of_state = db.Column(db.DateTime())
    previous_state = db.Column(db.Integer, index=True)
    current_state = db.Column(db.Integer, index=True)
    time_of_added = db.Column(db.DateTime())
    organization_id = db.Column(db.Integer, db.ForeignKey('organization.id'))
    service_repairer_id = db.Column(db.Integer,
                                    db.ForeignKey('user.id'),
                                    nullable=True)
    users = db.relationship("Subscription", back_populates="service")

    def __init__(self, address, name, time_of_added, organization_id):
        self.address = address
        self.name = name
        self.time_of_added = time_of_added
        self.organization_id = organization_id
        self.previous_state = ServiceState.unspecified
        self.current_state = ServiceState.unspecified

    def dump(self):
        return {
            "service": {
                'id': self.id,
                'address': self.address,
                'name': self.name,
                'organization_id': self.organization_id
            }
        }
Ejemplo n.º 7
0
class Operation(db.Model):
    __tablename__ = 'Operation'
    id = db.Column(db.Integer(), primary_key=True)
    clinic_id = db.Column(db.Integer(), db.ForeignKey('Clinic.id'), index=True)
    history_id = db.Column(db.Integer(), db.ForeignKey('History.id'))
    hospital_id = db.Column(db.Integer(), db.ForeignKey('HistoryEvent.id'))
    history_event_id = db.Column(db.Integer(),
                                 db.ForeignKey('HistoryEvent.id'))
    patient_id = db.Column(db.Integer(), db.ForeignKey('Patient.id'))
    doctor_surgeon_id = db.Column(db.Integer(), db.ForeignKey('Doctor.id'))
    doctor_assistant_id = db.Column(db.Integer(), db.ForeignKey('Doctor.id'))
    #operation_order_id = db.Column(db.Integer())
    operation_order = db.Column(db.Integer())
    time_begin = db.Column(db.DateTime())
    time_end = db.Column(db.DateTime())
    duration_min = db.Column(db.Integer())  # Длительность в минутах

    # Получить список операций для истории болезни
    @staticmethod
    def get_operations(history):

        operations = history.operations
        if operations:
            items = []
            for operation in operations:
                doctor = Doctor.get(operation.doctor_surgeon_id)
                item = {}
                item["date"] = operation.time_begin
                item["doctor_surgeon"] = doctor.fio
                items.append(item)

            return items
Ejemplo n.º 8
0
class Suggestion(db.Model):
  __tablename__ = 'suggestion'
  id = db.Column(db.Integer(), primary_key=True)
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  type = db.Column(db.String(128))
  suggestion = db.Column(db.Text())
Ejemplo n.º 9
0
class Region(db.Model):
  __tablename__ = 'region'
  
  id = db.Column(db.Integer(), primary_key=True)
  name = db.Column(db.String(255))
  slug = db.Column(db.String(255), unique=True)
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  osm_id = db.Column(db.Integer())
  geo_json = db.Column(db.Text())
  rgs = db.Column(db.String(255))
  region_level = db.Column(db.Integer())
  postalcode = db.Column(db.String(255))
  fulltext = db.Column(db.String(255))
  
  lat = db.Column(db.Numeric(precision=10,scale=7))
  lon = db.Column(db.Numeric(precision=10,scale=7))
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<Hoster %r>' % self.name
Ejemplo n.º 10
0
class Visualisation(db.Model):
  __tablename__ = 'visualisation'
  id = db.Column(db.Integer(), primary_key=True)
  
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  name = db.Column(db.Text())
  identifier = db.Column(db.String(128), unique=True)
  descr = db.Column(db.Text())
  data = db.Column(db.Text())
Ejemplo n.º 11
0
class OperationLog(db.Model):
    __tablename__ = 'OperationLog'
    id = db.Column(db.Integer(), primary_key=True)
    clinic_id = db.Column(db.Integer(), db.ForeignKey('Clinic.id'), index=True)
    history_id = db.Column(db.Integer(), db.ForeignKey('History.id'))
    patient_id = db.Column(db.Integer(), db.ForeignKey('Patient.id'))
    operation_id = db.Column(db.Integer(), db.ForeignKey('Operation.id'))
    operation_step_id = db.Column(db.Integer(),
                                  db.ForeignKey('OperationStep.id'))
    time_begin = db.Column(db.DateTime())
    time_end = db.Column(db.DateTime())
    duration_min = db.Column(db.Integer())  # Длительность в минутах
Ejemplo n.º 12
0
class UserModel(db.Model):

    #nombre tabla
    __tablename__ = 'users'

    #columns
    id = db.Column(db.Integer, primary_key=True)
    fullname = db.Column(db.String(80), nullable=True)
    username = db.Column(db.String(80), unique=True, nullable=True)
    email = db.Column(db.String(256), unique=True, nullable=True)
    password = db.Column(db.String(128), nullable=False)
    created_at = db.Column(db.DateTime(),
                           nullable=False,
                           default=datetime.datetime.now)

    #init data
    def __init__(self, fullname, username, email, password):

        #declare data
        self.fullname = fullname
        self.username = username
        self.email = email
        self.password = self.create_password(password)

    #Generate Hash password
    def create_password(self, password):
        return generate_password_hash(password)

    #Verifique hash password
    def verify_password(self, password):
        return check_password_hash(self.password, password)
Ejemplo n.º 13
0
class ServiceGroup(db.Model):
  __tablename__ = 'service_group'
  id = db.Column(db.Integer(), primary_key=True)
  
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  name = db.Column(db.Text())
  
  services = db.relationship("Service", backref="ServiceGroup", lazy='dynamic')
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<ServiceGroup %r>' % self.name
Ejemplo n.º 14
0
class Vehicle(db.Model):
    __tablename__ = 'vehicle'
    id = db.Column(db.Integer(), primary_key=True)
    created = db.Column(db.DateTime())
    updated = db.Column(db.DateTime())
    active = db.Column(db.Integer())

    sharing_station_id = db.Column(db.Integer,
                                   db.ForeignKey('sharing_station.id'))

    name = db.Column(db.String(255))
    external_id = db.Column(db.String(255))

    def __init__(self):
        pass

    def __repr__(self):
        return '<Procedure %r>' % self.name
Ejemplo n.º 15
0
class TrafficItemMeta(db.Model):
  __tablename__ = 'traffic_item_meta'
  id = db.Column(db.Integer(), primary_key=True)
  
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  key = db.Column(db.String(255))
  value = db.Column(db.String(255))
  
  traffic_item_id = db.Column(db.Integer, db.ForeignKey('traffic_item.id'))
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<TrafficItemMeta %r>' % self.name
Ejemplo n.º 16
0
class Base(db.Model):
    __abstract__ = True

    id = db.Column('id', db.Integer, primary_key=True)
    created_datetime = db.Column('created_datetime',
                                 db.DateTime(),
                                 nullable=True)

    def __init__(self, cdt):
        self.created_datetime = cdt
Ejemplo n.º 17
0
class IndicatorValue(db.Model):
    __tablename__ = 'IndicatorValue'
    id = db.Column(db.Integer(), primary_key=True)
    clinic_id = db.Column(db.Integer(), db.ForeignKey('Clinic.id'), index=True)
    history_id = db.Column(db.Integer(),
                           db.ForeignKey('History.id'),
                           index=True)
    patient_id = db.Column(db.Integer(), db.ForeignKey('Patient.id'))
    history_event_id = db.Column(db.Integer(),
                                 db.ForeignKey('HistoryEvent.id'))
    indicator_id = db.Column(db.Integer(), db.ForeignKey('Indicator.id'))
    slice = db.Column(db.String(100))
    time_created = db.Column(db.DateTime(), default=datetime.utcnow())
    date_value = db.Column(db.Date())
    date_time_value = db.Column(db.DateTime())
    text_value = db.Column(db.String(100))
    num_value = db.Column(db.Numeric())
    num_deviation = db.Column(db.Numeric())
    def_value = db.Column(db.Integer())
    comment = db.Column(db.String(500))
    events = db.relationship('HistoryEvent', backref='indicator_values')
Ejemplo n.º 18
0
class Tokens(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    token = db.Column(db.String(100), index=True, unique=True)
    email = db.Column(db.String(80), index=True)
    date_of_expire = db.Column(db.DateTime())
    is_used = db.Column(db.Boolean, index=True)

    def __init__(self, token, email, date):
        self.token = token
        self.email = email
        self.date_of_expire = date
        self.is_used = False
Ejemplo n.º 19
0
class SslTest(db.Model):
  __tablename__ = 'ssl_test'
  
  id = db.Column(db.Integer(), primary_key=True)
  created = db.Column(db.DateTime())
  
  host = db.Column(db.Text())
  ip = db.Column(db.Text())
  
  port_443_available = db.Column(db.Integer())
  port_25_available = db.Column(db.Integer())
  ssl_ok = db.Column(db.Integer())
  cert_matches = db.Column(db.Integer())
  
  rc4_available = db.Column(db.Integer())
  md5_available = db.Column(db.Integer())
  anon_suite_available = db.Column(db.Integer())
  dhe_key = db.Column(db.Integer())
  ecdhe_key = db.Column(db.Integer())
  pfs_available = db.Column(db.Integer())
  fallback_scsv_available = db.Column(db.Integer())
  protocol_num = db.Column(db.Integer())
  protocol_best = db.Column(db.String(255))
  
  sslv2_available = db.Column(db.Integer())
  sslv3_available = db.Column(db.Integer())
  tlsv1_available = db.Column(db.Integer())
  tlsv1_1_available = db.Column(db.Integer())
  tlsv1_2_available = db.Column(db.Integer())
  
  sslv2_cipher_accepted = db.Column(db.Text())
  sslv3_cipher_accepted = db.Column(db.Text())
  tlsv1_cipher_accepted = db.Column(db.Text())
  tlsv1_1_cipher_accepted = db.Column(db.Text())
  tlsv1_2_cipher_accepted = db.Column(db.Text())
  
  sslv2_cipher_preferred = db.Column(db.String(255))
  sslv3_cipher_preferred = db.Column(db.String(255))
  tlsv1_cipher_preferred = db.Column(db.String(255))
  tlsv1_1_cipher_preferred = db.Column(db.String(255))
  tlsv1_2_cipher_preferred = db.Column(db.String(255))
  
  hsts_available = db.Column(db.Integer())
  session_renegotiation_secure = db.Column(db.Integer())
  session_renegotiation_client = db.Column(db.Integer())
  heartbleed = db.Column(db.Integer())
  ccs_injection = db.Column(db.Integer())
  sha1_cert = db.Column(db.Integer())
  ocsp_stapling = db.Column(db.Integer())
  ssl_forward = db.Column(db.Integer())
  compression = db.Column(db.Integer())
  
  host_id = db.Column(db.Integer, db.ForeignKey('host.id'))
Ejemplo n.º 20
0
class ServiceSite(db.Model):
  __tablename__ = 'service_site'
  
  id = db.Column(db.Integer(), primary_key=True)
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  url = db.Column(db.Text())
  quality = db.Column(db.String(255)) # 'offline', 'mail', 'online'
  quality_show = db.Column(db.Integer())
  
  host_id = db.Column(db.Integer, db.ForeignKey('host.id'))
  region_id = db.Column(db.Integer, db.ForeignKey('region.id'))
  service_id = db.Column(db.Integer, db.ForeignKey('service.id'))
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<ServiceSite %r>' % self.name
Ejemplo n.º 21
0
class ConstructionSite(db.Model):
    __tablename__ = 'construction_site'

    id = db.Column(db.Integer(), primary_key=True)
    title = db.Column(db.String(255))

    descr = db.Column(db.Text())  # Allg. Beschreibung
    reason = db.Column(db.Text())  # Begründung für Baustelle
    type = db.Column(db.Text())  # Art der Verkehrseinschränkung
    constructor = db.Column(db.Text())  # Bauherr
    execution = db.Column(db.Text())  # Ausführendes Bauunternehmen
    location_descr = db.Column(db.Text())  # Ort
    restriction = db.Column(db.Text())  # Einschränkungen

    area = db.Column(db.Text())  # GeoJSON

    lat = db.Column(db.Numeric(precision=10, scale=7))
    lon = db.Column(db.Numeric(precision=10, scale=7))

    external_id = db.Column(
        db.String(255))  # Externe ID (innerhalb der Source einzigartig)
    external_url = db.Column(db.Text())  # Externe URL

    begin = db.Column(db.DateTime())  # Start der Baumaßnahme
    end = db.Column(db.DateTime())  # Ende der Baumaßnahme

    created_at = db.Column(db.DateTime())
    updated_at = db.Column(db.DateTime())

    source_id = db.Column(db.Integer())  # Quelle

    licence_name = db.Column(db.Text())
    licence_url = db.Column(db.Text())
    licence_owner = db.Column(db.Text())

    def __init__(self):
        pass

    def __repr__(self):
        return '<ConstructionSite %r>' % self.id
Ejemplo n.º 22
0
class Service(db.Model):
  __tablename__ = 'service'
  id = db.Column(db.Integer(), primary_key=True)
  
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  name = db.Column(db.Text())
  fa_icon = db.Column(db.String(64))
  descr_short = db.Column(db.Text())
  descr = db.Column(db.Text())
  make_ssl_test = db.Column(db.Integer())
  
  service_group_id = db.Column(db.Integer, db.ForeignKey('service_group.id'))
  service_sites = db.relationship("ServiceSite", backref="Service", lazy='dynamic')
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<Service %r>' % self.name
Ejemplo n.º 23
0
class Tree(db.Model):
  __tablename__ = 'tree'
  
  id = db.Column(db.Integer(), primary_key=True)
  
  type = db.Column(db.Integer())
  public = db.Column(db.Integer())
  author = db.Column(db.String(255))
  email = db.Column(db.String(255))
  
  ip = db.Column(db.String(15))
  hostname = db.Column(db.String(255))
  
  address = db.Column(db.String(255))
  postalcode = db.Column(db.String(255))
  city = db.Column(db.String(255))
  
  picture = db.Column(db.Integer())
  descr = db.Column(db.Text())
  
  lat = db.Column(db.Numeric(precision=10,scale=7))
  lng = db.Column(db.Numeric(precision=10,scale=7))
  
  external_id = db.Column(db.String(255))
  created_at = db.Column(db.DateTime())
  updated_at = db.Column(db.DateTime())
  
  tree_type_old = db.Column(db.String(255))
  tree_type_new = db.Column(db.String(255))
  chop_reason = db.Column(db.String(255))
  source = db.Column(db.String(255))
  
  tree_suggest = db.relationship('TreeSuggest', backref='tree', lazy='dynamic')
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<Tree %r>' % self.id
Ejemplo n.º 24
0
class History(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.String(100), index=True)
    name = db.Column(db.String(80), index=True)
    state = db.Column(db.Integer)
    state_set_time = db.Column(db.DateTime())
    organization_id = db.Column(db.Integer, db.ForeignKey('organization.id'))

    def __init__(self, address, name, state, state_set_time, organization_id):
        self.address = address
        self.name = name
        self.state = state
        self.state_set_time = state_set_time
        self.organization_id = organization_id
Ejemplo n.º 25
0
class TrafficItemProvider(db.Model):
  __tablename__ = 'traffic_item_provider'
  id = db.Column(db.Integer(), primary_key=True)
  
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  name = db.Column(db.String(255))
  slug = db.Column(db.String(255))
  descr_short = db.Column(db.Text())
  descr = db.Column(db.Text())
  external_id = db.Column(db.String(255))
  
  email = db.Column(db.String(255))
  website = db.Column(db.String(255))
  licence = db.Column(db.Text())
  
  street = db.Column(db.String(255))
  postalcode = db.Column(db.String(5))
  city = db.Column(db.String(255))
  
  traffic_item = db.relationship("TrafficItem", backref="TrafficItemProvider", lazy='dynamic')
Ejemplo n.º 26
0
class Host(db.Model):
  __tablename__ = 'host'
  
  id = db.Column(db.Integer(), primary_key=True)
  created = db.Column(db.DateTime())
  updated = db.Column(db.DateTime())
  active = db.Column(db.Integer())
  
  host = db.Column(db.String(255))
  type = db.Column(db.String(255))
  ip = db.Column(db.Text())
  reverse_hostname = db.Column(db.Text())
  ssl_result = db.Column(db.Integer())
  
  service_sites = db.relationship("ServiceSite", backref="host", lazy='dynamic')
  ssl_tests = db.relationship("SslTest", backref="Host", lazy='dynamic')
  regions = db.relationship('Region', secondary=hosts_regions, backref=db.backref('hosts', lazy='dynamic'))
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<Host %r>' % self.host
Ejemplo n.º 27
0
class SharingProvider(db.Model):
    __tablename__ = 'sharing_provider'
    id = db.Column(db.Integer(), primary_key=True)

    created = db.Column(db.DateTime())
    updated = db.Column(db.DateTime())
    active = db.Column(db.Integer())

    name = db.Column(db.String(255))
    slug = db.Column(db.String(255))
    descr_short = db.Column(db.Text())
    descr = db.Column(db.Text())

    email = db.Column(db.String(255))
    website = db.Column(db.String(255))
    licence = db.Column(db.Text())

    street = db.Column(db.String(255))
    postalcode = db.Column(db.String(5))
    city = db.Column(db.String(255))

    sharing_station = db.relationship("SharingStation",
                                      backref="SharingProvider",
                                      lazy='dynamic')
Ejemplo n.º 28
0
class User(db.Model, UserMixin):
    """Authorized Users For the ParseLeads
    :param str email: email address of user
    "param str password: encrypted password for the user
    """

    id = db.Column(db.Integer, primary_key=True, unique=True)
    email = db.Column(db.String, unique=True)
    password = db.Column(db.String)
    name = db.Column(db.String)
    active = db.Column(db.Boolean, default=False)
    confirmed_at = db.Column(db.DateTime())
    roles = db.relationship('Role',
                            secondary=roles_users,
                            backref=db.backref('users', lazy='dynamic'))

    def __str__(self):
        return self.email
Ejemplo n.º 29
0
class TreeSuggest(db.Model):
  __tablename__ = 'tree_suggest'
  
  id = db.Column(db.Integer(), primary_key=True)
  
  tree_id = db.Column(db.Integer(), db.ForeignKey('tree.id'))
  field = db.Column(db.String(255))
  value = db.Column(db.String(255))
  created_at = db.Column(db.DateTime())
  
  ip = db.Column(db.String(15))
  hostname = db.Column(db.String(255))
  
  def __init__(self):
    pass

  def __repr__(self):
    return '<TreeSuggest %r>' % self.id
Ejemplo n.º 30
0
class Acao(db.Model):
    __tablename__ = 'acoes'

    acao_id = db.Column(db.Integer, primary_key=True)
    entidade_id = db.Column(db.Integer,
                            db.ForeignKey('entidades.entidade_id'),
                            nullable=False)
    nome_acao = db.Column(db.String(), nullable=False)
    imagem_acao = db.Column(db.String())
    url_acao = db.Column(db.String())
    descricao = db.Column(db.String())
    contato = db.Column(db.String())
    tipo_ajuda = db.Column(db.Enum(TipoAjuda), nullable=False)
    forma_ajuda = db.Column(db.Enum(FormaAjuda), nullable=False)
    data_insercao = db.Column(db.DateTime())
    data_atualizacao = db.Column(db.DateTime())
    forma_verificacao = db.Column(db.String())
    resp_verificacao = db.Column(db.String())
    ativa = db.Column(db.Boolean)
    permanente = db.Column(db.Boolean)
    validade = db.Column(db.String())
    entidade = db.relationship(Entidade,
                               foreign_keys=entidade_id,
                               backref='entidade_acao')
    localizacoes = db.relationship(
        Localizacao, primaryjoin="and_(Acao.acao_id==Localizacao.acao_id)")
    midias = db.relationship(NaMidia,
                             primaryjoin="and_(Acao.acao_id==NaMidia.acao_id)")
    dados_bancarios = db.relationship(
        DadosBancarios,
        primaryjoin="and_(Acao.acao_id==DadosBancarios.acao_id)")

    def __init__(self, entidade_id, nome_acao, imagem_acao, url_acao,
                 descricao, contato, tipo_ajuda, forma_ajuda,
                 forma_verificacao, resp_verificacao, ativa, permanente,
                 validade):
        self.entidade_id = entidade_id
        self.nome_acao = nome_acao
        self.imagem_acao = imagem_acao
        self.url_acao = url_acao
        self.descricao = descricao
        self.contato = contato
        self.tipo_ajuda = tipo_ajuda
        self.forma_ajuda = forma_ajuda
        self.data_insercao = datetime.now()
        self.data_atualizacao = datetime.now()
        self.forma_verificacao = forma_verificacao
        self.resp_verificacao = resp_verificacao
        self.ativa = ativa
        self.permanente = permanente
        self.validade = validade

    def __repr__(self):
        return '<Acão %r>' % self.nome_acao

    def serialize(self):
        tipo_a = None
        forma_a = None
        if self.tipo_ajuda:
            tipo_a = self.tipo_ajuda.value
        if self.forma_ajuda:
            forma_a = self.forma_ajuda.value
        return {
            'acao_id':
            self.acao_id,
            'entidade_id':
            self.entidade_id,
            'nome_acao':
            self.nome_acao,
            #'imagem_acao': self.imagem_acao,
            'url_acao':
            self.url_acao,
            'descricao':
            self.descricao,
            'contato':
            self.contato,
            'tipo_ajuda':
            tipo_a,
            'forma_ajuda':
            forma_a,
            'data_insercao':
            self.data_insercao,
            'data_atualizacao':
            self.data_atualizacao,
            'forma_verificacao':
            self.forma_verificacao,
            'resp_verificacao':
            self.resp_verificacao,
            'ativa':
            self.ativa,
            'permanente':
            self.permanente,
            'validade':
            self.validade,
            'nome_entidade':
            self.entidade.nome,
            'localizacoes':
            [localizacao.serialize() for localizacao in self.localizacoes],
            'midias': [midia.serialize() for midia in self.midias],
            'dados_bancarios': [
                dado_bancario.serialize()
                for dado_bancario in self.dados_bancarios
            ]
        }