NoSqlMigrator 0.0.5-alpha
dotnet add package NoSqlMigrator --version 0.0.5-alpha
NuGet\Install-Package NoSqlMigrator -Version 0.0.5-alpha
<PackageReference Include="NoSqlMigrator" Version="0.0.5-alpha" />
paket add NoSqlMigrator --version 0.0.5-alpha
#r "nuget: NoSqlMigrator, 0.0.5-alpha"
// Install NoSqlMigrator as a Cake Addin #addin nuget:?package=NoSqlMigrator&version=0.0.5-alpha&prerelease // Install NoSqlMigrator as a Cake Tool #tool nuget:?package=NoSqlMigrator&version=0.0.5-alpha&prerelease
NoSqlMigrator
NoSqlMigrator is a migration framework for .NET, similar to Ruby on Rails Migrations, but heavily inspired by FluentMigrator (though it is NOT a fork or extension to that project).
Migrations are a structured way to alter your database schema structure/organization and are an alternative to creating lots of scripts that have to be run manually by every developer involved. Migrations solve the problem of evolving a database for multiple instances of that databases (for example, the developer's local database, the test database and the production database). Database changes are described in classes written in C# that can be checked into a version control system.
This project is VERY new, but if you have suggestions or improvements (even small things!), they are all very welcome.
Right now this tool ONLY supports Couchbase
Powered By
How to use it
If you've used FluentMigrator before, this should be very familiar.
Create a new C# class library project, add NoSqlMigrator from NuGet.
Create a series of classes (you will likely start with just one, and add them as you need to in future commits).
Compile that library into a DLL file.
Execute the migrations on that DLL file (you can use the NoSqlMigration.Runner, available in the Releases, or you can use the
MigrationRunner
class, and execute the runner from your own code. I'd recommend sticking to the CLI runner).
Classes
Here is an example of a migration.
[Migration(1)]
public class Migration001_CreateInitialScopeAndCollection : Migrate
{
public override void Up()
{
Create.Scope("myScope")
.WithCollection("myCollection1");
}
public override void Down()
{
Delete.Scope("myScope");
}
}
Each class should inherit from Migrate
. Each class should have a Migration(...)
attribute. Typically you would number these sequentially (e.g. 1 for your first migration, 2 for the one you create next week, etc). They don't HAVE to be exactly sequential--you could make the first one 100 and the second one 200 if you'd like.
Each class has an "up" and a "down".
"Up" is responsible for making a change. In the above example, it will create a new scope (and create a new collection within that scope).
"Down" is responsible for reversing that change, which is useful if you need to return to previous versions or undo what you're working on. Note that not everything can be neatly "down"ed.
Migration actions
The migrations within Up and Down use a fluent syntax: Create... Delete... Execute... Update... and so on.
There may be more than one way to do things: for instance, the above example creates a scope and puts a collection in it. You could also just create the scope, and separately run Create.Collection("...")
. Or you could Execute.Sql("...")
with the raw SQL++ to create the collection.
Actions currently available
- Create.Scope
- Create.Collection
- Create.Index
- Delete.Scope
- Delete.Collection
- Delete.FromCollection
- Delete.Index
- Insert.IntoCollection
- Execute.Sql
- Update.Document
- Update.Collection
Each has various optional and required extensions. This is meant to be a fluent interface, so Intellisense will help a lot. You can also refer to the test migrations in the NoSqlMigrator.Tests project (until better documentation comes along).
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- CouchbaseNetClient (>= 3.4.8)
- Polly (>= 7.2.4)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
0.0.5-alpha | 176 | 9/13/2023 |
0.0.4-alpha | 85 | 7/20/2023 |
0.0.3-alpha3 | 77 | 7/14/2023 |
0.0.3-alpha2 | 74 | 7/14/2023 |
0.0.3-alpha | 182 | 7/6/2023 |
0.0.2-alpha | 84 | 6/17/2023 |
0.0.1-alpha | 144 | 12/1/2022 |