#sqlx #postgresql #database #test

xsqlx-db-tester

A simple tool to test sqlx database, it automatically create and drop database when the test create and drop

4 releases

0.1.3 Jun 2, 2023
0.1.2 Jun 1, 2023
0.1.1 Jun 1, 2023
0.1.0 Jun 1, 2023

#2421 in Development tools

MIT license

8KB
99 lines

Source

This project learns from: https://github.com/tyrchen/sqlx-db-tester/tree/master

xsqlx-db-tester

This a tool test sqlx with postgres. It only support tokio runtime in this moment.

How to use it

You should first create TestDB data structure in your tests. It will automcatically create a database and a connection pool for you. Then you could get the connection string or connection pool from it to use on your own code. When TestDB gets drop, it will automcatically drop the database.

#[tokio::test]
async fn some_test() {
    let tdb = TestDB::new("postgers://postgrses:postgres@localhost:5432", "./migrations");
    let pool = tdb.get_pool().await;
    // do you test logic

    // the code finish in this test, tdb will drop the database which it create.
}

Have fun with this crate!

License

This project is distributed under the terms of MIT license.

Dependencies

~20–33MB
~586K SLoC