<!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/user.rs`."><meta name="keywords" content="rust, rustlang, rust-lang"><title>user.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 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">&#9776;</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"><button type="button" id="help-button" title="help">?</button><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>
<span id="397">397</span>
<span id="398">398</span>
<span id="399">399</span>
<span id="400">400</span>
<span id="401">401</span>
<span id="402">402</span>
<span id="403">403</span>
<span id="404">404</span>
<span id="405">405</span>
<span id="406">406</span>
<span id="407">407</span>
<span id="408">408</span>
<span id="409">409</span>
<span id="410">410</span>
<span id="411">411</span>
<span id="412">412</span>
<span id="413">413</span>
<span id="414">414</span>
<span id="415">415</span>
<span id="416">416</span>
<span id="417">417</span>
<span id="418">418</span>
<span id="419">419</span>
<span id="420">420</span>
<span id="421">421</span>
<span id="422">422</span>
<span id="423">423</span>
<span id="424">424</span>
<span id="425">425</span>
<span id="426">426</span>
<span id="427">427</span>
<span id="428">428</span>
<span id="429">429</span>
<span id="430">430</span>
<span id="431">431</span>
<span id="432">432</span>
<span id="433">433</span>
<span id="434">434</span>
<span id="435">435</span>
<span id="436">436</span>
<span id="437">437</span>
<span id="438">438</span>
<span id="439">439</span>
<span id="440">440</span>
<span id="441">441</span>
<span id="442">442</span>
<span id="443">443</span>
<span id="444">444</span>
<span id="445">445</span>
<span id="446">446</span>
<span id="447">447</span>
<span id="448">448</span>
<span id="449">449</span>
<span id="450">450</span>
<span id="451">451</span>
<span id="452">452</span>
<span id="453">453</span>
<span id="454">454</span>
<span id="455">455</span>
<span id="456">456</span>
<span id="457">457</span>
<span id="458">458</span>
<span id="459">459</span>
<span id="460">460</span>
<span id="461">461</span>
<span id="462">462</span>
<span id="463">463</span>
<span id="464">464</span>
<span id="465">465</span>
<span id="466">466</span>
<span id="467">467</span>
<span id="468">468</span>
<span id="469">469</span>
<span id="470">470</span>
<span id="471">471</span>
<span id="472">472</span>
<span id="473">473</span>
<span id="474">474</span>
<span id="475">475</span>
<span id="476">476</span>
<span id="477">477</span>
<span id="478">478</span>
<span id="479">479</span>
<span id="480">480</span>
<span id="481">481</span>
<span id="482">482</span>
<span id="483">483</span>
<span id="484">484</span>
<span id="485">485</span>
<span id="486">486</span>
<span id="487">487</span>
<span id="488">488</span>
<span id="489">489</span>
<span id="490">490</span>
<span id="491">491</span>
<span id="492">492</span>
<span id="493">493</span>
<span id="494">494</span>
<span id="495">495</span>
<span id="496">496</span>
<span id="497">497</span>
<span id="498">498</span>
<span id="499">499</span>
<span id="500">500</span>
<span id="501">501</span>
<span id="502">502</span>
<span id="503">503</span>
<span id="504">504</span>
<span id="505">505</span>
<span id="506">506</span>
<span id="507">507</span>
<span id="508">508</span>
<span id="509">509</span>
<span id="510">510</span>
<span id="511">511</span>
<span id="512">512</span>
<span id="513">513</span>
<span id="514">514</span>
<span id="515">515</span>
<span id="516">516</span>
<span id="517">517</span>
<span id="518">518</span>
<span id="519">519</span>
<span id="520">520</span>
<span id="521">521</span>
<span id="522">522</span>
<span id="523">523</span>
<span id="524">524</span>
<span id="525">525</span>
<span id="526">526</span>
<span id="527">527</span>
<span id="528">528</span>
<span id="529">529</span>
<span id="530">530</span>
<span id="531">531</span>
<span id="532">532</span>
<span id="533">533</span>
<span id="534">534</span>
<span id="535">535</span>
<span id="536">536</span>
<span id="537">537</span>
<span id="538">538</span>
<span id="539">539</span>
<span id="540">540</span>
<span id="541">541</span>
<span id="542">542</span>
<span id="543">543</span>
<span id="544">544</span>
<span id="545">545</span>
<span id="546">546</span>
<span id="547">547</span>
<span id="548">548</span>
<span id="549">549</span>
<span id="550">550</span>
<span id="551">551</span>
<span id="552">552</span>
<span id="553">553</span>
<span id="554">554</span>
<span id="555">555</span>
<span id="556">556</span>
<span id="557">557</span>
<span id="558">558</span>
<span id="559">559</span>
<span id="560">560</span>
<span id="561">561</span>
<span id="562">562</span>
<span id="563">563</span>
<span id="564">564</span>
<span id="565">565</span>
<span id="566">566</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">std::collections::HashMap</span>;
<span class="kw">use</span> <span class="ident">std::num::NonZeroU32</span>;
<span class="kw">use</span> <span class="ident">std::time::SystemTime</span>;

<span class="kw">use</span> <span class="ident">auth::user_cookie_decode</span>;
<span class="kw">use</span> <span class="ident">auth::user_cookie_generate</span>;
<span class="kw">use</span> <span class="ident">auth::AuthError</span>;
<span class="kw">use</span> <span class="ident">serde::Deserialize</span>;
<span class="kw">use</span> <span class="ident">serde::Serialize</span>;

<span class="kw">use</span> <span class="ident">ring::digest</span>;
<span class="kw">use</span> <span class="ident">ring::pbkdf2</span>;
<span class="kw">use</span> <span class="ident">sqlx::Decode</span>;
<span class="kw">use</span> <span class="ident">sqlx::Encode</span>;

<span class="kw">static</span> <span class="ident">PBKDF2_ALG</span>: <span class="ident">pbkdf2::Algorithm</span> <span class="op">=</span> <span class="ident">pbkdf2::PBKDF2_HMAC_SHA256</span>;
<span class="kw">const</span> <span class="ident">CREDENTIAL_LEN</span>: <span class="ident">usize</span> <span class="op">=</span> <span class="ident">digest::SHA256_OUTPUT_LEN</span>;
<span class="kw">const</span> <span class="ident">HASH_ROUNDS</span>: <span class="ident">NonZeroU32</span> <span class="op">=</span> <span class="kw">unsafe</span> { <span class="ident">NonZeroU32::new_unchecked</span>(<span class="number">1_000</span>) };

<span class="kw">pub</span> <span class="kw">type</span> <span class="ident">Credential</span> <span class="op">=</span> [<span class="ident">u8</span>; <span class="ident">CREDENTIAL_LEN</span>];

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Debug</span>, <span class="ident">Clone</span>, <span class="ident">Serialize</span>, <span class="ident">Deserialize</span>, <span class="ident">sqlx::Type</span>)]</span>
<span class="kw">pub</span> <span class="kw">enum</span> <span class="ident">Theme</span> {
    <span class="ident">Light</span>,
    <span class="ident">Dark</span>,
    <span class="ident">Black</span>,
}

<span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">default_theme</span>() -&gt; <span class="ident">Theme</span> {
    <span class="ident">Theme::Dark</span>
}

<span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">default_true</span>() -&gt; <span class="ident">bool</span> {
    <span class="bool-val">true</span>
}

<span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">default_false</span>() -&gt; <span class="ident">bool</span> {
    <span class="bool-val">false</span>
}

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Debug</span>, <span class="ident">Clone</span>, <span class="ident">Serialize</span>, <span class="ident">Deserialize</span>)]</span>
<span class="attribute">#[<span class="ident">serde</span>(<span class="ident">rename_all</span> <span class="op">=</span> <span class="string">&quot;lowercase&quot;</span>)]</span>
<span class="kw">pub</span> <span class="kw">enum</span> <span class="ident">DefaultVideoQuality</span> {
    <span class="doccomment">/// Represents DirectPlay quality</span>
    <span class="ident">DirectPlay</span>,
    <span class="doccomment">/// Represents a default video quality made up of resolution and bitrate.</span>
    <span class="ident">Resolution</span>(<span class="ident">u64</span>, <span class="ident">u64</span>),
}

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Debug</span>, <span class="ident">Clone</span>, <span class="ident">Serialize</span>, <span class="ident">Deserialize</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">UserSettings</span> {
    <span class="doccomment">/// Theme of the app</span>
    <span class="attribute">#[<span class="ident">serde</span>(<span class="ident">default</span> <span class="op">=</span> <span class="string">&quot;default_theme&quot;</span>)]</span>
    <span class="ident">theme</span>: <span class="ident">Theme</span>,
    <span class="doccomment">/// Defines whether the sidebar should be collapsed or not</span>
    <span class="attribute">#[<span class="ident">serde</span>(<span class="ident">default</span> <span class="op">=</span> <span class="string">&quot;default_false&quot;</span>)]</span>
    <span class="ident">is_sidebar_compact</span>: <span class="ident">bool</span>,
    <span class="attribute">#[<span class="ident">serde</span>(<span class="ident">default</span> <span class="op">=</span> <span class="string">&quot;default_true&quot;</span>)]</span>
    <span class="ident">show_card_names</span>: <span class="ident">bool</span>,
    <span class="doccomment">/// If this contains a string then the filebrowser/explorer will default to this path instead of `/`.</span>
    <span class="ident">filebrowser_default_path</span>: <span class="prelude-ty">Option</span><span class="op">&lt;</span><span class="ident">String</span><span class="op">&gt;</span>,
    <span class="attribute">#[<span class="ident">serde</span>(<span class="ident">default</span> <span class="op">=</span> <span class="string">&quot;default_true&quot;</span>)]</span>
    <span class="ident">filebrowser_list_view</span>: <span class="ident">bool</span>,
    <span class="doccomment">/// If a file has subtitles then the subtitles with this language will be selected.</span>
    <span class="ident">default_subtitle_language</span>: <span class="prelude-ty">Option</span><span class="op">&lt;</span><span class="ident">String</span><span class="op">&gt;</span>,
    <span class="doccomment">/// If a file has audio then the audio track with this language will be selected, otherwise the first one.</span>
    <span class="ident">default_audio_language</span>: <span class="prelude-ty">Option</span><span class="op">&lt;</span><span class="ident">String</span><span class="op">&gt;</span>,
    <span class="doccomment">/// Represents the default video quality for user.</span>
    <span class="kw">pub</span> <span class="ident">default_video_quality</span>: <span class="ident">DefaultVideoQuality</span>,
    <span class="doccomment">/// Any other external args.</span>
    <span class="attribute">#[<span class="ident">serde</span>(<span class="ident">default</span>)]</span>
    <span class="ident">external_args</span>: <span class="ident">HashMap</span><span class="op">&lt;</span><span class="ident">String</span>, <span class="ident">String</span><span class="op">&gt;</span>,
    <span class="doccomment">/// Whether hovercards are hidden or not</span>
    <span class="attribute">#[<span class="ident">serde</span>(<span class="ident">default</span>)]</span>
    <span class="ident">show_hovercards</span>: <span class="ident">bool</span>,
    <span class="doccomment">/// Whether to auto play next video</span>
    <span class="ident">enable_autoplay</span>: <span class="ident">bool</span>,
}

<span class="kw">impl</span><span class="op">&lt;</span><span class="ident">DB</span>: <span class="ident">sqlx::Database</span><span class="op">&gt;</span> <span class="ident">sqlx::Type</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span> <span class="kw">for</span> <span class="ident">UserSettings</span>
<span class="kw">where</span>
    <span class="ident">Vec</span><span class="op">&lt;</span><span class="ident">u8</span><span class="op">&gt;</span>: <span class="ident">sqlx::Type</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span>,
{
    <span class="kw">fn</span> <span class="ident">type_info</span>() -&gt; <span class="ident">DB::TypeInfo</span> {
        <span class="op">&lt;</span><span class="ident">Vec</span><span class="op">&lt;</span><span class="ident">u8</span><span class="op">&gt;</span> <span class="kw">as</span> <span class="ident">sqlx::Type</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::type_info</span>()
    }
}

<span class="kw">impl</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span>, <span class="ident">DB</span>: <span class="ident">sqlx::Database</span><span class="op">&gt;</span> <span class="ident">Decode</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span>, <span class="ident">DB</span><span class="op">&gt;</span> <span class="kw">for</span> <span class="ident">UserSettings</span>
<span class="kw">where</span>
    <span class="kw-2">&amp;</span><span class="lifetime">&#39;r</span> [<span class="ident">u8</span>]: <span class="ident">Decode</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span>, <span class="ident">DB</span><span class="op">&gt;</span>,
{
    <span class="kw">fn</span> <span class="ident">decode</span>(
        <span class="ident">value</span>: <span class="op">&lt;</span><span class="ident">DB</span> <span class="kw">as</span> <span class="ident">sqlx::database::HasValueRef</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::ValueRef</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="self">Self</span>, <span class="ident">sqlx::error::BoxDynError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="ident">value</span> <span class="op">=</span> <span class="op">&lt;</span><span class="kw-2">&amp;</span>[<span class="ident">u8</span>] <span class="kw">as</span> <span class="ident">Decode</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::decode</span>(<span class="ident">value</span>)<span class="question-mark">?</span>;
        <span class="prelude-val">Ok</span>(<span class="ident">serde_json::from_slice</span>(<span class="ident">value</span>).<span class="ident">unwrap_or_default</span>())
    }
}

<span class="kw">impl</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span>, <span class="ident">DB</span>: <span class="ident">sqlx::Database</span><span class="op">&gt;</span> <span class="ident">Encode</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span>, <span class="ident">DB</span><span class="op">&gt;</span> <span class="kw">for</span> <span class="ident">UserSettings</span>
<span class="kw">where</span>
    <span class="ident">Vec</span><span class="op">&lt;</span><span class="ident">u8</span><span class="op">&gt;</span>: <span class="ident">Encode</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span>, <span class="ident">DB</span><span class="op">&gt;</span>,
{
    <span class="kw">fn</span> <span class="ident">encode_by_ref</span>(
        <span class="kw-2">&amp;</span><span class="self">self</span>,
        <span class="ident">buf</span>: <span class="kw-2">&amp;mut</span> <span class="op">&lt;</span><span class="ident">DB</span> <span class="kw">as</span> <span class="ident">sqlx::database::HasArguments</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::ArgumentBuffer</span>,
    ) -&gt; <span class="ident">sqlx::encode::IsNull</span> {
        <span class="kw">let</span> <span class="ident">val</span> <span class="op">=</span> <span class="ident">serde_json::to_vec</span>(<span class="self">self</span>).<span class="ident">unwrap_or_default</span>();
        <span class="op">&lt;</span><span class="ident">Vec</span><span class="op">&lt;</span><span class="ident">u8</span><span class="op">&gt;</span> <span class="kw">as</span> <span class="ident">Encode</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::encode</span>(<span class="ident">val</span>, <span class="ident">buf</span>)
    }
}

<span class="kw">impl</span> <span class="ident">Default</span> <span class="kw">for</span> <span class="ident">UserSettings</span> {
    <span class="kw">fn</span> <span class="ident">default</span>() -&gt; <span class="self">Self</span> {
        <span class="self">Self</span> {
            <span class="ident">theme</span>: <span class="ident">Theme::Dark</span>,
            <span class="ident">is_sidebar_compact</span>: <span class="bool-val">false</span>,
            <span class="ident">show_card_names</span>: <span class="bool-val">true</span>,
            <span class="ident">filebrowser_default_path</span>: <span class="prelude-val">None</span>,
            <span class="ident">filebrowser_list_view</span>: <span class="bool-val">true</span>,
            <span class="ident">default_subtitle_language</span>: <span class="prelude-val">Some</span>(<span class="string">&quot;english&quot;</span>.<span class="ident">into</span>()),
            <span class="ident">default_audio_language</span>: <span class="prelude-val">Some</span>(<span class="string">&quot;english&quot;</span>.<span class="ident">into</span>()),
            <span class="ident">external_args</span>: <span class="ident">HashMap::new</span>(),
            <span class="ident">show_hovercards</span>: <span class="bool-val">true</span>,
            <span class="ident">default_video_quality</span>: <span class="ident">DefaultVideoQuality::DirectPlay</span>,
            <span class="ident">enable_autoplay</span>: <span class="bool-val">true</span>,
        }
    }
}

<span class="comment">// NOTE: Figure out the bug with this not being a valid postgres type</span>
<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Serialize</span>, <span class="ident">Deserialize</span>, <span class="ident">Debug</span>, <span class="ident">Eq</span>, <span class="ident">PartialEq</span>)]</span>
<span class="kw">pub</span> <span class="kw">enum</span> <span class="ident">Role</span> {
    <span class="ident">Owner</span>,
    <span class="ident">User</span>,
}

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Copy</span>, <span class="ident">Clone</span>, <span class="ident">Debug</span>, <span class="ident">Deserialize</span>, <span class="ident">Eq</span>, <span class="ident">PartialEq</span>, <span class="ident">Serialize</span>, <span class="ident">sqlx::Type</span>)]</span>
<span class="attribute">#[<span class="ident">sqlx</span>(<span class="ident">transparent</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">UserID</span>(<span class="kw">pub</span>(<span class="kw">crate</span>) <span class="ident">i64</span>);

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Clone</span>, <span class="ident">Debug</span>, <span class="ident">Default</span>, <span class="ident">Deserialize</span>, <span class="ident">Serialize</span>, <span class="ident">PartialEq</span>)]</span>
<span class="attribute">#[<span class="ident">serde</span>(<span class="ident">transparent</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">Roles</span>(<span class="kw">pub</span> <span class="ident">Vec</span><span class="op">&lt;</span><span class="ident">String</span><span class="op">&gt;</span>);

<span class="kw">impl</span><span class="op">&lt;</span><span class="ident">DB</span>: <span class="ident">sqlx::Database</span><span class="op">&gt;</span> <span class="ident">sqlx::Type</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span> <span class="kw">for</span> <span class="ident">Roles</span>
<span class="kw">where</span>
    <span class="ident">String</span>: <span class="ident">sqlx::Type</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span>,
{
    <span class="kw">fn</span> <span class="ident">type_info</span>() -&gt; <span class="ident">DB::TypeInfo</span> {
        <span class="op">&lt;</span><span class="ident">String</span> <span class="kw">as</span> <span class="ident">sqlx::Type</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::type_info</span>()
    }
}

<span class="kw">impl</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span>, <span class="ident">DB</span>: <span class="ident">sqlx::Database</span><span class="op">&gt;</span> <span class="ident">Decode</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span>, <span class="ident">DB</span><span class="op">&gt;</span> <span class="kw">for</span> <span class="ident">Roles</span>
<span class="kw">where</span>
    <span class="kw-2">&amp;</span><span class="lifetime">&#39;r</span> <span class="ident">str</span>: <span class="ident">Decode</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span>, <span class="ident">DB</span><span class="op">&gt;</span>,
{
    <span class="kw">fn</span> <span class="ident">decode</span>(
        <span class="ident">value</span>: <span class="op">&lt;</span><span class="ident">DB</span> <span class="kw">as</span> <span class="ident">sqlx::database::HasValueRef</span><span class="op">&lt;</span><span class="lifetime">&#39;r</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::ValueRef</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="self">Self</span>, <span class="ident">sqlx::error::BoxDynError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="ident">value</span> <span class="op">=</span> <span class="op">&lt;</span><span class="kw-2">&amp;</span><span class="ident">str</span> <span class="kw">as</span> <span class="ident">Decode</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::decode</span>(<span class="ident">value</span>)<span class="question-mark">?</span>;
        <span class="prelude-val">Ok</span>(<span class="ident">serde_json::from_str</span>(<span class="ident">value</span>).<span class="ident">unwrap_or_default</span>())
    }
}

<span class="kw">impl</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span>, <span class="ident">DB</span>: <span class="ident">sqlx::Database</span><span class="op">&gt;</span> <span class="ident">Encode</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span>, <span class="ident">DB</span><span class="op">&gt;</span> <span class="kw">for</span> <span class="ident">Roles</span>
<span class="kw">where</span>
    <span class="ident">String</span>: <span class="ident">Encode</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span>, <span class="ident">DB</span><span class="op">&gt;</span>,
{
    <span class="kw">fn</span> <span class="ident">encode_by_ref</span>(
        <span class="kw-2">&amp;</span><span class="self">self</span>,
        <span class="ident">buf</span>: <span class="kw-2">&amp;mut</span> <span class="op">&lt;</span><span class="ident">DB</span> <span class="kw">as</span> <span class="ident">sqlx::database::HasArguments</span><span class="op">&lt;</span><span class="lifetime">&#39;q</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::ArgumentBuffer</span>,
    ) -&gt; <span class="ident">sqlx::encode::IsNull</span> {
        <span class="kw">let</span> <span class="ident">val</span> <span class="op">=</span> <span class="ident">serde_json::to_string</span>(<span class="self">self</span>).<span class="ident">unwrap_or_default</span>();
        <span class="op">&lt;</span><span class="ident">String</span> <span class="kw">as</span> <span class="ident">Encode</span><span class="op">&lt;</span><span class="ident">DB</span><span class="op">&gt;</span><span class="op">&gt;</span><span class="ident">::encode</span>(<span class="ident">val</span>, <span class="ident">buf</span>)
    }
}

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Debug</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">User</span> {
    <span class="kw">pub</span> <span class="ident">id</span>: <span class="ident">UserID</span>,
    <span class="kw">pub</span> <span class="ident">username</span>: <span class="ident">String</span>,
    <span class="kw">pub</span> <span class="ident">roles</span>: <span class="ident">Roles</span>,
    <span class="kw">pub</span> <span class="ident">prefs</span>: <span class="ident">UserSettings</span>,
    <span class="kw">pub</span> <span class="ident">picture</span>: <span class="prelude-ty">Option</span><span class="op">&lt;</span><span class="ident">i64</span><span class="op">&gt;</span>,
}

<span class="kw">impl</span> <span class="ident">User</span> {
    <span class="doccomment">/// Method gets all entries from the table users.</span>
    <span class="doccomment">///</span>
    <span class="doccomment">/// # Arguments</span>
    <span class="doccomment">///</span>
    <span class="doccomment">/// * `&amp;` - postgres &amp;ection</span>
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">get_all</span>(<span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">Vec</span><span class="op">&lt;</span><span class="self">Self</span><span class="op">&gt;</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(
            <span class="macro">sqlx::query!</span>(
                <span class="string">r#&quot;SELECT id as &quot;id: UserID&quot;, username, roles as &quot;roles: Roles&quot;, prefs as &quot;prefs: UserSettings&quot;, picture FROM users&quot;#</span>
            )
            .<span class="ident">fetch_all</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
            .<span class="kw">await</span><span class="question-mark">?</span>
            .<span class="ident">into_iter</span>()
            .<span class="ident">map</span>(<span class="op">|</span><span class="ident">user</span><span class="op">|</span> <span class="self">Self</span> {
                <span class="ident">id</span>: <span class="ident">user</span>.<span class="ident">id</span>,
                <span class="ident">username</span>: <span class="ident">user</span>.<span class="ident">username</span>,
                <span class="ident">roles</span>: <span class="ident">user</span>.<span class="ident">roles</span>,
                <span class="ident">prefs</span>: <span class="ident">user</span>.<span class="ident">prefs</span>,
                <span class="ident">picture</span>: <span class="ident">user</span>.<span class="ident">picture</span>,
            })
            .<span class="ident">collect</span>(),
        )
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">get_by_id</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">uid</span>: <span class="ident">UserID</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="self">Self</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
            <span class="string">r#&quot;SELECT id as &quot;id: UserID&quot;, username, roles as &quot;roles: Roles&quot;, prefs as &quot;prefs: UserSettings&quot;, picture from users
                WHERE id = ?&quot;#</span>,
            <span class="ident">uid</span>
        )
        .<span class="ident">fetch_one</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span>
        .<span class="ident">map</span>(<span class="op">|</span><span class="ident">u</span><span class="op">|</span> <span class="self">Self</span> {
            <span class="ident">id</span>: <span class="ident">u</span>.<span class="ident">id</span>,
            <span class="ident">username</span>: <span class="ident">u</span>.<span class="ident">username</span>,
            <span class="ident">roles</span>: <span class="ident">u</span>.<span class="ident">roles</span>,
            <span class="ident">prefs</span>: <span class="ident">u</span>.<span class="ident">prefs</span>,
            <span class="ident">picture</span>: <span class="ident">u</span>.<span class="ident">picture</span>,
        })<span class="question-mark">?</span>)
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">get</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">username</span>: <span class="kw-2">&amp;</span><span class="ident">str</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="self">Self</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
            <span class="string">r#&quot;SELECT id as &quot;id: UserID&quot;, username, roles as &quot;roles: Roles&quot;, prefs as &quot;prefs: UserSettings&quot;, picture from users
                WHERE username = ?&quot;#</span>,
            <span class="ident">username</span>
        )
        .<span class="ident">fetch_one</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span>
        .<span class="ident">map</span>(<span class="op">|</span><span class="ident">u</span><span class="op">|</span> <span class="self">Self</span> {
            <span class="ident">id</span>: <span class="ident">u</span>.<span class="ident">id</span>,
            <span class="ident">username</span>: <span class="ident">u</span>.<span class="ident">username</span>,
            <span class="ident">roles</span>: <span class="ident">u</span>.<span class="ident">roles</span>,
            <span class="ident">prefs</span>: <span class="ident">u</span>.<span class="ident">prefs</span>,
            <span class="ident">picture</span>: <span class="ident">u</span>.<span class="ident">picture</span>,
        })<span class="question-mark">?</span>)
    }

    <span class="doccomment">/// Method gets one entry from the table users based on the username supplied and password.</span>
    <span class="doccomment">///</span>
    <span class="doccomment">/// # Arguments</span>
    <span class="doccomment">/// * `&amp;` - postgres &amp;ection</span>
    <span class="doccomment">/// * `uname` - username we wish to target and delete</span>
    <span class="doccomment">/// * `pw_hash` - hash of the password for the user we are trying to access</span>
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">authenticate</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">uname</span>: <span class="ident">String</span>,
        <span class="ident">pw</span>: <span class="ident">String</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="self">Self</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="ident">hash</span> <span class="op">=</span> <span class="ident">hash</span>(<span class="ident">uname</span>.<span class="ident">clone</span>(), <span class="ident">pw</span>);
        <span class="kw">let</span> <span class="ident">user</span> <span class="op">=</span> <span class="macro">sqlx::query!</span>(
            <span class="string">r#&quot;SELECT id as &quot;id: UserID&quot;, username, roles as &quot;roles: Roles&quot;, prefs as &quot;prefs: UserSettings&quot;, picture FROM users WHERE username = ? AND password = ?&quot;#</span>,
            <span class="ident">uname</span>,
            <span class="ident">hash</span>,
        )
        .<span class="ident">fetch_one</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>;

        <span class="prelude-val">Ok</span>(<span class="self">Self</span> {
            <span class="ident">id</span>: <span class="ident">user</span>.<span class="ident">id</span>,
            <span class="ident">username</span>: <span class="ident">user</span>.<span class="ident">username</span>,
            <span class="ident">roles</span>: <span class="ident">user</span>.<span class="ident">roles</span>,
            <span class="ident">prefs</span>: <span class="ident">user</span>.<span class="ident">prefs</span>,
            <span class="ident">picture</span>: <span class="ident">user</span>.<span class="ident">picture</span>,
        })
    }

    <span class="doccomment">/// Method gets users password from the table users based on the user</span>
    <span class="doccomment">///</span>
    <span class="doccomment">/// # Arguments</span>
    <span class="doccomment">/// * `conn` - DBTransaction</span>
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">get_pass</span>(
        <span class="kw-2">&amp;</span><span class="self">self</span>,
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">String</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="ident">pass</span> <span class="op">=</span> <span class="macro">sqlx::query!</span>(<span class="string">&quot;SELECT password FROM users WHERE id = ?&quot;</span>, <span class="self">self</span>.<span class="ident">id</span>,)
            .<span class="ident">fetch_one</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
            .<span class="kw">await</span>
            .<span class="ident">map</span>(<span class="op">|</span><span class="ident">r</span><span class="op">|</span> <span class="ident">r</span>.<span class="ident">password</span>)<span class="question-mark">?</span>;

        <span class="prelude-val">Ok</span>(<span class="ident">pass</span>)
    }

    <span class="doccomment">/// Method deletes a entry from the table users and returns the number of rows deleted.</span>
    <span class="doccomment">/// NOTE: Return should always be 1</span>
    <span class="doccomment">///</span>
    <span class="doccomment">/// # Arguments</span>
    <span class="doccomment">/// * `&amp;` - postgres &amp;ection</span>
    <span class="doccomment">/// * `uname` - username we wish to target and delete</span>
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">delete</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">uid</span>: <span class="ident">UserID</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">usize</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(<span class="string">&quot;DELETE FROM users WHERE id = ?&quot;</span>, <span class="ident">uid</span>)
            .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
            .<span class="kw">await</span><span class="question-mark">?</span>
            .<span class="ident">rows_affected</span>() <span class="kw">as</span> <span class="ident">usize</span>)
    }

    <span class="doccomment">/// Method resets the password for a user to a new password.</span>
    <span class="doccomment">///</span>
    <span class="doccomment">/// # Arguments</span>
    <span class="doccomment">/// * `&amp;` - db &amp;ection</span>
    <span class="doccomment">/// * `password` - new password.</span>
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">set_password</span>(
        <span class="kw-2">&amp;</span><span class="self">self</span>,
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">password</span>: <span class="ident">String</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">usize</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="ident">hash</span> <span class="op">=</span> <span class="ident">hash</span>(<span class="self">self</span>.<span class="ident">username</span>.<span class="ident">clone</span>(), <span class="ident">password</span>);

        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
            <span class="string">&quot;UPDATE users SET password = $1 WHERE username = ?2&quot;</span>,
            <span class="ident">hash</span>,
            <span class="self">self</span>.<span class="ident">username</span>
        )
        .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>
        .<span class="ident">rows_affected</span>() <span class="kw">as</span> <span class="ident">usize</span>)
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">set_username</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">old_username</span>: <span class="ident">String</span>,
        <span class="ident">new_username</span>: <span class="ident">String</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">usize</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
            <span class="string">&quot;UPDATE users SET username = $1 WHERE users.username = ?2&quot;</span>,
            <span class="ident">new_username</span>,
            <span class="ident">old_username</span>
        )
        .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>
        .<span class="ident">rows_affected</span>() <span class="kw">as</span> <span class="ident">usize</span>)
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">set_picture</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">uid</span>: <span class="ident">UserID</span>,
        <span class="ident">asset_id</span>: <span class="ident">i64</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">usize</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
            <span class="string">&quot;UPDATE users SET picture = $1 WHERE users.id = ?2&quot;</span>,
            <span class="ident">asset_id</span>,
            <span class="ident">uid</span>
        )
        .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>
        .<span class="ident">rows_affected</span>() <span class="kw">as</span> <span class="ident">usize</span>)
    }

    <span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">has_role</span>(<span class="kw-2">&amp;</span><span class="self">self</span>, <span class="ident">role</span>: <span class="kw-2">&amp;</span><span class="ident">str</span>) -&gt; <span class="ident">bool</span> {
        <span class="self">self</span>.<span class="ident">roles</span>.<span class="number">0</span>.<span class="ident">contains</span>(<span class="kw-2">&amp;</span><span class="ident">role</span>.<span class="ident">to_string</span>())
    }

    <span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">roles</span>(<span class="kw-2">&amp;</span><span class="self">self</span>) -&gt; <span class="ident">Roles</span> {
        <span class="self">self</span>.<span class="ident">roles</span>.<span class="ident">clone</span>()
    }
}

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Deserialize</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">InsertableUser</span> {
    <span class="kw">pub</span> <span class="ident">username</span>: <span class="ident">String</span>,
    <span class="kw">pub</span> <span class="ident">password</span>: <span class="ident">String</span>,
    <span class="kw">pub</span> <span class="ident">roles</span>: <span class="ident">Roles</span>,
    <span class="kw">pub</span> <span class="ident">prefs</span>: <span class="ident">UserSettings</span>,
    <span class="kw">pub</span> <span class="ident">claimed_invite</span>: <span class="ident">String</span>,
}

<span class="kw">impl</span> <span class="ident">InsertableUser</span> {
    <span class="doccomment">/// Method consumes a InsertableUser object and inserts the values under it into postgres users</span>
    <span class="doccomment">/// table as a new user</span>
    <span class="doccomment">///</span>
    <span class="doccomment">/// # Arguments</span>
    <span class="doccomment">/// * `self` - instance of InsertableUser which gets consumed</span>
    <span class="doccomment">/// * `&amp;` - postgres &amp;ection</span>
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">insert</span>(<span class="self">self</span>, <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">User</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="self">Self</span> {
            <span class="ident">username</span>,
            <span class="ident">password</span>,
            <span class="ident">roles</span>,
            <span class="ident">prefs</span>,
            <span class="ident">claimed_invite</span>,
        } <span class="op">=</span> <span class="self">self</span>;

        <span class="kw">let</span> <span class="ident">password</span> <span class="op">=</span> <span class="ident">hash</span>(<span class="ident">username</span>.<span class="ident">clone</span>(), <span class="ident">password</span>);

        <span class="kw">let</span> <span class="ident">user</span> <span class="op">=</span> <span class="macro">sqlx::query_as!</span>(
            <span class="ident">User</span>,
            <span class="string">r#&quot;INSERT INTO users (username, password, prefs, claimed_invite, roles) VALUES ($1, $2, $3, $4, $5) returning id as &quot;id: UserID&quot;,username,roles as &quot;roles: Roles&quot;,prefs as &quot;prefs: UserSettings&quot;,picture&quot;#</span>,
            <span class="ident">username</span>,
            <span class="ident">password</span>,
            <span class="ident">prefs</span>,
            <span class="ident">claimed_invite</span>,
            <span class="ident">roles</span>
        ).<span class="ident">fetch_one</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>;
        <span class="prelude-val">Ok</span>(<span class="ident">user</span>)
    }
}

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Deserialize</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">UpdateableUser</span> {
    <span class="kw">pub</span> <span class="ident">prefs</span>: <span class="prelude-ty">Option</span><span class="op">&lt;</span><span class="ident">UserSettings</span><span class="op">&gt;</span>,
}

<span class="kw">impl</span> <span class="ident">UpdateableUser</span> {
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">update</span>(
        <span class="kw-2">&amp;</span><span class="self">self</span>,
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">user</span>: <span class="ident">UserID</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">usize</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">if</span> <span class="kw">let</span> <span class="prelude-val">Some</span>(<span class="ident">prefs</span>) <span class="op">=</span> <span class="kw-2">&amp;</span><span class="self">self</span>.<span class="ident">prefs</span> {
            <span class="kw">return</span> <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
                <span class="string">&quot;UPDATE users SET prefs = $1 WHERE users.id = ?&quot;</span>,
                <span class="ident">prefs</span>,
                <span class="ident">user</span>
            )
            .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
            .<span class="kw">await</span><span class="question-mark">?</span>
            .<span class="ident">rows_affected</span>() <span class="kw">as</span> <span class="ident">usize</span>);
        }

        <span class="prelude-val">Ok</span>(<span class="number">0</span>)
    }
}

<span class="attribute">#[<span class="ident">derive</span>(<span class="ident">Deserialize</span>, <span class="ident">Default</span>)]</span>
<span class="kw">pub</span> <span class="kw">struct</span> <span class="ident">Login</span> {
    <span class="kw">pub</span> <span class="ident">username</span>: <span class="ident">String</span>,
    <span class="kw">pub</span> <span class="ident">password</span>: <span class="ident">String</span>,
    <span class="kw">pub</span> <span class="ident">invite_token</span>: <span class="prelude-ty">Option</span><span class="op">&lt;</span><span class="ident">String</span><span class="op">&gt;</span>,
}

<span class="kw">impl</span> <span class="ident">Login</span> {
    <span class="doccomment">/// Will return whether the token is valid and hasnt been claimed yet.</span>
    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">invite_token_valid</span>(
        <span class="kw-2">&amp;</span><span class="self">self</span>,
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">bool</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="ident">tok</span> <span class="op">=</span> <span class="kw">match</span> <span class="kw-2">&amp;</span><span class="self">self</span>.<span class="ident">invite_token</span> {
            <span class="prelude-val">None</span> =&gt; <span class="kw">return</span> <span class="prelude-val">Ok</span>(<span class="bool-val">false</span>),
            <span class="prelude-val">Some</span>(<span class="ident">t</span>) =&gt; <span class="ident">t</span>,
        };

        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
            <span class="string">&quot;SELECT id FROM invites
                          WHERE id NOT IN (
                              SELECT claimed_invite FROM users
                          )
                          AND id = ?&quot;</span>,
            <span class="ident">tok</span>
        )
        .<span class="ident">fetch_optional</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>
        .<span class="ident">is_some</span>())
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">invalidate_token</span>(
        <span class="kw-2">&amp;</span><span class="self">self</span>,
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">usize</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">if</span> <span class="kw">let</span> <span class="prelude-val">Some</span>(<span class="ident">tok</span>) <span class="op">=</span> <span class="kw-2">&amp;</span><span class="self">self</span>.<span class="ident">invite_token</span> {
            <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(<span class="string">&quot;DELETE FROM invites WHERE id = ?&quot;</span>, <span class="ident">tok</span>)
                .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
                .<span class="kw">await</span><span class="question-mark">?</span>
                .<span class="ident">rows_affected</span>() <span class="kw">as</span> <span class="ident">usize</span>)
        } <span class="kw">else</span> {
            <span class="prelude-val">Ok</span>(<span class="number">0</span>)
        }
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">new_invite</span>(<span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">String</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="kw">let</span> <span class="ident">ts</span> <span class="op">=</span> <span class="ident">SystemTime::now</span>()
            .<span class="ident">duration_since</span>(<span class="ident">SystemTime::UNIX_EPOCH</span>)
            .<span class="ident">unwrap</span>()
            .<span class="ident">as_secs</span>() <span class="kw">as</span> <span class="ident">i64</span>;
        <span class="kw">let</span> <span class="ident">token</span> <span class="op">=</span> <span class="ident">uuid::Uuid::new_v4</span>().<span class="ident">to_hyphenated</span>().<span class="ident">to_string</span>();
        <span class="kw">let</span> <span class="kw">_</span> <span class="op">=</span> <span class="macro">sqlx::query!</span>(
            <span class="string">&quot;INSERT INTO invites (id, date_added) VALUES ($1, $2)&quot;</span>,
            <span class="ident">token</span>,
            <span class="ident">ts</span>
        )
        .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>;

        <span class="prelude-val">Ok</span>(<span class="ident">token</span>)
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">get_all_invites</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">Vec</span><span class="op">&lt;</span><span class="ident">String</span><span class="op">&gt;</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(<span class="string">&quot;SELECT id from invites&quot;</span>)
            .<span class="ident">fetch_all</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
            .<span class="kw">await</span><span class="question-mark">?</span>
            .<span class="ident">into_iter</span>()
            .<span class="ident">map</span>(<span class="op">|</span><span class="ident">t</span><span class="op">|</span> <span class="ident">t</span>.<span class="ident">id</span>)
            .<span class="ident">collect</span>())
    }

    <span class="kw">pub</span> <span class="kw">async</span> <span class="kw">fn</span> <span class="ident">delete_token</span>(
        <span class="ident">conn</span>: <span class="kw-2">&amp;mut</span> <span class="ident"><span class="kw">crate</span>::Transaction</span><span class="op">&lt;</span><span class="lifetime">&#39;_</span><span class="op">&gt;</span>,
        <span class="ident">token</span>: <span class="ident">String</span>,
    ) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">usize</span>, <span class="ident">DatabaseError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="macro">sqlx::query!</span>(
            <span class="string">&quot;DELETE FROM invites
                WHERE id NOT IN (
                    SELECT claimed_invite FROM users
                ) AND id = ?&quot;</span>,
            <span class="ident">token</span>
        )
        .<span class="ident">execute</span>(<span class="kw-2">&amp;mut</span> <span class="kw-2">*</span><span class="ident">conn</span>)
        .<span class="kw">await</span><span class="question-mark">?</span>
        .<span class="ident">rows_affected</span>() <span class="kw">as</span> <span class="ident">usize</span>)
    }

    <span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">create_cookie</span>(<span class="ident">id</span>: <span class="ident">UserID</span>) -&gt; <span class="ident">String</span> {
        <span class="ident">user_cookie_generate</span>(<span class="ident">id</span>.<span class="number">0</span>)
    }

    <span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">verify_cookie</span>(<span class="ident">cookie</span>: <span class="ident">String</span>) -&gt; <span class="prelude-ty">Result</span><span class="op">&lt;</span><span class="ident">UserID</span>, <span class="ident">AuthError</span><span class="op">&gt;</span> {
        <span class="prelude-val">Ok</span>(<span class="ident">UserID</span>(<span class="ident">user_cookie_decode</span>(<span class="ident">cookie</span>)<span class="question-mark">?</span>))
    }
}

<span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">hash</span>(<span class="ident">salt</span>: <span class="ident">String</span>, <span class="ident">s</span>: <span class="ident">String</span>) -&gt; <span class="ident">String</span> {
    <span class="kw">let</span> <span class="kw-2">mut</span> <span class="ident">to_store</span>: <span class="ident">Credential</span> <span class="op">=</span> [<span class="number">0u8</span>; <span class="ident">CREDENTIAL_LEN</span>];
    <span class="ident">pbkdf2::derive</span>(
        <span class="ident">PBKDF2_ALG</span>,
        <span class="ident">HASH_ROUNDS</span>,
        <span class="kw-2">&amp;</span><span class="ident">salt</span>.<span class="ident">as_bytes</span>(),
        <span class="ident">s</span>.<span class="ident">as_bytes</span>(),
        <span class="kw-2">&amp;mut</span> <span class="ident">to_store</span>,
    );
    <span class="ident">base64::encode</span>(<span class="kw-2">&amp;</span><span class="ident">to_store</span>)
}

<span class="kw">pub</span> <span class="kw">fn</span> <span class="ident">verify</span>(<span class="ident">salt</span>: <span class="ident">String</span>, <span class="ident">password</span>: <span class="ident">String</span>, <span class="ident">attempted_password</span>: <span class="ident">String</span>) -&gt; <span class="ident">bool</span> {
    <span class="kw">let</span> <span class="ident">real_pwd</span> <span class="op">=</span> <span class="ident">base64::decode</span>(<span class="kw-2">&amp;</span><span class="ident">password</span>).<span class="ident">unwrap</span>();

    <span class="ident">pbkdf2::verify</span>(
        <span class="ident">PBKDF2_ALG</span>,
        <span class="ident">HASH_ROUNDS</span>,
        <span class="kw-2">&amp;</span><span class="ident">salt</span>.<span class="ident">as_bytes</span>(),
        <span class="ident">attempted_password</span>.<span class="ident">as_bytes</span>(),
        <span class="ident">real_pwd</span>.<span class="ident">as_slice</span>(),
    )
    .<span class="ident">is_ok</span>()
}
</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.63.0 (4b91a6ea7 2022-08-08)" ></div>
</body></html>