db_conn_postgres.rs 76.7 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 *                                                                             *
 *        WARNING                                                              *
 *                                                                             *
 * This file is auto generated by ./generate_connectors.sh                     *
 *                                                                             *
 * Do not edit this file directly. Instead edit one of the corresponding       *
 * .header.rs oder .base.rs files.                                             *
 *                                                                             *
 *                                                                             *
 *                                                                             *
 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */

14
15
16
17
18
19
20
21
22
23
24
25
26
27
/*  medal                                                                                                            *\
 *  Copyright (C) 2020  Bundesweite Informatikwettbewerbe                                                            *
 *                                                                                                                   *
 *  This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero        *
 *  General Public License as published  by the Free Software Foundation, either version 3 of the License, or (at    *
 *  your option) any later version.                                                                                  *
 *                                                                                                                   *
 *  This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the       *
 *  implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public      *
 *  License for more details.                                                                                        *
 *                                                                                                                   *
 *  You should have received a copy of the GNU Affero General Public License along with this program.  If not, see   *
\*  <http://www.gnu.org/licenses/>.                                                                                  */

28
29
#![cfg(feature = "postgres")]

30
31
extern crate postgres;

32
33
34
use postgres::Connection;
use time;
use time::Duration;
35
36
37

use db_conn::{MedalConnection, MedalObject};
use db_objects::*;
38
use helpers;
39

40
41
fn gen_tosql_vector() -> Vec<&'static dyn postgres::types::ToSql> { Vec::new() }

42
trait Queryable {
Robert Czechowski's avatar
rustfmt    
Robert Czechowski committed
43
44
    fn query_map_one<T, F>(&self, sql: &str, params: &[&dyn postgres::types::ToSql], f: F)
                           -> postgres::Result<Option<T>>
45
        where F: FnOnce(postgres::rows::Row<'_>) -> T;
46
47
    fn query_map_many<T, F>(&self, sql: &str, params: &[&dyn postgres::types::ToSql], f: F) -> postgres::Result<Vec<T>>
        where F: FnMut(postgres::rows::Row<'_>) -> T;
48
    fn exists(&self, sql: &str, params: &[&dyn postgres::types::ToSql]) -> bool;
49
    fn get_last_id(&self) -> Option<i32>;
50
51
52
}

impl Queryable for Connection {
Robert Czechowski's avatar
rustfmt    
Robert Czechowski committed
53
54
    fn query_map_one<T, F>(&self, sql: &str, params: &[&dyn postgres::types::ToSql], f: F)
                           -> postgres::Result<Option<T>>
55
56
        where F: FnOnce(postgres::rows::Row<'_>) -> T {
        let rows = self.query(sql, params)?;
57

58
59
        Ok(rows.iter().next().map(f))
    }
60

61
62
63
64
65
    fn query_map_many<T, F>(&self, sql: &str, params: &[&dyn postgres::types::ToSql], f: F) -> postgres::Result<Vec<T>>
        where F: FnMut(postgres::rows::Row<'_>) -> T {
        Ok(self.query(sql, params)?.iter().map(f).collect())
    }

66
67
68
69
70
    fn exists(&self, sql: &str, params: &[&dyn postgres::types::ToSql]) -> bool {
        let stmt = self.prepare(sql).unwrap();
        !stmt.query(params).unwrap().is_empty()
    }

71
72
73
74
75
76
    fn get_last_id(&self) -> Option<i32> {
        self.query("SELECT lastval()", &[]).unwrap().iter().next().map(|row| {
                                                                      let r: i64 = row.get(0);
                                                                      r as i32
                                                                  })
    }
77
    // Empty line intended
78
79
}

80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
impl MedalObject<Connection> for Submission {
    fn save(&mut self, conn: &Connection) {
        match self.get_id() {
            Some(_id) => unimplemented!(),
            None => {
                let query = "INSERT INTO submission (task, session, grade, validated, nonvalidated_grade,
                                                     subtask_identifier, value, date, needs_validation)
                             VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)";
                conn.execute(query,
                             &[&self.task,
                               &self.session_user,
                               &self.grade,
                               &self.validated,
                               &self.nonvalidated_grade,
                               &self.subtask_identifier,
                               &self.value,
                               &self.date,
                               &self.needs_validation])
                    .unwrap();
                self.set_id(conn.get_last_id().unwrap());
            }
        }
    }
}

impl MedalObject<Connection> for Grade {
    fn save(&mut self, conn: &Connection) {
        let query = "INSERT INTO grade (taskgroup, session, grade, validated)
                     VALUES ($1, $2, $3, $4)
                     ON CONFLICT ON CONSTRAINT grade_pkey DO UPDATE SET grade = excluded.grade, validated = excluded.validated";
        conn.execute(query, &[&self.taskgroup, &self.user, &self.grade, &self.validated]).unwrap();
    }
}
113
114
115
116
117
118
119
120
121
122
123
124
125
126
/*  medal                                                                                                            *\
 *  Copyright (C) 2020  Bundesweite Informatikwettbewerbe                                                            *
 *                                                                                                                   *
 *  This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero        *
 *  General Public License as published  by the Free Software Foundation, either version 3 of the License, or (at    *
 *  your option) any later version.                                                                                  *
 *                                                                                                                   *
 *  This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the       *
 *  implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public      *
 *  License for more details.                                                                                        *
 *                                                                                                                   *
 *  You should have received a copy of the GNU Affero General Public License along with this program.  If not, see   *
\*  <http://www.gnu.org/licenses/>.                                                                                  */

127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
impl MedalObject<Connection> for Participation {
    fn save(&mut self, conn: &Connection) {
        let query = "INSERT INTO participation (contest, session, start_date)
                     VALUES ($1, $2, $3)";
        conn.execute(query, &[&self.contest, &self.user, &self.start]).unwrap();
    }
}

impl MedalObject<Connection> for Group {
    fn save(&mut self, conn: &Connection) {
        match self.get_id() {
            Some(_id) => unimplemented!(),
            None => {
                let query = "INSERT INTO usergroup (name, groupcode, tag, admin)
                             VALUES ($1, $2, $3, $4)";
                conn.execute(query, &[&self.name, &self.groupcode, &self.tag, &self.admin]).unwrap();
                self.set_id(conn.get_last_id().unwrap());
            }
        }
    }
}

