ObjectEditor/DatabaseTools/Services/DatabaseExportService.cs at 85f54b8741defbeeb5c6106ef8f88947d9434745 · OpenLoco/ObjectEditor · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
using Common.Json;
using Definitions.Database;
using Definitions.SourceData;
using Microsoft.EntityFrameworkCore;
using System.Text.Json;

namespace DatabaseTools.Services;

public static class DatabaseExportService
{
	public static Task ExportAllAsync(ToolsSettings settings, Action<string> log)
		=> Task.Run(() =>
		{
			using var db = BaseLocoDbContext.GetDbFromFile(settings.DatabaseFile)
				?? throw new InvalidOperationException($"Database not found at {settings.DatabaseFile}");

			log("Loading from database...");
			_ = Directory.CreateDirectory(settings.JsonDirectory);

			var jsonOptions = JsonFile.DefaultSerializerOptions;

			var authors = JsonSerializer.Serialize<IEnumerable<string>>(
				db.Authors.Select(a => a.Name).ToList().Order(),
				jsonOptions);
			var tags = JsonSerializer.Serialize<IEnumerable<string>>(
				db.Tags.Select(t => t.Name).ToList().Order(),
				jsonOptions);
			var licences = JsonSerializer.Serialize<IEnumerable<LicenceJsonRecord>>(
				db.Licences.Select(l => new LicenceJsonRecord(l.Name, l.Text)).ToList().OrderBy(l => l.Name),
				jsonOptions);

			var sc5Files = db.SC5Files
				.Include(l => l.Licence)
				.Select(x => new ExpandedTbl<TblSC5File, TblSC5FilePack>(x, x.Authors, x.Tags, x.SC5FilePacks))
				.ToList()
				.OrderBy(x => x.Object.Name)
				.Select(o => new SC5FileJsonRecord(
					o.Object.Name,
					o.Object.Description,
					[.. o.Authors.Select(a => a.Name)],
					[.. o.Tags.Select(t => t.Name)],
					o.Object.Licence?.Name,
					o.Object.CreatedDate,
					o.Object.ModifiedDate,
					o.Object.UploadedDate,
					o.Object.ObjectSource));
			var sc5FilesJson = JsonSerializer.Serialize(sc5Files, jsonOptions);

			var sc5FilePacks = db.SC5FilePacks
				.Include(l => l.Licence)
				.Select(x => new ExpandedTblPack<TblSC5FilePack, TblSC5File>(x, x.SC5Files, x.Authors, x.Tags))
				.ToList()
				.OrderBy(x => x.Pack.Name)
				.Select(o => new SC5FilePackJsonRecord(
					o.Pack.Name,
					o.Pack.Description,
					[.. o.Authors.Select(a => a.Name)],
					[.. o.Tags.Select(t => t.Name)],
					o.Pack.Licence?.Name,
					o.Pack.CreatedDate,
					o.Pack.ModifiedDate,
					o.Pack.UploadedDate));
			var sc5FilePacksJson = JsonSerializer.Serialize(sc5FilePacks, jsonOptions);

			var objectPacks = db.ObjectPacks
				.Include(l => l.Licence)
				.Select(x => new ExpandedTblPack<TblObjectPack, TblObject>(x, x.Objects, x.Authors, x.Tags))
				.ToList()
				.OrderBy(x => x.Pack.Name)
				.Select(o => new ObjectPackJsonRecord(
					o.Pack.Name,
					o.Pack.Description,
					[.. o.Authors.Select(a => a.Name)],
					[.. o.Tags.Select(t => t.Name)],
					o.Pack.Licence?.Name,
					o.Pack.CreatedDate,
					o.Pack.ModifiedDate,
					o.Pack.UploadedDate));
			var objectPacksJson = JsonSerializer.Serialize(objectPacks, jsonOptions);

			var objects = db.DatObjects
				.Include(x => x.Object)
				.Include(x => x.Object.Licence)
				.Select(x => new ExpandedTbl<TblObject, TblObjectPack>(x.Object, x.Object.Authors, x.Object.Tags, x.Object.ObjectPacks))
				.ToList()
				.OrderBy(x => x.Object.Name)
				.Select(o => new ObjectMetadata(
					o.Object.Name,
					o.Object.Description,
					[.. o.Authors.Select(a => a.Name)],
					[.. o.Tags.Select(t => t.Name)],
					[.. o.Packs.Select(m => m.Name)],
					o.Object.Licence?.Name,
					o.Object.Availability,
					o.Object.CreatedDate,
					o.Object.ModifiedDate,
					o.Object.UploadedDate,
					o.Object.ObjectSource));
			var objectsJson = JsonSerializer.Serialize(objects, jsonOptions);

			log("Writing JSON files…");
			File.WriteAllText(Path.Combine(settings.JsonDirectory, "authors.json"), authors);
			File.WriteAllText(Path.Combine(settings.JsonDirectory, "tags.json"), tags);
			File.WriteAllText(Path.Combine(settings.JsonDirectory, "licences.json"), licences);
			File.WriteAllText(Path.Combine(settings.JsonDirectory, "objectPacks.json"), objectPacksJson);
			File.WriteAllText(Path.Combine(settings.JsonDirectory, "objectMetadata.json"), objectsJson);
			File.WriteAllText(Path.Combine(settings.JsonDirectory, "sc5Files.json"), sc5FilesJson);
			File.WriteAllText(Path.Combine(settings.JsonDirectory, "sc5FilePacks.json"), sc5FilePacksJson);
			log($"Done. Wrote 7 files to {settings.JsonDirectory}");
		});
}