evento-sql-migrator 2.0.0-alpha.30

SQL migrations for evento event sourcing library.
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

//! Keys projection snapshots by projection name.
//!
//! Until now the `snapshot` primary key was `(type, id)`: nothing said which
//! projection a row belonged to, so two snapshotted projections of one
//! aggregate overwrote each other and then failed to decode each other's
//! bytes. The key becomes `(type, projection, id)`.

mod recreate_snapshot;

use sqlx_migrator::vec_box;

/// Migration that adds the projection name to the `snapshot` primary key.
///
/// ## Changes
///
/// 1. Drops and recreates the `snapshot` table with a
///    `projection VARCHAR(255) NOT NULL` column and primary key
///    `(type, projection, id)`.
///
/// Existing snapshots are discarded: they are a cache, and every projection
/// rebuilds from events on its next load.
///
/// ## Dependencies
///
/// This migration depends on [`M0006`](crate::M0006).
pub struct M0007;

#[cfg(feature = "sqlite")]
sqlx_migrator::sqlite_migration!(
    M0007,
    "main",
    "m0007",
    vec_box![crate::M0006],
    vec_box![recreate_snapshot::Operation]
);

#[cfg(feature = "mysql")]
sqlx_migrator::mysql_migration!(
    M0007,
    "main",
    "m0007",
    vec_box![crate::M0006],
    vec_box![recreate_snapshot::Operation]
);

#[cfg(feature = "postgres")]
sqlx_migrator::postgres_migration!(
    M0007,
    "main",
    "m0007",
    vec_box![crate::M0006],
    vec_box![recreate_snapshot::Operation]
);