// -------- Constructor --------
/// <summary>
/// Constructor
/// </summary>
/// <param name="databaseLocation">The database location.</param>
public KarmaBotDatabase(string databaseLocation)
{
ISQLitePlatform platform;
if (Environment.OSVersion.Platform.Equals(PlatformID.Win32NT))
{
Console.WriteLine("KarmaBot> Using Win32 Sqlite Platform");
platform = new SQLite.Net.Platform.Win32.SQLitePlatformWin32();
}
else
{
// Requires the SQLite.so (shared object) files to be installed.
Console.WriteLine("KarmaBot> Using Generic Sqlite Platform");
platform = new SQLite.Net.Platform.Generic.SQLitePlatformGeneric();
}
this.sqlite = new SQLiteConnection(
platform,
databaseLocation,
SQLiteOpenFlags.Create | SQLiteOpenFlags.ReadWrite
);
this.sqlite.CreateTable <IrcUser>();
this.sqlite.Commit();
this.ircUserCache = new Dictionary <string, IrcUser>();
}
public Db(string dbPath)
{
var platform = new SQLite.Net.Platform.Generic.SQLitePlatformGeneric();
connection = new SQLiteConnection(platform, dbPath);
CreateDb();
}
public SQLiteConnection GetConnection()
{
if (_connection == null)
{
var folder = AppDomain.CurrentDomain.BaseDirectory;
string databaseFileName = Path.Combine(folder, GlobalConfig.DATABASE_NAME);
var platform = new SQLite.Net.Platform.Generic.SQLitePlatformGeneric();
_connection = new SQLite.Net.SQLiteConnection(platform, databaseFileName);
}
return(_connection);
}
protected override void AdditionalSetup()
{
_fixture = new Fixture().Customize(new AutoMoqCustomization());
var mockDeviceInfo = _fixture.InjectNewMock <IDeviceInfo>();
mockDeviceInfo.Setup(di => di.DatabasePath).Returns(string.Empty);
var platform = new SQLite.Net.Platform.Generic.SQLitePlatformGeneric();
_dataService = new DataService(mockDeviceInfo.Object, platform);
var connection = _dataService.GetDBConnection();
this.CreateEmptyTable <Device>(connection);
this.CreateEmptyTable <GrandParentEntity>(connection);
this.CreateEmptyTable <ParentEntity>(connection);
this.CreateEmptyTable <ChildEntity>(connection);
this.CreateEmptyTable <ChildEntity2>(connection);
this.CreateEmptyTable <SingleChildEntity>(connection);
this.CreateEmptyTable <MultiChildEntity>(connection);
}
