public DbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser) :
base(mapper, config, parser)
{
ScalarTypesToSqlTypes =
new Dictionary <ScalarType, string>
{
{ ScalarType.Int32, "INT" },
{ ScalarType.Double, "FLOAT" },
{ ScalarType.Int64, "BIGINT" },
{ ScalarType.Bool, "BIT" },
{ ScalarType.String, "NVARCHAR(4000)" },
{ ScalarType.Bytes, "VARBINARY(MAX)" },
{ ScalarType.DateTime, "DATETIME" },
{ ScalarType.Int16, "SMALLINT" },
{ ScalarType.Int8, "TINYINT" },
{ ScalarType.DateTimeOffset, "DATETIMEOFFSET(3)" },
{ ScalarType.TimeSpan, "TIME" },
{ ScalarType.Decimal, "DECIMAL" }
// {ScalarType.TimeStamp, typeof(DateTime)}
};
}
public PostgresDbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser) :
base(mapper, config, parser)
{
ScalarTypesToSqlTypes =
new Dictionary <ScalarType, string>
{
{ ScalarType.Int32, "INT" },
{ ScalarType.Double, "DOUBLE PRECISION" },
{ ScalarType.Int64, "BIGINT" },
{ ScalarType.Bool, "BOOLEAN" },
{ ScalarType.String, "VARCHAR(4000)" },
{ ScalarType.Bytes, "BYTEA" },
{ ScalarType.DateTime, "TIMESTAMP(3)" },
{ ScalarType.Int16, "SMALLINT" },
{ ScalarType.Int8, "SMALLINT" },
{ ScalarType.DateTimeOffset, "TIMESTAMP(3) WITH TIME ZONE" },
{ ScalarType.TimeSpan, "TIME" },
{ ScalarType.Decimal, "NUMERIC" }
// {ScalarType.TimeStamp, typeof(DateTime)}
};
}
public DbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser)
{
mapper.Map(config, this);
mapper.Map(config, Properties);
packageParser = parser;
scalarTypesToSqlTypes =
new Dictionary <ScalarType, string>
{
{ ScalarType.Int32, "int" },
{ ScalarType.Double, "float" },
{ ScalarType.Int64, "bigint" },
{ ScalarType.Bool, "bit" },
{ ScalarType.String, "nvarchar(4000)" },
{ ScalarType.Bytes, "varbinary(MAX)" },
{ ScalarType.DateTime, "datetime" },
{ ScalarType.Int16, "smallint" },
{ ScalarType.Int8, "tinyint" },
{ ScalarType.DateTimeOffset, "datetimeoffset" },
{ ScalarType.TimeSpan, "time" },
{ ScalarType.Decimal, "decimal" }
// {ScalarType.TimeStamp, typeof(DateTime)}
};
}
public BaseDbExporter(IMapper mapper, DbExporterConfig config, IPackageParser parser)
{
mapper.Map(config, this);
mapper.Map(config, Properties);
packageParser = parser;
}
