Skip to main content

A Production Asset Management (ProdAM) System

Project description


Stalker is an Open Source Production Asset Management (ProdAM) Library designed
specifically for Animation and VFX Studios but can be used for any kind of
projects. Stalker is licensed under LGPL v2.1.

* Designed for animation and VFX Studios.
* Platform independent.
* Default installation handles nearly all the asset and project management
needs of an animation and vfx studio.
* Customizable with configuration scripts.
* Customizable object model (Stalker Object Model - SOM).
* Uses TaskJuggler as the project planing and tracking backend.
* Can be used with any kind of databases supported by SQLAlchemy.
* Can be connected to all the major 3d animation packages like Maya, Houdini,
Nuke, Softimage, Vue, Blender etc. and any application that has a Python

Stalker is build over these other OpenSource projects:
* Python
* SQLAlchemy and Alembic
* Jinja2
* TaskJuggler

Stalker as a library has no graphical UI, it is a python library that gives you
the ability to build your pipeline on top of it. There are other python
packages like the Open Source Pyramid Web Application `Stalker Pyramid`_ and
the Open Source pipeline library `Anima`_ which has PyQt/PySide UIs for
applications like Maya, Nuke, Houdini, Eyeon Fusion, Photoshop etc.

.. _`Stalker Pyramid`:
.. _`Anima`:


The latest development version is available in `GitHub`_ page of Stalker or can
be directly cloned with the following command if you already have git

git clone

.. _GitHub:

Stalker Changes

* **Update:** ``TaskJugglerScheduler`` is now 466x faster when dumping all the
data to TJP file. So with this new update it is taking only 1.5 seconds to
dump ~20k tasks to a valid TJP file where it was around ~10 minutes in
previous implementation. The speed enhancements is available only to
PostgreSQL dialect for now.

* **Fix:** Fixed TimeLog output in one line per task in ``Task.to_tjp()``.

* **New:** Added ``TaskJugglerScheduler`` now accepts a new argument called
``compute_resources`` which when set to True will also consider
`Task.alternative_resources` attribute and will fill
``Task.computed_resources`` attribute for each Task. With
``TaskJugglerScheduler`` when the total number of Task is around 15k it will
take around 7 minutes to generate this data, so by default it is set to


* **New:** Added ``efficiency`` attribute to ``User`` class. See
:class:`.User` documentation for more info.

* **Fix:** Fixed an **autoflush** problem in ``Studio.schedule()`` method.

* **New:** Added ``Repository.make_relative()`` method, which makes the given
path to relative to the repository root. It considers that the path is
already in the repository. So for now, be careful about not to pass a path
outside of the repository.

* **Update:** ``TaskJugglerScheduler.schedule()`` method now uses the
``Studio.start`` and ``Studio.end`` values for the scheduling range instead
of the hardcoded dates.

* **Update:** ``Task.create_time_log()`` method now returns the created
``TimeLog`` instance.

* **Fix:** Fixed an ``autoflush`` issue in
``Task.update_status_with_children_statuses()`` method.

* **Update:** ``Studio.is_scheduling`` and ``Studio.is_scheduling_by``
attributes will not be updated or checked at the beginning of the
``Studio.schedule()`` method. It is the duty of the user to check those
attributes before calling ``Studio.schedule()``. This is done in this way
because without being able to do a db commit inside ``Studio.schedule()``
method (which is the case with transaction managers which may be used in web
applications like **Stalker Pyramid**) it is not possible to persist and thus
use those variables. So, to be able to use those attributes meaningfully the
user should set them. Those variables will be set to False and None
accordingly by the ``Studio.schedule()`` method after the scheduling is done.

* **Fix:** Fixed a deadlock in ``TaskJugglerScheduler.schedule()`` method
related with the ``Popen.stderr.readlines()`` blocking the TaskJuggler
process without being able to read the output buffer.

* **Update:** ``TaskJugglerScheduler.schedule()`` is now using bulk inserts and
updates which is way faster than doing it with pure Python. Use
``parsing_method`` (0: SQL, 1: Python) to choose between SQL or Pure Python
implementation. Also updated ``Studio.schedule()`` to take in a
``parsing_method`` parameter.

* **Update:** The ``cut_in``, ``cut_out`` and ``cut_duration`` attribute
behaviour and the attribute order is updated in ``Shot`` class. So, if three
of the values are given, then the ``cut_duration`` attribute value will be
calculated from ``cut_in`` and ``cut_out`` attribute values. In any case
``cut_out`` precedes ``cut_duration``, and if none of them given ``cut_in``
and ``cut_duration`` values will default to 1 and ``cut_out`` will be
calculated by using ``cut_in`` and ``cut_duration``.

* **New:** Entity to Note relation is now Many-to-Many. So one Note can now be
assigned more than one Entity.

* **New:** Added alembic revision for ``Entity_Notes`` table creation and data
migration from ``Notes`` table to ``Entity_Notes`` table. So all notes are

* **Fix:** Fixed ``Shot.cut_duration`` attribute initialization on ``Shot``
instances restored from database.

