use crate::common::generator_context::GeneratorContext;
use crate::common::relation_generator::{DefaultRelationGenerator, RelationGenerator};
use schema_model::model::table::Table;
use schema_model::model::types::ForeignKeyMode;
pub struct SqliteRelationGenerator {
relation_generator: DefaultRelationGenerator,
}
impl SqliteRelationGenerator {
pub fn new(context: GeneratorContext) -> Self {
Self {
relation_generator: DefaultRelationGenerator::new(context),
}
}
pub fn inline_foreign_key_constraints(&self, table: &Table) -> Vec<String> {
let context = self.relation_generator.context();
if context.settings().foreign_key_mode() != ForeignKeyMode::Relations {
return Vec::new();
}
let database_type = context.settings().database_type();
let database_model = context.settings().database_model();
table
.relations()
.iter()
.enumerate()
.map(|(relation_index, relation)| {
let constraint_name = self.relation_generator.relation_constraint_name(table, relation_index);
let to_table = database_model.find_table_by_qualified_name(relation.to_table_name());
let operation = self.relation_generator.relation_operation_type(relation.relation_type());
let from_columns = relation
.column_pairs()
.iter()
.map(|(from, _)| from.as_str())
.collect::<Vec<_>>()
.join(", ");
let to_columns = relation
.column_pairs()
.iter()
.map(|(_, to)| to.as_str())
.collect::<Vec<_>>()
.join(", ");
format!(
" constraint {} foreign key ({}) references {}({}) on delete {}",
constraint_name,
from_columns,
to_table.fully_qualified_table_name(database_type),
to_columns,
operation
)
})
.collect()
}
}
impl RelationGenerator for SqliteRelationGenerator {
fn output_relations(&self) {
}
}
#[cfg(test)]
mod tests {
use super::*;
use crate::common::test_support::{make_context, make_context_with_fk_mode};
use schema_model::builder::{ColumnBuilder, SchemaBuilder, TableBuilder};
use schema_model::model::column_type::ColumnType;
use schema_model::model::database_model::DatabaseModel;
use schema_model::model::relation::Relation;
use schema_model::model::types::{BooleanMode, DatabaseType, RelationType};
fn build_model_with_relation() -> (DatabaseModel, Table) {
let parent = TableBuilder::new(None::<&str>, "parent")
.add_column(ColumnBuilder::new(None::<&str>, "id", ColumnType::Sequence).required(true).build())
.build();
let child = TableBuilder::new(None::<&str>, "child")
.add_column(ColumnBuilder::new(None::<&str>, "parent_id", ColumnType::Int).required(true).build())
.add_relation(Relation::new("parent", "id", "child", "parent_id", RelationType::Cascade, false))
.build();
let schema = SchemaBuilder::new(None::<&str>)
.add_table(parent)
.add_table(child.clone())
.build();
let model = DatabaseModel::new(BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
(model, child)
}
#[test]
fn output_relations_never_emits_alter_table() {
let (model, _child) = build_model_with_relation();
let (ctx, buffer) = make_context(model, DatabaseType::Sqlite);
let generator = SqliteRelationGenerator::new(ctx);
generator.output_relations();
assert_eq!(buffer.contents(), "");
}
#[test]
fn inline_foreign_key_constraints_renders_clause_for_relation() {
let (model, child) = build_model_with_relation();
let (ctx, _buffer) = make_context(model, DatabaseType::Sqlite);
let generator = SqliteRelationGenerator::new(ctx);
let clauses = generator.inline_foreign_key_constraints(&child);
assert_eq!(clauses.len(), 1);
assert!(clauses[0].contains("foreign key (parent_id) references parent(id)"));
assert!(clauses[0].contains("on delete cascade"));
assert!(!clauses[0].contains("alter table"));
}
#[test]
fn inline_foreign_key_constraints_renders_composite_clause_for_relation() {
let parent = TableBuilder::new(None::<&str>, "parent")
.add_column(ColumnBuilder::new(None::<&str>, "id", ColumnType::Sequence).required(true).build())
.add_column(ColumnBuilder::new(None::<&str>, "tenant_id", ColumnType::Int).required(true).build())
.build();
let child = TableBuilder::new(None::<&str>, "child")
.add_column(ColumnBuilder::new(None::<&str>, "parent_id", ColumnType::Int).required(true).build())
.add_column(ColumnBuilder::new(None::<&str>, "tenant_id", ColumnType::Int).required(true).build())
.add_relation(
Relation::new_composite(
"parent",
"child",
vec![("parent_id", "id"), ("tenant_id", "tenant_id")],
RelationType::Cascade,
false,
)
.unwrap(),
)
.build();
let schema = SchemaBuilder::new(None::<&str>)
.add_table(parent)
.add_table(child.clone())
.build();
let model = DatabaseModel::new(BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
let (ctx, _buffer) = make_context(model, DatabaseType::Sqlite);
let generator = SqliteRelationGenerator::new(ctx);
let clauses = generator.inline_foreign_key_constraints(&child);
assert_eq!(clauses.len(), 1);
assert!(clauses[0].contains("foreign key (parent_id, tenant_id) references parent(id, tenant_id)"));
assert!(clauses[0].contains("on delete cascade"));
}
#[test]
fn inline_foreign_key_constraints_empty_when_table_has_no_relations() {
let table = TableBuilder::new(None::<&str>, "solo").build();
let schema = SchemaBuilder::new(None::<&str>).add_table(table.clone()).build();
let model = DatabaseModel::new(BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
let (ctx, _buffer) = make_context(model, DatabaseType::Sqlite);
let generator = SqliteRelationGenerator::new(ctx);
assert!(generator.inline_foreign_key_constraints(&table).is_empty());
}
#[test]
fn inline_foreign_key_constraints_empty_when_foreign_key_mode_is_not_relations() {
let parent = TableBuilder::new(None::<&str>, "parent")
.add_column(ColumnBuilder::new(None::<&str>, "id", ColumnType::Sequence).required(true).build())
.build();
let child = TableBuilder::new(None::<&str>, "child")
.add_column(ColumnBuilder::new(None::<&str>, "parent_id", ColumnType::Int).required(true).build())
.add_relation(Relation::new("parent", "id", "child", "parent_id", RelationType::Cascade, false))
.build();
let schema = SchemaBuilder::new(None::<&str>)
.add_table(parent)
.add_table(child.clone())
.build();
let model = DatabaseModel::new(BooleanMode::Native, ForeignKeyMode::Relations, vec![schema]);
let (ctx, _buffer) = make_context_with_fk_mode(model, DatabaseType::Sqlite, ForeignKeyMode::None);
let generator = SqliteRelationGenerator::new(ctx);
assert!(generator.inline_foreign_key_constraints(&child).is_empty());
}
}