mirror of
https://github.com/Phundrak/georm.git
synced 2026-07-29 04:19:18 +02:00
Claude
4c314c2f0b
Adds a SqliteDialect alongside PostgresDialect, gated by mutually exclusive postgres (default) / sqlite Cargo features, plus a feature-selected ActiveDatabase type alias used throughout the public Georm/Defaultable traits. Basic CRUD and Defaultable are fully covered by a new SQLite test suite (tests/sqlite/*) running against a real SQLite database, alongside split migrations/sqlite/*. Two real dialect differences surfaced beyond placeholder syntax: - SQLite's INTEGER columns type-infer as i64 in sqlx's compile-time query macros (unlike Postgres SERIAL -> i32), so the SQLite test models use i64 for integer PK/FK fields. - sqlx's SQLite query macros need bind arguments bound to a place rather than passed as an inline expression (fixed once, centrally, in SqlDialect::generate_relation_lookup). Composite-key entities with chrono::DateTime columns (tests/composite_key.rs) are not yet ported to SQLite: SQLite has no TIMESTAMPTZ equivalent, so sqlx infers TEXT date/time columns as String rather than DateTime<Utc> unless the query explicitly overrides the column type. That needs per-field type overrides threaded through the generated queries, left as follow-up. CI now matrixes over both backends; formatting/audit only run once since they don't vary by backend. examples/postgres/* stays out of --no-default-features builds by scoping sqlite lint/test just recipes to `-p georm` (it depends on georm's default postgres feature via Cargo feature unification, so building it under --features sqlite at the workspace level double-activates both dialects).
39 lines
1.0 KiB
SQL
39 lines
1.0 KiB
SQL
CREATE TABLE biographies (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
content TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE authors (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name VARCHAR(100) NOT NULL,
|
|
biography_id INT,
|
|
FOREIGN KEY (biography_id) REFERENCES biographies(id)
|
|
);
|
|
|
|
CREATE TABLE books (
|
|
ident INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
title VARCHAR(100) NOT NULL,
|
|
author_id INT NOT NULL,
|
|
FOREIGN KEY (author_id) REFERENCES authors(id) ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE TABLE reviews (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
book_id INT NOT NULL,
|
|
review TEXT NOT NULL,
|
|
FOREIGN KEY (book_id) REFERENCES books(ident) ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE TABLE genres (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name VARCHAR(100) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE book_genres (
|
|
book_id INT NOT NULL,
|
|
genre_id INT NOT NULL,
|
|
PRIMARY KEY (book_id, genre_id),
|
|
FOREIGN KEY (book_id) REFERENCES books(ident) ON DELETE CASCADE,
|
|
FOREIGN KEY (genre_id) REFERENCES genres(id) ON DELETE CASCADE
|
|
);
|