public static ExactType Create(SimpleTypes tp) { ExactType r = new ExactType(); r.Type = TypeSimpleToDb(tp); return(r); }
public static ExactType Create(DbColumnType tp, int precision = 0, int scale = 0, int maxCharLength = 0) { ExactType r = new ExactType(); r.MaxTextLength = maxCharLength; r.Precision = precision; r.Scale = scale; r.Type = tp; return(r); }
public static ExactType?Parse(LexemCollection collection) { ExactType res; var lex = collection.CurrentLexem(); if (lex.LexemType != LexType.Command) { collection.Error("Unknow data type", collection.CurrentLexem()); } string s = lex.LexemText.ToLower(); DbColumnType tp = DbColumnType.Unknow; int param1 = 0; int param2 = 0; switch (s) { case "datetime": tp = DbColumnType.DateTime; ReadSub1Number(collection, out param1); //ignore break; case "timestamp": tp = DbColumnType.DateTime; if (ParserUtils.ParseCommandPhrase(collection, "timestamp without time zone", true, false)) { tp = DbColumnType.DateTime; } if (ParserUtils.ParseCommandPhrase(collection, "timestamp with time zone", true, false)) { tp = DbColumnType.DateTimeWithTimeZone; } ReadSub1Number(collection, out param1); //ignore break; case "date": tp = DbColumnType.Date; ReadSub1Number(collection, out param1); //ignore break; case "time": tp = DbColumnType.Time; if (ParserUtils.ParseCommandPhrase(collection, "time without time zone", true, false)) { tp = DbColumnType.Time; } if (ParserUtils.ParseCommandPhrase(collection, "time with time zone", true, false)) { tp = DbColumnType.TimeWithTimeZome; } ReadSub1Number(collection, out param1); //ignore break; case "int8": case "byte": case "tinyint": tp = DbColumnType.Byte; break; case "int16": case "smallint": tp = DbColumnType.SmallInt; break; case "int32": case "integer": case "int": tp = DbColumnType.Integer; break; case "float": case "real": tp = DbColumnType.Real; ReadSub1Number(collection, out param1); //ignore break; case "double": ParserUtils.ParseCommandPhrase(collection, "double precision"); tp = DbColumnType.Double; break; case "bigint": case "int64": tp = DbColumnType.BigInt; break; case "decimal": case "numeric": tp = DbColumnType.Numeric; ReadSub2Number(collection, out param1, out param2); break; case "nvarchar": case "varchar": tp = DbColumnType.VarChar; if (ReadSub1Number(collection, out param1)) { if (param1 == 0) { tp = DbColumnType.Text; } } break; case "nchar": case "char": tp = DbColumnType.VarChar; if (!ReadSub1Number(collection, out param1)) { collection.ErrorUnexpected(collection.CurrentOrLast()); } break; case "character": tp = DbColumnType.Char; if (ParserUtils.ParseCommandPhrase(collection, "character varying")) { tp = DbColumnType.VarChar; } if (!ReadSub1Number(collection, out param1)) { collection.ErrorUnexpected(collection.CurrentOrLast()); } break; case "text": tp = DbColumnType.Text; break; case "blob": tp = DbColumnType.Blob; break; case "bit": case "bool": case "boolean": tp = DbColumnType.Boolean; break; case "geometry": tp = DbColumnType.Geometry; break; case "geography": tp = DbColumnType.Geography; break; default: return(null); } res = ExactType.Create(tp); if (tp == DbColumnType.Numeric) { res.Precision = param1; res.Scale = param2; } if (tp == DbColumnType.Char || tp == DbColumnType.VarChar) { res.MaxTextLength = param1; } return(res); }