* **Fix:** Fixed ``Studios.is_scheduling_by`` relationship configuration, which
was wrongly referencing the ``Studios.last_scheduled_by_id`` column instead
of ``Studios.is_scheduled_by_id`` column.

* **New:** Added a ``Task.review_set(review_number)`` method to get the desired
set of reviews. It will return the latest set of reviews if ``review_number``
is skipped or it is None.

* **Update:** Removed ``Task.approve()`` it was making things complex than it
should be.

* **Fix:** Added ``Page`` to ``class_names`` in ``db.init()``.

* **Fix:** Fixed ``TimeLog`` tjp representation to use bot the ``start`` and
``end`` date values instead of the ``start`` and ``duration``. This is much
better because it is independent from the timing resolution settings.

* **Fix:** Fixed ```` method, and prevented it
to call ``DBSession.commit()`` which causes errors if there is a transaction

* **Fix:** Fixed ``stalker.models._parse_csv_file()`` method for empty
computed resources list.

* **New:** ``stalker.models.task.TimeLog`` instances are now checking if the
dependency relation between the task that receives the time log and the tasks
that the task depends to will be violated in terms of the start and end dates
and raises a ``DependencyViolationError`` if it is the case.


* **New:** Added ```` class, for holding a per Project

* **Fix:** ``Review.task`` attribute now accepts None but this is mainly done
to allow its relation to the ``Task`` instance can be broken when it needs to
be deleted without issuing a database commit.

* **Update:** The following column names are updated:

* ``Tasks._review_number`` to ``Tasks.review_number``
* ``Tasks._schedule_seconds`` to ``Tasks.schedule_seconds``
* ``Tasks._total_logged_seconds`` to ``Tasks.total_logged_seconds``
* ``Reviews._review_number`` to ``Reviews.review_number``
* ``Shots._cut_in`` to ``Shots.cut_in``
* ``Shots._cut_out`` to ``Shots.cut_out``

Also updated alembic migration to create columns with those names.

* **Update:** Updated Alembic revision ``433d9caaafab`` (the one related with
stalker 2.5 update) to also include following updates:

* Create StatusLists for Tasks, Asset, Shot and Sequences and add all the
Statuses in the Task Status Workflow.
* Remove ``NEW`` from all of the status lists of Task, Asset, Shot and
* Update all the ``PREV`` tasks to ``WIP`` to let them use the new Review
* Update the ``Tasks.review_number`` to 0 for all tasks.
* Create StatusLists and Statuses (``NEW``, ``RREV``, ``APP``) for Reviews.
* Remove any other status then defined in the Task Status Workflow from Task,
Asset, Shot and Sequence status list.

* **Fix:** Fixed a bug in ``Task`` class where trying to remove the
dependencies will raise an ``AttributeError`` caused by the
``Task._previously_removed_dependent_tasks`` attribute.

* **New:** Task instances now have two new properties called ``path`` and
``absolute_path``. As in Version instances, these are the rendered version
of the related FilenameTemplate object in the related Project. The ``path``
attribute is Repository root relative and ``absolute_path`` is the absolute
path including the OS dependent Repository path.

* **Update:** Updated alembic revision with revision number "433d9caaafab" to
also create Statuses introduced with Stalker v0.2.5.

* **Update:** ``Version.__repr__`` results with a more readable string.

* **New:** Added a generalized generator called
``stalker.models.walk_hierarchy()`` that walks and yields the entities over
the given attribute in DFS or BFS fashion.

* **New:** Added ``Task.walk_hierarchy()`` which iterates over the hierarchy of
the task. It walks in a breadth first fashion. Use ``method=0`` to walk in
depth first.

* **New:** Added ``Task.walk_dependencies()`` which iterates over the
dependencies of the task. It walks in a breadth first fashion. Use
``method=0`` to walk in depth first.

* **New:** Added ``Version.walk_hierarchy()`` which iterates over the hierarchy
of the version. It walks in a depth first fashion. Use ``method=1`` to walk
in breadth first.

* **New:** Added ``Version.walk_inputs()`` which iterates over the inputs of
the version. It walks in a depth first fashion. Use ``method=1`` to walk in
breath first.

* **Update:** ``stalker.models.check_circular_dependency()`` function is now
using ``stalker.models.walk_hierarchy()`` instead of recursion over itself,
which makes it more robust in deep hierarchies.

* **Fix:** ``db.init()`` now updates the statuses of already created status
lists for ``Task``, ``Asset``, ``Shot`` and ``Sequence`` classes.


* **Update:** ``Revision`` class is renamed to ``Review`` and introduced a
couple of new attributes.

* **New:** Added a new workflow called "Task Review Workflow". Please see the
documentation about the new workflow.

* **Update:** ``Task.responsible`` attribute is now a list which allows
multiple responsible to be set for a ``Task``.

* **New:** Because of the new "Task Review Workflow" task statuses which are
normally created in Stalker Pyramid are now automatically created in Stalker
database initialization. The new statuses are
**Waiting For Dependency (WFD)**, **Ready To Start (RTS)**,
**Work In Progress (WIP)**, **Pending Review (PREV)**,
**Has Revision (HREV)**, **On Hold (OH)**, **Stopped (STOP)** and
**Completed (CMPL)** are all used in ``Task``, ``Asset``, ``Shot`` and
``Sequence`` status lists by default.

