public void TestSmallInt() { IColumn column = new SmallIntColumn("shoe_size", 2); column.NotNull(); column.AutoIncrement(); Assert.Equal("`shoe_size` SMALLINT(2) NOT NULL AUTO_INCREMENT", generator.ToSQL(column)); }
public override SearchParameterQueryGeneratorContext VisitSearchParameter(SearchParameterExpression expression, SearchParameterQueryGeneratorContext context) { short searchParamId = context.Model.GetSearchParamId(expression.Parameter.Url); SmallIntColumn searchParamIdColumn = VLatest.SearchParam.SearchParamId; context.StringBuilder .Append(searchParamIdColumn, context.TableAlias) .Append(" = ") .AppendLine(context.Parameters.AddParameter(searchParamIdColumn, searchParamId).ParameterName) .Append("AND "); return(expression.Expression.AcceptVisitor(this, context)); }
public override SearchParameterQueryGeneratorContext VisitMissingSearchParameter(MissingSearchParameterExpression expression, SearchParameterQueryGeneratorContext context) { Debug.Assert(!expression.IsMissing, "IsMissing=true expressions should have been rewritten"); short searchParamId = context.Model.GetSearchParamId(expression.Parameter.Url); SmallIntColumn searchParamIdColumn = VLatest.SearchParam.SearchParamId; context.StringBuilder .Append(searchParamIdColumn, context.TableAlias) .Append(" = ") .AppendLine(context.Parameters.AddParameter(searchParamIdColumn, searchParamId).ParameterName); return(context); }
public override SearchParameterQueryGeneratorContext VisitSearchParameter(SearchParameterExpression expression, SearchParameterQueryGeneratorContext context) { SearchParameterQueryGenerator delegatedGenerator = GetSearchParameterQueryGeneratorIfResourceColumnSearchParameter(expression); if (delegatedGenerator != null) { // This is a search parameter over a column that exists on the Resource table or both the Resource table and search parameter tables. // Delegate to the visitor specific to it. return(expression.Expression.AcceptVisitor(delegatedGenerator, context)); } short searchParamId = context.Model.GetSearchParamId(expression.Parameter.Url); SmallIntColumn searchParamIdColumn = VLatest.SearchParam.SearchParamId; context.StringBuilder .Append(searchParamIdColumn, context.TableAlias) .Append(" = ") .AppendLine(context.Parameters.AddParameter(searchParamIdColumn, searchParamId, true).ParameterName) .Append("AND "); return(expression.Expression.AcceptVisitor(this, context)); }
public override SearchParameterQueryGeneratorContext VisitMissingSearchParameter(MissingSearchParameterExpression expression, SearchParameterQueryGeneratorContext context) { SearchParameterQueryGenerator delegatedGenerator = GetSearchParameterQueryGeneratorIfResourceColumnSearchParameter(expression); if (delegatedGenerator != null) { // This is a search parameter over a column that exists on the Resource table or both the Resource table and search parameter tables. // Delegate to the visitor specific to it. return(expression.AcceptVisitor(delegatedGenerator, context)); } Debug.Assert(!expression.IsMissing, "IsMissing=true expressions should have been rewritten"); short searchParamId = context.Model.GetSearchParamId(expression.Parameter.Url); SmallIntColumn searchParamIdColumn = VLatest.SearchParam.SearchParamId; context.StringBuilder .Append(searchParamIdColumn, context.TableAlias) .Append(" = ") .AppendLine(context.Parameters.AddParameter(searchParamIdColumn, searchParamId).ParameterName); return(context); }