def delete_host_deployments(package_name, app_id, environment):
""" """
host_deps = (Session.query(HostDeployment).join(Host).join(Package).filter(
Package.pkg_name == package_name).filter(Host.app_id == app_id).filter(
Host.environment == environment).all())
for host_dep in host_deps:
# Commit to DB immediately
Session.delete(host_dep)
Session.commit()
def delete_host_deployment(hostname, package_name):
""" """
host_deps = (Session.query(HostDeployment).join(Host).join(Package).filter(
Package.pkg_name == package_name).filter(
Host.hostname == hostname).all())
# Allow this to silently do nothing if there are no matching rows
for host_dep in host_deps:
# Commit to DB immediately
Session.delete(host_dep)
Session.commit()
def delete_host_deployment(hostname, package_name):
""" """
host_deps = (Session.query(HostDeployment)
.join(Host)
.join(Package)
.filter(Package.pkg_name == package_name)
.filter(Host.hostname == hostname)
.all())
# Allow this to silently do nothing if there are no matching rows
for host_dep in host_deps:
# Commit to DB immediately
Session.delete(host_dep)
Session.commit()
def delete_host_deployments(package_name, app_id, environment):
""" """
host_deps = (Session.query(HostDeployment)
.join(Host)
.join(Package)
.filter(Package.pkg_name == package_name)
.filter(Host.app_id == app_id)
.filter(Host.environment == environment)
.all())
for host_dep in host_deps:
# Commit to DB immediately
Session.delete(host_dep)
Session.commit()
def add_host_deployment(dep_id, host_id, user, status, package_id):
"""Add host deployment for a given host and deployment"""
host_dep = HostDeployment(
deployment_id=dep_id,
host_id=host_id,
user=user,
status=status,
realized=func.current_timestamp(),
package_id=package_id,
)
# Commit to DB immediately
Session.add(host_dep)
Session.commit()
return host_dep
def add_host_deployment(dep_id, host_id, user, status, package_id):
"""Add host deployment for a given host and deployment"""
host_dep = HostDeployment(
deployment_id=dep_id,
host_id=host_id,
user=user,
status=status,
realized=func.current_timestamp(),
package_id=package_id,
)
# Commit to DB immediately
Session.add(host_dep)
Session.commit()
return host_dep
def add_deployment(user):
"""Add deployment for a given package ID"""
dep = Deployment(
user=user,
# THIS NEEDS TO BE REMOVED ONCE THE NEW DEPLOY CODE
# IS IN PLACE - KEL 20150827
status='complete',
declared=func.current_timestamp())
# Commit to DB immediately
Session.add(dep)
Session.commit()
Session.flush() # Needed to get DeploymentID generated
return dep
def add_deployment(user):
"""Add deployment for a given package ID"""
dep = Deployment(
user=user,
# THIS NEEDS TO BE REMOVED ONCE THE NEW DEPLOY CODE
# IS IN PLACE - KEL 20150827
status='complete',
declared=func.current_timestamp()
)
# Commit to DB immediately
Session.add(dep)
Session.commit()
Session.flush() # Needed to get DeploymentID generated
return dep
def add_app_deployment(dep_id, app_id, user, status, environment, package_id):
"""Add a tier deployment for a given deployment ID"""
environment_id = _calculate_environment_id(environment)
app_dep = AppDeployment(
deployment_id=dep_id,
app_id=app_id,
user=user,
status=status,
environment_id=environment_id,
realized=func.current_timestamp(),
package_id=package_id,
)
# Commit to DB immediately
Session.add(app_dep)
Session.commit()
return app_dep
def add_app_deployment(dep_id, app_id, user, status, environment, package_id):
"""Add a tier deployment for a given deployment ID"""
environment_id = _calculate_environment_id(environment)
app_dep = AppDeployment(
deployment_id=dep_id,
app_id=app_id,
user=user,
status=status,
environment_id=environment_id,
realized=func.current_timestamp(),
package_id=package_id,
)
# Commit to DB immediately
Session.add(app_dep)
Session.commit()
return app_dep
