mirror of
https://github.com/space-wizards/space-station-14.git
synced 2026-02-14 19:29:53 +01:00
Ban database refactor (#42495) * Ban DB refactor seems to work at a basic level for PostgreSQL * New ban creation API Supports all the new functionality (multiple players/addresses/hwids/roles/rounds per ban). * Make the migration irreversible * Re-implement ban notifications The server ID check is no longer done as admins may want to place bans spanning multiple rounds irrelevant of the source server. * Fix some split query warnings * Implement migration on SQLite * More comments * Remove required from ban reason SS14.Admin changes would like this * More missing AsSplitQuery() calls * Fix missing ban type filter * Fix old CreateServerBan API with permanent time * Fix department and role ban commands with permanent time * Re-add banhits navigation property Dropped this on accident, SS14.Admin needs it. * More ban API fixes. * Don't fetch ban exemption info for role bans Not relevant, reduces query performance * Regenerate migrations * Fix adminnotes command for players that never connected Would blow up handling null player records. Not a new bug introduced by the refactor, but I ran into it. * Great shame... I accidentally committed submodule update... * Update GDPR scripts * Fix sandbox violation * Fix bans with duplicate info causing DB exceptions Most notably happened with role bans, as multiple departments may include the same role.
38 lines
1003 B
C#
38 lines
1003 B
C#
using System.Linq;
|
|
using System.Linq.Expressions;
|
|
using Microsoft.EntityFrameworkCore;
|
|
|
|
namespace Content.Server.Database;
|
|
|
|
internal static class EFCoreExtensions
|
|
{
|
|
extension<TEntity>(IQueryable<TEntity> query) where TEntity : class
|
|
{
|
|
public IQueryable<TEntity> ApplyIncludes(
|
|
IEnumerable<Expression<Func<TEntity, object>>> properties)
|
|
{
|
|
var q = query;
|
|
foreach (var property in properties)
|
|
{
|
|
q = q.Include(property);
|
|
}
|
|
|
|
return q;
|
|
}
|
|
|
|
public IQueryable<TEntity> ApplyIncludes<TDerived>(
|
|
IEnumerable<Expression<Func<TDerived, object>>> properties,
|
|
Expression<Func<TEntity, TDerived>> getDerived)
|
|
where TDerived : class
|
|
{
|
|
var q = query;
|
|
foreach (var property in properties)
|
|
{
|
|
q = q.Include(getDerived).ThenInclude(property);
|
|
}
|
|
|
|
return q;
|
|
}
|
|
}
|
|
}
|