public NpgsqlQueryableAggregateMethodTranslator(
NpgsqlSqlExpressionFactory sqlExpressionFactory,
IRelationalTypeMappingSource typeMappingSource)
{
_sqlExpressionFactory = sqlExpressionFactory;
_typeMappingSource = typeMappingSource;
}
public NpgsqlJsonDbFunctionsTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory, IRelationalTypeMappingSource typeMappingSource)
{
_sqlExpressionFactory = sqlExpressionFactory;
_boolTypeMapping = typeMappingSource.FindMapping(typeof(bool));
_stringTypeMapping = typeMappingSource.FindMapping(typeof(string));
_jsonbTypeMapping = typeMappingSource.FindMapping("jsonb");
}
public NpgsqlJsonPocoMemberTranslator(IRelationalTypeMappingSource typeMappingSource, NpgsqlSqlExpressionFactory sqlExpressionFactory, IModel model)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_jsonPocoTranslator = new NpgsqlJsonPocoTranslator(_typeMappingSource, _sqlExpressionFactory, model);
_stringTypeMapping = typeMappingSource.FindMapping(typeof(string));
}
public NpgsqlNodaTimeMethodCallTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
}
public NpgsqlRangeTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory npgsqlSqlExpressionFactory)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = npgsqlSqlExpressionFactory;
_boolMapping = typeMappingSource.FindMapping(typeof(bool)) !;
}
public NpgsqlJsonDomTranslator(
[NotNull] IRelationalTypeMappingSource typeMappingSource,
[NotNull] NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_stringTypeMapping = typeMappingSource.FindMapping(typeof(string));
}
public NpgsqlFullTextSearchMethodTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory, IRelationalTypeMappingSource typeMappingSource)
{
_sqlExpressionFactory = sqlExpressionFactory;
_boolMapping = typeMappingSource.FindMapping(typeof(bool));
_tsQueryMapping = typeMappingSource.FindMapping("tsquery");
_tsVectorMapping = typeMappingSource.FindMapping("tsvector");
_regconfigMapping = typeMappingSource.FindMapping("regconfig");
}
public NpgsqlDateTimeMemberTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_timestampMapping = typeMappingSource.FindMapping("timestamp without time zone") !;
_timestampTzMapping = typeMappingSource.FindMapping("timestamp with time zone") !;
_sqlExpressionFactory = sqlExpressionFactory;
}
public NpgsqlJsonPocoTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_stringTypeMapping = typeMappingSource.FindMapping(typeof(string)) !;
}
public NpgsqlRangeTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory npgsqlSqlExpressionFactory,
IModel model)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = npgsqlSqlExpressionFactory;
_model = model;
}
public NpgsqlJsonDbFunctionsTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory,
IModel model)
{
_sqlExpressionFactory = sqlExpressionFactory;
_stringTypeMapping = typeMappingSource.FindMapping(typeof(string), model) !;
_jsonbTypeMapping = typeMappingSource.FindMapping("jsonb") !;
}
public NpgsqlArrayTranslator(
[NotNull] IRelationalTypeMappingSource typeMappingSource,
[NotNull] NpgsqlSqlExpressionFactory sqlExpressionFactory,
[NotNull] NpgsqlJsonPocoTranslator jsonPocoTranslator)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_jsonPocoTranslator = jsonPocoTranslator;
}
public NpgsqlArrayTranslator(
NpgsqlSqlExpressionFactory sqlExpressionFactory,
NpgsqlJsonPocoTranslator jsonPocoTranslator,
bool useRedshift)
{
_sqlExpressionFactory = sqlExpressionFactory;
_jsonPocoTranslator = jsonPocoTranslator;
_useRedshift = useRedshift;
}
public NpgsqlJsonDomTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory,
IModel model)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_model = model;
_stringTypeMapping = typeMappingSource.FindMapping(typeof(string), model) !;
}
public NpgsqlNodaTimeMemberTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_dateTypeMapping = typeMappingSource.FindMapping(typeof(LocalDate)) !;
_periodTypeMapping = typeMappingSource.FindMapping(typeof(Period)) !;
_localDateTimeTypeMapping = typeMappingSource.FindMapping(typeof(LocalDateTime)) !;
}
public NpgsqlNetworkTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory,
IModel model)
{
_sqlExpressionFactory = sqlExpressionFactory;
_inetMapping = typeMappingSource.FindMapping("inet") !;
_cidrMapping = typeMappingSource.FindMapping("cidr") !;
_macaddr8Mapping = typeMappingSource.FindMapping("macaddr8") !;
_longAddressMapping = typeMappingSource.FindMapping(typeof(long), model) !;
}
public NpgsqlNetworkTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_boolMapping = typeMappingSource.FindMapping(typeof(bool)) !;
_inetMapping = typeMappingSource.FindMapping("inet") !;
_cidrMapping = typeMappingSource.FindMapping("cidr") !;
_macaddr8Mapping = typeMappingSource.FindMapping("macaddr8") !;
}
public NpgsqlRangeTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory npgsqlSqlExpressionFactory,
IModel model,
INpgsqlSingletonOptions npgsqlSingletonOptions)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = npgsqlSqlExpressionFactory;
_model = model;
_supportsMultiranges = npgsqlSingletonOptions.PostgresVersionWithoutDefault is null ||
npgsqlSingletonOptions.PostgresVersionWithoutDefault.AtLeast(14);
}
public NpgsqlLTreeTranslator(
[NotNull] IRelationalTypeMappingSource typeMappingSource,
[NotNull] NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_boolTypeMapping = typeMappingSource.FindMapping(typeof(bool));
_ltreeTypeMapping = typeMappingSource.FindMapping(typeof(LTree));
_ltreeArrayTypeMapping = typeMappingSource.FindMapping(typeof(LTree[]));
_lqueryTypeMapping = typeMappingSource.FindMapping("lquery");
_lqueryArrayTypeMapping = typeMappingSource.FindMapping("lquery[]");
_ltxtqueryTypeMapping = typeMappingSource.FindMapping("ltxtquery");
}
public NpgsqlSqlTranslatingExpressionVisitor(
RelationalSqlTranslatingExpressionVisitorDependencies dependencies,
QueryCompilationContext queryCompilationContext,
QueryableMethodTranslatingExpressionVisitor queryableMethodTranslatingExpressionVisitor)
: base(dependencies, queryCompilationContext, queryableMethodTranslatingExpressionVisitor)
{
_sqlExpressionFactory = (NpgsqlSqlExpressionFactory)dependencies.SqlExpressionFactory;
_jsonPocoTranslator = ((NpgsqlMemberTranslatorProvider)Dependencies.MemberTranslatorProvider).JsonPocoTranslator;
_ltreeTranslator = ((NpgsqlMethodCallTranslatorProvider)Dependencies.MethodCallTranslatorProvider).LTreeTranslator;
_typeMappingSource = dependencies.TypeMappingSource;
_timestampMapping = _typeMappingSource.FindMapping("timestamp without time zone") !;
_timestampTzMapping = _typeMappingSource.FindMapping("timestamp with time zone") !;
}
public NpgsqlFullTextSearchMethodTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory,
IModel model)
{
_typeMappingSource = typeMappingSource;
_sqlExpressionFactory = sqlExpressionFactory;
_model = model;
_tsQueryMapping = typeMappingSource.FindMapping("tsquery") !;
_tsVectorMapping = typeMappingSource.FindMapping("tsvector") !;
_regconfigMapping = typeMappingSource.FindMapping("regconfig") !;
_regdictionaryMapping = typeMappingSource.FindMapping("regdictionary") !;
}
public NpgsqlLTreeTranslator(
IRelationalTypeMappingSource typeMappingSource,
NpgsqlSqlExpressionFactory sqlExpressionFactory,
IModel model)
{
_sqlExpressionFactory = sqlExpressionFactory;
_boolTypeMapping = typeMappingSource.FindMapping(typeof(bool), model) !;
_ltreeTypeMapping = typeMappingSource.FindMapping(typeof(LTree), model) !;
_ltreeArrayTypeMapping = typeMappingSource.FindMapping(typeof(LTree[]), model) !;
_lqueryTypeMapping = typeMappingSource.FindMapping("lquery") !;
_lqueryArrayTypeMapping = typeMappingSource.FindMapping("lquery[]") !;
_ltxtqueryTypeMapping = typeMappingSource.FindMapping("ltxtquery") !;
}
public NpgsqlNodaTimeMethodCallTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory) => _sqlExpressionFactory = sqlExpressionFactory;
public NpgsqlFuzzyStringMatchMethodTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory, IRelationalTypeMappingSource typeMappingSource) => _sqlExpressionFactory = sqlExpressionFactory;
public NpgsqlRegexIsMatchTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory) => _sqlExpressionFactory = sqlExpressionFactory;
public NpgsqlTrigramsMethodTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory, IRelationalTypeMappingSource typeMappingSource)
{
_sqlExpressionFactory = sqlExpressionFactory;
_boolMapping = typeMappingSource.FindMapping(typeof(bool));
_floatMapping = typeMappingSource.FindMapping(typeof(float));
}
public NpgsqlDateTimeMemberTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory) => _sqlExpressionFactory = sqlExpressionFactory;
public NpgsqlJsonDomTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory, IRelationalTypeMappingSource typeMappingSource)
{
_sqlExpressionFactory = sqlExpressionFactory;
_stringTypeMapping = typeMappingSource.FindMapping(typeof(string));
}
public NpgsqlJsonPocoTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory)
{
_sqlExpressionFactory = sqlExpressionFactory;
_stringTypeMapping = sqlExpressionFactory.FindMapping(typeof(string));
}
/// <summary> /// Initializes a new instance of the <see cref="NpgsqlMathTranslator"/> class. /// </summary> /// <param name="sqlExpressionFactory">The SQL expression factory to use when generating expressions..</param> public NpgsqlLikeTranslator(NpgsqlSqlExpressionFactory sqlExpressionFactory) => _sqlExpressionFactory = sqlExpressionFactory;
