tako8ki/testfixtures

A library for preparing test data from yaml files in Rust.

testfixtures

testfixtures is a Rust library for preparing test data from yaml files.

Usage | Docs | Examples

Install

This crate is compatible with the async-std and tokio runtimes.

async-std

[dependencies]
testfixtures = "0.1"
sqlx = "0.3"
chrono = "0.4.11"

tokio

[dependencies]
testfixtures = { version = "0.1", default-features = false, features = [ "runtime-tokio" ] }
sqlx = { version = "0.3", default-features = false, features = [ "runtime-tokio", "macros" ] }
chrono = "0.4.11"

Usage

Create fixture files like the following. Fixture files should have the name <table_name>.yml.

todos.yml

- id: 1
  description: buy a new camera
  done: true
  progress: 10.5
  created_at: 2020/01/01 01:01:01
- id: 2
  description: meeting
  done: false
  progress: 30.0
  created_at: 2020/01/01 02:02:02

Click and see the datetime format example

2020-01-01 01:01
2020-01-01 01:01:01
20200101 01:01
20200101 01:01:01
01012020 01:01
01012020 01:01:01
2020/01/01 01:01
2020/01/01 01:01:01

If you need to write raw SQL, probably to call a function, prefix the value of the column with RAW=.

- id: 1
  description: fizz
  done: true
  progress: 10.5
  created_at: RAW=NOW()

Your tests would look like this.

#[cfg(test)]
mod tests {
    use chrono::Utc;
    use sqlx::MySqlPool;
    use std::env;
    use testfixtures::MySqlLoader;

    #[async_std::test]
    async fn test_something() -> anyhow::Result<()> {
        let pool = MySqlPool::new(&env::var("DATABASE_URL")?).await?;
        let loader = MySqlLoader::new(|cfg| {
            cfg.location(Utc);
            cfg.database(pool);
            cfg.skip_test_database_check();
            cfg.paths(vec!["fixtures/todos.yml"]);
        })
        .await?;

        // load your fixtures
        loader.load().await.unwrap();

        // run your tests

        Ok(())
    }
}

PgLoader and SqliteLoader are under development.

Options

database(required)

database is a option for passing db connection pool to a Loader.

let pool = MySqlPool::new(&env::var("DATABASE_URL")?).await?;
let loader = MySqlLoader::new(|cfg| {
    cfg.database(pool);
    // ...
})
.await?;

location(required)

location is a option for setting timezone.

use chrono::Utc;

let loader = MySqlLoader::new(|cfg| {
    cfg.location(Utc);
    // or cfg.location(Local);
    // ...
})
.await?;

skip_test_database_check(optional)

skip_test_database_check is a option for setting a flag for checking if database name ends with "test".

let loader = MySqlLoader::new(|cfg| {
    cfg.skip_test_database_check();
    // ...
})
.await?;

files(optional)

files is a option for reading your fixture files.

let loader = MySqlLoader::new(|cfg| {
    cfg.files(vec!["fizz.yml"]);
    // ...
})
.await?;

directory(optional)

files is a option for reading your fixture files in a directory.

let loader = MySqlLoader::new(|cfg| {
    cfg.directory("fixture");
    // ...
})
.await?;

paths(optional)

paths is a option that is a combination of files option and directory option.

let loader = MySqlLoader::new(|cfg| {
    cfg.paths(vec!["fizz", "buzz/todos.yml"]);
    // ...
})
.await?;

Implemation status

Database

• MySQL and MariaDB
• Postgres
• SQLite

Options

• database
• load files
• skip_test_database_check
• location
• directory
• paths
• template

Contribution

# setup test db
$ make db

# load environment variables
$ make env
$ direnv allow # https://github.com/direnv/direnv

# run unit tests
$ make test

Show your support

Give a ⭐️ if this project helped you!

Reference

https://github.com/go-testfixtures/testfixtures

testfixtures's Issues

Add tests

• unit tests
• e2e tests

Add examples

Create PgLoader

Now, you can only use MysqlLoader. I want to create Loader for PostgreSQL.

• https://github.com/TaKO8Ki/testfixtures/blob/master/src/postgresql/helper.rs
• https://github.com/TaKO8Ki/testfixtures/blob/master/src/postgresql/loader.rs

Add datetime formats

add the following formats.

"2006-01-02",
"2006-01-02 15:04",
"2006-01-02 15:04:05",
"20060102",
"20060102 15:04",
"20060102 15:04:05",
"02/01/2006",
"02/01/2006 15:04",
"02/01/2006 15:04:05",
"2006-01-02T15:04-07:00",
"2006-01-02T15:04:05-07:00",
"2006-01-02T15:04:05Z07:00",
"2006-01-02 15:04:05Z07:00",
"2006-01-02T15:04:05Z0700",
"2006-01-02 15:04:05Z0700",
"2006-01-02T15:04:05Z07",
"2006-01-02 15:04:05Z07",
"2006-01-02 15:04:05 MST",

testfixtures/src/loader.rs

Lines 116 to 121 in e5e6d2c

	fn try_str_to_date(&self, s: String) -> Result<DateTime<Tz>, ParseError> {
	self.location
	.as_ref()
	.unwrap()
	.datetime_from_str(s.as_str(), "%Y/%m/%d %H:%M:%S")
	}

Add the option for changing timezone

complete this option.

let loader = MySqlLoader::new(|cfg| {
    cfg.location(Utc);
})
.await?;

then add tests.

Add float to SqlParam

Add doc comment

Is this repository maintained?

Hello.
It's a interesting idea.
However, It seems is updated last 3 year's ago.
Do you intend to continue maintaining this repository?

Add E2E test

Define impls for each database loader

define following impls

impl MySqlLoader {
    fn new() {}
}

impl PosgresLoader {
    fn new() {}
}