/// <summary>
/// Show the query analyser
/// </summary>
/// <returns></returns>
public static DialogResult ShowQueryAnalyzer()
{
var sqldbFile = FileUtil.CreateTempFile("db", new string[0]);
var connStr = ConnectionStringManager.MakeSQLite(sqldbFile, "", false, true);
return(ShowQueryAnalyzer(connStr, DatabaseProvider.SQLite));
}
static void Main(string[] args)
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new Form1());
string connectionString = string.Empty;
string filename = (args.Length > 0) ? args[0] : FileUtil.CreateTempFile("db", new string[0]);
connectionString = ConnectionStringManager.MakeSQLite(filename, string.Empty, false, true);
ControlManager.ShowQueryAnalyzer(connectionString, DatabaseProvider.SQLite);
}
public void DoPivotTest()
{
try
{
// data source="C:\twork\Realign\comp.db"; password=""; read only=false; failifmissing=false; compress=false
var df = new DataFactory(DatabaseProvider.SQLite, ConnectionStringManager.MakeSQLite(@"c:\twork\realign\comp.db", "", false, true));
df.MacroManager.Execute("@pivot b1_Zip_Comp_random1000 pivot sumCount zip foo");
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw;
}
}
/// <summary>
/// Show the query analyser
/// </summary>
/// <returns></returns>
public static DialogResult ShowQueryAnalyzer(DataSet ds)
{
var tmpFile = FileUtil.CreateTempFile("db", new string[0]);
var df = new DataFactory(DatabaseProvider.SQLite, ConnectionStringManager.MakeSQLite(tmpFile, "", false, true));
df.TestConnection();
foreach (DataTable dt in ds.Tables)
{
df.CreateTable(dt.TableName, dt);
}
return(ShowQueryAnalyzer(df.ConnectionStringManager.ConnectionString, df.Provider));
}
public void TestSQLiteConnectionString()
{
// Arrange
string connStr = ConnectionStringManager.MakeSQLite(@"c:\f=oo;ba'r.xls", "mypassword!", false, false);
// Act
var result = ConnectionStringParser.Parse(connStr);
// Assert
Assert.AreEqual(result["data source"], @"c:\f=oo;ba'r.xls");
Assert.AreEqual(result["password"], @"mypassword!");
Assert.AreEqual(result["read only"], @"false");
Assert.AreEqual(result["failifmissing"], @"false");
Assert.AreEqual(result["compress"], @"true");
Assert.AreEqual(result.Count, 5);
}
private static void ImportTableWithPrimaryKeyToSQLiteDB()
{
var df = new DataFactory(DatabaseProvider.SQLite, ConnectionStringManager.MakeSQLite("foo.db", "", false, false));
df.TestConnection();
var dt = new DataTable("MyTable");
dt.Columns.Add("ID", typeof(int)).AutoIncrement = true;
dt.Columns.Add("Name", typeof(string));
dt.Rows.Add(1, "Abc");
dt.Rows.Add(2, "Abc");
dt.Rows.Add(3, "Abc");
df.CreateTable(dt.TableName, dt);
}
static void TestQueryAnalyzer()
{
var connStr = ConnectionStringManager.MakeSQLite(@"%TMP%\foo.sqlitedb", null, false, false);
ControlManager.ShowQueryAnalyzer(connStr, DatabaseProvider.SQLite);
}