impl MedalObject<Connection> for Task {
    fn save(&mut self, conn: &Connection) {
        let query = "SELECT id
                     FROM task
                     WHERE taskgroup = $1
                     AND location = $2";
        conn.query_map_one(query, &[&self.taskgroup, &self.location], |row| row.get(0))
            .unwrap_or(None)
            .and_then(|id| {
                self.set_id(id);
                Some(())
            })
            .unwrap_or(()); // Err means no entry yet and is expected result

        let id = match self.get_id() {
            Some(id) => {
                let query = "UPDATE task
                             SET taskgroup = $1, location = $2, stars = $3
                             WHERE id = $4";
                conn.execute(query, &[&self.taskgroup, &self.location, &self.stars, &id]).unwrap();
                id
            }
            None => {
                let query = "INSERT INTO task (taskgroup, location, stars)
                             VALUES ($1, $2, $3)";
                conn.execute(query, &[&self.taskgroup, &self.location, &self.stars]).unwrap();
                conn.get_last_id().unwrap()
            }
        };
        self.set_id(id);
    }
}

impl MedalObject<Connection> for Taskgroup {
    fn save(&mut self, conn: &Connection) {
        if let Some(first_task) = self.tasks.get(0) {
            let query = "SELECT taskgroup.id
                         FROM taskgroup
                         JOIN task
                         ON task.taskgroup = taskgroup.id
                         WHERE contest = $1
                         AND task.location = $2";
            conn.query_map_one(query, &[&self.contest, &first_task.location], |row| row.get(0))
                .unwrap_or(None)
                .and_then(|id| {
                    self.set_id(id);
                    Some(())
                })
                .unwrap_or(()); // Err means no entry yet and is expected result
        }

        let id = match self.get_id() {
            Some(id) => {
                let query = "UPDATE taskgroup
203
204
205
                             SET contest = $1, name = $2, active = $3, positionalnumber = $4
                             WHERE id = $5";
                conn.execute(query, &[&self.contest, &self.name, &self.active, &self.positionalnumber, &id]).unwrap();
206
207
208
                id
            }
            None => {
209
210
211
                let query = "INSERT INTO taskgroup (contest, name, active, positionalnumber)
                             VALUES ($1, $2, $3, $4)";
                conn.execute(query, &[&self.contest, &self.name, &self.active, &self.positionalnumber]).unwrap();
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
                conn.get_last_id().unwrap()
            }
        };
        self.set_id(id);
        for mut task in &mut self.tasks {
            task.taskgroup = id;
            task.save(conn);
        }
    }
}

impl MedalObject<Connection> for Contest {
    fn save(&mut self, conn: &Connection) {
        let query = "SELECT id
                     FROM contest
                     WHERE location = $1
                     AND filename = $2";
        conn.query_map_one(query, &[&self.location, &self.filename], |row| row.get(0))
            .unwrap_or(None)
            .and_then(|id| {
                self.set_id(id);
                Some(())
            })
            .unwrap_or(()); // Err means no entry yet and is expected result

        let id = match self.get_id() {
            Some(id) => {
                let query = "UPDATE contest
240
241
242
243
                             SET location = $2,filename = $3, name = $4, duration = $5, public = $6, start_date = $7,
                                 end_date = $8, min_grade = $9, max_grade = $10, positionalnumber = $11,
                                 requires_login = $12, secret = $13
                             WHERE id = $1";
244
                conn.execute(query,
245
246
                             &[&id,
                               &self.location,
247
248
249
250
251
252
                               &self.filename,
                               &self.name,
                               &self.duration,
                               &self.public,
                               &self.start,
                               &self.end,
253
254
                               &self.min_grade,
                               &self.max_grade,
255
                               &self.positionalnumber,
256
257
                               &self.requires_login,
                               &self.secret])
258
259
260
261
                    .unwrap();
                id
            }
            None => {
262
                let query = "INSERT INTO contest (location, filename, name, duration, public, start_date, end_date,
263
264
                                                  min_grade, max_grade, positionalnumber, requires_login, secret)
                             VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12)";
265
266
267
268
269
270
271
                conn.execute(query,
                             &[&self.location,
                               &self.filename,
                               &self.name,
                               &self.duration,
                               &self.public,
                               &self.start,
272
273
                               &self.end,
                               &self.min_grade,
274
                               &self.max_grade,
275
276
277
                               &self.positionalnumber,
                               &self.requires_login,
                               &self.secret])
278
279
280
281
282
283
284
285
286
287
288
289
                    .unwrap();
                conn.get_last_id().unwrap()
            }
        };
        self.set_id(id);
        for mut taskgroup in &mut self.taskgroups {
            taskgroup.contest = id;
            taskgroup.save(conn);
        }
    }
}

290
impl MedalConnection for Connection {
291
292
293
294
295
296
    fn dbtype(&self) -> &'static str { "postgres" }

    fn migration_already_applied(&self, name: &str) -> bool {
        let create_string = "CREATE TABLE IF NOT EXISTS migrations (name TEXT PRIMARY KEY);";
        self.execute(create_string, &[]).unwrap();

297
298
        let query = "SELECT name FROM migrations WHERE name = $1";
        self.exists(query, &[&name])
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
    }

    fn apply_migration(&mut self, name: &str, contents: &str) {
        print!("Applying migration `{}` … ", name);

        let tx = self.transaction().unwrap();

        tx.batch_execute(&contents).unwrap();
        tx.execute("INSERT INTO migrations (name) VALUES ($1)", &[&name]).unwrap();

        tx.commit().unwrap();

        println!("OK.");
    }

