sea_query/backend/sqlite/
index.rs

1use super::*;
2
3impl IndexBuilder for SqliteQueryBuilder {
4    fn prepare_index_create_statement(
5        &self,
6        create: &IndexCreateStatement,
7        sql: &mut dyn SqlWriter,
8    ) {
9        write!(sql, "CREATE ").unwrap();
10        self.prepare_index_prefix(create, sql);
11        write!(sql, "INDEX ").unwrap();
12
13        if create.if_not_exists {
14            write!(sql, "IF NOT EXISTS ").unwrap();
15        }
16
17        if let Some(name) = &create.index.name {
18            write!(
19                sql,
20                "{}{}{}",
21                self.quote().left(),
22                name,
23                self.quote().right()
24            )
25            .unwrap();
26        }
27
28        write!(sql, " ON ").unwrap();
29        if let Some(table) = &create.table {
30            self.prepare_table_ref_index_stmt(table, sql);
31        }
32
33        write!(sql, " ").unwrap();
34        self.prepare_index_columns(&create.index.columns, sql);
35        self.prepare_filter(&create.r#where, sql);
36    }
37
38    fn prepare_table_ref_index_stmt(&self, table_ref: &TableRef, sql: &mut dyn SqlWriter) {
39        match table_ref {
40            TableRef::Table(_) => self.prepare_table_ref_iden(table_ref, sql),
41            _ => panic!("Not supported"),
42        }
43    }
44
45    fn prepare_index_drop_statement(&self, drop: &IndexDropStatement, sql: &mut dyn SqlWriter) {
46        write!(sql, "DROP INDEX ").unwrap();
47
48        if drop.if_exists {
49            write!(sql, "IF EXISTS ").unwrap();
50        }
51
52        if let Some(name) = &drop.index.name {
53            write!(
54                sql,
55                "{}{}{}",
56                self.quote().left(),
57                name,
58                self.quote().right()
59            )
60            .unwrap();
61        }
62    }
63
64    fn prepare_index_prefix(&self, create: &IndexCreateStatement, sql: &mut dyn SqlWriter) {
65        if create.primary {
66            write!(sql, "PRIMARY KEY ").unwrap();
67        } else if create.unique {
68            write!(sql, "UNIQUE ").unwrap();
69        }
70    }
71
72    fn write_column_index_prefix(&self, _col_prefix: &Option<u32>, _sql: &mut dyn SqlWriter) {}
73
74    fn prepare_filter(&self, condition: &ConditionHolder, sql: &mut dyn SqlWriter) {
75        self.prepare_condition(condition, "WHERE", sql);
76    }
77}
sea_query/backend/sqlite/index.rs

sea_query/backend/sqlite/
index.rs
