Exemple #1
0
        public AddColumn(string tablename, Column column)
        {
            RequiresReprojectionOf = tablename;

            Tablename = tablename;
            Column = column;
        }
        public DocumentTable(string name)
            : base(name)
        {
            IdColumn = new SystemColumn("Id", typeof(string), length: 1024, isPrimaryKey: true);
            Register(IdColumn);

            EtagColumn = new SystemColumn("Etag", typeof(Guid));
            Register(EtagColumn);

            CreatedAtColumn = new SystemColumn("CreatedAt", typeof(DateTimeOffset));
            Register(CreatedAtColumn);

            ModifiedAtColumn = new SystemColumn("ModifiedAt", typeof(DateTimeOffset));
            Register(ModifiedAtColumn);

            DocumentColumn = new Column("Document", typeof(byte[]));
            Register(DocumentColumn);

            MetadataColumn = new Column("Metadata", typeof(byte[]));
            Register(MetadataColumn);

            DiscriminatorColumn = new Column("Discriminator", typeof(string), length: 1024);
            Register(DiscriminatorColumn);

            AwaitsReprojectionColumn = new Column("AwaitsReprojection", typeof(bool));
            Register(AwaitsReprojectionColumn);

            VersionColumn = new Column("Version", typeof(int));
            Register(VersionColumn);
        }
Exemple #3
0
 public static SqlColumn Convert(Column column)
 {
     if (!ForNetType(column.Type).Any())
         throw new ArgumentException("Can only project .NET simple types, Guid, DateTime, DateTimeOffset, TimeSpan and byte[].");
     
     return new SqlColumn(ForNetType(column.Type).First().DbType, GetLength(column));
 }
Exemple #4
0
 protected bool Equals(Column other)
 {
     return Name == other.Name &&
            Type == other.Type &&
            Length == other.Length &&
            Nullable == other.Nullable &&
            IsPrimaryKey == other.IsPrimaryKey &&
            Equals(DefaultValue, other.DefaultValue);
 }
        protected SqlBuilder GetColumnSqlType(Column column, string defaultValuePostfix = "")
        {
            if (column.Type == null)
                throw new ArgumentException($"Column {column.Name} must have a type");

            var sql = new SqlBuilder();

            var sqlColumn = SqlTypeMap.Convert(column);
            sql.Append(new SqlParameter { DbType = sqlColumn.DbType }.SqlDbType.ToString());
            sql.Append(sqlColumn.Length != null, "(" + sqlColumn.Length + ")");
            sql.Append(column.Nullable, "NULL").Or("NOT NULL");
            sql.Append(column.DefaultValue != null, "DEFAULT '{0}'", column.DefaultValue);
            sql.Append(column.IsPrimaryKey, " PRIMARY KEY");

            return sql;
        }
Exemple #6
0
        static int? GetLength(Column column)
        {
            if (column.Length != null)
                return column.Length;

            if (column.Type == typeof (string))
                return Int32.MaxValue;
            
            if (column.Type == typeof(Enum))
                return 255;
            
            if (column.Type == typeof (byte[]))
                return Int32.MaxValue;

            return null;
        }
Exemple #7
0
        static string GetLength(Column column)
        {
            if (column.Length != null)
                return column.Length == -1 ? "MAX" : column.Length.ToString();

            if (column.Type == typeof (string))
                return "1024";

            if (column.Type == typeof(Enum))
                return "255";

            if (column.Type == typeof (byte[]))
                return "MAX";

            if (column.Type == typeof (decimal))
                return "28, 14";

            return null;
        }
Exemple #8
0
 public void ColumnGetsNullabilityFromType(Type columnType, bool isNullable)
 {
     var column = new Column("SomeColumn", columnType);
     column.Nullable.ShouldBe(isNullable);
 }
Exemple #9
0
 public void PrimaryKeyColumnCanNotBeNullable(Type columnType)
 {
     var column = new Column("SomeColumn", columnType, isPrimaryKey: true);
     column.Nullable.ShouldBe(false);
 }
 public ChangeColumnType(string tableName, Column column)
 {
     Unsafe = true;
     TableName = tableName;
     Column = column;
 }
 public ColumnAlreadRegisteredException(Table table, Column column)
     : base(string.Format("The table {0} already has a column named {1} and is not of the same type.", table.Name, column.Name)) {}
Exemple #12
0
 public void Register(Column column)
 {
     columns.Add(column.Name, column);
 }