    // fn get_session<T: ToSql>(&self, key: T, keyname: &str) -> Option<SessionUser> {
    fn get_session(&self, key: &str) -> Option<SessionUser> {
316
317
        let query = "SELECT id, csrf_token, last_login, last_activity, permanent_login, username, password, salt,
                            logincode, email, email_unconfirmed, email_confirmationcode, firstname, lastname, street,
318
                            zip, city, nation, grade, sex, is_admin, is_teacher, managed_by, oauth_provider, oauth_foreign_id
319
320
                     FROM session
                     WHERE session_token = $1";
321
322
323
324
325
326
327
328
329
        let session = self.query_map_one(query, &[&key], |row| SessionUser { id: row.get(0),
                                                                             session_token: Some(key.to_string()),
                                                                             csrf_token: row.get(1),
                                                                             last_login: row.get(2),
                                                                             last_activity: row.get(3),
                                                                             permanent_login: row.get(4),

                                                                             username: row.get(5),
                                                                             password: row.get(6),
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
                                                                             salt: row.get(7),
                                                                             logincode: row.get(8),
                                                                             email: row.get(9),
                                                                             email_unconfirmed: row.get(10),
                                                                             email_confirmationcode: row.get(11),

                                                                             firstname: row.get(12),
                                                                             lastname: row.get(13),
                                                                             street: row.get(14),
                                                                             zip: row.get(15),
                                                                             city: row.get(16),
                                                                             nation: row.get(17),
                                                                             grade: row.get(18),
                                                                             sex: row.get(19),

345
346
347
                                                                             is_admin: row.get(20),
                                                                             is_teacher: row.get(21),
                                                                             managed_by: row.get(22),
348

349
350
                                                                             oauth_provider: row.get(23),
                                                                             oauth_foreign_id: row.get(24) })
351
                          .ok()??;
352

353
        let duration = Duration::hours(12);
354
        let now = time::get_time();
355

356
357
        if let Some(last_activity) = session.last_activity {
            if now - last_activity < duration {
358
359
360
361
                let query = "UPDATE session
                             SET last_activity = $1
                             WHERE id = $2";
                self.execute(query, &[&now, &session.id]).unwrap();
362
                return Some(session);
363
            } else {
364
365
366
367
                // Session timed out
                // Should remove session token from session
                return None;
            }
368
        }
369
370
371
        // last_activity undefined
        // TODO: What should happen here?
        None
372
373
    }
    fn save_session(&self, session: SessionUser) {
374
375
376
377
378
379
380
381
382
383
384
385
        self.execute("UPDATE session
                      SET username = $1,
                          password = $2,
                          salt = $3,
                          logincode = $4,
                          firstname = $5,
                          lastname = $6,
                          street = $7,
                          zip = $8,
                          city = $9,
                          grade = $10,
                          sex = $11,
386
387
388
389
                          is_admin = $12,
                          is_teacher = $13,
                          permanent_login = $14
                      WHERE id = $15",
390
391
392
393
394
395
396
397
398
399
                     &[&session.username,
                       &session.password,
                       &session.salt,
                       &session.logincode,
                       &session.firstname,
                       &session.lastname,
                       &session.street,
                       &session.zip,
                       &session.city,
                       &session.grade,
400
                       &session.sex,
401
                       &session.is_admin,
402
                       &session.is_teacher,
403
                       &session.permanent_login,
404
405
406
407
                       &session.id])
            .unwrap();
    }
    fn new_session(&self, session_token: &str) -> SessionUser {
408
        let csrf_token = helpers::make_csrf_token();
409
410

        let now = time::get_time();
411
        let query = "INSERT INTO session (session_token, csrf_token, last_activity, permanent_login, grade, sex,
412
                                          is_teacher)
413
414
                     VALUES ($1, $2, $3, $4, $5, $6, $7)";
        self.execute(query, &[&session_token, &csrf_token, &now, &false, &0, &None::<i32>, &false]).unwrap();
415

416
417
        let id = self.get_last_id().expect("Expected to get last row id");

418
        SessionUser::minimal(id, session_token.to_owned(), csrf_token)
419
420
    }
    fn get_session_or_new(&self, key: &str) -> SessionUser {
421
422
423
        let query = "UPDATE session
                     SET session_token = $1
                     WHERE session_token = $2";
424
425
426
        self.get_session(&key).ensure_alive().unwrap_or_else(|| {
                                                 // TODO: Factor this out in own function
                                                 // TODO: Should a new session key be generated every time?
427
                                                 self.execute(query, &[&Option::<String>::None, &key]).unwrap();
428
429
                                                 self.new_session(&key)
                                             })
430
431
432
    }

    fn get_user_by_id(&self, user_id: i32) -> Option<SessionUser> {
433
        let query = "SELECT session_token, csrf_token, last_login, last_activity, permanent_login, username, password,
434
                            salt, logincode, email, email_unconfirmed, email_confirmationcode, firstname, lastname,
435
                            street, zip, city, nation, grade, sex, is_admin, is_teacher, managed_by, oauth_provider,
436
                            oauth_foreign_id
437
438
                     FROM session
                     WHERE id = $1";
439
440
441
442
443
444
445
446
447
        self.query_map_one(query, &[&user_id], |row| SessionUser { id: user_id,
                                                                   session_token: row.get(0),
                                                                   csrf_token: row.get(1),
                                                                   last_login: row.get(2),
                                                                   last_activity: row.get(3),
                                                                   permanent_login: row.get(4),

                                                                   username: row.get(5),
                                                                   password: row.get(6),
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
                                                                   salt: row.get(7),
                                                                   logincode: row.get(8),
                                                                   email: row.get(9),
                                                                   email_unconfirmed: row.get(10),
                                                                   email_confirmationcode: row.get(11),

                                                                   firstname: row.get(12),
                                                                   lastname: row.get(13),
                                                                   street: row.get(14),
                                                                   zip: row.get(15),
                                                                   city: row.get(16),
                                                                   nation: row.get(17),
                                                                   grade: row.get(18),
                                                                   sex: row.get(19),

463
464
465
                                                                   is_admin: row.get(20),
                                                                   is_teacher: row.get(21),
                                                                   managed_by: row.get(22),
466

467
468
                                                                   oauth_provider: row.get(23),
                                                                   oauth_foreign_id: row.get(24) })
469
            .ok()?
470
471
472
473
474
475
476
477
478
479
    }

    fn get_user_and_group_by_id(&self, user_id: i32) -> Option<(SessionUser, Option<Group>)> {
        let session = self.get_user_by_id(user_id)?;

        let group_id = match session.managed_by {
            Some(id) => id,
            None => return Some((session, None)),
        };

480
481
482
        let query = "SELECT name, groupcode, tag, admin
                     FROM usergroup
                     WHERE id = $1";
483
484
485
486
487
488
489
490
491
        let res = self.query_map_one(query, &[&group_id], |row| Group { id: Some(group_id),
                                                                        name: row.get(0),
                                                                        groupcode: row.get(1),
                                                                        tag: row.get(2),
                                                                        admin: row.get(3),
                                                                        members: Vec::new() })
                      .ok()?;
        match res {
            Some(group) => Some((session, Some(group))),
492
493
494
495
496
497
            _ => Some((session, None)),
        }
    }

    //TODO: use session
    fn login(&self, _session: Option<&str>, username: &str, password: &str) -> Result<String, ()> {
498
499
500
501
        let query = "SELECT id, password, salt
                     FROM session
                     WHERE username = $1";
        self.query_map_one(query, &[&username], |row| {
502
503
504
505
                let (id, password_hash, salt): (i32, Option<String>, Option<String>) =
                    (row.get(0), row.get(1), row.get(2));

                //password_hash ist das, was in der Datenbank steht
506
                if helpers::verify_password(&password,
507
508
                                            &salt.ok_or_else(|| println!("salt from database empty"))?,
                                            &password_hash.ok_or_else(|| println!("password from database empty"))?)
509
510
511
512
                {
                    // TODO: fail more pleasantly
                    // Login okay, update session now!

513
514
                    let session_token = helpers::make_session_token();
                    let csrf_token = helpers::make_csrf_token();
515
516
                    let now = time::get_time();

517
518
519
                    let query = "UPDATE session
                                 SET session_token = $1, csrf_token = $2, last_login = $3, last_activity = $3
                                 WHERE id = $4";
520
                    self.execute(query, &[&session_token, &csrf_token, &now, &id]).unwrap();
521
522
523
524
525

                    Ok(session_token)
                } else {
                    Err(())
                }
526
527
528
            })
            .map_err(|_| ())?
            .ok_or(())?
529
530
531
532
    }

    //TODO: use session
    fn login_with_code(&self, _session: Option<&str>, logincode: &str) -> Result<String, ()> {
533
534
535
536
        let query = "SELECT id
                     FROM session
                     WHERE logincode = $1";
        self.query_map_one(query, &[&logincode], |row| {
537
538
539
                // Login okay, update session now!
                let id: i32 = row.get(0);

540
541
                let session_token = helpers::make_session_token();
                let csrf_token = helpers::make_csrf_token();
542
543
                let now = time::get_time();

544
545
546
                let query = "UPDATE session
                             SET session_token = $1, csrf_token = $2, last_login = $3, last_activity = $3
                             WHERE id = $4";
547
                self.execute(query, &[&session_token, &csrf_token, &now, &id]).unwrap();
548

549
                session_token
550
551
552
            })
            .map_err(|_| ())?
            .ok_or(())
553
554
555
    }

    //TODO: use session
