Class BaseFunctionDescriptor

Inheritance

object

BaseSQLProgram

BaseFunctionDescriptor

AuditTrail

BaseGetItems

History

ItemAsOf

ItemExists

Inherited Members

BaseSQLProgram.GetColumnAlias(string)

BaseSQLProgram.GetDependantFunctionTypes()

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Namespace: LemonEdge.Connections.Database.Migrations.Core.SQLWriters.Functions

Assembly: LemonEdge.Database.Connector.dll

Syntax

public abstract class BaseFunctionDescriptor : BaseSQLProgram

Constructors

BaseFunctionDescriptor(EntityDescriptor, IQueryBuilderFactory, IEntityDescriptorFactory)

Declaration

protected BaseFunctionDescriptor(EntityDescriptor descriptor, IQueryBuilderFactory builderFactory, IEntityDescriptorFactory entityDescriptorFactory)

Parameters

Type	Name	Description
EntityDescriptor	descriptor
IQueryBuilderFactory	builderFactory
IEntityDescriptorFactory	entityDescriptorFactory

Properties

BuilderFactory

Declaration

protected IQueryBuilderFactory BuilderFactory { get; }

Property Value

Type	Description
IQueryBuilderFactory

Descriptor

Declaration

public EntityDescriptor Descriptor { get; }

Property Value

Type	Description
EntityDescriptor

EntityDescriptorFactory

Declaration

protected IEntityDescriptorFactory EntityDescriptorFactory { get; }

Property Value

Type	Description
IEntityDescriptorFactory

IncludeWhenChangingTableStructure

Declaration

public override bool IncludeWhenChangingTableStructure { get; }

Property Value

Type	Description
bool

Overrides

BaseSQLProgram.IncludeWhenChangingTableStructure

IsSchemaBound

Declaration

public abstract bool IsSchemaBound { get; }

Property Value

Type	Description
bool

Methods

AddCanvasFilter(IQuerySelectBuilder, EntityDescriptor, bool)

Declaration

protected static void AddCanvasFilter(IQuerySelectBuilder sbf, EntityDescriptor desc, bool allowHistory)

Parameters

Type	Name	Description
IQuerySelectBuilder	sbf
EntityDescriptor	desc
bool	allowHistory

AddCoreParameters(IQueryFunctionBuilder)

We have five common parameters across all functions: accountId, canvasId, teamId, userId, asOfDate

Declaration

protected void AddCoreParameters(IQueryFunctionBuilder fb)

Parameters

Type	Name	Description
IQueryFunctionBuilder	fb

CreateForOtherDescriptor(EntityDescriptor)

Declaration

public abstract BaseFunctionDescriptor CreateForOtherDescriptor(EntityDescriptor other)

Parameters

Type	Name	Description
EntityDescriptor	other

Returns

Type	Description
BaseFunctionDescriptor

DropFunctions(ObseleteEntityDescriptor, IDataAccessor, IDbConnection)

Declaration

public Task DropFunctions(ObseleteEntityDescriptor obseleteDesc, IDataAccessor accessor, IDbConnection cn)

Parameters

Type	Name	Description
ObseleteEntityDescriptor	obseleteDesc
IDataAccessor	accessor
IDbConnection	cn

Returns

Type	Description
Task

DropFunctions(IDataAccessor, IDbConnection)

Declaration

public Task DropFunctions(IDataAccessor accessor, IDbConnection cn)

Parameters

Type	Name	Description
IDataAccessor	accessor
IDbConnection	cn

Returns

Type	Description
Task

GetCanvasCteSelect(EntityDescriptor, bool, bool, IQueryBuilderFactory)

Declaration

protected static IQuerySelectBuilder GetCanvasCteSelect(EntityDescriptor desc, bool forceNoLock, bool includeLastUpdated, IQueryBuilderFactory queryBuilderFactory)

Parameters

Type	Name	Description
EntityDescriptor	desc
bool	forceNoLock
bool	includeLastUpdated
IQueryBuilderFactory	queryBuilderFactory

Returns

Type	Description
IQuerySelectBuilder

GetCreateFunction()

Declaration

public abstract string GetCreateFunction()

Returns

Type	Description
string

GetCreateSQL()

Declaration

public override sealed string GetCreateSQL()

Returns

Type	Description
string

Overrides

BaseSQLProgram.GetCreateSQL()

GetDoesExistSQL()

Declaration

public override sealed string GetDoesExistSQL()

Returns

Type	Description
string

Overrides

BaseSQLProgram.GetDoesExistSQL()

GetDoesFunctionExistSQL()

Declaration

public virtual string GetDoesFunctionExistSQL()

Returns

Type	Description
string

GetDropFunctionSQL()

Declaration

public string GetDropFunctionSQL()

Returns

Type	Description
string

GetDropFunctionSQL(ObseleteEntityDescriptor)

Declaration

public string GetDropFunctionSQL(ObseleteEntityDescriptor obseleteDesc)

Parameters

Type	Name	Description
ObseleteEntityDescriptor	obseleteDesc

Returns

Type	Description
string

GetDropSQL()

Declaration

public override sealed string GetDropSQL()

Returns

Type	Description
string

Overrides

BaseSQLProgram.GetDropSQL()

GetFunctionName(string, string, string)

Declaration

public abstract string GetFunctionName(string itemName, string setName, string replicatedFromItemName)

Parameters

Type	Name	Description
string	itemName
string	setName
string	replicatedFromItemName

Returns

Type	Description
string

Extension Methods

LinqExtensions.AsArray<T>(T)

LinqExtensions.ToArrayOfOne<T>(T)

LinqExtensions.ToListOfOne<T>(T)

MiscExtensions.SetIfNotEqual<T, TP>(T, Expression<Func<T, TP>>, TP)

WeakReferenceExtensions.WeakReference(object)

SQLExtensions.ToSQLValue(object, bool)

ReflectionExtensions.ClearEventInvocations(object, string)

StringExtensions.ToCSVFormatString(object, Type)