class Operation(Base):
# operation.state = Operation.States.IN_PROGRESS.value
States = OperationState
# operation.action = Operation.Actions.PROVISION.value
class Actions(Enum):
PROVISION = "Provision"
DEPROVISION = "Deprovision"
RENEW = "Renew"
UPDATE = "Update"
MIGRATE_TO_BROKER = "Migrate to broker"
id = db.Column(db.Integer, primary_key=True)
service_instance_id = db.Column(db.String,
db.ForeignKey("service_instance.id"),
nullable=False)
state = db.Column(
db.String,
default=States.IN_PROGRESS.value,
server_default=States.IN_PROGRESS.value,
nullable=False,
)
action = db.Column(db.String, nullable=False)
canceled_at = db.Column(db.TIMESTAMP(timezone=True))
step_description = db.Column(db.String)
def __repr__(self):
return f"<Operation {self.id} {self.state}>"
class ServiceInstance(Base):
id = db.Column(db.String(36), primary_key=True)
operations = db.relation("Operation",
backref="service_instance",
lazy="dynamic")
challenges = db.relation("Challenge",
backref="service_instance",
lazy="dynamic")
acme_user_id = db.Column(db.Integer, db.ForeignKey("acme_user.id"))
domain_names = db.Column(postgresql.JSONB, default=[])
order_json = db.Column(db.Text)
csr_pem = db.Column(db.Text)
cert_pem = db.Column(db.Text)
private_key_pem = db.Column(
StringEncryptedType(db.Text, db_encryption_key, AesGcmEngine, "pkcs5"))
fullchain_pem = db.Column(db.Text)
iam_server_certificate_id = db.Column(db.String)
iam_server_certificate_name = db.Column(db.String)
iam_server_certificate_arn = db.Column(db.String)
cloudfront_distribution_arn = db.Column(db.String)
cloudfront_distribution_id = db.Column(db.String)
cloudfront_distribution_url = db.Column(db.String)
cloudfront_origin_hostname = db.Column(db.String)
cloudfront_origin_path = db.Column(db.String)
route53_change_ids = db.Column(postgresql.JSONB, default=[])
deactivated_at = db.Column(db.TIMESTAMP(timezone=True))
def __repr__(self):
return f"<ServiceInstance {self.id} {self.domain_names}>"
class Challenge(Base):
id = db.Column(db.Integer, primary_key=True)
certificate_id = db.Column(db.Integer,
db.ForeignKey("certificate.id"),
nullable=False)
domain = db.Column(db.String, nullable=False)
validation_domain = db.Column(db.String, nullable=False)
validation_contents = db.Column(db.Text, nullable=False)
body_json = db.Column(db.Text)
answered = db.Column(db.Boolean, default=False)
def __repr__(self):
return f"<Challenge {self.id} {self.domain}>"
class Certificate(Base):
id = db.Column(db.Integer, primary_key=True)
service_instance_id = db.Column(db.String,
db.ForeignKey("service_instance.id"),
nullable=False)
subject_alternative_names = db.Column(postgresql.JSONB, default=[])
leaf_pem = db.Column(db.Text)
expires_at = db.Column(db.TIMESTAMP(timezone=True))
private_key_pem = db.Column(
StringEncryptedType(db.Text, db_encryption_key, AesGcmEngine, "pkcs5"))
csr_pem = db.Column(db.Text)
fullchain_pem = db.Column(db.Text)
iam_server_certificate_id = db.Column(db.String)
iam_server_certificate_name = db.Column(db.String)
iam_server_certificate_arn = db.Column(db.String)
challenges = db.relation("Challenge",
backref="certificate",
lazy="dynamic",
cascade="all, delete-orphan")
order_json = db.Column(db.Text)
class Operation(Base):
# operation.state = Operation.States.IN_PROGRESS.value
States = OperationState
# operation.action = Operation.Actions.PROVISION.value
class Actions(Enum):
PROVISION = "Provision"
DEPROVISION = "Deprovision"
id = db.Column(db.Integer, primary_key=True)
service_instance_id = db.Column(db.String,
db.ForeignKey("service_instance.id"),
nullable=False)
state = db.Column(
db.String,
default=States.IN_PROGRESS.value,
server_default=States.IN_PROGRESS.value,
nullable=False,
)
action = db.Column(db.String, nullable=False)
def __repr__(self):
return f"<Operation {self.id} {self.state}>"
class ServiceInstance(Base):
__tablename__ = "service_instance"
id = db.Column(db.String(36), primary_key=True)
operations = db.relation("Operation",
backref="service_instance",
lazy="dynamic")
acme_user_id = db.Column(db.Integer, db.ForeignKey("acme_user.id"))
domain_names = db.Column(postgresql.JSONB, default=[])
instance_type = db.Column(db.Text)
domain_internal = db.Column(db.String)
route53_alias_hosted_zone = db.Column(db.String)
route53_change_ids = db.Column(postgresql.JSONB, default=[])
deactivated_at = db.Column(db.TIMESTAMP(timezone=True))
certificates = db.relation(
"Certificate",
backref="service_instance",
foreign_keys=Certificate.service_instance_id,
)
current_certificate_id = db.Column(
db.Integer,
db.ForeignKey(
"certificate.id",
name="fk__service_instance__certificate__current_certificate_id",
),
)
current_certificate = db.relation(
Certificate,
primaryjoin=current_certificate_id == Certificate.id,
foreign_keys=current_certificate_id,
post_update=True,
)
new_certificate_id = db.Column(
db.Integer,
db.ForeignKey(
"certificate.id",
name="fk__service_instance__certificate__new_certificate_id",
),
)
new_certificate = db.relation(
Certificate,
primaryjoin=new_certificate_id == Certificate.id,
foreign_keys=new_certificate_id,
post_update=True,
)
__mapper_args__ = {
"polymorphic_identity": "service_instance",
"polymorphic_on": instance_type,
}
def has_active_operations(self):
for operation in self.operations:
if (operation.state == Operation.States.IN_PROGRESS.value
and operation.canceled_at is None):
return True
return False
def __repr__(self):
return f"<ServiceInstance {self.id} {self.domain_names}>"