# Path: ndscheduler/corescheduler/constants.py
# DEFAULT_JOBS_TABLENAME = 'scheduler_jobs'
# DEFAULT_EXECUTIONS_TABLENAME = 'scheduler_execution'
# DEFAULT_AUDIT_LOGS_TABLENAME = 'scheduler_jobauditlog'
# DEFAULT_THREAD_POOL_SIZE = 4
# DEFAULT_JOB_MAX_INSTANCES = 3
# DEFAULT_JOB_COALESCE = True
# DEFAULT_TIMEZONE = 'UTC'
# DEFAULT_JOB_MISFIRE_GRACE_SEC = 3600
# JOB_ARGS = 5
# EXECUTION_STATUS_SCHEDULED = 0
# EXECUTION_STATUS_RUNNING = 1
# EXECUTION_STATUS_STOPPING = 2
# EXECUTION_STATUS_STOPPED = 3
# EXECUTION_STATUS_FAILED = 4
# EXECUTION_STATUS_SUCCEEDED = 5
# EXECUTION_STATUS_TIMEOUT = 6
# EXECUTION_STATUS_SCHEDULED_ERROR = 7
# EXECUTION_STATUS_DICT = {
#     EXECUTION_STATUS_SCHEDULED: 'scheduled',
#     EXECUTION_STATUS_RUNNING: 'running',
#     EXECUTION_STATUS_STOPPING: 'stopping',
#     EXECUTION_STATUS_STOPPED: 'stopped',
#     EXECUTION_STATUS_FAILED: 'failed',
#     EXECUTION_STATUS_SUCCEEDED: 'succeeded',
#     EXECUTION_STATUS_TIMEOUT: 'timeout',
#     EXECUTION_STATUS_SCHEDULED_ERROR: 'scheduled error'
# }
# AUDIT_LOG_ADDED = 0
# AUDIT_LOG_MODIFIED = 1
# AUDIT_LOG_DELETED = 2
# AUDIT_LOG_PAUSED = 3
# AUDIT_LOG_RESUMED = 4
# AUDIT_LOG_CUSTOM_RUN = 5
# AUDIT_LOG_DICT = {
#     AUDIT_LOG_ADDED: 'added',
#     AUDIT_LOG_MODIFIED: 'modified',
#     AUDIT_LOG_DELETED: 'deleted',
#     AUDIT_LOG_PAUSED: 'paused',
#     AUDIT_LOG_RESUMED: 'resumed',
#     AUDIT_LOG_CUSTOM_RUN: 'custom_run'
# }
# 
# Path: ndscheduler/corescheduler/utils.py
# def import_from_path(path):
# def get_current_datetime():
# def get_job_name(job):
# def get_job_args(job):
# def get_job_kwargs(job):
# def get_cron_strings(job):
# def generate_uuid():
# def get_stacktrace():
# def get_hostname():
# def get_pid():
# def get_datastore_instance(datastore_class_path, db_config=None, db_tablenames=None):
# 
# Path: ndscheduler/corescheduler/datastore/tables.py
# def get_execution_table(metadata, tablename):
# def get_auditlogs_table(metadata, tablename):


