""" from security_monkey import db, app from sqlalchemy.dialects.postgresql import JSON from sqlalchemy import Column, Integer, String, DateTime, Boolean, Unicode from sqlalchemy.dialects.postgresql import CIDR from sqlalchemy.schema import ForeignKey, UniqueConstraint from sqlalchemy.orm import relationship from flask.ext.security import UserMixin, RoleMixin import datetime association_table = db.Table( 'association', Column('user_id', Integer, ForeignKey('user.id')), Column('account_id', Integer, ForeignKey('account.id'))) class Account(db.Model): """ Meant to model AWS accounts. """ __tablename__ = "account" id = Column(Integer, primary_key=True) active = Column(Boolean()) third_party = Column(Boolean()) name = Column(String(32)) notes = Column(String(256)) s3_name = Column(String(32)) number = Column(
from sqlalchemy import select, func from sqlalchemy.orm import deferred from copy import deepcopy import dpath.util from dpath.exceptions import PathNotFound from security_monkey.common.utils import sub_dict import datetime import json import hashlib import traceback association_table = db.Table( 'association', Column('user_id', Integer, ForeignKey('user.id'), primary_key=True), Column('account_id', Integer, ForeignKey('account.id'), primary_key=True)) class AccountType(db.Model): """ Defines the type of account based on where the data lives, e.g. AWS. """ __tablename__ = "account_type" id = Column(Integer, primary_key=True) name = db.Column(db.String(80), unique=True) accounts = relationship("Account", backref="account_type") class Account(db.Model): """