Respawn - GitLite

KO | EN

gitlite — search

#python #ai #typescript #llm #golang #android #machine-learning #rust #linux #docker #macos #windows #vue #ios

Respawn

(★ 3,019)

Intelligent database cleaner for integration tests

File Explorer

Download Latest Version (.zip)

- - ci.yml
  - release.yml
- NuGet.Config
- NuGet.exe
- NuGet.targets
- my_post.sh
- onconfig
- sqlhosts
- - GraphBuilder.cs
  - Relationship.cs
  - Table.cs
  - TemporalTable.cs
- - AssemblyInfo.cs
- DB2DbAdapter.cs
- DbAdapter.cs
- IDbAdapter.cs
- InformixDbAdapter.cs
- IsExternalInit.cs
- logo.png
- MySqlAdapter.cs
- OracleDbAdapter.cs
- PostgresDbAdapter.cs
- Respawn.csproj
- Respawner.cs
- RespawnerOptions.cs
- SnowflakeDbAdapter.cs
- SqliteDbAdapter.cs
- SqlServerDbAdapter.cs
- - AssemblyInfo.cs
- App.config
- DB2Fixture.cs
- DB2Tests.cs
- DbFixture.cs
- EmptyDbTests.cs
- InformixFixture.cs
- InformixTests.cs
- MySqlFixture.cs
- MySqlTests.cs
- OracleFixture.cs
- OracleTests.cs
- PostgresFixture.cs
- PostgresTests.cs
- Respawn.DatabaseTests.csproj
- SkipOnCIAttribute.cs
- SnowflakeTests.cs
- SqliteTests.cs
- SqlServerFixture.cs
- SqlServerTests.cs
- GraphTests.cs
- Respawn.UnitTests.csproj
.gitattributes
.gitignore
Build.ps1
Directory.Build.props
Directory.Build.targets
LICENSE
logo.png
Push.ps1
README.md
Respawn.sln

# Installation Guide

1. Get the code

git clone https://github.com/jbogard/Respawn

Downloads the entire project code from GitHub to your computer.

cd Respawn

Moves into the project folder you just downloaded.

2. .NET

Medium Recommended

Prerequisites

Git Needed to download the project code from GitHub.
.NET SDK The SDK required for the dotnet command.

dotnet add package Respawn

Type this command into your terminal and run it.

✅ After dotnet run, check the message or address shown in the terminal.

Pulled directly from this repo's README.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Respawn

![CI](https://github.com/jbogard/Respawn/workflows/CI/badge.svg)
[![NuGet](https://img.shields.io/nuget/dt/respawn.svg)](https://www.nuget.org/packages/respawn) 
[![NuGet](https://img.shields.io/nuget/vpre/respawn.svg)](https://www.nuget.org/packages/respawn)
[![MyGet (dev)](https://img.shields.io/myget/respawn-ci/v/respawn.svg)](https://myget.org/gallery/respawn-ci)

Respawn is a small utility to help in resetting test databases to a clean state. Instead of deleting data at the end of a test or rolling back a transaction, Respawn [resets the database back to a clean, empty state](http://lostechies.com/jimmybogard/2013/06/18/strategies-for-isolating-the-database-in-tests/) by intelligently deleting data from tables.

To use, create a `Respawner` and initialize with tables you want to skip, or schemas you want to keep/ignore:

```csharp
var respawner = await Respawner.CreateAsync(connection, new RespawnerOptions
{
    TablesToIgnore = new Table[]
    {
        "sysdiagrams",
        "tblUser",
        "tblObjectType",
        new Table("MyOtherSchema", "MyOtherTable")
    },
    SchemasToExclude = new []
    {
        "RoundhousE"
    }
});
```
Or if you want to use a different database:
```csharp
var respawner = await Respawner.CreateAsync(connection, new RespawnerOptions
{
    SchemasToInclude = new []
    {
        "public"
    },
    DbAdapter = DbAdapter.Postgres // 👈 optional, inferred from the connection for SQL Server, PostgreSQL, MySQL, Oracle and Informix
});
```

In your tests, in the fixture setup, reset to a clean state:
```csharp
await respawner.ResetAsync("MyConnectionStringName");
```
or if you're using a database besides SQL Server, pass an open `DbConnection`:
```csharp
using (var conn = new NpgsqlConnection("ConnectionString"))
{
    await conn.OpenAsync();

await respawner.ResetAsync(conn);
}
```

## How does it work?
Respawn examines the SQL metadata intelligently to build a deterministic order of tables to delete based on foreign key relationships between tables. It navigates these relationships to build a DELETE script starting with the tables with no relationships and moving inwards until all tables are accounted for.

Once this in-order list of tables is created in the `CreateAsync` factory, the Respawner object keeps this list of tables privately so that the list of tables and the order is only calculated once.

In your tests, you Reset your database before each test run. If there are any tables/schemas that you don't want to be cleared out, include these in the configuration of your RespawnerOptions.

In benchmarks, a deterministic deletion of tables is faster than truncation, since truncation requires disabling or deleting foreign key constraints. Deletion results in easier test debugging/maintenance, as transaction rollbacks/post-test deletion still rely on that mechanism at the beginning of each test. If data comes in from another source, your test might fail. Respawning to a clean state assures you have a known starting point before each test.

### Installing Respawn

You should install [Respawn with NuGet](https://www.nuget.org/packages/Respawn):

Install-Package Respawn

Or via the .NET Core CLI:

dotnet add package Respawn

This command from Package Manager Console will download and install Respawn.

### Local development

To install and run local dependencies needed for tests, (PostgreSQL and MySQL) install Docker for Windows and from the command line at the solution root run:

```
docker-compose up -d
```

This will pull down the latest container images and run them. You can then run the local build/tests.