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
354

        let duration = if session.permanent_login { Duration::days(90) } else { Duration::minutes(90) };
        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
559
                     -> Result<String, ()>
    {
560
561
        let session_token = helpers::make_session_token();
        let csrf_token = helpers::make_csrf_token();
562
563
        let now = time::get_time();

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

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

                Ok(session_token)
            }
        }
    }

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

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

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

644
        Ok(session_token)
645
646
    }

Robert Czechowski's avatar
rustfmt    
Robert Czechowski committed
647
    fn create_group_with_users(&self, mut group: Group) {
648
649
650
651
652
653
        // 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
654

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

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

    fn load_submission(&self, session: &SessionUser, task: i32, subtask: Option<&str>) -> Option<Submission> {
        match subtask {
681
682
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
            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()?
            }
722
723
        }
    }
724
725
726
727
728
729
730
731
    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)),
732
733
734
735
736
737
738
739
                                                                                     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),
740
741
742
                                                                                     needs_validation: row.get(6) })
                    .unwrap()
            }
743
            _ => unimplemented!(),
744
745
        }
    }
746
747
748
749
750
751
752
753
754
755
756
    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 {
757
758
759
760
761
762
        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";
763
764
765
766
767
768
769
        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
770
771
772
                         FROM submission
                         JOIN task ON task.id = submission.task
                         WHERE submission.id = $1";
773
774
775
776
777
778
779
                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?
            })
780
781
782
783
    }

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

792
793
794
795
796
797
798
        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);
        }

799
800
        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,
801
                            student.firstname, student.lastname, student.grade AS sgrade
802
803
804
805
806
807
                     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
808
                     AND taskgroup.active = $3
809
810
                     ORDER BY usergroup.id, sgrade, student.lastname, student.firstname, student.id,
                              taskgroup.positionalnumber";
811
        let gradeinfo =
812
            self.query_map_many(query, &[&session_id, &contest_id, &true], |row| {
813
814
815
816
817
818
819
820
821
822
823
                    (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),
824
                                lastname: row.get(12),
Robert Czechowski's avatar
Robert Czechowski committed
825
                                grade: row.get(13) })
826
827
828
                })
                .unwrap();
        let mut gradeinfo_iter = gradeinfo.iter();
829
830

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

            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;
838
            grades[taskindex[&index]] = grade;
839
840

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

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

            (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> {
867
868
869
        let query = "SELECT id, name
                     FROM taskgroup
                     WHERE contest = $1
870
871
                     AND active = $2
                     ORDER BY positionalnumber";
872
        let tasknames: Vec<(i32, String)> =
873
            self.query_map_many(query, &[&contest_id, &true], |row| (row.get(0), row.get(1))).unwrap();
874
875
876
877
878
879
880
        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);
        }

881
882
883
884
885
886
        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
887
888
                     AND taskgroup.active = $3
                     ORDER BY taskgroup.positionalnumber";
889
        let gradeinfo =
890
            self.query_map_many(query, &[&session_token, &contest_id, &true], |row| Grade { taskgroup: row.get(0),
Robert Czechowski's avatar
Robert Czechowski committed
891
892
893
                                                                                            user: row.get(1),
                                                                                            grade: row.get(2),
                                                                                            validated: row.get(3) })
894
895
                .unwrap();
        let gradeinfo_iter = gradeinfo.iter();
896
897
898
899
900

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

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

        grades
    }

    fn get_taskgroup_user_grade(&self, session_token: &str, taskgroup_id: i32) -> Grade {
908
        let query = "SELECT grade.taskgroup, grade.session, grade.grade, grade.validated
909
910
911
912
                     FROM grade
                     JOIN session ON session.id = grade.session
                     WHERE session.session_token = $1
                     AND grade.taskgroup = $2";
913
914
915
916
917
918
        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()
919
920
    }

921
    /* Warning: This function makes no use of rusts type safety. Handle with care when changeing */
922
923
    fn export_contest_results_to_file(&self, contest_id: i32, taskgroups: &[(i32, String)], filename: &str) {
        use std::fs::OpenOptions;
924
        // TODO: what to do, if this fails? Function should be fallible
925
        let file = OpenOptions::new().write(true).create(true).truncate(true).open(filename).unwrap();
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
        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"];
946
947
948

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

        let mut join_params = gen_tosql_vector();

952
        join_params.push(&contest_id);
953
954

        for (n, (id, name)) in taskgroups.iter().enumerate() {
955
956
957
958
959
            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);
        }
960

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
        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
987
988
                             WHERE participation.contest = $1",
                            select_part, join_part);
989
990

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

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

        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));
                }
1003
1004
                // 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)
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
                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();
1029
        wtr.flush().unwrap();
1030
1031
    }

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

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

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

1115
        // TODO: This can fail
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
    }

1210
    fn new_participation(&self, session: &str, contest_id: i32) -> Result<Participation, ()> {
1211
1212
1213
1214
1215
        let query = "SELECT session, start_date
                     FROM participation
                     JOIN session ON session.id = session
                     WHERE session.session_token = $1
                     AND contest = $2";
1216
1217
        match self.query_map_one(query, &[&session, &contest_id], |_| {}).map_err(|_| ())? {
            Some(()) => Err(()),