private void LoadArtistLinks(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from ArtistLink;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var artist = cache.GetArtist((uint)reader.GetInt64(1));
var name = reader.GetString(2);
var relationship = (Relationship)reader.GetInt32(3);
var source = (Source)reader.GetInt32(4);
var target = reader.GetString(5);
if (artist == null)
{
continue;
}
var link = new Link(name, relationship, source, target);
cache.Add(id, artist, link);
artist.AddLink(link);
}
}
}
private void LoadArtistTags(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from ArtistTag;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var artist = cache.GetArtist((uint)reader.GetInt64(1));
var name = reader.GetString(2);
var category = (Category)reader.GetInt32(3);
var source = (Source)reader.GetInt32(4);
if (artist == null)
{
continue;
}
var tag = new Tag(name, category, source);
cache.Add(id, artist, tag);
artist.AddTag(tag);
}
}
}
private void LoadWorks(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from Work;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var type = (WorkType)reader.GetInt32(1);
var parent = cache.GetWork((uint)reader.GetInt64(2));
var artist = cache.GetArtist((uint)reader.GetInt64(3));
var name = reader.GetString(4);
var year = reader.GetInt16(5);
var number = (uint)reader.GetInt64(6);
cache.Add(id, new Work()
{
Type = type, Parent = parent, Artist = artist, Name = name, Year = year, Number = number
});
}
}
LoadWorkLinks(connection, cache);
LoadWorkTags(connection, cache);
}
public GlobalBatch(GlobalCache cache, GlobalDatabase database)
{
if (cache == null)
throw new ArgumentNullException("cache");
if (database == null)
throw new ArgumentNullException("database");
this.cache = cache;
this.database = database;
}
public void Initialize(GlobalCache cache)
{
using (var connection = GetConnection())
{
connection.Open();
var command = GetCommand(connection, initializeCommandText);
command.ExecuteNonQuery();
LoadArtists(connection, cache);
LoadWorks(connection, cache);
}
}
public GlobalBatch(GlobalCache cache, GlobalDatabase database)
{
if (cache == null)
{
throw new ArgumentNullException("cache");
}
if (database == null)
{
throw new ArgumentNullException("database");
}
this.cache = cache;
this.database = database;
}
private void LoadArtists(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from Artist;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var type = (ArtistType)reader.GetInt32(1);
var name = reader.GetString(2);
var year = reader.GetInt16(3);
cache.Add(id, new Artist() { Type = type, Name = name, Year = year });
}
}
LoadArtistLinks(connection, cache);
LoadArtistTags(connection, cache);
}
private void LoadArtists(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from Artist;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var type = (ArtistType)reader.GetInt32(1);
var name = reader.GetString(2);
var year = reader.GetInt16(3);
cache.Add(id, new Artist()
{
Type = type, Name = name, Year = year
});
}
}
LoadArtistLinks(connection, cache);
LoadArtistTags(connection, cache);
}
private void LoadArtistTags(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from ArtistTag;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var artist = cache.GetArtist((uint)reader.GetInt64(1));
var name = reader.GetString(2);
var category = (Category)reader.GetInt32(3);
var source = (Source)reader.GetInt32(4);
if (artist == null)
continue;
var tag = new Tag(name, category, source);
cache.Add(id, artist, tag);
artist.AddTag(tag);
}
}
}
private void LoadArtistLinks(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from ArtistLink;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var artist = cache.GetArtist((uint)reader.GetInt64(1));
var name = reader.GetString(2);
var relationship = (Relationship)reader.GetInt32(3);
var source = (Source)reader.GetInt32(4);
var target = reader.GetString(5);
if (artist == null)
continue;
var link = new Link(name, relationship, source, target);
cache.Add(id, artist, link);
artist.AddLink(link);
}
}
}
public void Initialize(GlobalCache cache)
{
using (var connection = GetConnection())
{
connection.Open();
var command = GetCommand(connection, initializeCommandText);
command.ExecuteNonQuery();
LoadArtists(connection, cache);
LoadWorks(connection, cache);
}
}
private void LoadWorks(IDbConnection connection, GlobalCache cache)
{
var command = GetCommand(connection, "select * from Work;");
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = (uint)reader.GetInt64(0);
var type = (WorkType)reader.GetInt32(1);
var parent = cache.GetWork((uint)reader.GetInt64(2));
var artist = cache.GetArtist((uint)reader.GetInt64(3));
var name = reader.GetString(4);
var year = reader.GetInt16(5);
var number = (uint)reader.GetInt64(6);
cache.Add(id, new Work() { Type = type, Parent = parent, Artist = artist, Name = name, Year = year, Number = number });
}
}
LoadWorkLinks(connection, cache);
LoadWorkTags(connection, cache);
}
