use crudly::sql::{FormatPlaceholder, LastInsertedRowId, generic_insert_returning_id};
use crudly::{
CrudlyDefault, DeleteById, IdExists, Insert, InsertWithoutId, IntoRow, Schema, SelectAll,
SelectById, UpdateById,
};
use sqlx::{Database, Executor, IntoArguments, prelude::FromRow};
#[derive(IntoRow, Schema)]
#[allow(dead_code)]
struct Bar {
#[crudly(id)]
pub id: i64,
pub name: String,
}
impl<DB: Database> Foo<DB> for Bar
where
DB: FormatPlaceholder,
DB::QueryResult: LastInsertedRowId,
<DB as Database>::Arguments: IntoArguments<DB>,
for<'q> std::string::String: sqlx::Encode<'q, DB>,
std::string::String: sqlx::Type<DB>,
{
fn insert<'e, 'c, E>(self, executor: E) -> impl Future<Output = sqlx::Result<i64>> + Send
where
'c: 'e,
DB: 'e,
E: 'e + Executor<'c, Database = DB>,
{
async { generic_insert_returning_id::<Self, DB>(executor, self).await }
}
}
pub trait Foo<DB: Database>: Send {
fn insert<'e, 'c, E>(self, executor: E) -> impl Future<Output = sqlx::Result<i64>> + Send
where
'c: 'e,
DB: 'e,
E: 'e + Executor<'c, Database = DB>;
}
fn _do_stuff(bar: Bar, pool: sqlx::SqlitePool) {
tokio::spawn(async move {
let mut con = pool.acquire().await.unwrap();
bar.insert(&mut *con).await.unwrap();
});
}
#[derive(FromRow, IntoRow, Schema, Default)]
pub struct User {
#[crudly(id)]
pub id: i64,
pub name: String,
}
impl CrudlyDefault for User {}
#[derive(FromRow, IntoRow, Schema, Default)]
#[crudly(external_ids)]
pub struct UserExternalIds {
#[crudly(id)]
pub id: i64,
pub name: String,
}
impl CrudlyDefault for UserExternalIds {}
async fn _should_compile(pool: sqlx::SqlitePool) {
tokio::spawn(async move {
let mut con = pool.acquire().await.unwrap();
User::default().insert(&mut *con).await.unwrap();
UserExternalIds::default().insert(&mut *con).await.unwrap();
User::default().update_by_id(&mut *con).await.unwrap();
User::delete_by_id(&1, &mut *con).await.unwrap();
User::id_exists(&1, &mut *con).await.unwrap();
User::select_all(&mut *con).await.unwrap();
User::select_by_id(&1, &mut *con).await.unwrap();
});
}