convert_invert/internals/database/
schema.rs1pub mod sql_types {
4 #[derive(diesel::sql_types::SqlType)]
5 #[diesel(postgres_type(name = "reject_reason"))]
6 pub struct RejectReason;
7}
8
9diesel::table! {
10 downloadable_files (id) {
11 id -> Int4,
12 filename -> Varchar,
13 username -> Varchar,
14 size -> Int8,
15 }
16}
17
18diesel::table! {
19 downloaded_file (id) {
20 id -> Int4,
21 filename -> Varchar,
22 track -> Nullable<Int4>,
23 }
24}
25
26diesel::table! {
27 judge_submissions (id) {
28 id -> Int4,
29 track -> Int4,
30 query -> Int4,
31 score -> Nullable<Float4>,
32 }
33}
34
35diesel::table! {
36 use diesel::sql_types::*;
37 use super::sql_types::RejectReason;
38
39 rejected_track (id) {
40 id -> Int4,
41 track -> Int4,
42 reason -> RejectReason,
43 value -> Nullable<Varchar>,
44 }
45}
46
47diesel::table! {
48 retry_request (id) {
49 id -> Int4,
50 request -> Int4,
51 retry_attempts -> Int4,
52 failed_download_result -> Int4,
53 }
54}
55
56diesel::table! {
57 search_items (id) {
58 id -> Int4,
59 track_id -> Varchar,
60 track -> Varchar,
61 artist -> Varchar,
62 album -> Varchar,
63 }
64}
65
66diesel::joinable!(judge_submissions -> downloadable_files (query));
67diesel::joinable!(judge_submissions -> search_items (track));
68diesel::joinable!(downloaded_file -> search_items (track));
69diesel::joinable!(rejected_track -> judge_submissions (track));
70diesel::joinable!(retry_request -> downloadable_files (failed_download_result));
71diesel::joinable!(retry_request -> judge_submissions (request));
72
73diesel::allow_tables_to_appear_in_same_query!(
74 downloadable_files,
75 downloaded_file,
76 judge_submissions,
77 rejected_track,
78 retry_request,
79 search_items,
80);