private async Task AppMigrate(AppService appService, DbCtx dbctx, ILogger logger)
{
dbctx.Database.BeginTransaction();
var val = await dbctx.GetConfig("appver");
var origVal = val;
// if (val == null)
// {
// val = "1";
// }
// if (val == "1")
// {
// int count = 0;
// foreach (var item in dbctx.Tracks.AsNoTracking())
// {
// try
// {
// if (item.TryGetStoragePath(appService, out var path))
// {
// item.size = (int)new FileInfo(path).Length;
// dbctx.Entry(item).State = EntityState.Modified;
// if (++count % 100 == 0) await dbctx.SaveChangesAsync();
// }
// }
// catch (System.Exception ex)
// {
// logger.LogWarning(ex, "getting file length from track id {id}", item.id);
// }
// }
// await dbctx.SaveChangesAsync();
// logger.LogInformation("saved file length for {count} files", count);
// val = "2";
// }
// if (val == "2") {
// await dbctx.Database.ExecuteSqlRawAsync("UPDATE tracks SET album = \"\", albumArtist = \"\", groupId = id;");
// val = "3";
// }
// if (val == "3") {
// int count = 0;
// foreach (var track in dbctx.Tracks.Include(t => t.fileRecord))
// {
// track.fileRecord = new StoredFile {
// path = track.url,
// size = track.size
// };
// if (track.files != null)
// track.trackFiles = track.files.Select(x => {
// var cloned = x.Clone();
// cloned.Track = track;
// cloned.File = new StoredFile {
// path = track.url + "." + cloned.ConvName,
// size = cloned.Size
// };
// return cloned;
// }).ToList();
// else
// track.trackFiles = new List<TrackFile>();
// track.trackFiles.Insert(0, new TrackFile{
// Track = track,
// ConvName = "",
// Bitrate = track.length == 0 ? 0 : (int)(track.fileRecord.size * 8 / track.length / 1024),
// File = track.fileRecord,
// Format = track.fileRecord.path.Substring(track.fileRecord.path.LastIndexOf('.') + 1)
// });
// dbctx.TrackFiles.AddRange(track.trackFiles);
// dbctx.Files.AddRange(track.trackFiles.Select(t => t.File));
// dbctx.Entry(track).State = EntityState.Modified;
// if (++count % 100 == 0) await dbctx.SaveChangesAsync();
// }
// await dbctx.SaveChangesAsync();
// logger.LogInformation("updated StoredFile for {count} tracks", count);
// val = "4";
// }
if (val == null)
{
val = "4";
}
if (val != "4")
{
throw new Exception($"Unsupported appver \"{val}\"");
}
if (val != origVal)
{
logger.LogInformation("appver changed from {orig} to {val}", origVal, val);
await dbctx.SetConfig("appver", val);
}
dbctx.Database.CommitTransaction();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, AppService appService, DbCtx dbctx, ILogger <Startup> logger)
{
app.UseForwardedHeaders();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseCors(builder => builder.AllowAnyOrigin().AllowAnyMethod().AllowAnyHeader());
dbctx.Database.Migrate();
AppMigrate(appService, dbctx, logger).Wait();
AppCheckFirstRun(appService, dbctx, logger);
if (string.IsNullOrEmpty(MyConfigration.Passcode) == false)
{
app.UsePasscode(new SimplePasscodeOptions
{
CookieName = "mcloud_passcode",
Passcode = MyConfigration.Passcode,
Filter = ctx => !ctx.Request.Path.StartsWithSegments("/api/storage") &&
!ctx.Request.Path.StartsWithSegments("/.well-known")
});
}
if (MyConfigration.StaticDir != null)
{
var fileProvider = new PhysicalFileProvider(Path.Combine(Directory.GetCurrentDirectory(), MyConfigration.StaticDir));
app.UseDefaultFiles(new DefaultFilesOptions
{
FileProvider = fileProvider,
DefaultFileNames = new[] { "index.html" }
});
app.UseStaticFiles(new StaticFileOptions
{
FileProvider = fileProvider,
ServeUnknownFileTypes = true
});
}
if (string.IsNullOrEmpty(MyConfigration.StorageDir) == false)
{
string path = Path.Combine(Directory.GetCurrentDirectory(), MyConfigration.StorageDir);
Directory.CreateDirectory(path);
var fp = new StaticFileOptions
{
FileProvider = new PhysicalFileProvider(path),
RequestPath = "/api/storage",
ServeUnknownFileTypes = true
};
app.Use(async(ctx, next) =>
{
if (ctx.Request.Path.StartsWithSegments("/api/storage"))
{
ctx.Response.Headers.Add("Cache-Control", "public");
}
await next();
});
app.UseStaticFiles(fp);
}
app.Use((ctx, next) =>
{
if (ctx.Request.Path.StartsWithSegments("/api/my", out var remaining))
{
ctx.Request.Path = "/api/users/me" + remaining;
}
return(next());
});
app.UseWebSockets();
app.Use((next) => async(ctx) =>
{
if (ctx.Request.Path == "/api/ws" && ctx.WebSockets.IsWebSocketRequest)
{
var ws = await ctx.WebSockets.AcceptWebSocketAsync();
await ctx.RequestServices.GetService <MessageService>().HandleWebSocket(ws);
}
else
{
await next(ctx);
}
});
app.UseRouting();
app.UseAuthentication();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public bool TryGetStoragePath(AppService app, out string path) => app.Config.TryResolveStoragePath(this.url, out path);