* **New:** Because of the new "Task Review Workflow" also a status list for
``Review`` class is created by default. It contains the statuses of
**New (NEW)**, **Requested Revision (RREV)** and **Approved (APP)**.

* **Fix:** ``Users.login`` column is now unique.

* **Update:** Ticket workflow in config is now using the proper status names
instead of the lower case names of the statuses.

* **New:** Added a new exception called **StatusError** which states the entity
status is not suitable for the action it is applied to.

* **New:** ``Studio`` instance now stores the scheduling state to the database
to prevent two scheduling process to override each other. It also stores the
last schedule message and the last schedule date and the id of the user who
has done the scheduling.

* **New:** The **Task Dependency** relation is now using an
**Association Object** instead of just a **Secondary Table**. The
``Task.depends`` and ``Task.dependent_of`` attributes are now

Also added extra parameters like ``dependency_target``, ``gap_timing``,
``gap_unit`` and ``gap_model`` to the dependency relation. So all of the
dependency relations are now able to hold those extra information.

Updated the ``task_tjp_template`` to reflect the details of the dependencies
that a task has.

* **New:** ``ScheduleMixin`` class now has some default class attributes that
will allow customizations in inherited classes. This is mainly done for
``TaskDependency`` class and for ``the gap_timing``, ``gap_unit``,
``gap_model`` attributes which are in fact synonyms of ``schedule_timing``,
``schedule_unit`` and ``schedule_model`` attributes coming from the
``ScheduleMixin`` class. So by using the ``__default_schedule_attr_name__``
Stalker is able to display error messages complaining about ``gap_timing``
attribute instead of ``schedule_timing`` etc.

* **New:** Updating a task by calling ``Task.request_revision()`` will now set
the ``TaskDependency.dependency_target`` to **'onstart'** for tasks those are
depending to the revised task and updated to have a status of **DREV**,
**OH** or **STOP**. Thus, TaskJuggler will be able to continue scheduling
these tasks even if the tasks are now working together.

* **Update:** Updated the TaskJuggler templates to make the tjp output a little
bit more readable.

* **New:** ``ScheduleMixin`` now creates more localized (to the mixed in class)
column and enum type names in the mixed in classes.

For example, it creates the ``TaskScheduleModel`` enum type for ``Task``
class and for ``TaskDependency`` it creates ``TaskDependencyGapModel`` with
the same setup following the ``{{class_name}}{{attr_name}}Model`` template.

Also it creates ``schedule_model`` column for ``Task``, and ``gap_model`` for
``TaskDependency`` class.

* **Update:** Renamed the ``TaskScheduleUnit`` enum type name to ``TimeUnit``
in ``ScheduleMixin``.


* **New:** Added new class called ``Revision`` to hold info about Task

* **Update:** Renamed ``ScheduleMixin`` to ``DateRangeMixin``.

* **New:** Added a new mixin called ``ScheduleMixin`` (replacing the old one)
which adds attributes like ``schedule_timing``, ``schedule_unit``,
``schedule_model`` and ``schedule_constraint``.

* **New:** Added ```` and ``Task.open_tickets`` properties.

* **Update:** Removed unnecessary arguments (``project_lead``, ``tasks``,
``watching``, ``last_login``) from User class.

* **Update:** The ``timing_resolution`` attribute is moved from the
``DateRangeMixin`` to ``Studio`` class. So instances of classes like
``Project`` or ``Task`` will not have their own timing resolution anymore.

* **New:** The ``Studio`` instance now overrides the values on
``stalker.defaults`` on creation and on load, and also the ``db.setup()``
function lets the first ``Studio`` instance that it finds to update the
defaults. So it is now possible to use ``stalker.defaults`` all the time
without worrying about the Studio settings.

* **Update:** The ``Studio.yearly_working_days`` value is now always an

* **New:** Added a new method ``ScheduleMixin.least_meaningful_time_unit()`` to
calculate the most appropriate timing unit and the value of the given seconds
which represents an interval of time.

So it will convert 3600 seconds to 1 hours, and 8424000 seconds to 1 years if
it represents working time (``as_working_time=True``) or 2340 hours if it is
representing the calendar time.

* **New:** Added a new method to ``ScheduleMixin`` called ``to_seconds()``. The
``to_seconds()`` method converts the given schedule info values
(``schedule_timing``, ``schedule_unit``, ``schedule_model``) to seconds
considering if the given ``schedule_model`` is work time based ('effort' or
'length') or calendar time based ('duration').

* **New:** Added a new method to ``ScheduleMixin`` called ``schedule_seconds``
which you may recognise from ``Task`` class. What it does is pretty much the
same as in the ``Task`` class, it converts the given schedule info values to

* **Update:** In ``DateRangeMixin``, when the ``start``, ``end`` or
``duration`` arguments given so that the duration is smaller then the
``defaults.timing_resolution`` the ``defaults.timing_resolution`` will be
used as the ``duration`` and the ``end`` will be recalculated by anchoring
the ``start`` value.