556
557
    fn login_foreign(&self, _session: Option<&str>, provider_id: &str, foreign_id: &str,
                     (is_teacher, is_admin, firstname, lastname, sex): (bool, bool, &str, &str, Option<i32>))
558
                     -> Result<(String, Option<time::Timespec>), ()>
559
    {
560
561
        let session_token = helpers::make_session_token();
        let csrf_token = helpers::make_csrf_token();
562
563
        let now = time::get_time();

564
        let query = "SELECT id, last_activity
565
                     FROM session
566
567
                     WHERE oauth_foreign_id = $1
                           AND oauth_provider = $2";
568
569
570
571
        match self.query_map_one(query, &[&foreign_id, &provider_id], |row| -> (i32, time::Timespec) {
                      (row.get(0), row.get(1))
                  }) {
            Ok(Some((id, last_activity))) => {
572
                let query = "UPDATE session
573
                             SET session_token = $1, csrf_token = $2, last_login = $3, last_activity = $3,
574
575
                                 is_teacher = $4, is_admin = $5,  firstname = $6, lastname = $7, sex = $8
                             WHERE id = $9";
576
577
578
579
580
581
582
583
584
585
586
                self.execute(query,
                             &[&session_token,
                               &csrf_token,
                               &now,
                               &is_teacher,
                               &is_admin,
                               &firstname,
                               &lastname,
                               &sex,
                               &id])
                    .unwrap();
587

588
                Ok((session_token, Some(last_activity)))
589
590
591
            }
            // Add!
            _ => {
592
                let query = "INSERT INTO session (session_token, csrf_token, last_login, last_activity,
593
                                                  permanent_login, grade, sex, is_teacher, is_admin, oauth_foreign_id,
594
                                                  oauth_provider, firstname, lastname)
595
                             VALUES ($1, $2, $3, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12)";
596
597
598
599
600
                self.execute(query,
                             &[&session_token,
                               &csrf_token,
                               &now,
                               &false,
601
                               &(if is_teacher { 255 } else { 0 }),
602
                               &sex,
603
                               &is_teacher,
604
                               &is_admin,
605
                               &foreign_id,
606
                               &provider_id,
607
608
609
                               &firstname,
                               &lastname])
                    .unwrap();
610

611
                Ok((session_token, None))
612
613
614
615
616
617
            }
        }
    }

    //TODO: use session
    fn create_user_with_groupcode(&self, _session: Option<&str>, groupcode: &str) -> Result<String, ()> {
618
619
620
        let query = "SELECT id
                     FROM usergroup
                     WHERE groupcode = $1";
621
622
        let group_id =
            self.query_map_one(query, &[&groupcode], |row| -> i32 { row.get(0) }).map_err(|_| ())?.ok_or(())?;
623

624
625
626
        // Login okay, create session!
        let session_token = helpers::make_session_token();
        let csrf_token = helpers::make_csrf_token();
627
        let login_code = helpers::make_login_code(); // TODO: check for collisions
628
        let now = time::get_time();
629

630
        let query = "INSERT INTO session (session_token, csrf_token, last_login, last_activity, permanent_login,
631
                                          logincode, grade, sex, is_teacher, managed_by)
632
                     VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)";
