/// <summary>
/// Creates a new <see cref="Record"/> instance.
/// </summary>
/// <param name="columns"></param>
/// <param name="values"></param>
/// <param name="owner"></param>
/// <returns></returns>
public static Record Create(
ImmutableArray<Column> columns,
ImmutableArray<Value> values,
Database owner)
{
return new Record()
{
Id = Guid.NewGuid(),
Columns = columns,
Values = values,
Owner = owner
};
}
/// <summary>
/// Creates a new <see cref="Column"/> instance.
/// </summary>
/// <param name="name"></param>
/// <param name="owner"></param>
/// <param name="width"></param>
/// <param name="isVisible"></param>
/// <returns></returns>
public static Column Create(
string name,
Database owner,
double width = double.NaN,
bool isVisible = true)
{
return new Column()
{
Id = Guid.NewGuid(),
Name = name,
Width = width,
IsVisible = isVisible,
Owner = owner
};
}
/// <summary>
///
/// </summary>
/// <param name="path"></param>
/// <param name="database"></param>
public void UpdateData(string path, Database database)
{
try
{
if (_csvReader == null)
return;
var db = _csvReader.Read(path);
if (db.Columns.Length <= 1)
return;
// check for the Id column
if (db.Columns[0].Name != "Id")
return;
// skip Id column for update
if (db.Columns.Length - 1 != database.Columns.Length)
return;
// check column names
for (int i = 1; i < db.Columns.Length; i++)
{
if (db.Columns[i].Name != database.Columns[i - 1].Name)
return;
}
bool isDirty = false;
var recordsBuilder = database.Records.ToBuilder();
for (int i = 0; i < database.Records.Length; i++)
{
var record = database.Records[i];
var result = db.Records.FirstOrDefault(r => r.Id == record.Id);
if (result != null)
{
// update existing record
for (int j = 1; j < result.Values.Length; j++)
{
var valuesBuilder = record.Values.ToBuilder();
valuesBuilder[j - 1] = result.Values[j];
record.Values = valuesBuilder.ToImmutable();
}
isDirty = true;
}
else
{
var r = db.Records[i];
// use existing columns
r.Columns = database.Columns;
// skip Id column
r.Values = r.Values.Skip(1).ToImmutableArray();
recordsBuilder.Add(r);
isDirty = true;
}
}
if (isDirty)
{
var builder = _editor.Project.Databases.ToBuilder();
var index = builder.IndexOf(database);
database.Records = recordsBuilder.ToImmutable();
builder[index] = database;
var previous = _editor.Project.Databases;
var next = builder.ToImmutable();
_editor.History.Snapshot(previous, next, (p) => _editor.Project.Databases = p);
_editor.Project.Databases = next;
}
}
catch (Exception ex)
{
if (_editor.Log != null)
{
_editor.Log.LogError("{0}{1}{2}",
ex.Message,
Environment.NewLine,
ex.StackTrace);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="path"></param>
/// <param name="database"></param>
public void ExportData(string path, Database database)
{
try
{
if (_csvWriter == null)
return;
_csvWriter.Write(path, database);
}
catch (Exception ex)
{
if (_editor.Log != null)
{
_editor.Log.LogError("{0}{1}{2}",
ex.Message,
Environment.NewLine,
ex.StackTrace);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="database"></param>
public void Remove(Database database)
{
if (database == null)
return;
database.PropertyChanged -= DatabaseObserver;
Verbose("Remove Database: " + database.Name);
if (database.Columns != null)
{
Remove(database.Columns);
}
if (database.Records != null)
{
Remove(database.Records);
}
}
/// <summary>
///
/// </summary>
/// <param name="database"></param>
public void Add(Database database)
{
if (database == null)
return;
database.PropertyChanged += DatabaseObserver;
Verbose("Add Database: " + database.Name);
if (database.Columns != null)
{
Add(database.Columns);
}
if (database.Records != null)
{
Add(database.Records);
}
}
/// <summary>
///
/// </summary>
/// <param name="path"></param>
/// <param name="database"></param>
public void UpdateData(string path, Database database)
{
try
{
if (_csvReader == null)
return;
var db = _csvReader.Read(path);
_editor.ApplyDatabase(database, db);
}
catch (Exception ex)
{
if (_editor.Log != null)
{
_editor.Log.LogError("{0}{1}{2}",
ex.Message,
Environment.NewLine,
ex.StackTrace);
}
}
}
