private static void TestReadMappedSummaryTable(ITableReader tableReader)
{
var dict = tableReader.Rows
.Where(r => r["Name"] != null)
.ToDictionary(r => r.GetValue <string>("Name"), r => r["Value"]);
Assert.AreEqual(7, dict.Count);
var normalReader = new TableMappingReader <NameValue>()
.Map(o => o.Name)
.Map(o => o.Value);
var nameValueList = normalReader.Read(tableReader);
Assert.GreaterOrEqual(nameValueList.Count, 2);
Assert.IsTrue(nameValueList.Any(o => o.Name != o.Value));
var nameNameReader = new TableMappingReader <NameValue>()
.Map(o => o.Name)
.Map(o => o.Value, "Name");
nameValueList = nameNameReader.Read(tableReader);
Assert.GreaterOrEqual(nameValueList.Count, 2);
Assert.GreaterOrEqual(nameValueList.Count(o => !string.IsNullOrEmpty(o.Name)), 2);
Assert.IsFalse(nameValueList.Any(o => o.Name != o.Value));
nameValueList = normalReader.Read(tableReader);
Assert.GreaterOrEqual(nameValueList.Count, 2);
Assert.IsTrue(nameValueList.Any(o => o.Name != o.Value));
}
public TableDisplayVM(Table table, ITableReader tableReader)
{
_table = table;
_tableReader = tableReader;
IsVisible = true;
Load();
}
internal void Generating(ITableReader tableReader, IClassWriter classWriter)
{
tableReader.Close();
classWriter.ClearProperty();
string className = FileMedia.QUERY_CLASS_PRE + Misc.GetPublicName(tableReader.TableName);
classWriter.ClassName = className;
if (string.IsNullOrEmpty(classWriter.NameSpace))
{
classWriter.NameSpace = _nameSpace;
}
try
{
tableReader.Open();
while (tableReader.Read())
{
TableColumn tableColumn = tableReader.CurrentColumn().Value;
string propertyName = Misc.GetPublicName(tableColumn.Name);
classWriter.AppendProperty(propertyName, tableColumn, tableColumn.DotNetType);
}
classWriter.WriteOut();
}
finally
{
tableReader.Close();
}
}
public void Generating(ITableReader tableReader, IClassWriter classWriter, IClassLogicWriter classLogicWriter, IMapWriter mapWriter)
{
tableReader.Close();
classWriter.ClearProperty();
mapWriter.ClearItem();
if (classLogicWriter != null)
{
classLogicWriter.ClearProperty();
}
string className = FileMedia.ENTITY_CLASS_PRE + Misc.GetPublicName(tableReader.TableName);
classWriter.NameSpace = _nameSpace;
classWriter.ClassName = className;
if (classLogicWriter != null)
{
classLogicWriter.ClassNameSpace = _nameSpace;
classLogicWriter.ClassName = className;
classLogicWriter.ClassLogicNameSpace = _logicNameSpace;
classLogicWriter.ClassLogicName = className + "Helper";
}
mapWriter.ClassName = string.Format("{0}.{1}", _nameSpace, className);
mapWriter.AssemblyName = _assemblyName;
mapWriter.TableName = tableReader.TableName;
try
{
tableReader.Open();
while (tableReader.Read())
{
TableColumn tableColumn = tableReader.CurrentColumn().Value;
string propertyName = Misc.GetPublicName(tableColumn.Name);
classWriter.AppendProperty(propertyName, tableColumn, tableColumn.DotNetType);
if (classLogicWriter != null)
{
classLogicWriter.AppendProperty(propertyName, tableColumn.DotNetType, tableColumn.IsKey);
}
mapWriter.AppendItem(new MapItem(propertyName, tableColumn.Name, tableColumn.DatabaseType, tableColumn.IsKey, tableColumn.CanBeNull, tableColumn.MaxLength, true, true));
}
classWriter.WriteOut();
if (classLogicWriter != null)
{
classLogicWriter.WriteOut();
}
mapWriter.WriteOut();
}
finally
{
tableReader.Close();
}
}
public void Load(ITableReader reader)
{
Debug.Assert(reader != null);
foreach (byte b in Signature)
{
if (reader.ReadByte() != b)
{
throw new CorruptedStreamException();
}
}
DataPosition = reader.ReadLong();
TableVersion = reader.ReadUInt();
DateTime creation = reader.ReadTime();
DateTime access = reader.ReadTime();
DateTime write = reader.ReadTime();
uint nextId = reader.ReadUInt();
DoLoad(reader);
LastWriteTime = write;
LastAccessTime = access;
CreationTime = creation;
m_nextId = nextId;
IsDirty = false;
}
public UserSyncProcessor(ITableReader<UserEntry> reader,
IAFAccess afAccess,
AFElementTemplate userTemplate)
{
_reader = reader;
_afAccess = afAccess;
_template = userTemplate;
}
public FormTableImporter(ITableReader reader) : this()
{
this.reader = reader;
this.SelectedColumns = new int[reader.NumColumns];
for (int i = 0; i < SelectedColumns.Length; i++)
{
SelectedColumns[i] = -1;
}
}
public static void Copy(ITableReader tableReader, ITableWriter tableWriter)
{
while (tableReader.Read())
{
tableWriter.Next();
Copy <string>(tableReader, tableWriter);
}
}
/// <summary>
/// Initialize from a source, every item is added by calling InsertOrUpdate
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="writer"></param>
/// <param name="copyFrom"></param>
/// <returns></returns>
public static async Task Initialize <T>(this ITableWriter <T> writer, ITableReader <T> copyFrom)
{
var list = await copyFrom.GetAll();
foreach (var item in list)
{
var item1 = item;
await writer.InsertOrUpdate(item, obj => item1);
}
}
private void Trace(ITableReader reader)
{
foreach (var row in reader.Rows)
{
foreach (var columnName in reader.Columns)
{
Console.Write(row[columnName]);
Console.Write("\t");
}
Console.WriteLine();
}
}
//protected:
protected override void DoLoad(ITableReader reader)
{
int allCount = (int)reader.ReadLong();
int ndxFirstDelFrame = (int)reader.ReadLong();
if (allCount <= ndxFirstDelFrame)
{
throw new CorruptedStreamException();
}
m_frameCount = allCount;
m_ndxFirstDelFrame = ndxFirstDelFrame;
}
public GPXProcessor(ITableReader<GPXEntry> reader,
IGPXRowProcessor rowProcessor,
IAFAccess afAccess,
ITableWriter<GPXEntry> writer,
[Named("GpxElement")] AFElementTemplate gpxTemplate,
[Named("GpxEventFrame")] AFElementTemplate efTemplate)
{
_reader = reader;
_rowProcessor = rowProcessor;
_afAccess = afAccess;
_writer = writer;
_template = gpxTemplate;
_efTemplate = efTemplate;
}
public FormTableImporterPlayer(ITableReader reader, IList <Player> players) : base(reader)
{
this.players = players;
AddColumnInfo("Tag Number", "ID", "#", "Number", "Tag");
AddColumnInfo("Name", "Player");
AddColumnInfo("Primary Position", "Position", "Primary");
AddColumnInfo("Primary Grade", "Grade");
AddColumnInfo("Secondary Position", "Secondary");
AddColumnInfo("Secondary Grade");
AddColumnInfo("Primary Position and Grade");
AddColumnInfo("Secondary Position and Grade");
AddColumnInfo("Team Size", "Preferred Team Size");
this.Text = "Import Players";
DrawData();
}
void Init(ITableReader reader)
{
int ndx = m_header.FirstDeletedFrameIndex;
Assert(m_recycledData.Count == 0);
while (ndx != NULL_INDEX)
{
m_recycledData.Add(ndx);
reader.Position = GetFramePosition(ndx);
ndx = reader.ReadInt();
}
m_recycledData.Sort();
}
public void ReadAdHocTableExcelDataReader()
{
ITableReader reader = AdoTableReader.ReadContiguousExcelTableWithHeader(XlsTestFilePath, null, 17);
//Trace(reader);
var xlsResult = reader.Rows.ToListOfDictionaries();
reader = AdoTableReader.ReadContiguousExcelTableWithHeader(TestFilePath, null, 17);
//Trace(reader);
var xlsxResult = reader.Rows.ToListOfDictionaries();
Assert.AreEqual(xlsResult, xlsxResult);
Assert.AreEqual(1895, xlsResult.Count);
}
private void OpenRom()
{
var romStream = OpenRomFile();
_loaderRomManager = new LoadedRomManager(romStream, _definitionLoader);
var tables = _loaderRomManager.Rom.Tables.Select(t => new TableDisplayVM(t, _loaderRomManager));
var data = tables.GroupBy(g => g.Category)
.Select(g => new GroupTableDisplayVM()
{
Name = g.Key, Tables = g.Select(a => a).ToList()
})
.ToList();
GroupedTables = data;
}
public FitbitProcessor(
IAFAccess afAccess,
ITableReader<UserEntry> reader,
IFitbitUserFactory fitbitUserFactory,
Dictionary<string, FitbitUser> fitbitUserCache,
FitbitStreams fitbitStreams,
FitbitValuesConverter fitbitConverter,
AFElementTemplate elementTemplate)
{
_afAccess = afAccess;
_reader = reader;
_fitbitUserFactory = fitbitUserFactory;
_fitbitUserCache = fitbitUserCache;
_template = elementTemplate;
_fitbitStreams = fitbitStreams;
_fitbitConverter = fitbitConverter;
_count = 0;
}
public void Load(ITableReader reader)
{
Assert(reader != null);
byte[] sign = Signature;
byte[] bytes = reader.ReadBytes(sign.Length);
for (int i = 0; i < sign.Length; ++i)
{
if (sign[i] != bytes[i])
{
throw new CorruptedStreamException();
}
}
uint ver = reader.ReadUInt();
uint tag = reader.ReadUInt();
int nTotal = reader.ReadInt();
int ndxDeleted = reader.ReadInt();
int sz = reader.ReadInt();
if (nTotal <= ndxDeleted || sz <= 0)
{
throw new CorruptedStreamException();
}
CreationTime = reader.ReadTime();
LastWriteTime = reader.ReadTime();
Version = ver;
Tag = tag;
FrameCount = nTotal;
FirstDeletedFrameIndex = ndxDeleted;
FrameSize = sz;
DataOffset = reader.Position;
IsDirty = false;
}
public static CompaniesUsersAddresses LoadFrom(ITableReader reader)
{
Company[] companies = null;
User[] users = null;
Address[] addresses = null;
foreach (ITable table in reader.GetTables())
{
switch (table.Name)
{
case "Companies":
companies = new CompanyParser().GetAll(table).ToArray();
break;
case "Users":
users = new UserParser().GetAll(table).ToArray();
break;
case "Addresses":
addresses = new AddressParser().GetAll(table).ToArray();
break;
}
}
return new CompaniesUsersAddresses(companies, users, addresses);
}
public static void Copy(ITableReader tableReader, IDataWriter dataWriter)
{
Copy(new TableToArrayReader(tableReader), dataWriter.As <int>());
}
public Serializer(XLSSConfig config, ITableReader reader)
{
_config = config;
_reader = reader;
}
public static async Task <ReaderMatch <TEntity> > GetSingle <TEntity>(this ITableReader <TEntity> reader, TEntity match)
{
var r = await reader.Get(match);
return(await Task.FromResult(new ReaderMatch <TEntity>(r)));
}
public static async Task <ReaderMatch <IEnumerable <TEntity> > > QueryAll <TEntity>(this ITableReader <TEntity> reader, System.Linq.Expressions.Expression <Func <TEntity, bool> > query)
{
var items = await reader.GetAll();
if (items != null)
{
return(await Task.FromResult(new ReaderMatch <IEnumerable <TEntity> >(items.Where(query.Compile()))));
}
return(await Task.FromResult(new ReaderMatch <IEnumerable <TEntity> >(new TEntity[0]) { IsMatch = false }));
}
public Repository(LtConnection connection, ISqlBuilder sqlBuilder, ITableReader <TEntity> tableReader)
{
_connection = connection ?? throw new ArgumentNullException(nameof(connection));
_sqlBuilder = sqlBuilder ?? throw new ArgumentNullException(nameof(sqlBuilder));
_tableReader = tableReader ?? throw new ArgumentNullException(nameof(connection));
}
/// <summary>
/// Create a new enumerator to read through the table rows
/// </summary>
/// <param name="reader">the table to read lines from</param>
public TableEnumerator(ITableReader reader)
{
this.reader = reader;
}
public FamilyReader(ITableReader tableReader)
{
this.tableReader = tableReader;
}
/// <summary>
/// Read list of entity instances from raw table reader.
/// </summary>
/// <param name="tableReader"></param>
/// <returns></returns>
public IList <T> Read(ITableReader tableReader)
{
Check.DoRequireArgumentNotNull(tableReader, nameof(tableReader));
return(Mapper.Map <IEnumerable <ITableRowReader>, IList <T> >(tableReader.Rows));
}
protected abstract void DoLoad(ITableReader reader);
//protected:
protected override void DoLoad(ITableReader reader)
{
int count = (int)reader.ReadLong();
DataCount = count;
}
public TableToArrayReader(ITableReader tableReader)
{
this.tableReader = tableReader;
}