633
634
635
636
637
638
639
640
641
642
643
644
        self.execute(query,
                     &[&session_token,
                       &csrf_token,
                       &now,
                       &now,
                       &false,
                       &login_code,
                       &0,
                       &None::<i32>,
                       &false,
                       &group_id])
            .unwrap();
645

646
        Ok(session_token)
647
648
    }

Robert Czechowski's avatar
rustfmt    
Robert Czechowski committed
649
    fn create_group_with_users(&self, mut group: Group) {
650
651
652
653
654
655
        // Generate group ID:
        group.save(self);

        for user in group.members {
            let csrf_token = helpers::make_csrf_token();
            let login_code = helpers::make_login_code(); // TODO: check for collisions
Robert Czechowski's avatar
rustfmt    
Robert Czechowski committed
656

657
            let query = "INSERT INTO session (firstname, lastname, csrf_token, permanent_login, logincode, grade, sex,
658
                                              is_teacher, managed_by)
659
                         VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)";
660
661
662
663
664
665
666
            self.execute(query,
                         &[&user.firstname,
                           &user.lastname,
                           &csrf_token,
                           &false,
                           &login_code,
                           &user.grade,
667
                           &None::<i32>,
668
669
670
                           &false,
                           &group.id])
                .unwrap();
671
        }
672
673
    }

674
    fn logout(&self, session: &str) {
675
676
677
        let query = "UPDATE session
                     SET session_token = NULL
                     WHERE session_token = $1";
678
        self.execute(query, &[&session]).unwrap();
679
680
681
682
    }

    fn load_submission(&self, session: &SessionUser, task: i32, subtask: Option<&str>) -> Option<Submission> {
        match subtask {
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
            None => {
                let query = "SELECT id, grade, validated, nonvalidated_grade, value, date, needs_validation
                             FROM submission
                             WHERE task = $1
                             AND session = $2
                             ORDER BY id DESC
                             LIMIT 1";
                self.query_map_one(query, &[&task, &session.id], |row| Submission { id: Some(row.get(0)),
                                                                                    task: task,
                                                                                    session_user: session.id,
                                                                                    grade: row.get(1),
                                                                                    validated: row.get(2),
                                                                                    nonvalidated_grade: row.get(3),
                                                                                    subtask_identifier: None,
                                                                                    value: row.get(4),
                                                                                    date: row.get(5),
                                                                                    needs_validation: row.get(6) })
                    .ok()?
            }
            Some(subtask_id) => {
                let query = "SELECT id, grade, validated, nonvalidated_grade, value, date, needs_validation
                             FROM submission
                             WHERE task = $1
                             AND session = $2
                             AND subtask_identifier = $3
                             ORDER BY id DESC
                             LIMIT 1";
                self.query_map_one(query, &[&task, &session.id, &subtask_id], |row| {
                        Submission { id: Some(row.get(0)),
                                     task: task,
                                     session_user: session.id,
                                     grade: row.get(1),
                                     validated: row.get(2),
                                     nonvalidated_grade: row.get(3),
                                     subtask_identifier: Some(subtask_id.to_string()),
                                     value: row.get(4),
                                     date: row.get(5),
                                     needs_validation: row.get(6) }
                    })
                    .ok()?
            }
724
725
        }
    }
726
727
728
729
730
731
732
733
    fn get_all_submissions(&self, session_id: i32, task: i32, subtask: Option<&str>) -> Vec<Submission> {
        match subtask {
            None => {
                let query = "SELECT id, grade, validated, nonvalidated_grade, value, date, needs_validation
                             FROM submission
                             WHERE task = $1
                             AND session = $2";
                self.query_map_many(query, &[&task, &session_id], |row| Submission { id: Some(row.get(0)),
734
735
736
737
738
739
740
741
                                                                                     task: task,
                                                                                     session_user: session_id,
                                                                                     grade: row.get(1),
                                                                                     validated: row.get(2),
                                                                                     nonvalidated_grade: row.get(3),
                                                                                     subtask_identifier: None,
                                                                                     value: row.get(4),
                                                                                     date: row.get(5),
742
743
744
                                                                                     needs_validation: row.get(6) })
                    .unwrap()
            }
745
            _ => unimplemented!(),
746
747
        }
    }
