public override void Connect_To_Database(StorageConfig config)
{
myConfig = config as SQLiteConfig;
if (myConfig == null)
{
throw new Exception("Database Config is NULL");
}
try
{
string connString = string.Format("Data Source={0};Pooling=true;FailIfMissing=false", myConfig.DatabaseFile);
myDBConn = new FbConnection(connString);
myDBConn.Open();
if (myDBConn.State != System.Data.ConnectionState.Open)
{
throw new Exception();
}
}
catch (FbException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public override void Connect_To_Database(StorageConfig config)
{
myConfig = config as SQLiteConfig;
if (myConfig == null)
{
throw new Exception("Database Config is NULL");
}
if (!FileNameLockObjects.ContainsKey(myConfig.DatabaseFile))
{
FileNameLockObjects.Add(myConfig.DatabaseFile, new object());
}
try
{
myDBConn = new SQLiteConnection(ConnectionString);
myDBConn.Open();
if (myDBConn.State != System.Data.ConnectionState.Open)
{
throw new Exception("Unable to Open Database. Storage:" + config.Name);
}
}
catch (SQLiteException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public void TestWithObject()
{
SQLiteConfig config = new SQLiteConfig();
config.dataSource = @"test.db";
bool isConnect = SQLiteLib.connect(config);
Assert.AreEqual(true, isConnect);
}
public static void SetConfig(SQLiteConfig config, params object[] args)
{
int n = UnsafeNativeMethods.sqlite3_config((int)config, args);
if (n > 0)
{
throw new SqliteException(n, null);
}
}
public void TestWithJsonFile()
{
SQLiteConfig config = new SQLiteConfig();
config.dataSource = @"test.db";
SQLiteConfigJson.save(config, true);
bool isConnect = SQLiteLib.connect();
Assert.AreEqual(true, isConnect);
}
/// <summary>
/// Constructor of MongoConnecter
/// </summary>
/// <param name="configuration">Contain all of config for connecter</param>
private SQLiteConnecter(IConfigurationSection configuration)
{
Config = new SQLiteConfig();
configuration.Bind(Config);
string currentPath = Environment.CurrentDirectory;
string projectDirectory = Directory.GetParent(currentPath).FullName;
string connectString = string.Format("Data Source={0}; Version = 3;", projectDirectory + Config.Connect);
connection = new SQLiteConnection();
connection.ConnectionString = connectString;
}
private void cmdAddSQLiteStorage_Click(object sender, RoutedEventArgs e)
{
string val = "Storage_" + (grdStorages.Items.Count + 1);
if (DotNetSiemensPLCToolBoxLibrary.General.InputBox.Show("Storage-Name", "Name of the Storage", ref val) == DialogResult.OK)
{
foreach (var tmp in ProtokollerConfiguration.ActualConfigInstance.Storages)
{
if (tmp.Name.ToLower().Trim() == val.ToLower().Trim())
{
MessageBox.Show("A Storage with this Name already Exists!", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
SQLiteConfig storage = new SQLiteConfig()
{
Name = val
};
ProtokollerConfiguration.ActualConfigInstance.Storages.Add(storage);
}
}
// http://www.sqlite.org/c3ref/config.html
public static void SetConfig (SQLiteConfig config)
{
int n = UnsafeNativeMethods.sqlite3_config (config);
if (n > 0) throw new SqliteException (n, null);
}
internal static extern int sqlite3_config (SQLiteConfig config);
internal static extern int sqlite3_config(SQLiteConfig config);
public static void SetConfig(SQLiteConfig config, params object[] args)
{
int n = UnsafeNativeMethods.sqlite3_config((int)config, args);
if (n > 0) throw new SqliteException(n, null);
}
