DbMedia.cs


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

using Microsoft.AspNetCore.Mvc.ModelBinding.Binders;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Net.NetworkInformation;

namespace HyperBooru;

public class DbMedia : DbObject {
    public         string               Checksum         { get; set; }
    public         string               MimeType         { get; set; }
    public         string?              ShortDescription { get; set; }
    public         string?              LongDescription  { get; set; }
    public virtual List<DbUploadedFile> UploadedFiles    { get; set; } = new();

    public DbMedia() =>
        base.ObjectType = ObjectType.Media;

    public string? DisplayName {
        get {
            if(ShortDescription is not null)
                return ShortDescription;

            return UploadedFiles
                .OrderBy(f => f.UploadTime)
                .First()?.Filename;
        }
    }
}

public record DbUploadedFile {
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public         int         UploadedFileId   { get; set; }
    public         string      OriginalChecksum { get; set; }
    public         string?     Filename         { get; set; }
    public         DateTime    UploadTime       { get; set; } = DateTime.Now;
    public         DateTime?   LastAccessTime   { get; set; }
    public         DateTime?   LastWriteTime    { get; set; }
    public         DateTime?   CreateTime       { get; set; }
    public virtual DbMedia     Media            { get; set; }
}