import dateutil.tz
import dateutil.parser
from apscheduler.jobstores import sqlalchemy as sched_sqlalchemy
from sqlalchemy import desc, select, MetaData
from ndscheduler.corescheduler import constants
from ndscheduler.corescheduler import utils
from ndscheduler.corescheduler.datastore import tables
                        'description': ...
                    }
                ]
            }
            Sorted by created_time.
        :rtype: dict
        """
        utc = dateutil.tz.gettz('UTC')
        start_time = dateutil.parser.parse(time_range_start).replace(tzinfo=utc)
        end_time = dateutil.parser.parse(time_range_end).replace(tzinfo=utc)
        selectable = select('*').where(
            self.auditlogs_table.c.created_time.between(
                start_time, end_time)).order_by(desc(self.auditlogs_table.c.created_time))

        rows = self.engine.execute(selectable)

        return_json = {
            'logs': [self._build_audit_log(row) for row in rows]}

        return return_json

    def _build_audit_log(self, row):
        """Return audit_log from a row of scheduler_auditlog table.
        :param obj row: A row instance of scheduler_auditlog table.
        :return: A dictionary of audit log.
        :rtype: dict
        """
        return_dict = {
            'job_id': row.job_id,
            'job_name': row.job_name,

# Path: ndscheduler/corescheduler/constants.py
# DEFAULT_JOBS_TABLENAME = 'scheduler_jobs'
# DEFAULT_EXECUTIONS_TABLENAME = 'scheduler_execution'
# DEFAULT_AUDIT_LOGS_TABLENAME = 'scheduler_jobauditlog'
# DEFAULT_THREAD_POOL_SIZE = 4
# DEFAULT_JOB_MAX_INSTANCES = 3
# DEFAULT_JOB_COALESCE = True
# DEFAULT_TIMEZONE = 'UTC'
# DEFAULT_JOB_MISFIRE_GRACE_SEC = 3600
# JOB_ARGS = 5
# EXECUTION_STATUS_SCHEDULED = 0
# EXECUTION_STATUS_RUNNING = 1
# EXECUTION_STATUS_STOPPING = 2
# EXECUTION_STATUS_STOPPED = 3
# EXECUTION_STATUS_FAILED = 4
# EXECUTION_STATUS_SUCCEEDED = 5
# EXECUTION_STATUS_TIMEOUT = 6
# EXECUTION_STATUS_SCHEDULED_ERROR = 7
# EXECUTION_STATUS_DICT = {
#     EXECUTION_STATUS_SCHEDULED: 'scheduled',
#     EXECUTION_STATUS_RUNNING: 'running',
#     EXECUTION_STATUS_STOPPING: 'stopping',
#     EXECUTION_STATUS_STOPPED: 'stopped',
#     EXECUTION_STATUS_FAILED: 'failed',
#     EXECUTION_STATUS_SUCCEEDED: 'succeeded',
#     EXECUTION_STATUS_TIMEOUT: 'timeout',
#     EXECUTION_STATUS_SCHEDULED_ERROR: 'scheduled error'
# }
# AUDIT_LOG_ADDED = 0
# AUDIT_LOG_MODIFIED = 1
# AUDIT_LOG_DELETED = 2
# AUDIT_LOG_PAUSED = 3
# AUDIT_LOG_RESUMED = 4
# AUDIT_LOG_CUSTOM_RUN = 5
# AUDIT_LOG_DICT = {
#     AUDIT_LOG_ADDED: 'added',
#     AUDIT_LOG_MODIFIED: 'modified',
#     AUDIT_LOG_DELETED: 'deleted',
#     AUDIT_LOG_PAUSED: 'paused',
#     AUDIT_LOG_RESUMED: 'resumed',
#     AUDIT_LOG_CUSTOM_RUN: 'custom_run'
# }
# 
# Path: ndscheduler/corescheduler/utils.py
# def import_from_path(path):
# def get_current_datetime():
# def get_job_name(job):
# def get_job_args(job):
# def get_job_kwargs(job):
# def get_cron_strings(job):
# def generate_uuid():
# def get_stacktrace():
# def get_hostname():
# def get_pid():
# def get_datastore_instance(datastore_class_path, db_config=None, db_tablenames=None):
# 
# Path: ndscheduler/corescheduler/datastore/tables.py
# def get_execution_table(metadata, tablename):
# def get_auditlogs_table(metadata, tablename):


# Path: ndscheduler/corescheduler/datastore/base.py
import dateutil.tz
import dateutil.parser
from apscheduler.jobstores import sqlalchemy as sched_sqlalchemy
from sqlalchemy import desc, select, MetaData
from ndscheduler.corescheduler import constants
from ndscheduler.corescheduler import utils
from ndscheduler.corescheduler.datastore import tables

                        'description': ...
                    }
                ]
            }
            Sorted by created_time.
        :rtype: dict
        """
        utc = dateutil.tz.gettz('UTC')
        start_time = dateutil.parser.parse(time_range_start).replace(tzinfo=utc)
        end_time = dateutil.parser.parse(time_range_end).replace(tzinfo=utc)
        selectable = select('*').where(
            self.auditlogs_table.c.created_time.between(
                start_time, end_time)).order_by(desc(self.auditlogs_table.c.created_time))

        rows = self.engine.execute(selectable)

        return_json = {
            'logs': [self._build_audit_log(row) for row in rows]}

        return return_json

    def _build_audit_log(self, row):
        """Return audit_log from a row of scheduler_auditlog table.
        :param obj row: A row instance of scheduler_auditlog table.
        :return: A dictionary of audit log.
        :rtype: dict
        """
        return_dict = {
            'job_id': row.job_id,
            'job_name': row.job_name,

            'event': constants.AUDIT_LOG_DICT[row.event],