# Path: zoe_lib/state/base.py
# class BaseRecord:
#     """
#     :type sql_manager: SQLManager
#     """
#     def __init__(self, d, sql_manager):
#         """
#         :type sql_manager: SQLManager
#         """
#         self.sql_manager = sql_manager
#         self.id = d['id']
# 
#     def serialize(self):
#         """Generates a dictionary that can be serialized in JSON."""
#         raise NotImplementedError
# 
# class BaseTable:
#     """Common abstraction for all tables."""
#     def __init__(self, sql_manager, table_name):
#         self.table_name = table_name
#         self.sql_manager = sql_manager
#         self.cursor = self.sql_manager.cursor()
# 
#     def create(self):
#         """Create this table."""
#         raise NotImplementedError
# 
#     def insert(self, **kwargs):
#         """Create a new record."""
#         raise NotImplementedError
# 
#     def delete(self, record_id):
#         """Delete a record from this table."""
#         query = 'DELETE FROM "{}" WHERE id = %s'.format(self.table_name)
#         self.cursor.execute(query, (record_id,))
#         self.sql_manager.commit()
# 
#     def update(self, record_id, **kwargs):
#         """Update the state of an execution."""
#         arg_list = []
#         value_list = []
#         for key, value in kwargs.items():
#             arg_list.append('{} = %s'.format(key))
#             value_list.append(value)
#         set_q = ", ".join(arg_list)
#         value_list.append(record_id)
#         q_base = 'UPDATE "{}" SET '.format(self.table_name) + set_q + ' WHERE id=%s'
#         query = self.cursor.mogrify(q_base, value_list)
#         self.cursor.execute(query)
#         self.sql_manager.commit()
# 
#     def select(self, only_one=False, limit=-1, **kwargs):
#         """Select records."""
#         raise NotImplementedError


import datetime
import logging
import functools
import psycopg2
import zoe_lib.config
    from kazoo.client import KazooClient
from zoe_lib.state.base import BaseRecord, BaseTable
    @property
    def running_services_count(self) -> int:
        """Returns the number of services of this execution that are running."""
        count = 0
        for service in self.services:
            if not service.is_dead():
                count += 1
        return count

    @property
    def services_count(self) -> int:
        """Return the total number of services defined for this execution."""
        return len(self.services)

    @property
    def total_reservations(self):
        """Return the union/sum of resources reserved by all services of this execution."""
        if len(self.services) == 0:
            return None
        return functools.reduce(lambda x, y: x + y, [s.resource_reservation for s in self.services])

    @property
    def owner(self):
        """Returns the full user object that owns this execution."""
        return self.sql_manager.user.select(only_one=True, **{'id': self.user_id})

    def __repr__(self):
        return str(self.id)



# Path: zoe_lib/state/base.py
# class BaseRecord:
#     """
#     :type sql_manager: SQLManager
#     """
#     def __init__(self, d, sql_manager):
#         """
#         :type sql_manager: SQLManager
#         """
#         self.sql_manager = sql_manager
#         self.id = d['id']
# 
#     def serialize(self):
#         """Generates a dictionary that can be serialized in JSON."""
#         raise NotImplementedError
# 
# class BaseTable:
#     """Common abstraction for all tables."""
#     def __init__(self, sql_manager, table_name):
#         self.table_name = table_name
#         self.sql_manager = sql_manager
#         self.cursor = self.sql_manager.cursor()
# 
#     def create(self):
#         """Create this table."""
#         raise NotImplementedError
# 
#     def insert(self, **kwargs):
#         """Create a new record."""
#         raise NotImplementedError
# 
#     def delete(self, record_id):
#         """Delete a record from this table."""
#         query = 'DELETE FROM "{}" WHERE id = %s'.format(self.table_name)
#         self.cursor.execute(query, (record_id,))
#         self.sql_manager.commit()
# 
#     def update(self, record_id, **kwargs):
#         """Update the state of an execution."""
#         arg_list = []
#         value_list = []
#         for key, value in kwargs.items():
#             arg_list.append('{} = %s'.format(key))
#             value_list.append(value)
#         set_q = ", ".join(arg_list)
#         value_list.append(record_id)
#         q_base = 'UPDATE "{}" SET '.format(self.table_name) + set_q + ' WHERE id=%s'
#         query = self.cursor.mogrify(q_base, value_list)
#         self.cursor.execute(query)
#         self.sql_manager.commit()
# 
#     def select(self, only_one=False, limit=-1, **kwargs):
#         """Select records."""
#         raise NotImplementedError


# Path: zoe_lib/state/execution.py
import datetime
import logging
import functools
import psycopg2
import zoe_lib.config
    from kazoo.client import KazooClient
from zoe_lib.state.base import BaseRecord, BaseTable

    @property
    def running_services_count(self) -> int:
        """Returns the number of services of this execution that are running."""
        count = 0
        for service in self.services:
            if not service.is_dead():
                count += 1
        return count

    @property
    def services_count(self) -> int:
        """Return the total number of services defined for this execution."""
        return len(self.services)

    @property
    def total_reservations(self):
        """Return the union/sum of resources reserved by all services of this execution."""
        if len(self.services) == 0:
            return None
        return functools.reduce(lambda x, y: x + y, [s.resource_reservation for s in self.services])

    @property
    def owner(self):
        """Returns the full user object that owns this execution."""
        return self.sql_manager.user.select(only_one=True, **{'id': self.user_id})

    def __repr__(self):
        return str(self.id)



class ExecutionTable(BaseTable):