pyfarm.master.user_interface.jobs module

pyfarm.master.user_interface.jobs.add_notified_user_to_job(job_id)

pyfarm.master.user_interface.jobs.alter_autodeletion_for_job(job_id)

pyfarm.master.user_interface.jobs.alter_frames_in_single_job(job_id)

pyfarm.master.user_interface.jobs.alter_scheduling_parameters_for_job(job_id)

pyfarm.master.user_interface.jobs.asc(column)

Produce an ascending ORDER BY clause element.

e.g.:

from sqlalchemy import asc
stmt = select([users_table]).order_by(asc(users_table.c.name))

will produce SQL as:

SELECT id, name FROM user ORDER BY name ASC

The asc() function is a standalone version of the ColumnElement.asc() method available on all SQL expressions, e.g.:

stmt = select([users_table]).order_by(users_table.c.name.asc())

Parameters:column – A ColumnElement (e.g. scalar SQL expression) with which to apply the asc() operation.

See also

desc()

nullsfirst()

nullslast()

Select.order_by()

pyfarm.master.user_interface.jobs.delete_multiple_jobs()

pyfarm.master.user_interface.jobs.delete_single_job(job_id)

pyfarm.master.user_interface.jobs.desc(column)

Produce a descending ORDER BY clause element.

e.g.:

from sqlalchemy import desc

stmt = select([users_table]).order_by(desc(users_table.c.name))

will produce SQL as:

SELECT id, name FROM user ORDER BY name DESC

The desc() function is a standalone version of the ColumnElement.desc() method available on all SQL expressions, e.g.:

stmt = select([users_table]).order_by(users_table.c.name.desc())

Parameters:column – A ColumnElement (e.g. scalar SQL expression) with which to apply the desc() operation.

See also

asc()

nullsfirst()

nullslast()

Select.order_by()

pyfarm.master.user_interface.jobs.distinct(expr)

Produce an column-expression-level unary DISTINCT clause.

This applies the DISTINCT keyword to an individual column expression, and is typically contained within an aggregate function, as in:

from sqlalchemy import distinct, func
stmt = select([func.count(distinct(users_table.c.name))])

The above would produce an expression resembling:

SELECT COUNT(DISTINCT name) FROM user

The distinct() function is also available as a column-level method, e.g. ColumnElement.distinct(), as in:

stmt = select([func.count(users_table.c.name.distinct())])

The distinct() operator is different from the Select.distinct() method of Select, which produces a SELECT statement with DISTINCT applied to the result set as a whole, e.g. a SELECT DISTINCT expression. See that method for further information.

See also

ColumnElement.distinct()

Select.distinct()

func

pyfarm.master.user_interface.jobs.jobs()

pyfarm.master.user_interface.jobs.or_(*clauses)

Produce a conjunction of expressions joined by OR.

E.g.:

from sqlalchemy import or_

stmt = select([users_table]).where(
                or_(
                    users_table.c.name == 'wendy',
                    users_table.c.name == 'jack'
                )
            )

The or_() conjunction is also available using the Python | operator (though note that compound expressions need to be parenthesized in order to function with Python operator precedence behavior):

stmt = select([users_table]).where(
                (users_table.c.name == 'wendy') |
                (users_table.c.name == 'jack')
            )

See also

and_()

pyfarm.master.user_interface.jobs.pause_multiple_jobs()

pyfarm.master.user_interface.jobs.pause_single_job(job_id)

pyfarm.master.user_interface.jobs.remove_notified_user_from_job(job_id, user_id)

pyfarm.master.user_interface.jobs.rerun_failed_in_job(job_id)

pyfarm.master.user_interface.jobs.rerun_failed_in_multiple_jobs()

pyfarm.master.user_interface.jobs.rerun_multiple_jobs()

pyfarm.master.user_interface.jobs.rerun_single_job(job_id)

pyfarm.master.user_interface.jobs.rerun_single_task(job_id, task_id)

pyfarm.master.user_interface.jobs.single_job(job_id)

pyfarm.master.user_interface.jobs.unpause_multiple_jobs()

pyfarm.master.user_interface.jobs.unpause_single_job(job_id)

pyfarm.master.user_interface.jobs.update_notes_for_job(job_id)

pyfarm.master.user_interface.jobs.update_tags_in_job(job_id)

pyfarm.master.user_interface.jobs.upgrade_job_to_latest_jobtype_version(job_id)