public void Type_Precision() { ISqlType type = sql.Type("DECIMAL", 10, 2); QueryResult result = engine.Compile(type); Assert.Equal("DECIMAL(10, 2)", result.Sql); Assert.Equal(new Dictionary <string, object>(), result.Parameters); }
public void Type_Length() { ISqlType type = sql.Type("VARCHAR", 50); QueryResult result = engine.Compile(type); Assert.Equal("VARCHAR(50)", result.Sql); Assert.Equal(new Dictionary <string, object>(), result.Parameters); }
public object GetDefaultValue(DataColumn col, ISqlType sqlType) { if (col?.ColumnID == null) { return(null); } if (_cachedDefaultValues.TryGetValue(col.ColumnID.Value, out var defaultValue)) { return(defaultValue); } if (!_defaultConstraints.TryGetValue(col.ColumnID.Value, out var defaultConstraint)) { return(null); } defaultValue = sqlType.GetDefaultValue(defaultConstraint); _cachedDefaultValues[col.ColumnID.Value] = defaultValue; return(defaultValue); }
public void To_String() { ISqlType type = sql.Type("DECIMAL", 10, 2); Assert.Equal("DECIMAL(10, 2)", type.ToString()); }
public LineProcessor(ISqlType from, ISqlType to) { _from = from; _to = to; }
public Statement And(ISqlType field, string oper, ISqlType otherField) { And(field.FullName, oper, otherField.FormatValue()); return(Next); }
public Statement And(ISqlType field, string oper, string value) { And(field.FullName, oper, value); return(Next); }
public Statement Where(ISqlType field, string oper, ISqlType otherField) { Where($"{field.Parent.Name}.{field.Name}", oper, otherField.FormatValue()); return(Next); }
public Statement Where(ISqlType field, string oper, string value) { Where($"{field.Parent.Name}.{field.Name}", oper, value); return(Next); }
public Statement OrderBy(ISqlType field, string order = Operators.Ascending) { OrderBy(field.FullName, order); return(Next); }
public ScriptConversor(ISqlType from, ISqlType to) { _from = from; _to = to; }