/// <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); }