title: Rust/Rocket/Diesel - How can I query a MySqlDatabase using rocket_sync_db_pools
body: <p>When trying to call load on my prices schema created by diesel in a Rocket app, I get the error <strong>the trait <code>LoadConnection</code> is not implemented for <code>&amp;mut rocket_sync_db_pools::diesel::MysqlConnection</code></strong></p>
  <p>I've looked at a few tutorials, and have followed the examples on github and on rocket's documentation, as well as Diesel's documentation.</p>
  <p>I've tried implementing the DbConn with diesel::MySqlConnection instead of rocket_sync_db_pools, but I get an error saying <strong>the trait bound <code>diesel::MysqlConnection: Poolable</code> is not satisfied</strong></p>
  <p>Would love some help!</p>
  <p>My code can be found below.
  [main.rs]</p>
  <pre><code>#[macro_use] extern crate rocket;
  #[macro_use] extern crate diesel;
  #[macro_use] extern crate diesel_migrations;
  #[macro_use] extern crate rocket_sync_db_pools;
  
  
  mod schema;
  mod db_utils;
  
  use rocket::{Rocket, Build};
  use rocket::fairing::AdHoc;
  use rocket::request::FlashMessage;
  use rocket::serde::Serialize;
  use rocket::form::Form;
  use rocket::fs::{FileServer, relative};
  use diesel::prelude::*;
  
  
  #[database(&quot;my_db&quot;)]
  pub struct DbConn(rocket_sync_db_pools::diesel::MysqlConnection);
  
  
  #[get(&quot;/&quot;)]
  fn index(conn: DbConn) {
  
      conn.run(|c| self::schema::prices::dsl::prices.load(&amp;mut c));
  
  }
  
  
  
  #[launch]
  fn rocket() -&gt; _ {
      rocket::build()
          .attach(DbConn::fairing())
          .mount(&quot;/&quot;, routes![index])
  }
  </code></pre>
  <p>And
  [schema.rs]</p>
  <pre><code>// @generated automatically by Diesel CLI.
  
  diesel::table! {
      prices (id) {
          id -&gt; Integer,
          date -&gt; Text,
          ticker -&gt; Text,
          price -&gt; Float,
      }
  }
  </code></pre>
  <p>and
  [db_utils/models.rs]</p>
  <pre><code>use diesel::prelude::*;
  
  
  #[derive(Queryable)]
  pub struct Price {
    pub id: i32,
    pub date: String,
    pub ticker: String,
    pub price: f32
  }
  </code></pre>