|
public Limit ( DatabaseType type, int limit, int offset, string orderBy ) : |
||
| type | DatabaseType | |
| limit | int | |
| offset | int | |
| orderBy | string | |
| Результат | ||
public static async Task<DTO.Configuration> GetDefaultConfigurationAsync(string tenant)
{
using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase())
{
var sql = new Sql("SELECT * FROM website.configurations");
sql.Where("is_default=@0", true);
sql.Limit(db.DatabaseType, 1, 0, "configuration_id");
var awaiter = await db.SelectAsync<DTO.Configuration>(sql).ConfigureAwait(false);
return awaiter.FirstOrDefault();
}
}
public static async Task<User> GetAsync(string tenant, string email)
{
using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase())
{
var sql = new Sql("SELECT * FROM account.users");
sql.Where("email=@0", email);
sql.Limit(db.DatabaseType, 1, 0, "user_id");
var awaiter = await db.SelectAsync<User>(sql).ConfigureAwait(false);
return awaiter.FirstOrDefault();
}
}
public static async Task<IEnumerable<PublishedContentView>> GetBlogContentsAsync(string tenant, string categoryAlias,
int limit,
int offset)
{
using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase())
{
var sql = new Sql("SELECT * FROM website.published_content_view");
sql.Where("LOWER(category_alias)=@0", categoryAlias);
sql.And("is_blog=@0", true);
sql.Limit(db.DatabaseType, limit, offset, "publish_on");
return await db.SelectAsync<PublishedContentView>(sql).ConfigureAwait(false);
}
}
public static async Task<SmtpConfig> GetConfigAsync(string tenant)
{
using(var db = DbProvider.GetDatabase(tenant))
{
var sql = new Sql("SELECT * FROM config.smtp_configs");
sql.Where("enabled=@0", true);
sql.And("is_default=@0", true);
sql.Limit(db.DatabaseType, 1, 0, "smtp_config_id");
var awaiter = await db.SelectAsync<SmtpConfig>(sql).ConfigureAwait(false);
return awaiter.FirstOrDefault();
}
}
public static async Task<PublishedContentView> GetDefaultAsync(string tenant)
{
using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase())
{
var sql = new Sql("SELECT * FROM website.published_content_view");
sql.Where("is_homepage=@0", true);
sql.Limit(db.DatabaseType, 1, 0, "publish_on");
var awaiter = await db.SelectAsync<PublishedContentView>(sql).ConfigureAwait(false);
return awaiter.FirstOrDefault();
}
}