748
749
750
751
752
753
754
755
756
757
758
    fn submit_submission(&self, mut submission: Submission) {
        submission.save(self);

        let mut grade = self.get_grade_by_submission(submission.id.unwrap());
        if grade.grade.is_none() || submission.grade > grade.grade.unwrap() {
            grade.grade = Some(submission.grade);
            grade.validated = false;
            grade.save(self);
        }
    }
    fn get_grade_by_submission(&self, submission_id: i32) -> Grade {
759
760
761
762
763
764
        let query = "SELECT grade.taskgroup, grade.session, grade.grade, grade.validated
                     FROM grade
                     JOIN task ON grade.taskgroup = task.taskgroup
                     JOIN submission ON task.id = submission.task
                     AND grade.session = submission.session
                     WHERE submission.id = $1";
765
766
767
768
769
770
771
        self.query_map_one(query, &[&submission_id], |row| Grade { taskgroup: row.get(0),
                                                                   user: row.get(1),
                                                                   grade: row.get(2),
                                                                   validated: row.get(3) })
            .unwrap_or(None)
            .unwrap_or_else(|| {
                let query = "SELECT task.taskgroup, submission.session
772
773
774
                         FROM submission
                         JOIN task ON task.id = submission.task
                         WHERE submission.id = $1";
775
776
777
778
779
780
781
                self.query_map_one(query, &[&submission_id], |row| Grade { taskgroup: row.get(0),
                                                                           user: row.get(1),
                                                                           grade: None,
                                                                           validated: false })
                    .unwrap()
                    .unwrap() // should this unwrap?
            })
782
783
784
785
    }

    fn get_contest_groups_grades(&self, session_id: i32, contest_id: i32)
                                 -> (Vec<String>, Vec<(Group, Vec<(UserInfo, Vec<Grade>)>)>) {
786
787
788
        let query = "SELECT id, name
                     FROM taskgroup
                     WHERE contest = $1
789
790
                     AND active = $2
                     ORDER BY positionalnumber";
791
        let tasknames: Vec<(i32, String)> =
792
            self.query_map_many(query, &[&contest_id, &true], |row| (row.get(0), row.get(1))).unwrap();
793

794
795
796
797
798
799
800
        let mut taskindex: ::std::collections::BTreeMap<i32, usize> = ::std::collections::BTreeMap::new();

        let n_tasks = tasknames.len();
        for (index, (i, _)) in tasknames.iter().enumerate() {
            taskindex.insert(*i, index);
        }

801
802
        let query = "SELECT grade.taskgroup, grade.session, grade.grade, grade.validated, usergroup.id, usergroup.name,
                            usergroup.groupcode, usergroup.tag, student.id, student.username, student.logincode,
803
                            student.firstname, student.lastname, student.grade AS sgrade
804
805
806
807
808
809
                     FROM grade
                     JOIN taskgroup ON grade.taskgroup = taskgroup.id
                     JOIN session AS student ON grade.session = student.id
                     JOIN usergroup ON student.managed_by = usergroup.id
                     WHERE usergroup.admin = $1
                     AND taskgroup.contest = $2
810
                     AND taskgroup.active = $3
811
812
                     ORDER BY usergroup.id, sgrade, student.lastname, student.firstname, student.id,
                              taskgroup.positionalnumber";
813
        let gradeinfo =
814
            self.query_map_many(query, &[&session_id, &contest_id, &true], |row| {
815
816
817
818
819
820
821
822
823
824
825
                    (Grade { taskgroup: row.get(0), user: row.get(1), grade: row.get(2), validated: row.get(3) },
                     Group { id: Some(row.get(4)),
                             name: row.get(5),
                             groupcode: row.get(6),
                             tag: row.get(7),
                             admin: session_id,
                             members: Vec::new() },
                     UserInfo { id: row.get(8),
                                username: row.get(9),
                                logincode: row.get(10),
                                firstname: row.get(11),
826
                                lastname: row.get(12),
Robert Czechowski's avatar
Robert Czechowski committed
827
                                grade: row.get(13) })
828
829
830
                })
                .unwrap();
        let mut gradeinfo_iter = gradeinfo.iter();
831
832

        if let Some(t /*Ok((grade, mut group, mut userinfo))*/) = gradeinfo_iter.next() {
833
            let (grade, mut group, mut userinfo) = t.clone();
834
835
836
837
838
839

            let mut grades: Vec<Grade> = vec![Default::default(); n_tasks];
            let mut users: Vec<(UserInfo, Vec<Grade>)> = Vec::new();
            let mut groups: Vec<(Group, Vec<(UserInfo, Vec<Grade>)>)> = Vec::new();

            let index = grade.taskgroup;
840
            grades[taskindex[&index]] = grade;
841
842

            for ggu in gradeinfo_iter {
843
844
                let (g, gr, ui) = ggu;
                if gr.id != group.id {
845
846
                    users.push((userinfo, grades));
                    userinfo = ui.clone();
847
848
                    grades = vec![Default::default(); n_tasks];

849
850
                    groups.push((group, users));
                    group = gr.clone();
851
852
                    users = Vec::new();
                } else if ui.id != userinfo.id {
853
854
                    users.push((userinfo, grades));
                    userinfo = ui.clone();
855
                    grades = vec![Default::default(); n_tasks];
856
                }
857
                let index = g.taskgroup;
858
                grades[taskindex[&index]] = *g;
859
            }
860
861
            users.push((userinfo, grades));
            groups.push((group, users));
862
863
864
865
866
867
868

            (tasknames.iter().map(|(_, name)| name.clone()).collect(), groups)
        } else {
            (Vec::new(), Vec::new()) // should those be default filled?
        }
    }
    fn get_contest_user_grades(&self, session_token: &str, contest_id: i32) -> Vec<Grade> {
869
870
871
        let query = "SELECT id, name
                     FROM taskgroup
                     WHERE contest = $1
872
873
                     AND active = $2
                     ORDER BY positionalnumber";
874
        let tasknames: Vec<(i32, String)> =
875
            self.query_map_many(query, &[&contest_id, &true], |row| (row.get(0), row.get(1))).unwrap();
876
877
878
879
880
881
882
        let mut taskindex: ::std::collections::BTreeMap<i32, usize> = ::std::collections::BTreeMap::new();

        let n_tasks = tasknames.len();
        for (index, (i, _)) in tasknames.iter().enumerate() {
            taskindex.insert(*i, index);
        }

883
884
885
886
887
888
        let query = "SELECT grade.taskgroup, grade.session, grade.grade, grade.validated
                     FROM grade
                     JOIN taskgroup ON grade.taskgroup = taskgroup.id
                     JOIN session ON session.id = grade.session
                     WHERE session.session_token = $1
                     AND taskgroup.contest = $2
889
890
                     AND taskgroup.active = $3
                     ORDER BY taskgroup.positionalnumber";
891
        let gradeinfo =
892
            self.query_map_many(query, &[&session_token, &contest_id, &true], |row| Grade { taskgroup: row.get(0),
Robert Czechowski's avatar
Robert Czechowski committed
893
894
895
                                                                                            user: row.get(1),
                                                                                            grade: row.get(2),
                                                                                            validated: row.get(3) })
896
897
                .unwrap();
        let gradeinfo_iter = gradeinfo.iter();
898
899
900
901
902

        let mut grades: Vec<Grade> = vec![Default::default(); n_tasks];

        for g in gradeinfo_iter {
            let index = g.taskgroup;
903
            grades[taskindex[&index]] = *g;
904
905
906
907
908
909
        }

        grades
    }

    fn get_taskgroup_user_grade(&self, session_token: &str, taskgroup_id: i32) -> Grade {
910
        let query = "SELECT grade.taskgroup, grade.session, grade.grade, grade.validated
911
912
913
914
                     FROM grade
                     JOIN session ON session.id = grade.session
                     WHERE session.session_token = $1
                     AND grade.taskgroup = $2";
915
916
917
918
919
920
        self.query_map_one(query, &[&session_token, &taskgroup_id], |row| Grade { taskgroup: row.get(0),
                                                                                  user: row.get(1),
                                                                                  grade: row.get(2),
                                                                                  validated: row.get(3) })
            .unwrap_or(None)
            .unwrap_or_default()
921
922
    }

