blob: 4005f7b39d89f68a14159a07287661e43c8dfb4a (
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
|
/*
* Copyright (c) 2023 Vaughn Nugent
*
* Library: VNLib
* Package: Emails.Transactional
* File: TransactionStore.cs
*
* TransactionStore.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 System.Linq;
using Microsoft.EntityFrameworkCore;
using VNLib.Plugins.Extensions.Data;
using VNLib.Plugins.Extensions.Data.Abstractions;
namespace Emails.Transactional.Transactions
{
internal class TransactionStore : DbStore<EmailTransaction>
{
private readonly DbContextOptions Options;
public TransactionStore(DbContextOptions options)
{
Options = options;
}
///<inheritdoc/>
public override IDbContextHandle GetNewContext() => new EmailDbCtx(Options);
///<inheritdoc/>
public override string GetNewRecordId() => Guid.NewGuid().ToString("N");
///<inheritdoc/>
public override void OnRecordUpdate(EmailTransaction newRecord, EmailTransaction oldRecord)
{
oldRecord.LastModified = DateTime.UtcNow;
}
public override IDbQueryLookup<EmailTransaction> QueryTable { get; } = new DbQueries();
private sealed record class DbQueries : IDbQueryLookup<EmailTransaction>
{
public IQueryable<EmailTransaction> GetCollectionQueryBuilder(IDbContextHandle context, params string[] constraints)
{
string userId = constraints[0];
//Get the last transactions for the specifed user
EmailDbCtx ctx = (context as EmailDbCtx)!;
return from trans in ctx.EmailTransactions
where trans.UserId == userId
orderby trans.LastModified descending
select trans;
}
public IQueryable<EmailTransaction> GetSingleQueryBuilder(IDbContextHandle context, params string[] constraints)
{
string transactionid = constraints[0];
EmailDbCtx ctx = (context as EmailDbCtx)!;
//Selet the exact transaction from its id
return from trans in ctx.EmailTransactions
where trans.Id == transactionid
select trans;
}
}
}
}
|
