bappity , 3 hours ago (edited 3 hours ago)

I switched to using tiberius

bit different but not too hard don’t have my code on hand atm but this is how I started with it

<span style="color:#323232;">    </span><span style="font-weight:bold;color:#a71d5d;">let mut</span><span style="color:#323232;"> config </span><span style="font-weight:bold;color:#a71d5d;">= </span><span style="color:#323232;">Config::new();
</span><span style="color:#323232;">    config.</span><span style="color:#62a35c;">host</span><span style="color:#323232;">(</span><span style="color:#183691;">"your_server_name"</span><span style="color:#323232;">);
</span><span style="color:#323232;">    config.</span><span style="color:#62a35c;">database</span><span style="color:#323232;">(</span><span style="color:#183691;">"your_database_name"</span><span style="color:#323232;">);
</span><span style="color:#323232;">    config.</span><span style="color:#62a35c;">authentication</span><span style="color:#323232;">(tiberius::AuthMethod::sql_server(</span><span style="color:#183691;">"your_username"</span><span style="color:#323232;">, </span><span style="color:#183691;">"your_password"</span><span style="color:#323232;">));
</span><span style="color:#323232;">    config.</span><span style="color:#62a35c;">trust_cert</span><span style="color:#323232;">();
</span><span style="color:#323232;">
</span><span style="color:#323232;">    </span><span style="font-weight:bold;color:#a71d5d;">let</span><span style="color:#323232;"> tcp </span><span style="font-weight:bold;color:#a71d5d;">= </span><span style="color:#323232;">TcpStream::connect(config.</span><span style="color:#62a35c;">get_addr</span><span style="color:#323232;">()).await</span><span style="font-weight:bold;color:#a71d5d;">?</span><span style="color:#323232;">;
</span><span style="color:#323232;">    tcp.</span><span style="color:#62a35c;">set_nodelay</span><span style="color:#323232;">(</span><span style="color:#0086b3;">true</span><span style="color:#323232;">)</span><span style="font-weight:bold;color:#a71d5d;">?</span><span style="color:#323232;">;
</span><span style="color:#323232;">    
</span><span style="color:#323232;">    </span><span style="font-weight:bold;color:#a71d5d;">let mut</span><span style="color:#323232;"> client </span><span style="font-weight:bold;color:#a71d5d;">= </span><span style="color:#323232;">Client::connect(config, tcp.</span><span style="color:#62a35c;">compat_write</span><span style="color:#323232;">()).await</span><span style="font-weight:bold;color:#a71d5d;">?</span><span style="color:#323232;">;
</span>

then I did something along the lines of

<span style="font-weight:bold;color:#a71d5d;">fn </span><span style="font-weight:bold;color:#795da3;">main</span><span style="color:#323232;">() {
</span><span style="color:#323232;">        </span><span style="font-weight:bold;color:#a71d5d;">let</span><span style="color:#323232;"> stream </span><span style="font-weight:bold;color:#a71d5d;">=</span><span style="color:#323232;"> client.</span><span style="color:#62a35c;">query</span><span style="color:#323232;">(</span><span style="font-weight:bold;color:#a71d5d;">&</span><span style="color:#323232;">query, </span><span style="font-weight:bold;color:#a71d5d;">&</span><span style="color:#323232;">[]).await</span><span style="font-weight:bold;color:#a71d5d;">?</span><span style="color:#323232;">;
</span><span style="color:#323232;">        </span><span style="font-weight:bold;color:#a71d5d;">let</span><span style="color:#323232;"> rows </span><span style="font-weight:bold;color:#a71d5d;">=</span><span style="color:#323232;"> stream.</span><span style="color:#62a35c;">into_first_result</span><span style="color:#323232;">().await</span><span style="font-weight:bold;color:#a71d5d;">?</span><span style="color:#323232;">;
</span><span style="color:#323232;">
</span><span style="color:#323232;">        </span><span style="font-weight:bold;color:#a71d5d;">let</span><span style="color:#323232;"> db_data: Vec<MyObject> </span><span style="font-weight:bold;color:#a71d5d;">=</span><span style="color:#323232;"> rows.</span><span style="color:#62a35c;">into_iter</span><span style="color:#323232;">().</span><span style="color:#62a35c;">map</span><span style="color:#323232;">(mapping_function_i_made_for_myobject).</span><span style="color:#62a35c;">collect</span><span style="color:#323232;">();
</span><span style="color:#323232;">}
</span><span style="color:#323232;">
</span><span style="font-weight:bold;color:#a71d5d;">fn </span><span style="font-weight:bold;color:#795da3;">mapping_function_i_made_for_myobject</span><span style="color:#323232;">(row: Row) -> MyObject {
</span><span style="color:#323232;">    MyObject {
</span><span style="color:#323232;">        my_date_field: row.get::<NaiveDateTime, </span><span style="font-weight:bold;color:#a71d5d;">_</span><span style="color:#323232;">>(</span><span style="color:#183691;">"my_date_field"</span><span style="color:#323232;">).</span><span style="color:#62a35c;">map</span><span style="color:#323232;">(|dt| Local.</span><span style="color:#62a35c;">from_local_datetime</span><span style="color:#323232;">(</span><span style="font-weight:bold;color:#a71d5d;">&</span><span style="color:#323232;">dt).</span><span style="color:#62a35c;">unwrap</span><span style="color:#323232;">()),
</span><span style="color:#323232;">    }
</span><span style="color:#323232;">}
</span><span style="color:#323232;">
</span>