923
    /* Warning: This function makes no use of rusts type safety. Handle with care when changeing */
924
925
    fn export_contest_results_to_file(&self, contest_id: i32, taskgroups: &[(i32, String)], filename: &str) {
        use std::fs::OpenOptions;
926
        let file = OpenOptions::new().write(true).create(true).truncate(true).open(filename).unwrap();
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
        let mut headers = vec!["id",
                               "username",
                               "logincode",
                               "oauth_foreign_id",
                               "oauth_provider",
                               "firstname",
                               "lastname",
                               "grade",
                               "sex",
                               "is_teacher",
                               "group_id",
                               "group_name",
                               "group_tag",
                               "teacher_id",
                               "teacher_firstname",
                               "teacher_lastname",
                               "teacher_oauth_foreign_id",
                               "teacher_oauth_provider",
                               "contest_id",
                               "start_date"];
947
948
949

        let mut select_part = String::new();
        let mut join_part = String::new();
950
951
952

        let mut join_params = gen_tosql_vector();

953
        join_params.push(&contest_id);
954
955

        for (n, (id, name)) in taskgroups.iter().enumerate() {
956
957
958
959
960
            select_part.push_str(&format!(",\n g{}.grade ", n));
            join_part.push_str(&format!("\n LEFT JOIN grade AS g{} ON session.id = g{}.session AND g{}.taskgroup = ${} ", n, n, n, n + 2));
            join_params.push(id);
            headers.push(&name);
        }
961

962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
        let query = format!("SELECT session.id,
                                    session.username,
                                    session.logincode,
                                    session.oauth_foreign_id,
                                    session.oauth_provider,
                                    session.firstname,
                                    session.lastname,
                                    session.grade,
                                    session.sex,
                                    session.is_teacher,
                                    session.managed_by,
                                    usergroup.name,
                                    usergroup.tag,
                                    teacher.id,
                                    teacher.firstname,
                                    teacher.lastname,
                                    teacher.oauth_foreign_id,
                                    teacher.oauth_provider,
                                    participation.contest,
                                    participation.start_date
                                    {}
                             FROM participation
                             JOIN session ON participation.session = session.id
                             {}
                             LEFT JOIN usergroup ON session.managed_by = usergroup.id
                             LEFT JOIN session AS teacher ON usergroup.admin = teacher.id
988
989
                             WHERE participation.contest = $1",
                            select_part, join_part);
990
991

        use csv::Writer;
992
        let mut wtr = Writer::from_writer(file);
993
994
        wtr.serialize(&headers).unwrap();
        wtr.flush().unwrap();
995

996
997
        let file = wtr.into_inner().unwrap();
        let mut wtr = Writer::from_writer(file);
998
999
1000
1001
1002
1003

        self.query_map_many(&query, join_params.as_slice(), |row| {
                let mut points = Vec::new();
                for i in 20..20 + taskgroups.len() {
                    points.push(row.get::<_, Option<i32>>(i));
                }
1004
1005
                // Serialized as several tuples because Serde only supports tuples up to a certain length
                // (16 according to https://docs.serde.rs/serde/trait.Deserialize.html)
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
                wtr.serialize(((row.get::<_, i32>(0),
                                row.get::<_, Option<String>>(1),
                                row.get::<_, Option<String>>(2),
                                row.get::<_, Option<String>>(3),
                                row.get::<_, Option<String>>(4),
                                row.get::<_, Option<String>>(5),
                                row.get::<_, Option<String>>(6),
                                row.get::<_, i32>(7),
                                row.get::<_, Option<i32>>(8),
                                row.get::<_, bool>(9)),
                               (row.get::<_, Option<i32>>(10),
                                row.get::<_, Option<String>>(11),
                                row.get::<_, Option<String>>(12),
                                row.get::<_, Option<i32>>(13),
                                row.get::<_, Option<String>>(14),
                                row.get::<_, Option<String>>(15),
                                row.get::<_, Option<String>>(16),
                                row.get::<_, Option<String>>(17)),
                               row.get::<_, Option<i32>>(18),
                               row.get::<_, Option<String>>(19),
                               points))
                   .unwrap();
            })
            .unwrap();
1030
        wtr.flush().unwrap();
1031
1032
    }

