This is a snapshot of Indico's old Trac site. Any information contained herein is most probably outdated. Access our new GitHub site here.

Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#493 closed enhancement (fixed)

Recording Manager should report title and creator to micala database

Reported by: jherr Owned by: jherr
Priority: normal Milestone: v0.97.0
Component: Video Services Version: 0.97.0
Keywords: Cc:

Description

to make it easier to quickly identify web lectures in the micala database, the Recording Manager should update the Title and Creator columns in the Lectures table.

Change History (3)

comment:1 Changed 5 years ago by jherr

  • Status changed from new to in_merge

comment:2 Changed 5 years ago by Jeremy Herr <jeremy.herr@…>

  • Resolution set to fixed
  • Status changed from in_merge to closed

In [81f040d68db6b46175e54e8443c8601a0f31f984]:

[IMP] Rec Man adds Title and Creator to micala db

  • lectureTitle and lectureSpeakers were already to be found in Extra.js, I just added them in the necessary places to the other vars get

ting passed.

  • New method in micala.py: cleanSQLData() removes all but alphanumeric chars from title/author strings to prevent SQL injection
  • New method in micala.py: updateLectureInfo() sends UPDATE query to database with Title and Creator for given lecture
  • fixes #493

comment:3 Changed 5 years ago by Jeremy Herr <jeremy.herr@…>

In [81f040d68db6b46175e54e8443c8601a0f31f984]:

[IMP] Rec Man adds Title and Creator to micala db

  • lectureTitle and lectureSpeakers were already to be found in Extra.js, I just added them in the necessary places to the other vars get

ting passed.

  • New method in micala.py: cleanSQLData() removes all but alphanumeric chars from title/author strings to prevent SQL injection
  • New method in micala.py: updateLectureInfo() sends UPDATE query to database with Title and Creator for given lecture
  • fixes #493
Note: See TracTickets for help on using tickets.