} // End Constructor 0
public cSQLite(string strConnectionString)
{
CopySQLite();
this.m_dbtDBtype = DataBaseEngine_t.SQLite;
this.m_providerFactory = this.GetFactory();
this.m_dictScriptTemplates = GetSQLtemplates();
//this.m_dblDBversion = 8.0;
this.m_ConnectionString = new SQLiteConnectionStringBuilder(strConnectionString);
} // End Constructor 1
} // End Sub CopySQLite
public override string GetConnectionString(string strDb)
{
if (string.IsNullOrEmpty(strDb))
{
return(this.m_ConnectionString.ConnectionString);
}
SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder(this.m_ConnectionString.ConnectionString);
csb.DataSource = strDb;
string strRetVal = csb.ConnectionString;
// csb.Clear ();
csb = null;
return(strRetVal);
} // End Function GetConnectionString
/// <summary>
/// Initializes a new instance of the <see cref="InMemorySQLiteDatabase"/> class.
/// </summary>
public InMemorySQLiteDatabase()
{
var connectionStringBuilder = new SQLiteConnectionStringBuilder
{
DataSource = ":memory:",
Version = 3,
DefaultTimeout = 5,
#if MONO
JournalMode = SQLiteJournalModeEnum.Off,
#else
JournalMode = SQLiteJournalModeEnum.Memory,
#endif
UseUTF16Encoding = true
};
ConnectionString = connectionStringBuilder.ToString();
connectionManager = new SQLiteConnectionManager(connectionStringBuilder.ConnectionString);
sharedConnection = new SQLiteConnection(connectionStringBuilder.ConnectionString);
sharedConnection.Open();
sqlRunner = new AdHocSqlRunner(() => sharedConnection.CreateCommand(), null, () => true);
}
/// <summary>
/// Initializes a new instance of the <see cref="InMemorySQLiteDatabase"/> class.
/// </summary>
public InMemorySQLiteDatabase()
{
var connectionStringBuilder = new SQLiteConnectionStringBuilder
{
DataSource = ":memory:",
Version = 3,
DefaultTimeout = 5,
#if MONO
JournalMode = SQLiteJournalModeEnum.Off,
#else
JournalMode = SQLiteJournalModeEnum.Memory,
#endif
UseUTF16Encoding = true
};
ConnectionString = connectionStringBuilder.ToString();
connectionManager = new SQLiteConnectionManager(connectionStringBuilder.ConnectionString);
sharedConnection = new SQLiteConnection(connectionStringBuilder.ConnectionString);
sharedConnection.Open();
sqlRunner = new AdHocSqlRunner(() => sharedConnection.CreateCommand(), null, () => true);
}
/// <summary>
/// Initializes a new instance of the <see cref="TemporarySQLiteDatabase"/> class.
/// </summary>
/// <param name="name">The name.</param>
public TemporarySQLiteDatabase(string name)
{
dataSourcePath = Path.Combine(Environment.CurrentDirectory, name);
var connectionStringBuilder = new SQLiteConnectionStringBuilder
{
DataSource = name,
Version = 3,
DefaultTimeout = 5,
#if MONO
JournalMode = SQLiteJournalModeEnum.Off,
#else
JournalMode = SQLiteJournalModeEnum.Memory,
#endif
UseUTF16Encoding = true
};
sqLiteConnection = new SQLiteConnection(connectionStringBuilder.ConnectionString);
sqLiteConnection.Open();
sharedConnection = new SharedConnection(sqLiteConnection);
sqlRunner = new AdHocSqlRunner(() => sqLiteConnection.CreateCommand(), null, () => true);
}
/// <summary>
/// Initializes a new instance of the <see cref="TemporarySQLiteDatabase"/> class.
/// </summary>
/// <param name="name">The name.</param>
public TemporarySQLiteDatabase(string name)
{
dataSourcePath = Path.Combine(Environment.CurrentDirectory, name);
var connectionStringBuilder = new SQLiteConnectionStringBuilder
{
DataSource = name,
Version = 3,
DefaultTimeout = 5,
#if MONO
JournalMode = SQLiteJournalModeEnum.Off,
#else
JournalMode = SQLiteJournalModeEnum.Memory,
#endif
UseUTF16Encoding = true
};
sqLiteConnection = new SQLiteConnection(connectionStringBuilder.ConnectionString);
sqLiteConnection.Open();
sharedConnection = new SharedConnection(sqLiteConnection);
sqlRunner = new AdHocSqlRunner(() => sqLiteConnection.CreateCommand(), null, () => true);
}
public static void Setup(bool useLocalFiles)
{
DataDirectory = new DirectoryInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "Gablarski"));
if (!DataDirectory.Exists)
{
DataDirectory.Create();
}
if (useLocalFiles)
{
KeyFile = new FileInfo("gablarski.key");
DbFile = new FileInfo("gablarski.db");
}
else
{
KeyFile = new FileInfo(Path.Combine(DataDirectory.FullName, "gablarski.key"));
DbFile = new FileInfo(Path.Combine(DataDirectory.FullName, "gablarski.db"));
}
#if !XAMARIN
var builder = new SQLiteConnectionStringBuilder();
builder.DataSource = DbFile.FullName;
db = new SQLiteConnection(builder.ToString());
#else
KeyFile = new FileInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), KeyFile.Name));
DbFile = new FileInfo(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), DbFile.Name));
if (!DbFile.Exists)
{
SQLiteConnection.CreateFile(DbFile.FullName);
}
db = new SQLiteConnection("Data Source=" + DbFile.FullName);
#endif
db.Open();
CreateDbs();
}
public new static void Tests()
{
System.Data.Common.DbConnectionStringBuilder dbcsb = new System.Data.Common.DbConnectionStringBuilder();
System.Data.SqlClient.SqlConnectionStringBuilder sqlcsb =
new System.Data.SqlClient.SqlConnectionStringBuilder();
sqlcsb.NetworkLibrary = "";
//sqlcsb.TransactionBinding
sqlcsb.TypeSystemVersion = "";
sqlcsb.UserInstance = true;
Npgsql.NpgsqlConnectionStringBuilder csb =
new Npgsql.NpgsqlConnectionStringBuilder();
// csb.Protocol
// csb.Compatible
//csb.SslMode = Npgsql.SslMode.Require;
// csb.UseExtendedTypes
System.Data.OracleClient.OracleConnectionStringBuilder ocb = new System.Data.OracleClient.OracleConnectionStringBuilder();
FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder fbcsb = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder();
fbcsb.ServerType = FirebirdSql.Data.FirebirdClient.FbServerType.Embedded;
Mono.Data.Sqlite.SqliteConnectionStringBuilder litecsb = new Mono.Data.Sqlite.SqliteConnectionStringBuilder();
litecsb.BinaryGUID = true;
litecsb.DateTimeFormat = Mono.Data.Sqlite.SQLiteDateFormats.ISO8601;
litecsb.DefaultIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
litecsb.DefaultTimeout = 123;
litecsb.FailIfMissing = true;
litecsb.JournalMode = Mono.Data.Sqlite.SQLiteJournalModeEnum.Off;
litecsb.LegacyFormat = false;
litecsb.SyncMode = Mono.Data.Sqlite.SynchronizationModes.Full;
litecsb.Uri = "";
litecsb.Version = 123;
MySql.Data.MySqlClient.MySqlConnectionStringBuilder mycb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
mycb.AllowBatch = true;
mycb.CertificateFile = "";
mycb.CertificatePassword = "";
mycb.CertificateStoreLocation = MySql.Data.MySqlClient.MySqlCertificateStoreLocation.LocalMachine;
mycb.CertificateThumbprint = "";
mycb.CharacterSet = "";
mycb.CheckParameters = true;
mycb.ConnectionLifeTime = 123;
mycb.ConnectionProtocol = MySql.Data.MySqlClient.MySqlConnectionProtocol.Tcp;
mycb.ConnectionReset = true;
mycb.ConvertZeroDateTime = false;
mycb.DefaultCommandTimeout = 123;
mycb.FunctionsReturnString = true;
mycb.IgnorePrepare = true;
mycb.InteractiveSession = false;
mycb.Keepalive = 123;
mycb.PipeName = "";
System.Data.Odbc.OdbcConnectionStringBuilder odbc = new System.Data.Odbc.OdbcConnectionStringBuilder();
//System.Data.OleDb.OleDbConnectionStringBuilder oledb = new System.Data.OleDb.OleDbConnectionStringBuilder();
} // End Sub
public void Open(string absoluteFilePath)
{
try
{
ConnectionStringBuilder connstr = new ConnectionStringBuilder();
connstr.DataSource = absoluteFilePath;
conn = new Connection();
conn.ConnectionString = connstr.ToString();
conn.Open();
cmdCommand = new Command(
"SELECT [Command] FROM [Command] WHERE [Name]=:name AND [Class]=:class",
conn);
cmdCommand.Parameters.Add(":name", DbType.Binary);
cmdCommand.Parameters.Add(":class", DbType.Binary);
textCommand = new Command(
"SELECT [Content] FROM [Text] WHERE [Name]=:name AND [Language]=:language AND [Class]=:class",
conn);
textCommand.Parameters.Add(":name", DbType.Binary);
textCommand.Parameters.Add(":language", DbType.Binary);
textCommand.Parameters.Add(":class", DbType.Binary);
troubleCodeCommand = new Command(
"SELECT [Content], [Description] FROM [TroubleCode] WHERE [Code]=:code AND [Language]=:language AND [Class]=:class",
conn);
troubleCodeCommand.Parameters.Add(":code", DbType.Binary);
troubleCodeCommand.Parameters.Add(":language", DbType.Binary);
troubleCodeCommand.Parameters.Add(":class", DbType.Binary);
liveDataCommand = new Command(
"SELECT [ShortName], [Content], [Unit], [DefaultValue], [CommandName], [CommandClass], [Description], [Index] FROM [LiveData] WHERE [Language]=:language AND [Class]=:class",
conn);
liveDataCommand.Parameters.Add(":language", DbType.Binary);
liveDataCommand.Parameters.Add(":class", DbType.Binary);
}
catch (Exception ex)
{
Close();
throw new DatabaseException(
String.Format("Cannot open vehicle database! file path = \"{0}\", error message: {1}",
absoluteFilePath, ex.Message));
}
}