1033
    fn get_contest_list(&self) -> Vec<Contest> {
1034
        let query = "SELECT id, location, filename, name, duration, public, start_date, end_date, min_grade, max_grade,
1035
                            positionalnumber, requires_login, secret
1036
                     FROM contest
1037
                     ORDER BY positionalnumber";
1038
1039
1040
1041
1042
1043
1044
1045
        self.query_map_many(query, &[], |row| Contest { id: Some(row.get(0)),
                                                        location: row.get(1),
                                                        filename: row.get(2),
                                                        name: row.get(3),
                                                        duration: row.get(4),
                                                        public: row.get(5),
                                                        start: row.get(6),
                                                        end: row.get(7),
1046
1047
                                                        min_grade: row.get(8),
                                                        max_grade: row.get(9),
1048
                                                        positionalnumber: row.get(10),
1049
1050
                                                        requires_login: row.get(11),
                                                        secret: row.get(12),
1051
1052
                                                        taskgroups: Vec::new() })
            .unwrap()
1053
1054
1055
    }

    fn get_contest_by_id(&self, contest_id: i32) -> Contest {
1056
1057
        let query = "SELECT location, filename, name, duration, public, start_date, end_date, min_grade, max_grade,
                            requires_login, secret
1058
1059
                     FROM contest
                     WHERE id = $1";
1060
1061
1062
1063
1064
1065
1066
1067
        self.query_map_one(query, &[&contest_id], |row| Contest { id: Some(contest_id),
                                                                  location: row.get(0),
                                                                  filename: row.get(1),
                                                                  name: row.get(2),
                                                                  duration: row.get(3),
                                                                  public: row.get(4),
                                                                  start: row.get(5),
                                                                  end: row.get(6),
1068
1069
                                                                  min_grade: row.get(7),
                                                                  max_grade: row.get(8),
1070
                                                                  positionalnumber: None,
1071
1072
                                                                  requires_login: row.get(9),
                                                                  secret: row.get(10),
1073
                                                                  taskgroups: Vec::new() })
1074
1075
1076
1077
1078
            .unwrap()
            .unwrap() // TODO: Should return Option?
    }

    fn get_contest_by_id_complete(&self, contest_id: i32) -> Contest {
1079
        let query = "SELECT contest.location, contest.filename, contest.name, contest.duration, contest.public,
1080
1081
1082
                            contest.start_date, contest.end_date, contest.min_grade, contest.max_grade,
                            contest.requires_login, contest.secret, taskgroup.id, taskgroup.name, task.id,
                            task.location, task.stars
1083
1084
1085
1086
                     FROM contest
                     JOIN taskgroup ON contest.id = taskgroup.contest
                     JOIN task ON taskgroup.id = task.taskgroup
                     WHERE contest.id = $1
1087
                     AND taskgroup.active = $2
1088
                     ORDER BY taskgroup.positionalnumber";
1089
        let taskgroupcontest =
1090
            self.query_map_many(query, &[&contest_id, &true], |row| {
1091
1092
1093
1094
1095
1096
1097
1098
                    (Contest { id: Some(contest_id),
                               location: row.get(0),
                               filename: row.get(1),
                               name: row.get(2),
                               duration: row.get(3),
                               public: row.get(4),
                               start: row.get(5),
                               end: row.get(6),
1099
1100
                               min_grade: row.get(7),
                               max_grade: row.get(8),
1101
                               positionalnumber: None,
1102
1103
                               requires_login: row.get(9),
                               secret: row.get(10),
1104
                               taskgroups: Vec::new() },
1105
                     Taskgroup { id: Some(row.get(11)),
1106
                                 contest: contest_id,
1107
                                 name: row.get(12),
1108
                                 active: true,
1109
1110
                                 positionalnumber: None,
                                 tasks: Vec::new() },
1111
                     Task { id: Some(row.get(13)), taskgroup: row.get(11), location: row.get(14), stars: row.get(15) })
1112
1113
1114
                })
                .unwrap();
        let mut taskgroupcontest_iter = taskgroupcontest.into_iter();
1115
1116
1117
1118

        let (mut contest, mut taskgroup, task) = taskgroupcontest_iter.next().unwrap();
        taskgroup.tasks.push(task);
        for tgc in taskgroupcontest_iter {
1119
1120
1121
1122
            let (_, tg, t) = tgc;
            if tg.id != taskgroup.id {
                contest.taskgroups.push(taskgroup);
                taskgroup = tg;
1123
            }
1124
            taskgroup.tasks.push(t);
1125
1126
1127
1128
1129
1130
        }
        contest.taskgroups.push(taskgroup);
        contest
    }

    fn get_contest_by_id_partial(&self, contest_id: i32) -> Contest {
1131
        let query = "SELECT contest.location, contest.filename, contest.name, contest.duration, contest.public,
1132
1133
                            contest.start_date, contest.end_date, contest.min_grade, contest.max_grade,
                            contest.requires_login, contest_secret, taskgroup.id, taskgroup.name
1134
1135
                     FROM contest
                     JOIN taskgroup ON contest.id = taskgroup.contest
1136
1137
1138
                     WHERE contest.id = $1
                     AND taskgroup.active = $2";
        let taskgroupcontest = self.query_map_many(query, &[&contest_id, &true], |row| {
1139
1140
1141
1142
1143
1144
1145
1146
                                       (Contest { id: Some(contest_id),
                                                  location: row.get(0),
                                                  filename: row.get(1),
                                                  name: row.get(2),
                                                  duration: row.get(3),
                                                  public: row.get(4),
                                                  start: row.get(5),
                                                  end: row.get(6),
1147
1148
                                                  min_grade: row.get(7),
                                                  max_grade: row.get(8),
1149
                                                  positionalnumber: None,
1150
1151
                                                  requires_login: row.get(9),
                                                  secret: row.get(10),
1152
                                                  taskgroups: Vec::new() },
1153
                                        Taskgroup { id: Some(row.get(11)),
1154
                                                    contest: contest_id,
1155
                                                    name: row.get(12),
1156
                                                    active: true,
1157
1158
1159
1160
                                                    positionalnumber: None,
                                                    tasks: Vec::new() })
                                   })
                                   .unwrap();
1161
        let mut taskgroupcontest_iter = taskgroupcontest.into_iter();
1162
1163
1164
1165

        let (mut contest, taskgroup) = taskgroupcontest_iter.next().unwrap();
        contest.taskgroups.push(taskgroup);
        for tgc in taskgroupcontest_iter {
1166
1167
            let (_, tg) = tgc;
            contest.taskgroups.push(tg);
1168
1169
1170
1171
1172
        }
        contest
    }

    fn get_participation(&self, session: &str, contest_id: i32) -> Option<Participation> {
1173
1174
1175
1176
1177
        let query = "SELECT session, start_date
                     FROM participation
                     JOIN session ON session.id = session
                     WHERE session.session_token = $1
                     AND contest = $2";
1178
1179
1180
1181
        self.query_map_one(query, &[&session, &contest_id], |row| Participation { contest: contest_id,
                                                                                  user: row.get(0),
                                                                                  start: row.get(1) })
            .ok()?
1182
    }
1183
1184
1185
1186
1187
1188
1189
1190

    fn get_all_participations_complete(&self, session_id: i32) -> Vec<(Participation, Contest)> {
        let query = "SELECT participation.start_date, contest.id, location, filename, name, duration, public,
                            contest.start_date, end_date, min_grade, max_grade, requires_login, secret
                     FROM participation
                     JOIN contest ON participation.contest = contest.id
                     WHERE participation.session = $1";
        self.query_map_many(query, &[&session_id], |row| {
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
                (Participation { contest: row.get(1), user: session_id, start: row.get(0) },
                 Contest { id: Some(row.get(1)),
                           location: row.get(2),
                           filename: row.get(3),
                           name: row.get(4),
                           duration: row.get(5),
                           public: row.get(6),
                           start: row.get(7),
                           end: row.get(8),
                           min_grade: row.get(9),
                           max_grade: row.get(10),
                           positionalnumber: None,
                           requires_login: row.get(11),
                           secret: row.get(12),
                           taskgroups: Vec::new() })
            })
            .unwrap()
1208
1209
    }