59 lines
2.2 KiB
C#
59 lines
2.2 KiB
C#
using System;
|
|
using System.IO;
|
|
using System.Text.Json;
|
|
using System.Threading.Tasks;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using NexusReader.Data.Persistence;
|
|
using Xunit;
|
|
|
|
namespace NexusReader.Application.Tests.Queries;
|
|
|
|
public class CheckDatabaseTest
|
|
{
|
|
[Fact]
|
|
public async Task PrintDatabaseStats()
|
|
{
|
|
var configJson = await File.ReadAllTextAsync("../../../../../src/NexusReader.Web/appsettings.json");
|
|
var doc = JsonDocument.Parse(configJson);
|
|
var pgConn = doc.RootElement.GetProperty("ConnectionStrings").GetProperty("PostgresConnection").GetString();
|
|
|
|
Console.WriteLine($"Postgres Connection: {pgConn}");
|
|
|
|
var optionsBuilder = new DbContextOptionsBuilder<AppDbContext>();
|
|
optionsBuilder.UseNpgsql(pgConn);
|
|
|
|
using var context = new AppDbContext(optionsBuilder.Options);
|
|
|
|
var usersCount = await context.Users.CountAsync();
|
|
var ebooksCount = await context.Ebooks.CountAsync();
|
|
var unitsCount = await context.KnowledgeUnits.CountAsync();
|
|
var cacheCount = await context.SemanticKnowledgeCache.CountAsync();
|
|
|
|
Console.WriteLine($"=== DATABASE STATS ===");
|
|
Console.WriteLine($"Users: {usersCount}");
|
|
Console.WriteLine($"Ebooks: {ebooksCount}");
|
|
Console.WriteLine($"KnowledgeUnits: {unitsCount}");
|
|
Console.WriteLine($"SemanticKnowledgeCache: {cacheCount}");
|
|
|
|
var users = await context.Users.ToListAsync();
|
|
foreach (var u in users)
|
|
{
|
|
Console.WriteLine($"User: {u.Email}, TenantId: '{u.TenantId}'");
|
|
}
|
|
|
|
var ebooks = await context.Ebooks.ToListAsync();
|
|
foreach (var eb in ebooks)
|
|
{
|
|
Console.WriteLine($"Ebook Id: {eb.Id}, Title: '{eb.Title}', FilePath: '{eb.FilePath}', Ready: {eb.IsReadyForReading}");
|
|
}
|
|
|
|
var cache = await context.SemanticKnowledgeCache.ToListAsync();
|
|
foreach (var c in cache)
|
|
{
|
|
Console.WriteLine($"Cache Hash: {c.ContentHash}, TenantId: '{c.TenantId}', PromptVersion: {c.PromptVersion}, JsonData Preview: {c.JsonData.Substring(0, Math.Min(c.JsonData.Length, 150))}");
|
|
}
|
|
|
|
Assert.True(true);
|
|
}
|
|
}
|