test.migrations.toml

# This file is auto-generated by Turbosql.
# It is used to create and apply automatic schema migrations.
# It should be checked into source control.
# Modifying it by hand may be dangerous; see the docs.

migrations_append_only = [
    "CREATE TABLE personintegrationtest (rowid INTEGER PRIMARY KEY) STRICT",
    "ALTER TABLE personintegrationtest ADD COLUMN field_string TEXT",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i64 INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_bool INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_f64 REAL",
    "ALTER TABLE personintegrationtest ADD COLUMN field_f32 REAL",
    "ALTER TABLE personintegrationtest ADD COLUMN field_u8 INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i8 INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_u16 INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i16 INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_u32 INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i32 INTEGER",
    "ALTER TABLE personintegrationtest ADD COLUMN field_blob BLOB",
    "ALTER TABLE personintegrationtest ADD COLUMN field_vec_u8 BLOB",
    "ALTER TABLE personintegrationtest ADD COLUMN field_array_u8 BLOB",
    "ALTER TABLE personintegrationtest ADD COLUMN field_serialize TEXT",
    "ALTER TABLE personintegrationtest ADD COLUMN field_string_not_null TEXT NOT NULL DEFAULT 'foo foo'",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i64_not_null INTEGER NOT NULL DEFAULT 6",
    "ALTER TABLE personintegrationtest ADD COLUMN field_bool_not_null INTEGER NOT NULL DEFAULT false",
    "ALTER TABLE personintegrationtest ADD COLUMN field_f64_not_null REAL NOT NULL DEFAULT 1.1",
    "ALTER TABLE personintegrationtest ADD COLUMN field_f32_not_null REAL NOT NULL DEFAULT '2.3'",
    "ALTER TABLE personintegrationtest ADD COLUMN field_u8_not_null INTEGER NOT NULL DEFAULT -1.2",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i8_not_null INTEGER NOT NULL DEFAULT 0",
    "ALTER TABLE personintegrationtest ADD COLUMN field_u16_not_null INTEGER NOT NULL DEFAULT 'hello'",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i16_not_null INTEGER NOT NULL DEFAULT -1",
    "ALTER TABLE personintegrationtest ADD COLUMN field_u32_not_null INTEGER NOT NULL DEFAULT -1",
    "ALTER TABLE personintegrationtest ADD COLUMN field_i32_not_null INTEGER NOT NULL DEFAULT -1",
    "ALTER TABLE personintegrationtest ADD COLUMN field_blob_not_null BLOB NOT NULL DEFAULT x''",
    "ALTER TABLE personintegrationtest ADD COLUMN field_vec_u8_not_null BLOB NOT NULL DEFAULT x'30'",
    "ALTER TABLE personintegrationtest ADD COLUMN field_array_u8_not_null BLOB NOT NULL DEFAULT x'0001ff'",
    "ALTER TABLE personintegrationtest ADD COLUMN field_serialize_not_null TEXT NOT NULL DEFAULT ''",
    "CREATE TABLE nooption (rowid INTEGER PRIMARY KEY) STRICT",
    "ALTER TABLE nooption ADD COLUMN e INTEGER NOT NULL DEFAULT 0",
    "CREATE TABLE person (rowid INTEGER PRIMARY KEY) STRICT",
    "ALTER TABLE person ADD COLUMN name TEXT",
    "ALTER TABLE person ADD COLUMN age INTEGER",
    "ALTER TABLE person ADD COLUMN image_jpg BLOB",
]
output_generated_schema_for_your_information_do_not_edit = """
  CREATE TABLE _turbosql_migrations (
    rowid INTEGER PRIMARY KEY,
    migration TEXT NOT NULL
  ) STRICT
  CREATE TABLE nooption (
    rowid INTEGER PRIMARY KEY,
    e INTEGER NOT NULL DEFAULT 0
  ) STRICT
  CREATE TABLE person (
    rowid INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER,
    image_jpg BLOB
  ) STRICT
  CREATE TABLE personintegrationtest (
    rowid INTEGER PRIMARY KEY,
    field_string TEXT,
    field_i64 INTEGER,
    field_bool INTEGER,
    field_f64 REAL,
    field_f32 REAL,
    field_u8 INTEGER,
    field_i8 INTEGER,
    field_u16 INTEGER,
    field_i16 INTEGER,
    field_u32 INTEGER,
    field_i32 INTEGER,
    field_blob BLOB,
    field_vec_u8 BLOB,
    field_array_u8 BLOB,
    field_serialize TEXT,
    field_string_not_null TEXT NOT NULL DEFAULT 'foo foo',
    field_i64_not_null INTEGER NOT NULL DEFAULT 6,
    field_bool_not_null INTEGER NOT NULL DEFAULT false,
    field_f64_not_null REAL NOT NULL DEFAULT 1.1,
    field_f32_not_null REAL NOT NULL DEFAULT '2.3',
    field_u8_not_null INTEGER NOT NULL DEFAULT -1.2,
    field_i8_not_null INTEGER NOT NULL DEFAULT 0,
    field_u16_not_null INTEGER NOT NULL DEFAULT 'hello',
    field_i16_not_null INTEGER NOT NULL DEFAULT -1,
    field_u32_not_null INTEGER NOT NULL DEFAULT -1,
    field_i32_not_null INTEGER NOT NULL DEFAULT -1,
    field_blob_not_null BLOB NOT NULL DEFAULT x'',
    field_vec_u8_not_null BLOB NOT NULL DEFAULT x'30',
    field_array_u8_not_null BLOB NOT NULL DEFAULT x'0001ff',
    field_serialize_not_null TEXT NOT NULL DEFAULT ''
  ) STRICT
"""

