use sqlx::{Postgres, Sqlite, postgres::PgArguments, query::QueryAs, sqlite::SqliteArguments};
use crate::domain::model::UserRole;
use super::traits::{IdResult, MongoInsert, PgInsert, SqliteInsert};
impl PgInsert for UserRole {
fn columns() -> Vec<&'static str> {
vec!["userId", "roleId", "issuedAt"]
}
fn uniques() -> Vec<&'static str> {
vec!["\"userId\"", "\"roleId\""]
}
fn bind_query<'q>(
self,
query: QueryAs<'q, Postgres, IdResult, PgArguments>,
) -> QueryAs<'q, Postgres, IdResult, PgArguments> {
query
.bind(self.user_id)
.bind(self.role_id)
.bind(self.issued_at)
}
}
impl SqliteInsert for UserRole {
fn columns() -> Vec<&'static str> {
vec!["userId", "roleId", "issuedAt"]
}
fn uniques() -> Vec<&'static str> {
vec!["\"userId\"", "\"roleId\""]
}
fn bind_query<'q>(
self,
query: QueryAs<'q, Sqlite, IdResult, SqliteArguments<'q>>,
) -> QueryAs<'q, Sqlite, IdResult, SqliteArguments<'q>> {
query
.bind(self.user_id)
.bind(self.role_id)
.bind(self.issued_at)
}
}
impl MongoInsert for UserRole {
fn columns() -> Vec<&'static str> {
vec!["userId", "roleId", "issuedAt"]
}
fn uniques() -> Vec<&'static str> {
vec!["\"userId\"", "\"roleId\""]
}
}