2024-11-13 18:18:28 +08:00

76 lines
1.6 KiB
C#

using FreeSql.DataAnnotations;
using System;
using Xunit;
namespace FreeSql.Tests.Custom.PostgreSQL
{
public class PostgreSQLAdoTest
{
[Fact]
public void Pool()
{
var t1 = g.pgsql.Ado.MasterPool.StatisticsFullily;
}
[Fact]
public void SlavePools()
{
var t2 = g.pgsql.Ado.SlavePools.Count;
}
[Fact]
public void ExecuteTest()
{
Assert.True(g.pgsql.Ado.ExecuteConnectTest());
}
[Fact]
public void ExecuteReader()
{
}
[Fact]
public void ExecuteArray()
{
}
[Fact]
public void ExecuteNonQuery()
{
}
[Fact]
public void ExecuteScalar()
{
}
[Fact]
public void Query()
{
g.pgsql.CodeFirst.SyncStructure<xxx>();
var t3 = g.pgsql.Ado.Query<xxx>("select * from xxx");
var t4 = g.pgsql.Ado.Query<(int, string, string)>("select * from xxx");
var t5 = g.pgsql.Ado.Query<dynamic>("select * from xxx");
}
[Fact]
public void QueryMultipline()
{
g.pgsql.CodeFirst.SyncStructure<xxx>();
var t3 = g.pgsql.Ado.Query<xxx, (int, string, string), dynamic>("select * from xxx; select * from xxx; select * from xxx");
}
class xxx
{
public string Id { get; set; }
public string Path { get; set; }
public string Title2 { get; set; }
public string testf { get; set; }
}
}
}