public override string SerializeTableFieldNullableOption(SQLTableField field)
 {
     if (field.AutoIncrements)
         return String.Empty;		// NULL/NOT NULL is not required if it's an IDENTITY field
     else
         return base.SerializeTableFieldNullableOption(field);
 }
Exemplo n.º 2
0
 public virtual string SerializeTableFieldNullableOption(SQLTableField field)
 {
     if (field.AcceptsNull)
         return "NULL";
     else
         return "NOT NULL";
 }
 public override string SerializeTableFieldDataType(SQLTableField field)
 {
     if (field.AutoIncrements)
         return "IDENTITY";
     else
         return base.SerializeTableFieldDataType(field);
 }
Exemplo n.º 4
0
 public virtual string SerializeTableFieldDefaultOption(SQLTableField field)
 {
     if (field.Default != null)
         return "DEFAULT " + SerializeValue(field.Default);
     else
         return String.Empty;
 }
Exemplo n.º 5
0
 public virtual string SerializeTableFieldKeyTypeOption(SQLTableField field)
 {
     if (field.KeyType == KeyType.Primary)
         return "PRIMARY KEY";
     else if (field.KeyType == KeyType.Unique)
         return "UNIQUE";
     else
         return String.Empty;
 }
Exemplo n.º 6
0
 public virtual string SerializeTableFieldCollationOption(SQLTableField field)
 {
     return string.Empty;
 }
Exemplo n.º 7
0
 public virtual string SerializeTableFieldDataType(SQLTableField field)
 {
     return SerializeDataType(field.DataType, field.Size, field.Precision, field.ScaleLength);
 }
Exemplo n.º 8
0
        public virtual string SerializeTableField(SQLTableField field, SQLTableFields.AlterModeType alterMode)
        {
            var tokens = new TokenSerializer();

            if (alterMode == SQLTableFields.AlterModeType.Drop)
                tokens.Add(SerializeTableFieldAsName(field));
            else
            {
                tokens.Add(SerializeTableFieldAsName(field));
                tokens.Add(SerializeTableFieldDataType(field));
                tokens.Add(SerializeTableFieldCollationOption(field));
                tokens.Add(SerializeTableFieldDefaultOption(field));
                tokens.Add(SerializeTableFieldNullableOption(field));
                tokens.Add(SerializeTableFieldKeyTypeOption(field));
            }

            return tokens.ToString();
        }
Exemplo n.º 9
0
 public virtual string SerializeTableFieldAsName(SQLTableField field)
 {
     return field.NameAsExpression.SQL(this);
 }
Exemplo n.º 10
0
 public override string SerializeTableFieldDataType(SQLTableField field)
 {
     if (field.AutoIncrements)
         return base.SerializeTableFieldDataType(field) + " GENERATED BY DEFAULT AS IDENTITY(START WITH 1 INCREMENT BY 1)";
     else
         return base.SerializeTableFieldDataType(field);
 }
Exemplo n.º 11
0
 public override string SerializeTableFieldKeyTypeOption(SQLTableField field)
 {
     // must be set to a key type if it is an auto increment field
     if (field.AutoIncrements && field.KeyType == KeyType.None)
         return "UNIQUE";
     else
         return base.SerializeTableFieldKeyTypeOption(field);
 }
Exemplo n.º 12
0
 public override string SerializeTableFieldDataType(SQLTableField field)
 {
     if (field.AutoIncrements)
         return base.SerializeTableFieldDataType(field) + " AUTO_INCREMENT";
     else
         return base.SerializeTableFieldDataType(field);
 }
Exemplo n.º 13
0
 public override string SerializeTableFieldCollationOption(SQLTableField field)
 {
     // Force to case-insensitive text comparison.
     return "COLLATE NOCASE";
 }
Exemplo n.º 14
0
 public override string SerializeTableField(SQLTableField field, SQLTableFields.AlterModeType alterMode)
 {
     // if altering or creating a field append the AUTOINCREMENT. Field format: name datatype default nullable keytype AUTOINCREMENT
     if (alterMode != SQLTableFields.AlterModeType.Drop && field.AutoIncrements)
         return base.SerializeTableField(field, alterMode) + " AUTOINCREMENT";
     else
         return base.SerializeTableField(field, alterMode);
 }