[output_generated_tables_do_not_edit.nooption]
name = "nooption"

[[output_generated_tables_do_not_edit.nooption.columns]]
name = "rowid"
rust_type = "Option < i64 >"
sql_type = "INTEGER PRIMARY KEY"

[[output_generated_tables_do_not_edit.nooption.columns]]
name = "e"
rust_type = "u8"
sql_type = "INTEGER NOT NULL"

[output_generated_tables_do_not_edit.person]
name = "person"

[[output_generated_tables_do_not_edit.person.columns]]
name = "rowid"
rust_type = "Option < i64 >"
sql_type = "INTEGER PRIMARY KEY"

[[output_generated_tables_do_not_edit.person.columns]]
name = "name"
rust_type = "Option < String >"
sql_type = "TEXT"

[[output_generated_tables_do_not_edit.person.columns]]
name = "age"
rust_type = "Option < i64 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.person.columns]]
name = "image_jpg"
rust_type = "Option < Vec < u8 > >"
sql_type = "BLOB"

[output_generated_tables_do_not_edit.personintegrationtest]
name = "personintegrationtest"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "rowid"
rust_type = "Option < i64 >"
sql_type = "INTEGER PRIMARY KEY"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_string"
rust_type = "Option < String >"
sql_type = "TEXT"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i64"
rust_type = "Option < i64 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_bool"
rust_type = "Option < bool >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_f64"
rust_type = "Option < f64 >"
sql_type = "REAL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_f32"
rust_type = "Option < f32 >"
sql_type = "REAL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_u8"
rust_type = "Option < u8 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i8"
rust_type = "Option < i8 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_u16"
rust_type = "Option < u16 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i16"
rust_type = "Option < i16 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_u32"
rust_type = "Option < u32 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i32"
rust_type = "Option < i32 >"
sql_type = "INTEGER"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_blob"
rust_type = "Option < Blob >"
sql_type = "BLOB"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_vec_u8"
rust_type = "Option < Vec < u8 > >"
sql_type = "BLOB"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_array_u8"
rust_type = "Option < [u8; 99] >"
sql_type = "BLOB"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_serialize"
rust_type = "Option < Vec < i64 > >"
sql_type = "TEXT"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_string_not_null"
rust_type = "String"
sql_type = "TEXT NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i64_not_null"
rust_type = "i64"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_bool_not_null"
rust_type = "bool"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_f64_not_null"
rust_type = "f64"
sql_type = "REAL NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_f32_not_null"
rust_type = "f32"
sql_type = "REAL NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_u8_not_null"
rust_type = "u8"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i8_not_null"
rust_type = "i8"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_u16_not_null"
rust_type = "u16"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i16_not_null"
rust_type = "i16"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_u32_not_null"
rust_type = "u32"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_i32_not_null"
rust_type = "i32"
sql_type = "INTEGER NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_blob_not_null"
rust_type = "Blob"
sql_type = "BLOB NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_vec_u8_not_null"
rust_type = "Vec < u8 >"
sql_type = "BLOB NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_array_u8_not_null"
rust_type = "[u8; 5]"
sql_type = "BLOB NOT NULL"

[[output_generated_tables_do_not_edit.personintegrationtest.columns]]
name = "field_serialize_not_null"
rust_type = "Vec < i64 >"
sql_type = "TEXT NOT NULL"