<!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/mediafile.rs`."><meta name="keywords" content="rust, rustlang, rust-lang"><title>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" href="../../normalize.css"><link rel="stylesheet" href="../../rustdoc.css" id="mainThemeStyle"><link rel="stylesheet" href="../../ayu.css" disabled><link rel="stylesheet" href="../../dark.css" disabled><link rel="stylesheet" href="../../light.css" id="themeStyle"><script id="default-settings" ></script><script src="../../storage.js"></script><script defer src="../../source-script.js"></script><script defer src="../../source-files.js"></script><script defer src="../../main.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"><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"><div id="help-button" title="help" tabindex="-1"><button type="button">?</button></div><div id="settings-menu" tabindex="-1"><a href="../../settings.html" title="settings"><img width="22" height="22" alt="Change settings" src="../../wheel.svg"></a></div></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>
<span id="103">103</span>
<span id="104">104</span>
<span id="105">105</span>
<span id="106">106</span>
<span id="107">107</span>
<span id="108">108</span>
<span id="109">109</span>
<span id="110">110</span>
<span id="111">111</span>
<span id="112">112</span>
<span id="113">113</span>
<span id="114">114</span>
<span id="115">115</span>
<span id="116">116</span>
<span id="117">117</span>
<span id="118">118</span>
<span id="119">119</span>
<span id="120">120</span>
<span id="121">121</span>
<span id="122">122</span>
<span id="123">123</span>
<span id="124">124</span>
<span id="125">125</span>
<span id="126">126</span>
<span id="127">127</span>
<span id="128">128</span>
<span id="129">129</span>
<span id="130">130</span>
<span id="131">131</span>
<span id="132">132</span>
<span id="133">133</span>
<span id="134">134</span>
<span id="135">135</span>
<span id="136">136</span>
<span id="137">137</span>
<span id="138">138</span>
<span id="139">139</span>
<span id="140">140</span>
<span id="141">141</span>
<span id="142">142</span>
<span id="143">143</span>
<span id="144">144</span>
<span id="145">145</span>
<span id="146">146</span>
<span id="147">147</span>
<span id="148">148</span>
<span id="149">149</span>
<span id="150">150</span>
<span id="151">151</span>
<span id="152">152</span>
<span id="153">153</span>
<span id="154">154</span>
<span id="155">155</span>
<span id="156">156</span>
<span id="157">157</span>
<span id="158">158</span>
<span id="159">159</span>
<span id="160">160</span>
<span id="161">161</span>
<span id="162">162</span>
<span id="163">163</span>
<span id="164">164</span>
<span id="165">165</span>
<span id="166">166</span>
<span id="167">167</span>
<span id="168">168</span>
<span id="169">169</span>
<span id="170">170</span>
<span id="171">171</span>
<span id="172">172</span>
<span id="173">173</span>
<span id="174">174</span>
<span id="175">175</span>
<span id="176">176</span>
<span id="177">177</span>
<span id="178">178</span>
<span id="179">179</span>
<span id="180">180</span>
<span id="181">181</span>
<span id="182">182</span>
<span id="183">183</span>
<span id="184">184</span>
<span id="185">185</span>
<span id="186">186</span>
<span id="187">187</span>
<span id="188">188</span>
<span id="189">189</span>
<span id="190">190</span>
<span id="191">191</span>
<span id="192">192</span>
<span id="193">193</span>
<span id="194">194</span>
<span id="195">195</span>
<span id="196">196</span>
<span id="197">197</span>
<span id="198">198</span>
<span id="199">199</span>
<span id="200">200</span>
<span id="201">201</span>
<span id="202">202</span>
<span id="203">203</span>
<span id="204">204</span>
<span id="205">205</span>
<span id="206">206</span>
<span id="207">207</span>
<span id="208">208</span>
<span id="209">209</span>
<span id="210">210</span>
<span id="211">211</span>
<span id="212">212</span>
<span id="213">213</span>
<span id="214">214</span>
<span id="215">215</span>
<span id="216">216</span>
<span id="217">217</span>
<span id="218">218</span>
<span id="219">219</span>
<span id="220">220</span>
<span id="221">221</span>
<span id="222">222</span>
<span id="223">223</span>
<span id="224">224</span>
<span id="225">225</span>
<span id="226">226</span>
<span id="227">227</span>
<span id="228">228</span>
<span id="229">229</span>
<span id="230">230</span>
<span id="231">231</span>
<span id="232">232</span>
<span id="233">233</span>
<span id="234">234</span>
<span id="235">235</span>
<span id="236">236</span>
<span id="237">237</span>
<span id="238">238</span>
<span id="239">239</span>
<span id="240">240</span>
<span id="241">241</span>
<span id="242">242</span>
<span id="243">243</span>
<span id="244">244</span>
<span id="245">245</span>
<span id="246">246</span>
<span id="247">247</span>
<span id="248">248</span>
<span id="249">249</span>
<span id="250">250</span>
<span id="251">251</span>
<span id="252">252</span>
<span id="253">253</span>
<span id="254">254</span>
<span id="255">255</span>
<span id="256">256</span>
<span id="257">257</span>
<span id="258">258</span>
<span id="259">259</span>
<span id="260">260</span>
<span id="261">261</span>
<span id="262">262</span>
<span id="263">263</span>
<span id="264">264</span>
<span id="265">265</span>
<span id="266">266</span>
<span id="267">267</span>
<span id="268">268</span>
<span id="269">269</span>
<span id="270">270</span>
<span id="271">271</span>
<span id="272">272</span>
<span id="273">273</span>
<span id="274">274</span>
<span id="275">275</span>
<span id="276">276</span>
<span id="277">277</span>
<span id="278">278</span>
<span id="279">279</span>
<span id="280">280</span>
<span id="281">281</span>
<span id="282">282</span>
<span id="283">283</span>
<span id="284">284</span>
<span id="285">285</span>
<span id="286">286</span>
<span id="287">287</span>
<span id="288">288</span>
<span id="289">289</span>
<span id="290">290</span>
<span id="291">291</span>
<span id="292">292</span>
<span id="293">293</span>
<span id="294">294</span>
<span id="295">295</span>
<span id="296">296</span>
<span id="297">297</span>
<span id="298">298</span>
<span id="299">299</span>
<span id="300">300</span>
<span id="301">301</span>
<span id="302">302</span>
<span id="303">303</span>
<span id="304">304</span>
<span id="305">305</span>
<span id="306">306</span>
<span id="307">307</span>
<span id="308">308</span>
<span id="309">309</span>
<span id="310">310</span>
<span id="311">311</span>
<span id="312">312</span>
<span id="313">313</span>
<span id="314">314</span>
<span id="315">315</span>
<span id="316">316</span>
<span id="317">317</span>
<span id="318">318</span>
<span id="319">319</span>
<span id="320">320</span>
<span id="321">321</span>
<span id="322">322</span>
<span id="323">323</span>
<span id="324">324</span>
<span id="325">325</span>
<span id="326">326</span>
<span id="327">327</span>
<span id="328">328</span>
<span id="329">329</span>
<span id="330">330</span>
<span id="331">331</span>
<span id="332">332</span>
<span id="333">333</span>
<span id="334">334</span>
<span id="335">335</span>
<span id="336">336</span>
<span id="337">337</span>
<span id="338">338</span>
<span id="339">339</span>
<span id="340">340</span>
<span id="341">341</span>
<span id="342">342</span>
<span id="343">343</span>
<span id="344">344</span>
<span id="345">345</span>
<span id="346">346</span>
<span id="347">347</span>
<span id="348">348</span>
<span id="349">349</span>
<span id="350">350</span>
<span id="351">351</span>
<span id="352">352</span>
<span id="353">353</span>
<span id="354">354</span>
<span id="355">355</span>
<span id="356">356</span>
<span id="357">357</span>
<span id="358">358</span>
<span id="359">359</span>
<span id="360">360</span>
<span id="361">361</span>
<span id="362">362</span>
<span id="363">363</span>
<span id="364">364</span>
<span id="365">365</span>
<span id="366">366</span>
<span id="367">367</span>
<span id="368">368</span>
<span id="369">369</span>
<span id="370">370</span>
<span id="371">371</span>
<span id="372">372</span>
<span id="373">373</span>
<span id="374">374</span>
<span id="375">375</span>
<span id="376">376</span>
<span id="377">377</span>
<span id="378">378</span>
<span id="379">379</span>
<span id="380">380</span>
<span id="381">381</span>
<span id="382">382</span>
<span id="383">383</span>
<span id="384">384</span>
<span id="385">385</span>
<span id="386">386</span>
<span id="387">387</span>
<span id="388">388</span>
<span id="389">389</span>
<span id="390">390</span>
<span id="391">391</span>
<span id="392">392</span>
<span id="393">393</span>
<span id="394">394</span>
<span id="395">395</span>
<span id="396">396</span>
</pre><pre class="rust"><code><span class="kw">use </span><span class="kw">crate</span>::media::Media;
<span class="kw">use </span><span class="kw">crate</span>::query_ext::QueryExt;
<span class="kw">use </span><span class="kw">crate</span>::DatabaseError;
<span class="kw">use </span>itertools::intersperse;
<span class="kw">use </span>serde::Deserialize;
<span class="kw">use </span>serde::Serialize;
<span class="kw">use </span>std::iter::repeat;
<span class="doccomment">/// MediaFile struct which represents a media file on the filesystem. This struct holds some basic
/// information which the video player on the front end might require.
</span><span class="attribute">#[derive(Serialize, PartialEq, Debug, Clone, sqlx::FromRow)]
</span><span class="kw">pub struct </span>MediaFile {
<span class="doccomment">/// Unique identifier of a mediafile.
</span><span class="kw">pub </span>id: i64,
<span class="doccomment">/// Foreign key linking this entry to the media table or [`Media`](Media) struct
</span><span class="kw">pub </span>media_id: <span class="prelude-ty">Option</span><i64>,
<span class="doccomment">/// Library foreign key linking this entry to the library table or [`Library`](Library) struct
</span><span class="kw">pub </span>library_id: i64,
<span class="doccomment">/// String representing the file path of the file we target. This should be a real path on the
/// filesystem.
</span><span class="kw">pub </span>target_file: String,
<span class="doccomment">/// Raw name that we extract from the filename using regex and the parse-torrent-name library
</span><span class="kw">pub </span>raw_name: String,
<span class="doccomment">/// Raw year we might be able to extract from the filename using regex and the
/// parse-torrent-name library
</span><span class="kw">pub </span>raw_year: <span class="prelude-ty">Option</span><i64>,
<span class="doccomment">/// Quality string that we might get from ffprobe when running it against our file
</span><span class="kw">pub </span>quality: <span class="prelude-ty">Option</span><String>,
<span class="doccomment">/// Codec that we might get from ffprobe when running it against our file
</span><span class="kw">pub </span>codec: <span class="prelude-ty">Option</span><String>,
<span class="doccomment">/// Container descriptor that we might get from ffprobe
</span><span class="kw">pub </span>container: <span class="prelude-ty">Option</span><String>,
<span class="doccomment">/// Audio codec specifier that we might get from ffprobe
</span><span class="kw">pub </span>audio: <span class="prelude-ty">Option</span><String>,
<span class="doccomment">/// Video resolution that we can obtain from ffprobe
</span><span class="kw">pub </span>original_resolution: <span class="prelude-ty">Option</span><String>,
<span class="doccomment">/// Duration of the video file that we obtain from ffprobe
</span><span class="kw">pub </span>duration: <span class="prelude-ty">Option</span><i64>,
<span class="doccomment">/// Episode number that we might get from using regex and the parse-torrent-name crate. This is
/// specific to tv shows only.
</span><span class="kw">pub </span>episode: <span class="prelude-ty">Option</span><i64>,
<span class="doccomment">/// Season number that we might get from using regexa and the parse-torrent-name crate. This is
/// specific to tv shows only.
</span><span class="kw">pub </span>season: <span class="prelude-ty">Option</span><i64>,
<span class="doccomment">/// Flag which tells us if the file is corrupted or not. ie if ffprobe cant open the file and
/// reports no metadata this flag will be set.
</span><span class="kw">pub </span>corrupt: <span class="prelude-ty">Option</span><bool>,
<span class="doccomment">/// Audio channels count
</span><span class="kw">pub </span>channels: <span class="prelude-ty">Option</span><i64>,
<span class="doccomment">/// avc_profile
</span><span class="kw">pub </span>profile: <span class="prelude-ty">Option</span><String>,
<span class="doccomment">/// Primary audio language
</span><span class="kw">pub </span>audio_language: <span class="prelude-ty">Option</span><String>,
}
<span class="kw">impl </span>MediaFile {
<span class="doccomment">/// Method returns all mediafiles associated with a library.
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `lib` - reference to a Library object that we will match against
</span><span class="kw">pub async fn </span>get_by_lib(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
library_id: i64,
) -> <span class="prelude-ty">Result</span><Vec<<span class="self">Self</span>>, DatabaseError> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
MediaFile,
<span class="string">"SELECT * FROM mediafile WHERE library_id = ?"</span>,
library_id
)
.fetch_all(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>)
}
<span class="doccomment">/// Method returns all mediafiles associated with a library and filters for those not
/// associated with a media
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `lib` - reference to a Library object that we will match against
</span><span class="kw">pub async fn </span>get_by_lib_null_media(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
library_id: i64,
) -> <span class="prelude-ty">Result</span><Vec<<span class="self">Self</span>>, DatabaseError> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
MediaFile,
<span class="string">"SELECT * FROM mediafile WHERE library_id = ? AND media_id IS NULL"</span>,
library_id
)
.fetch_all(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>)
}
<span class="doccomment">/// Method returns all mediafiles associated with a Media object.
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `lib` - reference to a Library object that we will match against
</span><span class="kw">pub async fn </span>get_of_media(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
media_id: i64,
) -> <span class="prelude-ty">Result</span><Vec<<span class="self">Self</span>>, DatabaseError> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
MediaFile,
<span class="string">"SELECT mediafile.* FROM mediafile
INNER JOIN media ON media.id = mediafile.media_id
WHERE media.id = ?"</span>,
media_id
)
.fetch_all(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>)
}
<span class="kw">pub async fn </span>get_of_show(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
id: i64,
) -> <span class="prelude-ty">Result</span><Vec<<span class="self">Self</span>>, DatabaseError> {
<span class="comment">// FIXME: I think we can make this query a bit more efficient by adding an index on
// mediafile.mediaid, but given how often this is called, this might not be worth it.
</span><span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
MediaFile,
<span class="string">"SELECT mediafile.* FROM _tblseason
INNER JOIN episode ON _tblseason.id = episode.seasonid
INNER JOIN mediafile ON mediafile.media_id = episode.id
WHERE _tblseason.tvshowid = ?
GROUP BY mediafile.id"</span>,
id
)
.fetch_all(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>)
}
<span class="doccomment">/// Method returns all metadata of a mediafile based on the id supplied.
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `_id` - id of the mediafile object we are targetting
</span><span class="kw">pub async fn </span>get_one(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
id: i64,
) -> <span class="prelude-ty">Result</span><<span class="self">Self</span>, DatabaseError> {
<span class="prelude-val">Ok</span>(
<span class="macro">sqlx::query_as!</span>(MediaFile, <span class="string">"SELECT * FROM mediafile WHERE id = ?"</span>, id)
.fetch_one(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>,
)
}
<span class="doccomment">/// Method returns all metadata for a set of mediafile ids.
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `ids` - list of mediafile ids
</span><span class="kw">pub async fn </span>get_many(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
ids: <span class="kw-2">&</span>[i64],
) -> <span class="prelude-ty">Result</span><Vec<<span class="self">Self</span>>, DatabaseError> {
<span class="kw">let </span>placeholders = intersperse(repeat(<span class="string">"?"</span>).take(ids.len()), <span class="string">","</span>).collect::<String>();
<span class="kw">let </span>query = <span class="macro">format!</span>(<span class="string">"SELECT * FROM mediafile WHERE id IN ({placeholders})"</span>);
<span class="prelude-val">Ok</span>(sqlx::query_as::<<span class="kw">_</span>, MediaFile>(<span class="kw-2">&</span>query)
.bind_all(ids)
.fetch_all(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>)
}
<span class="doccomment">/// Method checks whether a mediafile entry with the filepath supplied exists or not, returning
/// a bool.
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `file` - string slice containing our filepath
</span><span class="kw">pub async fn </span>exists_by_file(conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>, file: <span class="kw-2">&</span>str) -> bool {
<span class="macro">sqlx::query!</span>(<span class="string">"SELECT id FROM mediafile WHERE target_file = ?"</span>, file)
.fetch_one(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await
</span>.is_ok()
}
<span class="kw">pub async fn </span>get_by_file(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
file: <span class="kw-2">&</span>str,
) -> <span class="prelude-ty">Result</span><<span class="self">Self</span>, DatabaseError> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query_as!</span>(
MediaFile,
<span class="string">r#"SELECT * FROM mediafile WHERE target_file = ?"#</span>,
file
)
.fetch_one(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>)
}
<span class="doccomment">/// Function will return the largest duration for a media.
</span><span class="kw">pub async fn </span>get_largest_duration(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
media_id: i64,
) -> <span class="prelude-ty">Result</span><i64, DatabaseError> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
<span class="string">r#"SELECT MAX(COALESCE(mediafile.duration, 0)) as "duration!: i64" FROM mediafile
WHERE mediafile.media_id = ?
GROUP BY mediafile.media_id
LIMIT 1"#</span>,
media_id
)
.fetch_one(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?
</span>.duration)
}
<span class="doccomment">/// Method deletes mediafile matching the id supplied
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `_id` - id of the mediafile entry we want to delete
</span><span class="kw">pub async fn </span>delete(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
id: i64,
) -> <span class="prelude-ty">Result</span><usize, DatabaseError> {
<span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(<span class="string">"DELETE FROM mediafile WHERE id = ?"</span>, id)
.execute(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?
</span>.rows_affected() <span class="kw">as </span>usize)
}
<span class="doccomment">/// Function deletes all mediafiles with `library_id` of lib_id. This function is used when
/// deleting a library with a sqlite backend.
</span><span class="kw">pub async fn </span>delete_by_lib_id(
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
lib_id: i64,
) -> <span class="prelude-ty">Result</span><usize, DatabaseError> {
<span class="prelude-val">Ok</span>(
<span class="macro">sqlx::query!</span>(<span class="string">"DELETE FROM mediafile WHERE library_id = ?"</span>, lib_id)
.execute(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?
</span>.rows_affected() <span class="kw">as </span>usize,
)
}
}
<span class="doccomment">/// Same as [`MediaFile`](MediaFile) except its missing the id field.
</span><span class="attribute">#[derive(Clone, Serialize, Debug, Default)]
</span><span class="kw">pub struct </span>InsertableMediaFile {
<span class="kw">pub </span>media_id: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>library_id: i64,
<span class="kw">pub </span>target_file: String,
<span class="kw">pub </span>raw_name: String,
<span class="kw">pub </span>raw_year: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>quality: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>codec: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>container: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>audio: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>original_resolution: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>duration: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>channels: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>profile: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>audio_language: <span class="prelude-ty">Option</span><String>,
<span class="comment">/***
* Options specific to tv show scanner hence Option<T>
***/
</span><span class="kw">pub </span>episode: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>season: <span class="prelude-ty">Option</span><i64>,
<span class="comment">/*** ***/
</span><span class="kw">pub </span>corrupt: <span class="prelude-ty">Option</span><bool>,
}
<span class="kw">impl </span>InsertableMediaFile {
<span class="doccomment">/// Method checks if a mediafile with the the target file exists in the database.
</span><span class="kw">pub async fn </span>exists(<span class="kw-2">&</span><span class="self">self</span>, conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>) -> <span class="prelude-ty">Result</span><bool, DatabaseError> {
<span class="kw">let </span>result: <span class="prelude-ty">Option</span><i64> =
sqlx::query_scalar(<span class="string">"SELECT 1 FROM mediafile WHERE target_file = ?"</span>)
.bind(<span class="kw-2">&</span><span class="self">self</span>.target_file)
.fetch_optional(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?</span>;
<span class="prelude-val">Ok</span>(result == <span class="prelude-val">Some</span>(<span class="number">1</span>))
}
<span class="doccomment">/// Method inserts a new mediafile into the database.
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
</span><span class="kw">pub async fn </span>insert(<span class="kw-2">&</span><span class="self">self</span>, conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>) -> <span class="prelude-ty">Result</span><i64, DatabaseError> {
<span class="kw">let </span>id = <span class="macro">sqlx::query!</span>(
<span class="string">r#"
INSERT INTO mediafile (media_id, library_id, target_file, raw_name, raw_year, quality,
codec, container, audio, original_resolution, duration, episode, season, corrupt, channels, profile, audio_language)
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17)
"#</span>,
<span class="self">self</span>.media_id,
<span class="self">self</span>.library_id,
<span class="self">self</span>.target_file,
<span class="self">self</span>.raw_name,
<span class="self">self</span>.raw_year,
<span class="self">self</span>.quality,
<span class="self">self</span>.codec,
<span class="self">self</span>.container,
<span class="self">self</span>.audio,
<span class="self">self</span>.original_resolution,
<span class="self">self</span>.duration,
<span class="self">self</span>.episode,
<span class="self">self</span>.season,
<span class="self">self</span>.corrupt,
<span class="self">self</span>.channels,
<span class="self">self</span>.profile,
<span class="self">self</span>.audio_language
)
.execute(<span class="kw-2">&mut *</span>conn)
.<span class="kw">await</span><span class="question-mark">?
</span>.last_insert_rowid();
<span class="prelude-val">Ok</span>(id)
}
}
<span class="doccomment">/// Same as [`MediaFile`](MediaFile) except its missing the id and library_id fields. Everything is
/// optional too.
</span><span class="attribute">#[derive(Clone, Default, Deserialize, PartialEq, Debug)]
</span><span class="kw">pub struct </span>UpdateMediaFile {
<span class="kw">pub </span>media_id: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>target_file: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>raw_name: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>raw_year: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>quality: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>codec: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>container: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>audio: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>original_resolution: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>duration: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>channels: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>profile: <span class="prelude-ty">Option</span><String>,
<span class="kw">pub </span>audio_language: <span class="prelude-ty">Option</span><String>,
<span class="comment">/***
* Options specific to tv show scanner hence Option<T>
***/
</span><span class="kw">pub </span>episode: <span class="prelude-ty">Option</span><i64>,
<span class="kw">pub </span>season: <span class="prelude-ty">Option</span><i64>,
<span class="comment">/*** ***/
</span><span class="kw">pub </span>corrupt: <span class="prelude-ty">Option</span><bool>,
}
<span class="kw">impl </span>UpdateMediaFile {
<span class="doccomment">/// Method updates the columns of a mediafile entry with what is supplied. The row is selected
/// based on its id.
///
/// # Arguments
/// * `conn` - mutable reference to a sqlx transaction.
/// * `_id` - id of the mediafile row we are targetting
</span><span class="kw">pub async fn </span>update(
<span class="kw-2">&</span><span class="self">self</span>,
conn: <span class="kw-2">&mut </span><span class="kw">crate</span>::Transaction<<span class="lifetime">'_</span>>,
id: i64,
) -> <span class="prelude-ty">Result</span><usize, DatabaseError> {
<span class="macro">crate::opt_update!</span>(conn,
<span class="string">"UPDATE mediafile SET media_id = ? WHERE id = ?" </span>=> (<span class="self">self</span>.media_id, id),
<span class="string">"UPDATE mediafile SET target_file = ? WHERE id = ?" </span>=> (<span class="self">self</span>.target_file, id),
<span class="string">"UPDATE mediafile SET raw_name = ? WHERE id = ?" </span>=> (<span class="self">self</span>.raw_name, id),
<span class="string">"UPDATE mediafile SET raw_year = ? WHERE id = ?" </span>=> (<span class="self">self</span>.raw_year, id),
<span class="string">"UPDATE mediafile SET quality = ? WHERE id = ?" </span>=> (<span class="self">self</span>.quality, id),
<span class="string">"UPDATE mediafile SET codec = ? WHERE id = ?" </span>=> (<span class="self">self</span>.codec, id),
<span class="string">"UPDATE mediafile SET container = ? WHERE id = ?" </span>=> (<span class="self">self</span>.container, id),
<span class="string">"UPDATE mediafile SET audio = ? WHERE id = ?" </span>=> (<span class="self">self</span>.audio, id),
<span class="string">"UPDATE mediafile SET original_resolution = ? WHERE id = ?" </span>=> (<span class="self">self</span>.original_resolution, id),
<span class="string">"UPDATE mediafile SET duration = ? WHERE id = ?" </span>=> (<span class="self">self</span>.duration, id),
<span class="string">"UPDATE mediafile SET episode = ? WHERE id = ?" </span>=> (<span class="self">self</span>.episode, id),
<span class="string">"UPDATE mediafile SET season = ? WHERE id = ?" </span>=> (<span class="self">self</span>.season, id),
<span class="string">"UPDATE mediafile SET corrupt = ? WHERE id = ?" </span>=> (<span class="self">self</span>.corrupt, id),
<span class="string">"UPDATE mediafile SET channels = ? WHERE id = ?" </span>=> (<span class="self">self</span>.channels, id),
<span class="string">"UPDATE mediafile SET profile = ? WHERE id = ?" </span>=> (<span class="self">self</span>.profile, id),
<span class="string">"UPDATE mediafile SET audio_language = ? WHERE id = ?" </span>=> (<span class="self">self</span>.audio_language, id)
);
<span class="prelude-val">Ok</span>(<span class="number">1</span>)
}
}
<span class="kw">impl </span>Into<Media> <span class="kw">for </span>MediaFile {
<span class="kw">fn </span>into(<span class="self">self</span>) -> Media {
Media {
id: <span class="self">self</span>.id,
library_id: <span class="self">self</span>.library_id,
name: <span class="self">self</span>.raw_name,
..Default::default()
}
}
}
</code></pre></div>
</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.65.0 (897e37553 2022-11-02)" ></div></body></html>