#sqlx #postgres #database #test


A simple tool to test sqlx with postgres , It will automatically create a database and a table for testing. and drop the database after testing.

2 releases

0.1.1 Dec 1, 2022
0.1.0 Nov 30, 2022

#1918 in Development tools

MIT license

120 lines


This a tool to test sqlx with postgres,It only support tokio runtime at this moment.

study by tyr Chen

How to use it

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

fn some_awesom_test() {
    let tdb = TestDb::new("localhost", 5432, "postgres", "postgres", "./migrations");
    let pool = tdb.get_pool().await;
    // do something with the pool
    // when tdb gets dropped, the database will be dropped

Have fun with this crate!


This project is distributed under the terms of MIT.

See LICENSE for details.

Copyright 2021 ssk


~606K SLoC