* **New:** Adding a ``TimeLog`` to a ``Task`` and extending its schedule info
values now will always use the least meaningful timing unit. So expanding a
task from 16 hours to 18 hours will result a task with 2 days of schedule
(considering the ``daily_working_hours = 9``).

* **Update:** Moved the ``daily_working_hours`` attribute from ``Studio`` class
to ``WorkingHours`` class as it was much related to this one then ``Studio``
class. Left a property with the same name in the ``Studio`` class, so it will
still function as it was before but there will be no column in the database
for that attribute anymore.

* **Fix:** Fixed a bug in ``stalker.models.auth.LocalSession`` where stalker
was complaining about "copy_reg" module, it seems that it is related to
`this bug`_.

.. _this bug:

* **Update:** Fixed a little bug in Link.extension property setter.

* **New:** Moved the stalker.models.env.EnvironmentBase class to
"Anima Tools" python module.

* **Fix:** Fixed a bug in stalker.models.task.Task._responsible_getter() where
it was always returning the greatest parents responsible as the responsible
for the child task when the responsible is set to None for the child.

* **New:** Added ``stalker.models.version.Version.naming_parents`` which
returns a list of parents starting from the closest parent Asset, Shot or

* **New:** ``stalker.models.version.Version.nice_name`` now generates a name
starting from the closest Asset, Shot or Sequence parent.

* **New:** ``Ticket`` action methods (``resolve``, ``accept``, ``reassign``,
``reopen``) now return the created ``TicketLog`` instance.

* **Update:** Added tests for negative or zero fps value in Project class.

* **Fix:** Minor fix to ``schedule_timing`` argument in Task class, where IDEs
where assuming that the value passed to the ``schedule_timing`` should be
integer where as it accepts floats also.

* **Update:** Removed ``bg_color`` and ``fg_color`` attributes (and columns)
from Status class. Use SimpleEntity.html_class and SimpleEntity.html_style
attributes instead.

* **New:** Added ``Project.open_tickets`` property.

* **Fix:** Fixed an inconvenience in SimpleEntity.__init__() when a
date_created argument with a value is later than is
supplied and the date_updated argument is skipped or given as None, then the
date_updated attribute value was generated from this
was causing an unnecessary ValueError. This is fixed by directly copying the
date_created value to date_updated value when it is skipped or None.


* **New:** SimpleEntity now have two new attributes called ``html_style`` and
``html_class`` which can be used in storing cosmetic html values.

* **Update:** Note.content attribute is now a synonym of the Note.description

* **Update:** Studio.schedule() now returns information about how much did it
take to schedule the tasks.

* **Update:** Studio.to_tjp() now returns information about how much did it
take to complete the conversion.

* **Fix:** Task.percent_complete() now calculates the percent complete


* **Update:** Added cascade attributes to all necessary relations for all the

* **Update:** The Version class is not mixed with the StatusMixin anymore. So
the versions are not going to be statusable anymore. Also created alembic
revision (a6598cde6b) for that update.

* **Update:** TaskJugglerScheduler and the Studio classes are now returning the
stderr message out of their ``schedule()`` methods.

* **Fix:** Disabled some deep debug messages on

* **Fix:** Fixed a flush issue related to the Task.parent attribute which is
lazily loaded in Task._schedule_seconds_setter().


* **Fix:** As usual distutil thinks ``0.2.0`` is a lower version number than
``0.2.0.rc5`` (I should have read the documentation again and used
``0.2.0.c5`` instead of ``0.2.0.rc5``) so this is a dummy update to just to
fix the version number.


* **Update:** Vacation tjp template now includes the time values of the start
and end dates of the Vacation instance.


* **Update:** For a container task, ``Task.total_logged_seconds`` and
``Task.schedule_seconds`` attributes are now using the info of the child
tasks. Also these attributes are cached to database, so instead of querying
the child tasks all the time, the calculated data is cached and whenever a
TimeLog is created or updated for a child task (which changes the
``total_logged_seconds`` for the child task) or the ``schedule_timing`` or
``schedule_unit`` attributes are updated, the cached values are updated on
the parents. Allowing Stalker to display percent_complete info of a container
task without loading any of its children.

* **New:** Added ``Task.percent_complete`` attribute, which calculates the
percent of completeness of the task based on the
``Task.total_logged_seconds`` and ``Task.schedule_seconds`` attributes.

* **Fix:** Added ``TimeLog.__eq__()`` operator to more robustly check if the
time logs are overlapping.

* **New:** Added ``Project.percent_complete``,
``Percent.total_logged_seconds`` and ``Project.schedule_seconds`` attributes.

* **Update:** ``ScheduleMixin._validate_dates()`` does not set the date values
anymore, it just return the calculated and validated ``start``, ``end`` and
``duration`` values.

* **Update:** ``Vacation`` now can be created without a ``User`` instance,
effectively making the ``Vacation`` a ``Studio`` wide vacation, which applies
to all users.

* **Update:** ``Vacation.__strictly_typed__`` is updated to ``False``, so there
is no need to create a ``Type`` instance to be able to create a ``Vacation``.

