"""
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):
"""
