blob: de9cc9d9a6c8724f092d560d86ea4ce5ed53df05 (
plain)
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
|
/*
* Copyright (c) 2023 Vaughn Nugent
*
* Library: VNLib
* Package: Emails.Transactional
* File: EmailDbCtx.cs
*
* EmailDbCtx.cs is part of Emails.Transactional which is part of the larger
* VNLib collection of libraries and utilities.
*
* Emails.Transactional is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published
* by the Free Software Foundation, either version 2 of the License,
* or (at your option) any later version.
*
* Emails.Transactional is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with Emails.Transactional. If not, see http://www.gnu.org/licenses/.
*/
using System;
using Microsoft.EntityFrameworkCore;
using VNLib.Plugins.Extensions.Data;
using VNLib.Plugins.Extensions.Loading.Sql;
namespace Emails.Transactional
{
internal class EmailDbCtx : TransactionalDbContext, IDbTableDefinition
{
public DbSet<EmailTransaction> EmailTransactions { get; set; }
public EmailDbCtx(DbContextOptions options) : base(options)
{}
public EmailDbCtx()
{ }
public void OnDatabaseCreating(IDbContextBuilder builder, object? userState)
{
//Define email tables
builder.DefineTable<EmailTransaction>(nameof(EmailTransactions))
//Start with id, its a primary key
.WithColumn(e => e.Id)
.MaxLength(50)
.Next()
.WithColumn(e => e.Created)
.AllowNull(false)
.Next()
.WithColumn(e => e.LastModified)
.AllowNull(false)
.Next()
.WithColumn(e => e.UserId)
.MaxLength(100)
.Next()
//To is allowed to be null
.WithColumn(e => e.To)
.MaxLength(1000)
.Next()
.WithColumn(e => e.From)
.MaxLength(100)
.Next()
.WithColumn(e => e.FromName)
.MaxLength(100)
.Next()
.WithColumn(e => e.Subject)
.MaxLength(500)
.Next()
.WithColumn(e => e.Ccs)
.MaxLength(1000)
.Next()
.WithColumn(e => e.Bccs)
.MaxLength(1000)
.Next()
.WithColumn(e => e.ReplyTo)
.MaxLength(100)
.Next()
.WithColumn(e => e.ReplyToName)
.MaxLength(100)
.Next()
.WithColumn(e => e.TemplateId)
.MaxLength(100)
.Next()
.WithColumn(e => e.Result)
.MaxLength(200);
}
}
}
|