easy_sqlx_core/sql/dialects/schema/
schema.rs

1use sqlx::{ColumnIndex, Database, Decode, Encode, Executor, IntoArguments};
2
3use crate::sql::{
4    dialects::{
5        condition::Where,
6        page::{Order, PageRequest},
7    },
8    schema::{column::Column, index::Index, table::TableSchema},
9    utils::quote::Quoter,
10};
11use std::{future::Future, io};
12
13pub trait Schema
14// where
15//     for<'e> &'e mut C: Executor<'e, Database = DB>,
16//     for<'a> DB::Arguments<'a>: IntoArguments<'a, DB>,
17{
18    fn quoter(&self) -> Quoter;
19
20    fn query_upgrade_tags<C, DB: Database>(
21        &self,
22        conn: &mut C,
23        table_name: &String,
24        tag: &String,
25    ) -> impl Future<Output = io::Result<Vec<String>>> + Send
26    where
27        for<'a> &'a mut C: Executor<'a, Database = DB>,
28        for<'a> DB::Arguments<'a>: IntoArguments<'a, DB>,
29        for<'a> &'a str: ColumnIndex<DB::Row>,
30        for<'a> bool: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
31        for<'a> i32: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
32        for<'a> i64: sqlx::Decode<'a, DB> + sqlx::Type<DB> + Encode<'a, DB>,
33        for<'a> std::string::String: Decode<'a, DB> + Encode<'a, DB> + sqlx::Type<DB>;
34
35    // type DB: Database;
36    // fn check_upgrade_table(&self, conn: &mut C) -> impl Future<Output = io::Result<()>> + Send;
37    // fn query_upgrade_tags(
38    //     &self,
39    //     conn: &mut C,
40    //     table_name: &String,
41    //     tag: &String,
42    // ) -> impl Future<Output = io::Result<Vec<String>>> + Send
43    // where
44    //     for<'e> &'e mut C: Executor<'e, Database = DB>,
45    //     for<'a> DB::Arguments<'a>: IntoArguments<'a, DB>;
46    fn insert_upgrade_tag<C, DB: Database>(
47        &self,
48        conn: &mut C,
49        table_name: &String,
50        tag: &String,
51        tag_value: &String,
52    ) -> impl Future<Output = io::Result<()>> + Send
53    where
54        for<'a> &'a mut C: Executor<'a, Database = DB>,
55        for<'a> <DB as Database>::Arguments<'a>: IntoArguments<'a, DB>,
56        for<'a> &'a str: ColumnIndex<DB::Row>,
57        for<'a> bool: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
58        for<'a> i32: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
59        for<'a> i64: sqlx::Decode<'a, DB> + sqlx::Type<DB> + Encode<'a, DB>,
60        for<'a> std::string::String: Decode<'a, DB> + Encode<'a, DB> + sqlx::Type<DB>;
61
62    fn table_name_with_schema(&self, table: &TableSchema) -> String;
63    fn is_table_name_equal(&self, table1: &TableSchema, table2: &TableSchema) -> bool;
64
65    fn execute_sql<'c, C, DB: Database>(
66        &self,
67        conn: &mut C,
68        sql: &'c str,
69    ) -> impl Future<Output = io::Result<<DB as Database>::QueryResult>> + Send
70    where
71        for<'a> &'a mut C: Executor<'a, Database = DB>,
72        for<'a> DB::Arguments<'a>: IntoArguments<'a, DB>,
73        for<'a> &'a str: ColumnIndex<DB::Row>,
74        for<'a> bool: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
75        for<'a> i32: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
76        for<'a> i64: sqlx::Decode<'a, DB> + sqlx::Type<DB> + Encode<'a, DB>,
77        for<'a> std::string::String: Decode<'a, DB> + Encode<'a, DB> + sqlx::Type<DB>;
78
79    // type Connection;
80    fn get_tables<C, DB: Database>(
81        &self,
82        conn: &mut C,
83    ) -> impl std::future::Future<Output = io::Result<Vec<TableSchema>>> + Send
84    where
85        for<'e> &'e mut C: Executor<'e, Database = DB>,
86        for<'a> DB::Arguments<'a>: IntoArguments<'a, DB>,
87        for<'a> &'a str: ColumnIndex<DB::Row>,
88        for<'a> bool: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
89        for<'a> i32: sqlx::Decode<'a, DB> + sqlx::Type<DB>,
90        for<'a> i64: sqlx::Decode<'a, DB> + sqlx::Type<DB> + Encode<'a, DB>,
91        for<'a> std::string::String: Decode<'a, DB> + Encode<'a, DB> + sqlx::Type<DB>;
92
93    fn sql_table_rename(&self, table: &TableSchema, new_table_name: &String) -> String;
94
95    fn sql_create_table(&self, table: &TableSchema) -> io::Result<Vec<String>>;
96    fn sql_drop_table(&self, table: &TableSchema) -> String;
97
98    fn sql_create_index(&self, table: &TableSchema, index: &Index) -> Option<String>;
99    fn sql_create_indexes(&self, table: &TableSchema) -> Vec<String>;
100    fn sql_drop_index(&self, table: &TableSchema, index: &Index) -> String;
101
102    fn sql_add_column(&self, table: &TableSchema, col: &Column) -> String;
103    fn sql_alter_column(
104        &self,
105        table: &TableSchema,
106        old: &Column,
107        new: &Column,
108    ) -> io::Result<Vec<String>>;
109    fn sql_drop_column(&self, table: &TableSchema, col: &Column) -> String;
110
111    fn sql_insert(&self, table: &TableSchema, return_sql: bool) -> String;
112    fn sql_insert_columns(
113        &self,
114        table: &TableSchema,
115        cols: &Vec<String>,
116        return_sql: bool,
117    ) -> String;
118    fn sql_update_columns(
119        &self,
120        table: &TableSchema,
121        cols: &Vec<String>,
122        wh: Option<Where>,
123        return_sql: bool,
124    ) -> String;
125
126    fn sql_delete(&self, table: &TableSchema, wh: Option<Where>, return_sql: bool) -> String;
127    fn sql_count(&self, table: &TableSchema, wh: Option<Where>) -> String;
128
129    // fn sql_max(&self, table: &TableSchema, col: &Column, wh: Option<Where>) -> String;
130    // fn sql_min(&self, table: &TableSchema, col: &Column, wh: Option<Where>) -> String;
131
132    fn sql_select(
133        &self,
134        table: &TableSchema,
135        wh: Option<Where>,
136        orders: &Vec<Order>,
137        pg: Option<&PageRequest>,
138    ) -> String;
139    fn sql_select_columns(
140        &self,
141        table: &TableSchema,
142        columns: &Vec<Column>,
143        wh: Option<Where>,
144        orders: &Vec<Order>,
145        pg: Option<&PageRequest>,
146    ) -> String;
147}
easy_sqlx_core/sql/dialects/schema/schema.rs

easy_sqlx_core/sql/dialects/schema/
schema.rs
