public CsvReader(TableInfo structure, LumenWorks.Framework.IO.Csv.CsvReader reader, DataFormatSettings dataFormat)
: base(structure)
{
_reader = reader;
_array = new string[structure.ColumnCount];
_dataFormat = dataFormat ?? new DataFormatSettings();
}
public XmlWriterImpl(System.Xml.XmlWriter writer, bool closeWriter, DataFormatSettings dataFormat, bool useAttributes, string rowElementName)
{
_writer = writer;
_dataFormat = dataFormat;
_formatter = new CdlValueFormatter(_dataFormat ?? new DataFormatSettings());
_useAttributes = useAttributes;
_closeWriter = closeWriter;
_rowElementName = rowElementName;
}
public void WriteStart(StreamWriter fw, ITableStructure table, ref object manager)
{
var fmtset = new DataFormatSettings();
SettingsTool.CopySettingsPage(FormatSettings, fmtset);
fmtset.DateTimeFormat = "s";
fw.Write(IoRes.excelxml_start.Replace("#HDRCOLOR#", m_headerColor.ToWebName()));
WriteHeaders(fw, table, m_sheetName);
manager = new Manager {
formatter = new BedValueFormatter(fmtset)
};
}
public CsvWriter(TextWriter stream, char delimiter, char quote, char escape, char comment, CsvQuotingMode qmode, string lineEnds, DataFormatSettings dataFormat)
{
_stream = stream;
_lineEnds = lineEnds;
_delimiter = delimiter;
_quote = quote;
_escape = escape;
_comment = comment;
_qmode = qmode;
_dataFormat = dataFormat;
_formatter = new CdlValueFormatter(_dataFormat ?? new DataFormatSettings());
}
public ICdlWriter CreateWriter(TableInfo inputRowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
var connection = GetConnectionProvider(context);
using (var conn = connection.Connect())
{
var db = new DatabaseInfo();
db.LinkedInfo = LinkedInfo;
var tbl = inputRowFormat.CloneTable(db);
tbl.FullName = GetFullName(context);
foreach (var col in tbl.Columns)
{
col.AutoIncrement = false;
}
tbl.ForeignKeys.Clear();
if (tbl.PrimaryKey != null)
{
tbl.PrimaryKey.ConstraintName = null;
}
tbl.AfterLoadLink();
if (IdentityColumn != null)
{
var col = new ColumnInfo(tbl);
col.Name = IdentityColumn;
col.DataType = "int";
col.AutoIncrement = true;
col.NotNull = true;
var pk = new PrimaryKeyInfo(tbl);
pk.Columns.Add(new ColumnReference {
RefColumn = col
});
pk.ConstraintName = "PK_" + tbl.Name;
tbl.PrimaryKey = pk;
tbl.Columns.Insert(0, col);
}
//var sw = new StringWriter();
var so = new ConnectionSqlOutputStream(conn, null, connection.Factory.CreateDialect());
var dmp = connection.Factory.CreateDumper(so, new SqlFormatProperties());
if (DropIfExists)
{
dmp.DropTable(tbl, true);
}
bool useExistingTable = false;
if (UseIfExists)
{
var ts = context.GetDatabaseStructure(connection.ProviderString);
useExistingTable = ts.FindTableLike(tbl.FullName.Schema, tbl.FullName.Name) != null;
}
if (!useExistingTable)
{
tbl.Columns.ForEach(x => x.EnsureDataType(connection.Factory.CreateSqlTypeProvider()));
dmp.CreateTable(tbl);
}
//using (var cmd = conn.CreateCommand())
//{
// cmd.CommandText = sw.ToString();
// cmd.ExecuteNonQuery();
//}
return(new TableWriter(context, connection, GetFullName(context), inputRowFormat, options, useExistingTable ? null : tbl, LinkedInfo, sourceDataFormat));
}
}
ICdlWriter ITabularDataTarget.CreateWriter(TableInfo rowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
string file = GetName(context);
file = context.ResolveFile(file, ResolveFileMode.Output);
context.Info("Writing file " + Path.GetFullPath(file));
return(new CdlFileWriter(file, rowFormat));
}
ICdlWriter ITabularDataTarget.CreateWriter(TableInfo inputRowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
var writer = GetModel(context);
bool closeWriter = false;
if (writer == null)
{
closeWriter = true;
writer = CreateWriter(context.ResolveFile(context.Replace(File), ResolveFileMode.Output));
}
var impl = new XmlWriterImpl(writer, closeWriter, sourceDataFormat, UseAttributes, RowElementName);
return(impl);
}
public TableWriter(IShellContext context, IConnectionProvider connection, NameWithSchema name, TableInfo inputRowFormat, CopyTableTargetOptions options, TableInfo destinationTableOverride = null, LinkedDatabaseInfo linkedInfo = null, DataFormatSettings sourceDataFormat = null)
{
_connectionProvider = connection;
_linkedInfo = linkedInfo;
_name = name;
_inputRowFormat = inputRowFormat;
_queue = new CdlDataQueue(inputRowFormat);
_context = context;
_inserter = connection.Factory.CreateBulkInserter();
_inserter.SourceDataFormat = sourceDataFormat;
_connection = _connectionProvider.Connect();
_inserter.Connection = _connection;
_inserter.Factory = connection.Factory;
_inserter.LinkedInfo = _linkedInfo;
var db = context.GetDatabaseStructure(connection.ProviderString);
_inserter.DestinationTable = destinationTableOverride ?? db.FindTableLike(_name.Schema, _name.Name);
_inserter.CopyOptions = options;
_inserter.MessageLogger = _context;
_inserter.ServiceProvider = context.ServiceProvider;
_thread = new Thread(Run);
_thread.Start();
}
public ICdlWriter CreateWriter(TableInfo rowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
return(GetModel(context).CreateWriter(rowFormat, context.Replace(SheetName)));
}
ICdlWriter ITabularDataTarget.CreateWriter(TableInfo rowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
string file = context.ResolveFile(GetName(context), ResolveFileMode.Output);
context.GetLogger <CsvFile>().LogInformation("Writing file {file}", Path.GetFullPath(file));
context.Info("Writing file " + Path.GetFullPath(file));
var fs = System.IO.File.OpenWrite(file);
var fw = new StreamWriter(fs, Encoding);
var writer = new CsvWriter(fw, Delimiter, Quote, Escape, Comment, QuotingMode, EndOfLine, DataFormat);
if (HasHeaders)
{
writer.WriteRow(rowFormat.Columns.Select(c => c.Name));
}
return(writer);
}
public CdlValueConvertor(DataFormatSettings settings)
{
m_parser = new CdlValueParser(settings);
m_formatter = new CdlValueFormatter(settings);
}
public ExcelWriter(TableInfo rowFormat, ExcelWorksheet sheet, DataFormatSettings dataFormat)
{
_rowFormat = rowFormat;
_sheet = sheet;
_formatter = new CdlValueFormatter(dataFormat ?? new DataFormatSettings());
}
ICdlWriter ITabularDataTarget.CreateWriter(TableInfo rowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
return(CreateTarget(context).CreateWriter(rowFormat, options, context, sourceDataFormat));
}
public ICdlWriter CreateWriter(TableInfo rowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
string file = context.ResolveFile(context.Replace(File), ResolveFileMode.Output);
var fw = new StreamWriter(System.IO.File.OpenWrite(file));
var provider = GetConnectionProvider(context);
return(new SqlFileWriter(fw, provider.Factory, InsertSeparatorAfterRows));
}
ICdlWriter ITabularDataTarget.CreateWriter(TableInfo inputRowFormat, CopyTableTargetOptions options, IShellContext context, DataFormatSettings sourceDataFormat)
{
return(new TableWriter(context, GetConnectionProvider(context), GetFullName(context), inputRowFormat, options, StructureOverride, LinkedInfo, sourceDataFormat));
}
public CdlValueConvertor(DataFormatSettings settings)
{
m_parser = new CdlValueParser(settings);
m_formatter = new CdlValueFormatter(settings);
}
public RecordToDbAdapter(TargetColumnMap columnMap, IDatabaseFactory targetFactory, DataFormatSettings formatSettings)
{
_columnMap = columnMap;
_dda = targetFactory.CreateDataAdapter();
_outputConv = new CdlValueConvertor(formatSettings);
}
