public void Dispose() { if (_dbcon != null) { _dbcon.Dispose(); _dbcon = null; } }
public SqliteSettingsStorage() { _availableKeys = new Hashtable(); try { var sf = Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), "GSAKWrapper"); RootSettingsFolder = sf; if (!Directory.Exists(sf)) { Directory.CreateDirectory(sf); } sf = Path.Combine(sf, "settings.db3"); if (ApplicationRunning) { _dbcon = new Database.DBConSqlite(sf); if (!_dbcon.TableExists("settings")) { _dbcon.ExecuteNonQuery("create table 'settings' (item_name text, item_value text)"); _dbcon.ExecuteNonQuery("create index idx_key on settings (item_name)"); } else { DbDataReader dr = _dbcon.ExecuteReader("select item_name, item_value from settings"); while (dr.Read()) { _availableKeys[dr[0] as string] = dr[1] as string; } } object o = _dbcon.ExecuteScalar("PRAGMA integrity_check"); if (o as string == "ok") { //what is expected } else { //oeps? _dbcon.Dispose(); _dbcon = null; } } } catch//(Exception e) { _dbcon = null; } }
public SqliteSettingsStorage() { _availableKeys = new Hashtable(); try { var sf = Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), "GSAKWrapper"); RootSettingsFolder = sf; if (!Directory.Exists(sf)) { Directory.CreateDirectory(sf); } sf = Path.Combine(sf, "settings.db3"); if (ApplicationRunning) { _dbcon = new Database.DBConSqlite(sf); if (!_dbcon.TableExists("settings")) { _dbcon.ExecuteNonQuery("create table 'settings' (item_name text, item_value text)"); _dbcon.ExecuteNonQuery("create index idx_key on settings (item_name)"); } else { DbDataReader dr = _dbcon.ExecuteReader("select item_name, item_value from settings"); while (dr.Read()) { _availableKeys[dr[0] as string] = dr[1] as string; } } object o = _dbcon.ExecuteScalar("PRAGMA integrity_check"); if (o as string == "ok") { //what is expected } else { //oeps? _dbcon.Dispose(); _dbcon = null; } } } catch//(Exception e) { _dbcon = null; } }
public SqliteSettingsStorage() { _availableKeys = new Hashtable(); try { var sf = Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData), "GSAKWrapper"); RootSettingsFolder = sf; if (!Directory.Exists(sf)) { Directory.CreateDirectory(sf); } sf = Path.Combine(sf, "settings.db3"); if (ApplicationRunning) { _dbcon = new Database.DBConSqlite(sf); if (!_dbcon.TableExists("settings")) { _dbcon.ExecuteNonQuery("create table 'settings' (item_name text, item_value text)"); _dbcon.ExecuteNonQuery("create index idx_key on settings (item_name)"); } else { DbDataReader dr = _dbcon.ExecuteReader("select item_name, item_value from settings"); while (dr.Read()) { _availableKeys[dr[0] as string] = dr[1] as string; } } if (!_dbcon.TableExists("formulasolv")) { _dbcon.ExecuteNonQuery("create table 'formulasolv' (gccode text, formula text)"); _dbcon.ExecuteNonQuery("create index idx_form on formulasolv (gccode)"); } if (!_dbcon.TableExists("GeocacheCollection")) { _dbcon.ExecuteNonQuery("create table 'GeocacheCollection' (CollectionID integer not null, Name text not null)"); _dbcon.ExecuteNonQuery("create index idx_gckey on GeocacheCollection (CollectionID)"); _dbcon.ExecuteNonQuery("create index idx_gcname on GeocacheCollection (Name)"); } if (!_dbcon.TableExists("GeocacheCollectionItem")) { _dbcon.ExecuteNonQuery("create table 'GeocacheCollectionItem' (CollectionID integer not null, GeocacheCode text not null, Name text not null)"); _dbcon.ExecuteNonQuery("create unique index idx_gcikey on GeocacheCollectionItem (CollectionID, GeocacheCode)"); _dbcon.ExecuteNonQuery("CREATE TRIGGER Delete_GeocacheCollection Delete ON GeocacheCollection BEGIN delete from GeocacheCollectionItem where CollectionID = old.CollectionID; END"); } if (!_dbcon.TableExists("ShapeFileItemV2")) { _dbcon.ExecuteNonQuery("create table 'ShapeFileItemV2' (FileName text, TableName text not null, CoordType text not null, AreaType text not null, NamePrefix text, Encoding text not null, Enabled integer not null)"); } if (!_dbcon.TableExists("Scripts")) { _dbcon.ExecuteNonQuery("create table 'Scripts' (Name text not null, ScriptType integer not null, Code text not null)"); _dbcon.ExecuteNonQuery("create unique index idx_scname on Scripts (Name)"); } object o = _dbcon.ExecuteScalar("PRAGMA integrity_check"); if (o as string == "ok") { //what is expected } else { //oeps? _dbcon.Dispose(); _dbcon = null; } } } catch//(Exception e) { _dbcon = null; } }