public void SetTenantQuotaRow(TenantQuotaRow row, bool exchange)
{
if (row == null) throw new ArgumentNullException("row");
ExecAction(db =>
{
var counter = db.ExecScalar<long>(Query(tenants_quotarow, row.Tenant)
.Select("counter")
.Where("path", row.Path));
db.ExecNonQuery(Insert(tenants_quotarow, row.Tenant)
.InColumnValue("path", row.Path)
.InColumnValue("counter", exchange ? counter + row.Counter : row.Counter)
.InColumnValue("tag", row.Tag)
.InColumnValue("last_modified", DateTime.UtcNow));
});
}
public void SetTenantQuotaRow(TenantQuotaRow row, bool exchange)
{
service.SetTenantQuotaRow(row, exchange);
interval.Expire();
}
public void SetTenantQuotaRow(TenantQuotaRow row, bool exchange)
{
quotaService.SetTenantQuotaRow(row, exchange);
}
public void SetTenantQuotaRow(TenantQuotaRow row, bool exchange)
{
if (row == null) throw new ArgumentNullException("row");
using (var db = GetDb())
using (var tx = db.BeginTransaction())
{
var counter = db.ExecuteScalar<long>(Query(tenants_quotarow, row.Tenant)
.Select("counter")
.Where("path", row.Path));
db.ExecuteNonQuery(Insert(tenants_quotarow, row.Tenant)
.InColumnValue("path", row.Path)
.InColumnValue("counter", exchange ? counter + row.Counter : row.Counter)
.InColumnValue("tag", row.Tag)
.InColumnValue("last_modified", DateTime.UtcNow));
tx.Commit();
}
}
public void SetTenantQuotaRow(TenantQuotaRow row, bool exchange)
{
if (row == null) throw new ArgumentNullException("row");
ExecAction(db =>
{
var counter = db.ExecScalar<long?>(Query(tenants_quotarow, row.Tenant)
.Select("counter")
.Where("path", row.Path));
if (counter.HasValue)
{
db.ExecNonQuery(Update(tenants_quotarow, row.Tenant)
.Set("counter", exchange ? counter.Value + row.Counter : row.Counter)
.Set("last_modified", DateTime.UtcNow)
.Where(Exp.Eq("path", row.Path)));
//db.ExecNonQuery(Insert(tenants_quotarow, row.Tenant)
// .InColumnValue("path", row.Path)
// .InColumnValue("counter", exchange ? counter.Value + row.Counter : row.Counter)
// .InColumnValue("tag", row.Tag)
// .InColumnValue("last_modified", DateTime.UtcNow));
}
else
{
//ok
db.ExecNonQuery(Insert(tenants_quotarow, row.Tenant)
.InColumnValue("path", row.Path)
.InColumnValue("counter", row.Counter)
.InColumnValue("tag", row.Tag)
.InColumnValue("last_modified", DateTime.UtcNow));
}
});
}