NAME

SReview::Talk - Database abstraction for talks in the SReview database

SYNOPSIS

  use SReview::Talk;

  my $talk = SReview::Talk->new(talkid => 1);
  print $talk->nonce;
  my $nonce = $talk->nonce;
  my $talk_alt = SReview::Talk->by_nonce($nonce);
  print $talk_alt->talkid; # 1

  $talk->add_correction(length_adj => 1);
  $talk->done_correcting;

DESCRIPTION

SReview::Talk provides a (Moose-based) object-oriented interface to the data related to a talk that is stored in the SReview database. Although it is not yet used everywhere, the intention is for it to eventually replace all the direct PostgreSQL calls.

PROPERTIES

talkid

The unique ID of the talk. Required attribute at construction time (but see the by_nonce method, below). Is used to look up the relevant data in the database.

pathinfo

Helper property to look up information from the database. Should not be used directly.

flags

Flags set on this talk. Setter: set_flag; getter: get_flag. Flags can be deleted with delete_flag.

apology

The apology note, if any. Predicate: has_apology.

comment

The comments that the user entered in the "other brokenness" field. Predicate: has_comment; clearer: clear_comment.

corrected_times

The start- and endtime of the talk, with corrections (if any) applied.

nonce

The talk's unique hex string, used to look it up for review.

date

The date on which the talk happened

readable_date

The date on which the talk happened, in a (somewhat) more human-readable format than the date property.

eventname

The name of the event of which this talk is part

event_output

The name of the event as used in output directories, if any.

progress

The current progress value of the talk, as an SReview::Talk::Progress

state

The current state of the talk, as an SReview::Talk::State

title

The title of the talk

subtitle

The subtitle of the talk

workdir

The working directory where the files for this talk should be stored

relative_name

The relative path- and file name under the output directory for this talk.

outname

The output name for this talk

finaldir

The directory in which things are stored

slug

A short, safe representation of the talk; used for filenames.

corrections

The corrections that are set on this talk.

Supports:

has_correction

check whether a correction exists (by name)

set_correction

Overwrite a correction with a new value

clear_correction

Remove a correction from the set of corrections

correction_pairs

Get a key/value list of corrections

video_fragments

Gets a list of hashes with data on the fragments of video files that are necessary to build the talk, given the schedule and the current corrections.

Each hash contains:

talkid

The talk ID for fragments that are part of the main video; -1 for fragments that are part of the pre video; and -2 for fragments that are part of the post video.

rawid

The unique ID of the raw file

raw_filename

The filename of the raw file

fragment_start

The offset into the raw file where the interesting content begins.

raw_length

The length of the entire video (should be the same for each fragment)

raw_length_corrected

The length of the interesting content in this raw file

avs_video_fragments

The same values as the video_fragments attribute, but with every length extended as needed for A/V sync operations.

speakers

The names of the speakers as a single string, in the format 'Firstname Lastname, Firstname Lastname, ..., Firstname Lastname and Firstname Lastname'

speakerlist

An array of speaker names

room

The room in which the talk happened/will happen

roomid

The unique ID of the room

eventurl

The URL for the talk on the event's website. Only contains data if $eventurl_format is set in the config file; if it doesn't, returns the empty string.

output_video_urls

An array of URLs for the output videos, as they will be published. Used by final review.

preview_exten

The file extension of the preview file (.webm or .mp4)

scheduled_length

The length of the talk, as scheduled

METHODS

by_nonce

Looks up (and returns) the talk by nonce, rather than by talk ID

by_slug

Looks up (and returns) the talk by slug, rather than by talk ID

add_correction

Interpret a correction as a number, and add the passed parameter to it. The new value of the correction will be the sum of the parameter and the old correction.

done_correcting

Commit the created corrections to the database. Also commits other things, like the comment and the flags.

set_state

Override the state of the talk to a new state, ignoring the state transitions. Note, does not update the object, so this should be done just before destroying it.

state_done

Set the progress to "done" in the given state. Does nothing if the talk has since moved to another state.

reset_corrections

Clear all corrections, except the serial one. Used when a user requests that the talk be reset to default.

cpanm SReview

perl -MCPAN -e shell
install SReview