1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137
use super::*; use crate::extension::postgres::types::*; impl TypeBuilder for PostgresQueryBuilder { fn prepare_type_create_statement( &self, create: &TypeCreateStatement, sql: &mut SqlWriter, collector: &mut dyn FnMut(Value), ) { write!(sql, "CREATE TYPE ").unwrap(); if let Some(name) = &create.name { name.prepare(sql, '"'); } if let Some(as_type) = &create.as_type { write!(sql, " AS ").unwrap(); self.prepare_create_as_type(&as_type, sql); } if !create.values.is_empty() { write!(sql, " (").unwrap(); for (count, val) in create.values.iter().enumerate() { if count > 0 { write!(sql, ", ").unwrap(); } self.prepare_value(&val.to_string().into(), sql, collector); } write!(sql, ")").unwrap(); } } fn prepare_type_drop_statement( &self, drop: &TypeDropStatement, sql: &mut SqlWriter, _collector: &mut dyn FnMut(Value), ) { write!(sql, "DROP TYPE ").unwrap(); if drop.if_exists { write!(sql, "IF EXISTS ").unwrap(); } for name in drop.names.iter() { name.prepare(sql, '"'); } if let Some(option) = &drop.option { write!(sql, " ").unwrap(); self.prepare_drop_type_opt(&option, sql); } } fn prepare_type_alter_statement( &self, alter: &TypeAlterStatement, sql: &mut SqlWriter, collector: &mut dyn FnMut(Value), ) { write!(sql, "ALTER TYPE ").unwrap(); if let Some(name) = &alter.name { name.prepare(sql, '"'); } if let Some(option) = &alter.option { self.prepare_alter_type_opt(&option, sql, collector) } } } impl PostgresQueryBuilder { fn prepare_create_as_type(&self, as_type: &TypeAs, sql: &mut SqlWriter) { write!( sql, "{}", match as_type { TypeAs::Enum => "ENUM", } ) .unwrap() } fn prepare_drop_type_opt(&self, opt: &TypeDropOpt, sql: &mut SqlWriter) { write!( sql, "{}", match opt { TypeDropOpt::Cascade => "CASCADE", TypeDropOpt::Restrict => "RESTRICT", } ) .unwrap() } fn prepare_alter_type_opt( &self, opt: &TypeAlterOpt, sql: &mut SqlWriter, collector: &mut dyn FnMut(Value), ) { match opt { TypeAlterOpt::Add(value, placement) => { write!(sql, "{}", " ADD VALUE ").unwrap(); match placement { Some(add_option) => match add_option { TypeAlterAddOpt::Before(before_value) => { self.prepare_value(&value.to_string().into(), sql, collector); write!(sql, "{}", " BEFORE ").unwrap(); self.prepare_value(&before_value.to_string().into(), sql, collector); } TypeAlterAddOpt::After(after_value) => { self.prepare_value(&value.to_string().into(), sql, collector); write!(sql, "{}", " AFTER ").unwrap(); self.prepare_value(&after_value.to_string().into(), sql, collector); } }, None => self.prepare_value(&value.to_string().into(), sql, collector), } } TypeAlterOpt::Rename(new_name) => { write!(sql, "{}", " RENAME TO ").unwrap(); self.prepare_value(&new_name.to_string().into(), sql, collector); } TypeAlterOpt::RenameValue(existing, new_name) => { write!(sql, "{}", " RENAME VALUE ").unwrap(); self.prepare_value(&existing.to_string().into(), sql, collector); write!(sql, "{}", " TO ").unwrap(); self.prepare_value(&new_name.to_string().into(), sql, collector); } } } }