entrouvert
/
tabellio.pcfdb
Archived
17
0
Fork 0
Code Issues Pull Requests Releases Activity

get written question date from t_qe table (#1388)

This commit is contained in:
Frédéric Péters 2012-07-09 10:15:28 +02:00
parent 186c5734e6
commit 507e8cb4d5
1 changed files with 14 additions and 2 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

16
tabellio/pcfdb/sync.py
View File

@ -1087,7 +1087,7 @@ class SyncFromPcfDbView(BrowserView):
cursor.execute('''SELECT t_histo.id, t_histo.st, t_histo.type, t_histo.sess,
t_histo.no, t_histo.intit, t_histo.auteurs,
t_histo.comppols, t_histo.matiereids
t_histo.comppols, t_histo.matiereids, t_histo.objid
FROM t_histo
WHERE t_histo.intit IS NOT NULL
AND t_histo.type IN ('QA', 'QE', 'QO', 'INTERP')
@ -1099,7 +1099,7 @@ class SyncFromPcfDbView(BrowserView):
if row is None:
break
count += 1
dos_id, state, dostype, sess, no, intit, authors, polgroups, topics = row
dos_id, state, dostype, sess, no, intit, authors, polgroups, topics, objid = row
log.debug('t_qx/dos id: %s', dos_id)
if intit and '\n' in intit:
@ -1137,6 +1137,18 @@ class SyncFromPcfDbView(BrowserView):
if object.histolines:
object.date = object.histolines[0].date
if object.questype == 'QE':
# query into t_qe to get the question date instead of the bqr
# date
qe_cursor = self.db_connection.cursor()
qe_cursor.execute('''SELECT date
FROM t_qe
WHERE id = %s''', (objid,))
row = qe_cursor.fetchone()
if row is not None:
object.date = row[0]
qe_cursor.close()
notify(ObjectModifiedEvent(object))
self.publish(object)