public async Task <T> SelectFirst <T>(SqlessSelectRequest request)
{
await OpenSqlConnection();
SqlessSelectSqlBuilder selectSqlProducer = new SqlessSelectSqlBuilder(this, request);
return(await selectSqlProducer.ExecuteScalarAsync <T>(false));
}
public void LoadSelectRequestFromObjectTest()
{
var request = new SqlessSelectRequest();
request.LoadFromType(typeof(User), Tables.User);
Assert.IsTrue(request.Fields.Count > 0);
Assert.AreEqual(request.Fields[0].Field, nameof(User.Uid));
Assert.AreEqual(request.Fields[1].Field, nameof(User.Name));
}
public async Task <List <dynamic> > Select(SqlessSelectRequest request)
{
await OpenSqlConnection();
SqlessSelectSqlBuilder selectSqlProducer = new SqlessSelectSqlBuilder(this, request);
using var dataTable = await selectSqlProducer.ExecuteTableAsync();
return(dataTable.ToList());
}
protected virtual SqlessSelectRequest GetRequest(string[] strs)
{
var result = new SqlessSelectRequest {
Table = AccessTable
};
result.Fields.Add(new Query.SqlessField()
{
Field = UidField
});
return(result);
}
public async Task AccessSelectTest()
{
var request = new SqlessSelectRequest()
{
Table = Tables.User,
PageSize = 2,
Fields = new List <Query.SqlessField>
{
new Query.SqlessField()
{
Field = "Name"
}
}
};
using Sqless sqless = new Sqless(Global.GetOwnerAccessConfig("1"));
var result = await sqless.Select(request);
Assert.IsTrue(result.Count > 0);
}
public async void Init()
{
var request = new SqlessSelectRequest()
{
AccessParams = new string[] { WpfGlobal.LoginUser.Uid, WpfGlobal.LoginUser.Password },
Table = Tables.Order
};
request.LoadFromType(typeof(Order));
try {
var orders = await SqlessClient.Select <Order>(request);
foreach (var order in orders)
{
Orders.Add(order);
}
} catch (SqlessRequestException ex) {
MessageBox.Show(ex.Message);
}
}
public async Task AccessSelectSqlTest()
{
var request = new SqlessSelectRequest()
{
Table = Tables.User,
PageSize = 2,
Fields = new List <Query.SqlessField>
{
new Query.SqlessField()
{
Field = "Name"
}
}
};
using Sqless sqless = new Sqless(Global.GetOwnerAccessConfig("1"));
SqlessSelectSqlBuilder producer = new SqlessSelectSqlBuilder(sqless, request);
var sqlStr = await producer.GetSqlStrTest();
Assert.AreEqual(sqlStr.Replace(" ", " ").Trim(), "SELECT TOP 2 [Name] FROM [User] WHERE [User].[Uid] = '1'");
}
public async Task UpdateOwnerFieldTest()
{
var updateRequest = new SqlessEditRequest()
{
Table = Tables.User,
Fields = new List <SqlessEditField>()
{
new SqlessEditField()
{
Field = "Uid",
Value = "2",
Type = System.Data.DbType.String
}
}
};
using Sqless updateSqless = new Sqless(Global.GetOwnerAccessConfig("1"));
var updateResult = await updateSqless.Update(updateRequest);
Assert.IsTrue(updateResult > 0);
var selectRequest = new SqlessSelectRequest()
{
Table = Tables.User,
Fields = new List <Query.SqlessField>()
{
new SqlessField()
{
Field = "Uid"
}
}
};
using Sqless selectSqless = new Sqless(Global.GetOwnerAccessConfig("1"));
var selectResult = await selectSqless.SelectFirstOrDefault <string>(selectRequest);
Assert.AreEqual(selectResult, "1");
}
public async void Init()
{
var request = new SqlessSelectRequest()
{
AccessParams = new string[] { User.Uid, User.Password },
Table = Tables.Product
};
request.LoadFromType(typeof(Product));
try
{
var products = await SqlessClient.Select <Product>(request);
foreach (var product in products)
{
Products.Add(product);
}
}
catch (SqlessRequestException ex)
{
MessageBox.Show(ex.Message);
}
}
public static async Task <T> SelectFirstOrDefault <T>(SqlessSelectRequest request) => await Post <T>(request, SqlessApiType.SelectFirstOrDefault);
public static async Task <List <T> > Select <T>(SqlessSelectRequest request) => await Post <List <T> >(request, SqlessApiType.Select);
public virtual async Task <ActionResult> SelectFirstOrDefault(SqlessSelectRequest request)
{
using Sqless sqless = await GetSqless(request);
return(Ok((await sqless.Select(request)).FirstOrDefault()));
}
public SqlessSelectSqlBuilder(Sqless sqless, SqlessSelectRequest request)
: base(sqless, request, new SqlessAuth() { Writable = false, Readable = true })
{
}
