gistlyn · May 17, 2024 05:27
diff --git a/_init b/_init
 dotnet add package ServiceStack.OrmLite.Sqlite.Data
diff --git a/Configure.Db.cs b/Configure.Db.cs
 using Microsoft.Extensions.Configuration;
 using Microsoft.Extensions.DependencyInjection;
 using ServiceStack;
 using ServiceStack.Data;
 using ServiceStack.DataAnnotations;
 using ServiceStack.OrmLite;

 [assembly: HostingStartup(typeof(MyApp.ConfigureDb))]

 namespace MyApp;

 public class ConfigureDb : IHostingStartup
 {
    public void Configure(IWebHostBuilder builder) => builder
        .ConfigureServices((context, services) => {
            services.AddSingleton<IDbConnectionFactory>(new OrmLiteConnectionFactory(
                context.Configuration.GetConnectionString("DefaultConnection")
                ?? ":memory:",
                SqliteDialect.Provider));
        })
        .ConfigureAppHost(appHost => {
            // Enable built-in Database Admin UI at /admin-ui/database
            // appHost.Plugins.Add(new AdminDatabaseFeature());
        });
 }
diff --git a/Configure.Db.Migrations.cs b/Configure.Db.Migrations.cs
 using MyApp.Migrations;
 using ServiceStack;
 using ServiceStack.Data;
 using ServiceStack.OrmLite;

 [assembly: HostingStartup(typeof(MyApp.ConfigureDbMigrations))]

 namespace MyApp;

 // Code-First DB Migrations: https://docs.servicestack.net/ormlite/db-migrations
 public class ConfigureDbMigrations : IHostingStartup
 {
    public void Configure(IWebHostBuilder builder) => builder
        .ConfigureAppHost(afterAppHostInit:appHost => {
            var migrator = new Migrator(appHost.Resolve<IDbConnectionFactory>(), typeof(Migration1000).Assembly);
            AppTasks.Register("migrate", _ => migrator.Run());
            AppTasks.Register("migrate.revert", args => migrator.Revert(args[0]));
            AppTasks.Run();
        });
 }
diff --git a/Migrations\Migration1000.cs b/Migrations\Migration1000.cs
 using ServiceStack.DataAnnotations;
 using ServiceStack.OrmLite;

 namespace MyApp.Migrations;

 public class Migration1000 : MigrationBase
 {
    public class MyTable
    {
        [AutoIncrement]
        public int Id { get; set; }
        public string Name { get; set; }
    }

    public override void Up()
    {
        Db.CreateTable<MyTable>();
    }

    public override void Down()
    {
        Db.DropTable<MyTable>();
    }
 }
diff --git a/package.json.patch b/package.json.patch
 [
    { "op":"add", "path":"/scripts/postinstall", "value":"dotnet run --AppTasks=migrate" },
    { "op":"add", "path":"/scripts/migrate",     "value":"dotnet run --AppTasks=migrate" },
    { "op":"add", "path":"/scripts/revert:last", "value":"dotnet run --AppTasks=migrate.revert:last" },
    { "op":"add", "path":"/scripts/revert:all",  "value":"dotnet run --AppTasks=migrate.revert:all" },
 ]
	using Microsoft.Extensions.Configuration;
	using Microsoft.Extensions.DependencyInjection;
	using ServiceStack;
	using ServiceStack.Data;
	using ServiceStack.DataAnnotations;
	using ServiceStack.OrmLite;

	[assembly: HostingStartup(typeof(MyApp.ConfigureDb))]

	namespace MyApp;

	public class ConfigureDb : IHostingStartup
	{
	public void Configure(IWebHostBuilder builder) => builder
	.ConfigureServices((context, services) => {
	services.AddSingleton<IDbConnectionFactory>(new OrmLiteConnectionFactory(
	context.Configuration.GetConnectionString("DefaultConnection")
	?? ":memory:",
	SqliteDialect.Provider));
	})
	.ConfigureAppHost(appHost => {
	// Enable built-in Database Admin UI at /admin-ui/database
	// appHost.Plugins.Add(new AdminDatabaseFeature());
	});
	}
	using MyApp.Migrations;
	using ServiceStack;
	using ServiceStack.Data;
	using ServiceStack.OrmLite;

	[assembly: HostingStartup(typeof(MyApp.ConfigureDbMigrations))]

	namespace MyApp;

	// Code-First DB Migrations: https://docs.servicestack.net/ormlite/db-migrations
	public class ConfigureDbMigrations : IHostingStartup
	{
	public void Configure(IWebHostBuilder builder) => builder
	.ConfigureAppHost(afterAppHostInit:appHost => {
	var migrator = new Migrator(appHost.Resolve<IDbConnectionFactory>(), typeof(Migration1000).Assembly);
	AppTasks.Register("migrate", _ => migrator.Run());
	AppTasks.Register("migrate.revert", args => migrator.Revert(args[0]));
	AppTasks.Run();
	});
	}
	using ServiceStack.DataAnnotations;
	using ServiceStack.OrmLite;

	namespace MyApp.Migrations;

	public class Migration1000 : MigrationBase
	{
	public class MyTable
	{
	[AutoIncrement]
	public int Id { get; set; }
	public string Name { get; set; }
	}

	public override void Up()
	{
	Db.CreateTable<MyTable>();
	}

	public override void Down()
	{
	Db.DropTable<MyTable>();
	}
	}
	[
	{ "op":"add", "path":"/scripts/postinstall", "value":"dotnet run --AppTasks=migrate" },
	{ "op":"add", "path":"/scripts/migrate", "value":"dotnet run --AppTasks=migrate" },
	{ "op":"add", "path":"/scripts/revert:last", "value":"dotnet run --AppTasks=migrate.revert:last" },
	{ "op":"add", "path":"/scripts/revert:all", "value":"dotnet run --AppTasks=migrate.revert:all" },
	]