lamadelrae/schemabuilder

Project for versioning databases. Using fluent interfaces.

Schema builder project in .NET 6.

Syntax:

---

public class SomeScript : Script
{
	public SomeScript() : base(1)
	{
		Add().Table("TableName")
			.Column("Test", x => x.Int());
	}
}

public class AnotherScript : Script
{
	public AnotherScript() : base(2)
	{
		Add().Column("ColumnName", x => x.Guid())
			.To("TableName");
	}
}

public class Renaming : Script
{
	public Renaming() : base(3)
	{
		// Has to have same structure.
		Rename()
			.Table("SomeTable")
			.To("AnotherTable");

		Rename()
			.Column("SomeColumn").In("Table")
			.To("AnotherTable");
	}
}

public class ComplexScript : Script
{
	public ComplexScript() : base(4)
	{
		Drop().Table("SomeTable").
		Drop().Column("SomeColumn").In("SomeTable");

		Add().Table("NewTable")
			 .Column("Id", x => x.Guid())
			 .Column("IsDeleted", x => x.Bool())
			 .Column("CreatedAt", x => x.DateTime());
	}
}

---

As you can see, we have a structure where each class is a script, and when you instantiate the Script, you have to inform the script id.

Internally, the schema builder is going to order these scripts by their id and execute them, so it is very important to never alter the order of the scripts.

SchemaBuilder will create an internal table to store all the Scripts so it knows what to run and what not to run.

---