public DocumentStorage(DocumentMapping document)
{
_mapping = document;
_document = document;
Fields = document;
TableName = document.Table;
_defaultWhere = document.DefaultWhereFragment();
_selectClause = $"select {_document.SelectFields().Select(x => $"d.{x}").Join(", ")} from {document.Table.QualifiedName} as d";
_loaderSql =
$"select {document.SelectFields().Join(", ")} from {document.Table.QualifiedName} as d where id = :id";
_loadArraySql =
$"select {document.SelectFields().Join(", ")} from {document.Table.QualifiedName} as d where id = ANY(:ids)";
if (document.TenancyStyle == TenancyStyle.Conjoined)
{
_loaderSql += $" and {TenantWhereFragment.Filter}";
_loadArraySql += $" and {TenantWhereFragment.Filter}";
}
QueryableDocument = document;
UseOptimisticConcurrency = document.UseOptimisticConcurrency;
_setter = LambdaBuilder.Setter <T, TId>(document.IdMember);
}
public DocumentStorage(StorageStyle storageStyle, DocumentMapping document)
{
_mapping = document;
Fields = document;
TableName = document.TableName;
determineDefaultWhereFragment();
_idType = PostgresqlProvider.Instance.ToParameterType(typeof(TId));
var table = _mapping.Schema.Table;
_selectFields = table.SelectColumns(storageStyle).Select(x => $"d.{x.Name}").ToArray();
var fieldSelector = _selectFields.Join(", ");
_selectClause = $"select {fieldSelector} from {document.TableName.QualifiedName} as d";
_loaderSql =
$"select {fieldSelector} from {document.TableName.QualifiedName} as d where id = :id";
_loadArraySql =
$"select {fieldSelector} from {document.TableName.QualifiedName} as d where id = ANY(:ids)";
if (document.TenancyStyle == TenancyStyle.Conjoined)
{
_loaderSql += $" and {CurrentTenantFilter.Filter}";
_loadArraySql += $" and {CurrentTenantFilter.Filter}";
}
UseOptimisticConcurrency = document.UseOptimisticConcurrency;
_setter = LambdaBuilder.Setter <T, TId>(document.IdMember) !;
DeleteFragment = _mapping.DeleteStyle == DeleteStyle.Remove
? (IOperationFragment) new HardDelete(this)
: new SoftDelete(this);
HardDeleteFragment = new HardDelete(this);
DuplicatedFields = _mapping.DuplicatedFields;
}
public DocumentStorage(DocumentMapping document)
{
_mapping = document;
_document = document;
Fields = document;
TableName = document.Table;
_defaultWhere = document.DefaultWhereFragment();
_idType = TypeMappings.ToDbType(typeof(TId));
_selectClause = $"select {_document.SelectFields().Select(x => $"d.{x}").Join(", ")} from {document.Table.QualifiedName} as d";
_loaderSql =
$"select {document.SelectFields().Join(", ")} from {document.Table.QualifiedName} as d where id = :id";
_loadArraySql =
$"select {document.SelectFields().Join(", ")} from {document.Table.QualifiedName} as d where id = ANY(:ids)";
if (document.TenancyStyle == TenancyStyle.Conjoined)
{
_loaderSql += $" and {TenantWhereFragment.Filter}";
_loadArraySql += $" and {TenantWhereFragment.Filter}";
}
QueryableDocument = document;
UseOptimisticConcurrency = document.UseOptimisticConcurrency;
_setter = LambdaBuilder.Setter <T, TId>(document.IdMember);
DeleteFragment = _mapping.DeleteStyle == DeleteStyle.Remove
? (IOperationFragment) new HardDelete(this)
: new SoftDelete(this);
}
