EEMS/Test/DBTest.cs

using DataService;
using SqlSugar;
using SqlSugarORM;
using System.Text.Json;

namespace Test
{
    internal class DBTest
    {
        public static void Test()
        {
            SqlSugarCustom orm = new();

            orm.Initialize(null);
            string dbString = "Database=thermaldb;Password=123456;Host=localhost;Username=postgres;Persist Security Info=True";
            //string dbString = "Database=Kepler;Password=123456;Host=localhost;Username=postgres;Persist Security Info=True";
            if (!orm.Open(dbString, DbType.PostgreSQL, true))
                return;

            dynamic[] t = orm._Client!.Queryable<dynamic>().AS("\"20250627.System\"").Take(1).ToArray();
            //dynamic[] t = orm._Client!.Queryable<dynamic>().AS("\"20250626.Data\"").Take(1).ToArray();

            GeneralProcessData processData = new(0);
            if (!processData.ToDictionary(t, out Dictionary<string, object>? outputs) || outputs is null)
                return;

            
            foreach (var item in outputs)
            {
                //string s = JsonSerializer.Serialize(item);
                //Console.WriteLine(s);
     
            }
            //int totalCount = 0;
            //int totalPages = 0;
            //dynamic[] page = orm._Client!.Queryable<dynamic>().AS("\"20250626.Data\"").ToPageList(1, 1000, ref totalCount, ref totalPages).ToArray();
        }
    }
}