public void Write(ICdlRecord row) { if (_insertSeparatorAfterRows.HasValue && _rowsAfterSeparator > _insertSeparatorAfterRows.Value) { _stream.Write("GO\n"); _rowsAfterSeparator = 0; } var fmt = _factory.CreateLiteralFormatter(); _stream.Write("INSERT INTO [TABLE_NAME] ("); _stream.Write(row.GetFieldNames().Select(x => "[" + x + "]").CreateDelimitedText(", ")); _stream.Write(") VALUES ("); for (int i = 0; i < row.FieldCount; i++) { if (i > 0) { _stream.Write(", "); } row.ReadValue(i); fmt.ReadFrom(row); _stream.Write(fmt.GetText()); } _stream.Write(");\n"); _rowsAfterSeparator++; }
public void Write(ICdlRecord row) { WantTransaction(); var sb = new StringBuilder(); sb.AppendFormat("insert into {0} ({1}) values (", TABLE_NAME, ColumnsText); for (int i = 0; i < row.FieldCount; i++) { row.ReadValue(i); if (i > 0) { sb.Append(","); } sb.Append((int)row.GetFieldType()); sb.Append(","); string sqldata; StorageTool.GetValueAsSqlLiteral(row, out sqldata); sb.Append(sqldata); } sb.Append(")"); using (var inscmd = _conn.CreateCommand()) { inscmd.Transaction = _tran; inscmd.CommandText = sb.ToString().Replace("\0", "\\0"); inscmd.ExecuteNonQuery(); _rowCount++; } }
private void WantField(int index) { if (index != m_curField) { m_curField = index; m_record.ReadValue(m_curField); } }
public void ReadValue(int i) { m_curField = i; if (m_original != null) { m_original.ReadValue(i); } }
public static object SafeGetValue(this ICdlRecord record, int ordinal) { if (ordinal < 0) { return(null); } record.ReadValue(ordinal); return(record.GetValue()); }
public void Write(ICdlRecord row) { var dataRow = new object[row.FieldCount]; _rows.Add(dataRow); for (int i = 0; i < row.FieldCount; i++) { row.ReadValue(i); _formatter.ReadFrom(row); dataRow[i] = _formatter.GetText(); } }
public void Write(ICdlRecord row) { _orec.Clear(); for (int i = 0; i < row.FieldCount; i++) { row.ReadValue(i); _formatter.ReadFrom(row); _orec[i] = _formatter.GetText(); } _dbf.Write(_orec); }
public static void SaveRecord(int fldcount, ICdlRecord record, BinaryWriter stream) { var fw = new StreamValueWriter(stream); if (fldcount != record.FieldCount) { throw new InternalError("DBSH-00034 field count mitchmatch"); } for (int i = 0; i < fldcount; i++) { record.ReadValue(i); fw.ReadFrom(record); } }
void ICdlWriter.Write(ICdlRecord row) { if (_dataRecord == null) { _dataRecord = new string[row.FieldCount]; } for (int i = 0; i < _dataRecord.Length; i++) { row.ReadValue(i); _formatter.ReadFrom(row); _dataRecord[i] = _formatter.GetText(); } WriteRow(_dataRecord); }
public ICdlRecord AdaptRecord(ICdlRecord record) { var res = new ArrayDataRecord(record.Structure); for (int i = 0; i < Math.Min(res.FieldCount, record.FieldCount); i++) { var targetColumn = _columnMap.GetTargetColumnBySourceIndex(i); if (targetColumn == null) continue; record.ReadValue(i); res.SeekValue(i); _dda.AdaptValue(record, targetColumn.CommonType, res, _outputConv); } return res; }
public void Write(ICdlRecord row) { var fmt = _factory.CreateLiteralFormatter(); _stream.Write("INSERT INTO [TABLE_NAME] ("); _stream.Write(row.GetFieldNames().Select(x => "[" + x + "]").CreateDelimitedText(", ")); _stream.Write(") VALUES ("); for (int i = 0; i < row.FieldCount; i++) { if (i > 0) _stream.Write(", "); row.ReadValue(i); fmt.ReadFrom(row); _stream.Write(fmt.GetText()); } _stream.Write(");\n"); }
public ICdlRecord AdaptRecord(ICdlRecord record) { var res = new ArrayDataRecord(record.Structure); for (int i = 0; i < Math.Min(res.FieldCount, record.FieldCount); i++) { var targetColumn = _columnMap.GetTargetColumnBySourceIndex(i); if (targetColumn == null) { continue; } record.ReadValue(i); res.SeekValue(i); _dda.AdaptValue(record, targetColumn.CommonType, res, _outputConv); } return(res); }
public void Write(ICdlRecord row) { _writer.WriteStartElement(_rowElementName ?? "Row"); for (int i = 0; i < row.FieldCount; i++) { string name = row.GetName(i); row.ReadValue(i); _formatter.ReadFrom(row); string value = _formatter.GetText(); if (_useAttributes) { _writer.WriteAttributeString(name, value); } else { _writer.WriteStartElement(name); _writer.WriteString(value); _writer.WriteEndElement(); } } _writer.WriteEndElement(); }
void IColumnMapping.ProcessMapping(int column, int rowNumber, ICdlRecord record, ICdlValueWriter writer, IShellContext context) { record.ReadValue(record.GetOrdinal(Name)); record.WriteTo(writer); }
public static void SaveRecord(int fldcount, ICdlRecord record, BinaryWriter stream) { var fw = new StreamValueWriter(stream); if (fldcount != record.FieldCount) throw new InternalError("DBSH-00034 field count mitchmatch"); for (int i = 0; i < fldcount; i++) { record.ReadValue(i); fw.ReadFrom(record); } }
public static object GetValue(this ICdlRecord record, int ordinal) { record.ReadValue(ordinal); return(record.GetValue()); }
public void ReadValue(int i) { RefObject.ReadValue(i); }
public void Write(ICdlRecord row) { WantTransaction(); var sb = new StringBuilder(); sb.AppendFormat("insert into {0} ({1}) values (", TABLE_NAME, ColumnsText); for (int i = 0; i < row.FieldCount; i++) { row.ReadValue(i); if (i > 0) sb.Append(","); sb.Append((int)row.GetFieldType()); sb.Append(","); string sqldata; StorageTool.GetValueAsSqlLiteral(row, out sqldata); sb.Append(sqldata); } sb.Append(")"); using (var inscmd = _conn.CreateCommand()) { inscmd.Transaction = _tran; inscmd.CommandText = sb.ToString().Replace("\0", "\\0"); inscmd.ExecuteNonQuery(); _rowCount++; } }
public void Write(ICdlRecord row) { _stream.Write("<tr>"); for (int i = 0; i < row.FieldCount; i++) { row.ReadValue(i); _formatter.ReadFrom(row); string value = _formatter.GetText(); _stream.WriteLine("<td>{0}</td>", HttpUtility.HtmlEncode(value)); } _stream.Write("</tr>"); }