Created by Lucas Correia last modified 2017-09-08

api_example_timelogs.py

      # :coding: utf-8
# :copyright: Copyright (c) 2017 ftrack

'''API Example - Timelogs'''

import datetime

import ftrack_api
session = ftrack_api.Session();

# Get the current user
user = session.query(
    'User where username is "{}"'.format(session.api_user)
).one()

# Get a task instance
task = session.query('Task').first()

## Create a new timelog
# Assuming server is running in UTC, a local installation may run in a 
# different time zone. Duration is specified in seconds.
start = datetime.datetime.utcnow()
duration = 8 * 60 * 60
timelog = session.create('Timelog', {
    'context': task,
    'user': user,
    'start': start,
    'duration': duration
})
session.commit()


## Print total duration logged on a single task
timelogs = session.query(
    'select duration from Timelog where context_id is "{}"'
    .format(
        task['id']
    )
)
total_duration = sum(timelog['duration'] for timelog in timelogs)
print datetime.timedelta(seconds=total_duration)


## Print total duration logged on all tasks beneath an episode named EP01 on a project, SHOW
timelogs = session.query(
    'select duration from Timelog '
    'where context.ancestors any (name is "EP01") '
    'and context.project.name is "SHOW"'
)
total_duration = sum(timelog['duration'] for timelog in timelogs)
print datetime.timedelta(seconds=total_duration)


## Get time logged by a user during last week
# Assuming server is running in UTC, a local installation may run in a 
# different time zone.
today = datetime.datetime.combine(
    datetime.datetime.utcnow(), datetime.datetime.min.time()
)
start_from = today - datetime.timedelta(weeks=1, days=today.weekday())
start_to = start_from + datetime.timedelta(weeks=1, seconds=-1)
timelogs = session.query(
    'select start, duration from Timelog where user_id is "{}" '
    'and start >= "{}" and start <= "{}" order by start'
    .format(
        user['id'], start_from, start_to
    )
)
total_duration = sum(timelog['duration'] for timelog in timelogs)
print datetime.timedelta(seconds=total_duration)

    

Comments (3)

HTTPS

SSH

You can clone a snippet to your computer for local editing. Learn more.