<!DOCTYPE html><html lang="en"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><meta name="generator" content="rustdoc"><meta name="description" content="Source of the Rust file `database/src/compact_mediafile.rs`."><meta name="keywords" content="rust, rustlang, rust-lang"><title>compact_mediafile.rs - source</title><link rel="preload" as="font" type="font/woff2" crossorigin href="../../SourceSerif4-Regular.ttf.woff2"><link rel="preload" as="font" type="font/woff2" crossorigin href="../../FiraSans-Regular.woff2"><link rel="preload" as="font" type="font/woff2" crossorigin href="../../FiraSans-Medium.woff2"><link rel="preload" as="font" type="font/woff2" crossorigin href="../../SourceCodePro-Regular.ttf.woff2"><link rel="preload" as="font" type="font/woff2" crossorigin href="../../SourceSerif4-Bold.ttf.woff2"><link rel="preload" as="font" type="font/woff2" crossorigin href="../../SourceCodePro-Semibold.ttf.woff2"><link rel="stylesheet" type="text/css" href="../../normalize.css"><link rel="stylesheet" type="text/css" href="../../rustdoc.css" id="mainThemeStyle"><link rel="stylesheet" type="text/css" href="../../ayu.css" disabled><link rel="stylesheet" type="text/css" href="../../dark.css" disabled><link rel="stylesheet" type="text/css" href="../../light.css" id="themeStyle"><script id="default-settings" ></script><script src="../../storage.js"></script><script src="../../crates.js"></script><script defer src="../../main.js"></script><script defer src="../../source-script.js"></script><script defer src="../../source-files.js"></script>
<noscript><link rel="stylesheet" href="../../noscript.css"></noscript><link rel="alternate icon" type="image/png" href="../../favicon-16x16.png"><link rel="alternate icon" type="image/png" href="../../favicon-32x32.png"><link rel="icon" type="image/svg+xml" href="../../favicon.svg"></head><body class="rustdoc source"><!--[if lte IE 11]><div class="warning">This old browser is unsupported and will most likely display funky things.</div><![endif]--><nav class="mobile-topbar"><button class="sidebar-menu-toggle">☰</button><a class="sidebar-logo" href="../../database/index.html"><div class="logo-container"><img class="rust-logo" src="../../rust-logo.svg" alt="logo"></div>
</a><h2 class="location"></h2>
</nav>
<nav class="sidebar"><a class="sidebar-logo" href="../../database/index.html"><div class="logo-container"><img class="rust-logo" src="../../rust-logo.svg" alt="logo"></div>
</a></nav><main><div class="width-limiter"><div class="sub-container"><a class="sub-logo-container" href="../../database/index.html"><img class="rust-logo" src="../../rust-logo.svg" alt="logo"></a><nav class="sub"><div class="theme-picker hidden"><button id="theme-picker" aria-label="Pick another theme!" aria-haspopup="menu" title="themes"><img width="22" height="22" alt="Pick another theme!" src="../../brush.svg"></button><div id="theme-choices" role="menu"></div></div><form class="search-form"><div class="search-container"><span></span><input class="search-input" name="search" autocomplete="off" spellcheck="false" placeholder="Click or press ‘S’ to search, ‘?’ for more options…" type="search"><button type="button" id="help-button" title="help">?</button><a id="settings-menu" href="../../settings.html" title="settings"><img width="22" height="22" alt="Change settings" src="../../wheel.svg"></a></div></form></nav></div><section id="main-content" class="content"><div class="example-wrap"><pre class="line-numbers"><span id="1">1</span>
<span id="2">2</span>
<span id="3">3</span>
<span id="4">4</span>
<span id="5">5</span>
<span id="6">6</span>
<span id="7">7</span>
<span id="8">8</span>
<span id="9">9</span>
<span id="10">10</span>
<span id="11">11</span>
<span id="12">12</span>
<span id="13">13</span>
<span id="14">14</span>
<span id="15">15</span>
<span id="16">16</span>
<span id="17">17</span>
<span id="18">18</span>
<span id="19">19</span>
<span id="20">20</span>
<span id="21">21</span>
<span id="22">22</span>
<span id="23">23</span>
<span id="24">24</span>
<span id="25">25</span>
<span id="26">26</span>
<span id="27">27</span>
<span id="28">28</span>
<span id="29">29</span>
<span id="30">30</span>
<span id="31">31</span>
<span id="32">32</span>
<span id="33">33</span>
<span id="34">34</span>
<span id="35">35</span>
<span id="36">36</span>
<span id="37">37</span>
<span id="38">38</span>
<span id="39">39</span>
<span id="40">40</span>
<span id="41">41</span>
<span id="42">42</span>
<span id="43">43</span>
<span id="44">44</span>
<span id="45">45</span>
<span id="46">46</span>
<span id="47">47</span>
<span id="48">48</span>
<span id="49">49</span>
<span id="50">50</span>
<span id="51">51</span>
<span id="52">52</span>
<span id="53">53</span>
<span id="54">54</span>
<span id="55">55</span>
<span id="56">56</span>
<span id="57">57</span>
<span id="58">58</span>
<span id="59">59</span>
<span id="60">60</span>
<span id="61">61</span>
<span id="62">62</span>
<span id="63">63</span>
<span id="64">64</span>
<span id="65">65</span>
<span id="66">66</span>
<span id="67">67</span>
<span id="68">68</span>
<span id="69">69</span>
<span id="70">70</span>
<span id="71">71</span>
<span id="72">72</span>
<span id="73">73</span>
<span id="74">74</span>
<span id="75">75</span>
<span id="76">76</span>
<span id="77">77</span>
<span id="78">78</span>
<span id="79">79</span>
<span id="80">80</span>
<span id="81">81</span>
<span id="82">82</span>
<span id="83">83</span>
<span id="84">84</span>
<span id="85">85</span>
<span id="86">86</span>
<span id="87">87</span>
<span id="88">88</span>
<span id="89">89</span>
<span id="90">90</span>
<span id="91">91</span>
<span id="92">92</span>
<span id="93">93</span>
<span id="94">94</span>
<span id="95">95</span>
<span id="96">96</span>
<span id="97">97</span>
<span id="98">98</span>
<span id="99">99</span>
<span id="100">100</span>
<span id="101">101</span>
<span id="102">102</span>
</pre><pre class="rust"><code><span class="kw">use</span> <span class="ident"><span class="kw">crate</span>::DatabaseError</span>;
<span class="kw">use</span> <span class="ident"><span class="kw">crate</span>::Transaction</span>;
<span class="kw">use</span> <span class="ident">std::path::Path</span>;
<span class="kw">use</span> <span class="ident">std::path::PathBuf</span>;
<span class="doccomment">/// A compact version of `MediaFile`. Useful in cases where we need to request some basic info for</span>
<span class="doccomment">/// a lot of mediafiles, and as such a `SELECT *` is not viable.</span>
<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Clone</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">CompactMediafile</span> {
<span class="kw">pub</span> <span class="ident">id</span>: <span class="ident">i64</span>,
<span class="kw">pub</span> <span class="ident">name</span>: <span class="ident">String</span>,
<span class="kw">pub</span> <span class="ident">duration</span>: <span class="prelude-ty">Option</span><span class="op"><</span><span class="ident">i64</span><span class="op">></span>,
<span class="kw">pub</span> <span class="ident">target_file</span>: <span class="ident">PathBuf</span>,
}
<span class="doccomment">/// Intermediary record which is later converted into a `CompactMediafile`. This is needed because</span>
<span class="doccomment">/// sqlx doesnt support deserializing into a `PathBuf`.</span>
<span class="kw">struct</span> <span class="ident">Record</span> {
<span class="ident">id</span>: <span class="ident">i64</span>,
<span class="ident">name</span>: <span class="ident">String</span>,
<span class="ident">duration</span>: <span class="prelude-ty">Option</span><span class="op"><</span><span class="ident">i64</span><span class="op">></span>,
<span class="ident">target_file</span>: <span class="ident">String</span>,
}
<span class="kw">impl</span> <span class="ident">From</span><span class="op"><</span><span class="ident">Record</span><span class="op">></span> <span class="kw">for</span> <span class="ident">CompactMediafile</span> {
<span class="kw">fn</span> <span class="ident">from</span>(
<span class="ident">Record</span> {
<span class="ident">id</span>,
<span class="ident">name</span>,
<span class="ident">duration</span>,
<span class="ident">target_file</span>,
}: <span class="ident">Record</span>,
) -> <span class="self">Self</span> {
<span class="self">Self</span> {
<span class="ident">id</span>,
<span class="ident">name</span>,
<span class="ident">duration</span>,
<span class="ident">target_file</span>: <span class="ident">Path::new</span>(<span class="kw-2">&</span><span class="ident">target_file</span>).<span class="ident">to_path_buf</span>(),
}
}
}
<span class="kw">impl</span> <span class="ident">CompactMediafile</span> {
<span class="doccomment">/// Method will return all the unmatched mediafiles for a specific library.</span>
<span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">unmatched_for_library</span>(
<span class="ident">tx</span>: <span class="kw-2">&mut</span> <span class="ident">Transaction</span><span class="op"><</span><span class="lifetime">'_</span><span class="op">></span>,
<span class="ident">library_id</span>: <span class="ident">i64</span>,
) -> <span class="prelude-ty">Result</span><span class="op"><</span><span class="ident">Vec</span><span class="op"><</span><span class="self">Self</span><span class="op">></span>, <span class="ident">DatabaseError</span><span class="op">></span> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
<span class="ident">Record</span>,
<span class="string">r#"SELECT id, raw_name as name, duration, target_file FROM mediafile
WHERE library_id = ? AND media_id IS NULL"#</span>,
<span class="ident">library_id</span>
)
.<span class="ident">fetch_all</span>(<span class="ident">tx</span>)
.<span class="kw">await</span><span class="question-mark">?</span>
.<span class="ident">into_iter</span>()
.<span class="ident">map</span>(<span class="ident">Into::into</span>)
.<span class="ident">collect</span>())
}
<span class="doccomment">/// Method will return all mediafiles for a media id.</span>
<span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">all_for_media</span>(
<span class="ident">tx</span>: <span class="kw-2">&mut</span> <span class="ident">Transaction</span><span class="op"><</span><span class="lifetime">'_</span><span class="op">></span>,
<span class="ident">media_id</span>: <span class="ident">i64</span>,
) -> <span class="prelude-ty">Result</span><span class="op"><</span><span class="ident">Vec</span><span class="op"><</span><span class="self">Self</span><span class="op">></span>, <span class="ident">DatabaseError</span><span class="op">></span> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
<span class="ident">Record</span>,
<span class="string">r#"SELECT id, raw_name as name, duration, target_file FROM mediafile
WHERE mediafile.media_id = ?"#</span>,
<span class="ident">media_id</span>
)
.<span class="ident">fetch_all</span>(<span class="ident">tx</span>)
.<span class="kw">await</span><span class="question-mark">?</span>
.<span class="ident">into_iter</span>()
.<span class="ident">map</span>(<span class="ident">Into::into</span>)
.<span class="ident">collect</span>())
}
<span class="doccomment">/// Method will return all mediafiles for a tv show.</span>
<span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">all_for_tv</span>(
<span class="ident">tx</span>: <span class="kw-2">&mut</span> <span class="ident">Transaction</span><span class="op"><</span><span class="lifetime">'_</span><span class="op">></span>,
<span class="ident">tv_id</span>: <span class="ident">i64</span>,
) -> <span class="prelude-ty">Result</span><span class="op"><</span><span class="ident">Vec</span><span class="op"><</span><span class="self">Self</span><span class="op">></span>, <span class="ident">DatabaseError</span><span class="op">></span> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
<span class="ident">Record</span>,
<span class="string">"SELECT mediafile.id, raw_name as name, duration, target_file FROM mediafile
INNER JOIN episode ON mediafile.media_id = episode.id
INNER JOIN _tblseason ON episode.seasonid = _tblseason.id
WHERE _tblseason.tvshowid = ?
GROUP BY episode.id
"</span>,
<span class="ident">tv_id</span>
)
.<span class="ident">fetch_all</span>(<span class="kw-2">&mut</span> <span class="kw-2">*</span><span class="ident">tx</span>)
.<span class="kw">await</span><span class="question-mark">?</span>
.<span class="ident">into_iter</span>()
.<span class="ident">map</span>(<span class="ident">Into::into</span>)
.<span class="ident">collect</span>())
}
}
</code></pre></div>
</section><section id="search" class="content hidden"></section></div></main><div id="rustdoc-vars" data-root-path="../../" data-current-crate="database" data-themes="ayu,dark,light" data-resource-suffix="" data-rustdoc-version="1.61.0 (fe5b13d68 2022-05-18)" ></div>
</body></html>