public void Save(IEnumerable<Gnosis.ITag> tags)
{
if (tags == null)
throw new ArgumentNullException("tags");
try
{
logger.Info("SQLiteTagRepository.Save(IEnumerable<ITag>)");
var builders = new List<ICommandBuilder>();
foreach (var tag in tags)
{
var builder = new CommandBuilder();
builder.AppendLine("replace into Tag (Id, Target, Algorithm, Domain, Type, Value, Data) values (@Id, @Target, @Algorithm, @Domain, @Type, @Value, @Data);");
builder.AddParameter("@Id", tag.Id > 0 ? (object)tag.Id : (object)DBNull.Value);
builder.AddParameter("@Target", tag.Target.ToString());
builder.AddParameter("@Algorithm", tag.Algorithm.Id);
builder.AddParameter("@Domain", (int)tag.Type.Domain);
builder.AddParameter("@Type", tag.Type.Id);
builder.AddParameter("@Value", tag.Value);
builder.AddParameter("@Data", tag.Data);
builders.Add(builder);
}
if (builders.Count == 0)
return;
ExecuteTransaction(builders);
}
catch (Exception ex)
{
logger.Error(" Save(IEnumerable<ITag>)", ex);
throw;
}
}
public void Delete(IEnumerable<long> ids)
{
if (ids == null)
throw new ArgumentNullException("ids");
try
{
logger.Info("SQLiteTagRepository.Delete(IEnumerable<long>)");
var builders = new List<ICommandBuilder>();
foreach (var id in ids)
{
var builder = new CommandBuilder();
builder.AppendLine("delete from Tag where Id = @Id;");
builder.AddParameter("@Id", id);
builders.Add(builder);
}
if (builders.Count == 0)
return;
ExecuteTransaction(builders);
}
catch (Exception ex)
{
logger.Error(" Delete(IEnumerable<long>)", ex);
throw;
}
}
public void Initialize()
{
try
{
logger.Info("SQLiteTagRepository.Initialize");
var builder = new CommandBuilder();
builder.AppendLine("create table if not exists Tag (Id integer primary key not null, Target text not null, Algorithm integer not null, Domain integer not null, Type integer not null, Value text not null, Data blob not null);");
builder.AppendLine("create index if not exists Tag_Target on Tag (Target asc);");
builder.AppendLine("create index if not exists Tag_Target_Domain on Tag (Target asc, Domain asc);");
builder.AppendLine("create unique index if not exists Tag_Target_Algorithm_Type_Value on Tag (Target asc, Algorithm asc, Type asc, Value asc);");
builder.AppendLine("create index if not exists Tag_Target_Type on Tag (Target asc, Type asc);");
builder.AppendLine("create index if not exists Tag_Target_Type_Value on Tag (Target asc, Type asc, Value asc);");
builder.AppendLine("create index if not exists Tag_Algorithm_Domain_Value on Tag (Algorithm asc, Domain asc, Value asc);");
ExecuteNonQuery(builder);
}
catch (Exception ex)
{
logger.Error(" Initialize", ex);
throw;
}
}