* **New:** ```` property now returns the ``Vacation`` instances
which has no *user*.

* **Update:** ``Task.start`` and ``Task.end`` values are no more read from
children Tasks for a container task over and over again but calculated
whenever the start and end values of a child task are changed or a new child
is appended or removed.

* **Update:** ``SimpleEntity.description`` validation routine doesn't convert
the input to string anymore, but checks the given description value against
being a string or unicode instance.

* **New:** Added ``Ticket.summary`` field.

* **Fix:** Fixed ``Link.extension``, it is now accepting unicode.


* **New:** Added a new attribute to ``Version`` class called
``latest_version`` which holds the latest version in the version queue.

* **New:** To optimize the database connection times, ``stalker.db.setup()``
will not try to initialize the database every time it is called anymore. This
leads a ~4x speed up in database connection setup. To initialize a newly
created database please use::

# for a newly created database
from stalker import db
db.setup() # connects to database
db.init() # fills some default values to be used with Stalker

# for any subsequent access just use (don't need to call db.init())

* **Update:** Removed all ``__init_on_load()`` methods from all of the classes.
It was causing SQLAlchemy to eagerly load relations, thus slowing down
queries in certain cases (especially in ``Task.parent`` -> ``Task.children``

* **Fix:** Fixed ``Vacation`` class tj3 format.

* **Fix:** ```` attribute was not properly working when the
``Studio`` instance has been restored from database.


* **New:** Added a new attribute to ``Task`` class called ``responsible``.

* **Update:** Removed ``Sequence.lead_id`` use ``Task.reponsible`` instead.

* **Update:** Updated documentation to include documentation about
Configuring Stalker with ````.

* **Update:** The ``duration`` argument in ``Task`` class is removed. It is
somehow against the idea of having ``schedule_model`` and ``schedule_timing``
arguments (``schedule_model='duration'`` is kind of the same).

* **Update:** Updated ``Task`` class documentation.


* **New:** Added ``Version.created_with`` attribute to track the environment or
host program name that a particular ``Version`` instance is created with.


* **Update:** Moved the Pyramid part of the system to another package called

* **Fix:** Fixed ```` where importing ``stalker`` to get the
``__version__`` variable causing problems.


* **New:** Added ``Version.latest_published_version`` and

* **Fix:** Fixed ``Version.__eq__()``, now Stalker correctly distinguishes
different Version instances.

* **New:** Added ``Repository.to_linux_path()``,
``Repository.to_windows_path()``, ``Repository.to_osx_path()`` and
``Repository.to_native_path()`` to the ``Repository`` class.

* **New:** Added ``Repository.is_in_repo(path)`` which checks if the given
path is in this repo.


* **Update:** Renamed **Version.version_of** attribute to **Version.task**.

* **Fix:** Fixed **Version.version_number** where it was not possible to have
a version number bigger than 2.

* **Fix:** In **db.setup()** Ticket statuses are only created if there aren't

* **Fix:** Added **Vacation** class to the registered class list in


* **Update:** **Task.schedule_constraint** is now reflected to the tjp file

* **Fix:** **check_circular_dependency()** now checks if the **entity** and
the **other_entity** are the same.

* **Fix:** **Task.to_tjp()** now correctly add the dependent tasks of a
container task.

* **Fix:** **Task.__eq__()** now correctly considers the parent, depends,
resources, start and end dates.

* **Update:** **Task.priority** is now reflected in tjp file if it is
different than the default value (500).

* **New::** Added a new class called **Vacation** to hold user vacations.

* **Update:** Removed dependencies to ```` and
```` in couple of packages.

* **Update:** Changed the way the ``stalker.defaults`` is created.

* **Fix:** **EnvironmentBase.get_version_from_full_path()**,
**EnvironmentBase.trim_repo_path()**, **EnvironmentBase.find_repo** methods
are now working properly.

* **Update:** Added **Version.absolute_full_path** property which renders the
absolute full path which also includes the repository path.

* **Update:** Added **Version.absolute_path** property which renders the
absolute path which also includes the repository path.


* **Fix:** Fixed **LocalSession._write_data()**, previously it was not
creating the local session folder.

* **New:** Added a new method called **LocalSession.delete()** to remove the
local session file.

* **Update:** **Link.full_path** can now be set to an empty string. This is
updated in this way for **Version** class.

* **Update:** Updated the formatting of **SimpleEntity.nice_name**, it is now
possible to have uppercase letters and camel case format will be preserved.

* **Update**: **Version.take_name** formatting is enhanced.

* **New**: **Task** class is now mixed in with **ReferenceMixin** making it
unnecessary to have **Asset**, **Shot** and **Sequence** classes all mixed
in individually. Thus removed the **ReferenceMixin** from **Asset**,
**Shot** and **Sequence** classes.

* **Update**: Added **Task.schedule_model** validation and its tests.

* **New**: Added **ScheduleMixin.total_seconds** and


* **New:** **Version** class now has two new attributes called ``parent`` and
``children`` which will be used in tracking of the history of Version
instances and track which Versions are derived from which Version.

* **New:** **Versions** instances are now derived from **Link** class and not

* **Update:** Added new revisions to **alembic** to reflect the change in
**Versions** table.

* **Update:** **Links.path** is renamed to **Links.full_path** and added
three new attributes called **path**, **filename** and **extension**.

* **Update:** Added new revisions to alembic to reflect the change in
**Links** table.

* **New:** Added a new class called **LocalSession** to store session data in
users local filesystem. It is going to be replaced with some other system
like **Beaker**.

* **Fix:** Database part of Stalker can now be imported without depending to

* **Fix:** Fixed documentation errors that **Sphinx** complained about.


* No changes in SOM.


* **Update:** FilenameTemplate's are not ``strictly typed`` anymore.

* **Update:** Removed the FilenameTemplate type initialization, FilenameTemplates
do not depend on Types anymore.

* **Update:** Added back the ``plural_class_name`` (previously ``plural_name``)
property to the ORMClass class, so all the classes in SOM now have this new

* **Update:** Added ``accepts_references`` attribute to the EntityType class.

* **New:** The Link class has a new attribute called ``original_filename`` to
store the original file names of link files.

* **New:** Added **alembic** to the project requirements.

* **New:** Added alembic migrations which adds the ``accepts_references`` column
to ``EntityTypes`` table and ``original_name`` to the ``Links`` table.


* Stalker is now compatible with Python 2.6.
* Task:

* **Update:** Tasks now have a new attribute called ``watchers`` which holds a
list of User instances watching the particular Task.

* **Update:** Users now have a new attribute called ``watching`` which is a
list of Task instances that this user is watching.

* TimeLog:

* **Update:** TimeLog instances will expand Task.schedule_timing value
automatically if the total amount of logged time is more than the
schedule_timing value.

* **Update:** TimeLogs are now considered while scheduling the task.

* **Fix:** TimeLogs raises OverBookedError when appending the same TimeLog
instance to the same resource.

* Auth:

* **Fix:** The default ACLs for determining the permissions are now working


* WorkingHours.is_working_hour() is working now.

* WorkingHours class is moved from stalker.models.project to module.

* ``daily_working_hours`` attribute is moved from
stalker.models.project.Project to class.

* Repository path variables now ends with a forward slash even if it is not

* Updated Project classes validation messages to correlate with Stalker

* Implementation of the Studio class is finished. The scheduling works like a

* It is now possible to use any characters in and the derived

* Booking class is renamed to TimeLog.


* Added new attribute to WorkingHours class called ``weekly_working_hours``,
which calculates the weekly working hours based on the working hours defined
in the instance.

* Task class now has a new attribute called ``schedule_timing`` which is
replacing the ``effort``, ``length`` and ``duration`` attributes. Together
with the ``schedule_model`` attribute it will be used in scheduling the Task.

* Updated the config system to the one used in oyProjectManager (based on
Sphinx config system). Now to reach the defaults::

# instead of doing the following
from stalker.conf import defaults # not valid anymore

# use this
from stalker import defaults

If the above idiom is used, the old ``defaults`` module behaviour is
retained, so no code change is required other than the new lower case config
variable names.


* A new property called ``to_tjp`` added to the SimpleEntity class which needs
to be implemented in the child and is going to be used in TaskJuggler

* A new attribute called ``is_scheduled`` added to Task class and it is going
to be used in Gantt charts. Where it will lock the class and will not try
to snap it to anywhere if it is scheduled.

* Changed the ``resolution`` attribute name to ``timing_resolution`` to comply
with TaskJuggler.

* ScheduleMixin:

* Updated ScheduleMixin class documentation.

* There are two new read-only attributes called ``computed_start`` and
``computed_end``. These attributes will be used in storing of the values
calculated by TaskJuggler, and will be used in Gantt Charts if available.

* Added ``computed_duration``.

* Task:

* Arranged the TaskJuggler workflow.

* The task will use the effort > length > duration attributes in `to_tjp`

* Changed the license of Stalker from BSD-2 to LGPL 2.1. Any version previous
to 0.2.0.a9 will be still BSD-2 and any version from and including 0.2.0.a9
will be distributed under LGPL 2.1 license.

* Added new types of classes called Schedulers which are going to be used in
scheduling the tasks.

* Added TaskJugglerScheduler, it uses the given project and schedules its


* TagSelect now can be filled by setting its ``value`` attribute (Ex:
TagSelect.set('value', data))

* Added a new method called ``is_root`` to Task class. It is true for tasks
where there are no parents.

* Added a new attribute called ``users`` to the Department class which is a
synonym for the ``members`` attribute.

* Task:

* Task class is now preventing one of the dependents to be set as the parent
of a task.

* Task class is now preventing one of the parents to be set as the one of the
dependents of a task.

* Fixed ``autoflush`` bugs in Task class.

* Fixed `admin` users department initialization.

* Added ``thumbnail`` attribute to the SimpleEntity class which is a reference
to a Link instance, showing the path of the thumbnail.

* Fixed Circular Dependency bug in Task class, where a parent of a newly
created task is depending to another task which is set as the dependee for
this newly created task (T1 -> T3 -> T2 -> T1 (parent relation) -> T3 -> T2


* Changed these default setting value names to corresponding new names:


* stalker.conf.defaults:

* Added default settings for project working hours (``WORKING_HOURS``,

* Added a new variable for setting the task time resolution called

* stalker.models.project.Project:

* Removed Project.project_tasks attribute, use Project.tasks directly to get
all the Tasks in that project. For root task you can do a quick query::


This will also return the Assets, Sequences and Shots in that project,
which are also Tasks.

* Users are now assigned to Projects by appending them to the Project.users
list. This is done in this way to allow a reduced list of resources to be
shown in the Task creation dialogs.

* Added a new helper class for Project working hour management, called

* Added a new attribute to Project class called ``working_hours`` which holds
stalker.models.project.WorkingHours instances to manage the Project working
hours. It will directly be passed to TaskJuggler.

* stalker.models.task.Task:

* Removed the Task.task_of attribute, use Task.parent to get the owner of
this Task.

* Task now has two new attributes called Task.parent and Task.children which
allow more complex Task-to-Task relation.

* Secondary table name for holding Task to Task dependency relation is
renamed from ``Task_Tasks`` to ``Task_Dependencies``.

* check_circular_dependency function is now accepting a third argument which
is the name of the attribute to be investigated for circular relationship.
It is done in that way to be able to use the same function in searching for
circular relations both in parent/child and depender/dependee relations.

* ScheduleMixin:

* Added a new attribute to ScheduleMixin for time resolution adjustment.
Default value is 1 hour and can be set with
stalker.conf.defaults.TIME_RESOLUTION. Any finer time than the resolution
is rounded to the closest multiply of the resolution. It is possible to set
it from microseconds to years. Although 1 hour is a very reasonable
resolution which is also the default resolution for TaskJuggler.

* ScheduleMixin now uses datetime.datetime for the start and end attributes.

* Renamed the ``start_date`` attribute to ``start``.

* Renamed the ``end_date`` attribute to ``end``

* Removed the TaskableEntity.

* Asset, Sequence and Shot classes are now derived from Task class allowing
more complex Task relation combined with the new parent/child relation of
Tasks. Use Asset.children or Asset.tasks to reach the child tasks of that
asset (same with Sequence and Shot classes).

* stalker.models.shot.Shot:

* Removed the sequence and introduced sequences attribute in Shot class. Now
one shot can be in more than one Sequence. Allowing more complex
Shot/Sequence relations..

* Shots can now be created without a Sequence instance. The sequence
attribute is just used to group the Shots.

* Shots now have a new attribute called ``scenes``, holding Scene instances.
It is created to group same shots occurring in the same scenes.

* In tests all the Warnings are now properly handled as Warnings.

* stalker.models.ticket.Ticket:

* Ticket instances are now tied to Projects and it is now possible to create
Tickets without supplying a Version. They are free now.

* It is now possible to link any SimpleEntity to a Ticket.

* The Ticket Workflow is now fully customizable. Use
stalker.conf.defaults.TICKET_WORKFLOW dictionary to define the workflow and
stalker.conf.defaults.TICKET_STATUS_ORDER for the order of the ticket

* Added a new class called ``Scene`` to manage Shots with another property.

* Removed the ``output_path`` attribute in FilenameTemplate class.

* Grouped the templates for each entity under a directory with the entity name.


* Users now can have more than one Department.

* User instances now have two new properties for getting the user tickets
( and the open tickets (User.open_tickets).

* New shortcut Task.project returns the Task.task_of.project value.

* Shot and Asset creation dialogs now automatically updated with the given
Project instance info.

* User overview page is now reflection the new design.


* The ``code`` attribute of the SimpleEntity is now introduced as a separate
mixin. To let it be used by the classes it is really needed.

* The ``query`` method is now converted to a property so it is now possible to
use it like a property as in the SQLAlchemy.orm.Session as shown below::

from stalker import Project
Project.query.all() # instead of Project.query().all()

* ScheduleMixin.due_date is renamed to ScheduleMixin.end_date.

* Added a new class attribute to SimpleEntity called ``__auto_name__`` which
controls the naming of the instances and instances derived from SimpleEntity.
If ``__auto_name__`` is set to True the ``name`` attribute of the instance
will be automatically generated and it will have the following format::


Here are a couple of naming examples::


* Fixed an autoflush issue with SQLAlchemy in StatusList class. Now the status
column is again not nullable in StatusMixin.


* Added a new class called EntityType to hold all the available class names and

* Version class now has a new attribute called ``inputs`` to hold the inputs of
the current Version instance. It is a list of Link instances.

* FilenameTemplate classes ``path`` and ``filename`` attributes are no more
converted to string, so given a non string value will raise TypeError.

* Structure.custom_template now only accepts strings and None, setting it to
anything else will raise a TypeError.

* Two Type's for FilenameTemplate's are created by default when initializing
the database, first is called "Version" and it is used to define
FilenameTemplates which are used for placing Version source files. The second
one is called "Reference" and it is used when injecting references to a given
class. Along with the FilenameTemplate.target_entity_type this will allow one
to create two different FilenameTemplates for one class::

# first get the Types
vers_type = Type.query()\

ref_type = Type.query()\

# lets create a FilenameTemplate for placing Asset Version files.
f_ver = FilenameTemplate(

# and now define a FilenameTemplate for placing Asset Reference files.
# no need to have an output_path here...
f_ref = FilenameTemplate(

* stalker.db.register() now accepts only real classes instead of class names.
This way it can store more information about classes.

* Status.bg_color and Status.fg_color attributes are now simple integers. And
the Color class is removed.

* StatusMixin.status is now a ForeignKey to a the Statuses table, thus it is a
real Status instance instead of an integer showing the index of the Status in
the related StatusList. This way the Status of the object will not change if
the content of the StatusList is changed.

* Added new attribute Project.project_tasks which holds all the direct or
indirect Tasks created for that project.

* User.login_name is renamed to User.login.

* Removed the ``first_name``, ``last_name`` and ``initials`` attributes from
User class. Now the ``name`` and ``code`` attributes are going to be used,
thus the ``name`` attribute is no more the equivalent of ``login`` and the
``code`` attribute is doing what was ``initials`` doing previously.


* Status class now has two new attributes ``bg_color`` and ``fg_color`` to hold
the UI colors of the Status instance. The colors are Color instances.


* SimpleEntity now has an attribute called ``generic_data`` which can hold any
kind of ``SOM`` object inside and it is a list.

* Changed the formatting rules for the ``name`` in SimpleEntity class, now it
can start with a number, and it is not allowed to have multiple whitespace
characters following each other.

* The ``source`` attribute in Version is renamed to ``source_file``.

* The ``version`` attribute in Version is renamed to ``version_number``.

* The ``take`` attribute in Version is renamed to ``take_name``.

* The ``version_number`` in Version is now generated automatically if it is
skipped or given as None or it is too low where there is already a version
number for the same Version series (means attached to the same Task and has
the same ``take_name``.

* Moved the User class to ``stalker.models.auth module``.

* Removed the ``stalker.ext.auth`` module because it is not necessary anymore.
Thus the User now handles all the password conversions by itself.

* ``PermissionGroup`` is renamed back to Group
again to match with the general naming of the authorization concept.

* Created two new classes for the Authorization system, first one is called
Permission and the second one is a Mixin which is called ACLMixin which adds
ACLs to the mixed in class. For now, only the User and Group classes are
mixed with this mixin by default.

* The declarative Base class of SQLAlchemy is now created by binding it to a
ORMClass (a random name) which lets all the derived class to have a method
called ``query`` which will bypass the need of calling
``DBSession.query(class_)`` but instead just call ``class_.query()``::

from stalker.models.auth import User
user_1 = User.query().filter_by(name='a user name').first()


* Changed the ``db.setup`` arguments. It is now accepting a dictionary instead
of just a string to comply with the SQLAlchemy scaffold and this dictionary
should contain keys for the SQLAlchemy engine setup. There is another utility
that comes with Pyramid to setup the database under the `scripts` folder, it
is also working without any problem with stalker.db.

* The ``session`` variable is renamed to ``DBSession`` and is now a scopped
session, so there is no need to use ``DBSession.commit`` it will be handled
by the system it self.

* Even though the ``DBSession`` is using the Zope Transaction Manager extension
normally, in the database tests no extension is used because the transaction
manager was swallowing all errors and it was a little weird to try to catch
this errors out of the ``with`` block.

* Refactored the code, all the models are now in separate python files, but can
be directly imported from the main stalker module as shown::

from stalker import User, Department, Task

By using this kind of organization, both development and usage will be eased

* ``task_of`` now only accepts TaskableEntity instances.

* Updated the examples. It is now showing how to extend SOM correctly.

* Updated the references to the SOM classes in docstrings and rst files.

* Removed the ``Review`` class. And introduced the much handier Ticket class.
Now reviewing a data is the process of creating Ticket's to that data.

* The database is now initialized with a StatusList and a couple of Statuses
appropriate for Ticket instances.

* The database is now initialized with two Type instances ('Enhancement' and
'Defect') suitable for Ticket instances.

* StatusMixin now stores the status attribute as an Integer showing the index
of the Status in the ``status_list`` attribute but when asked for the value
of ``StatusMixin.status`` attribute it will return a proper Status instance
and the attribute can be set with an integer or with a proper Status

Project details

Release history Release notifications

History Node


History Node


History Node


History Node


History Node

History Node

History Node

History Node

History Node


History Node

History Node

History Node

History Node

History Node

History Node

History Node


History Node


History Node

History Node

History Node

History Node


History Node

History Node


History Node


History Node

History Node

History Node

History Node

History Node

History Node


History Node

History Node


History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

This version
History Node

History Node


History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node

History Node


History Node

History Node

History Node

History Node

History Node


History Node

History Node

History Node

History Node

History Node

History Node


History Node

History Node

History Node

History Node


History Node

History Node

History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
stalker- (525.4 kB) Copy SHA256 hash SHA256 Source None Apr 30, 2014

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page