public void SelectAllFromElastic() { ConnectEngine engine = new ConnectEngine(); engine.AddConector(this.config); var results = engine.Run("SELECT * FROM [elastic].[]"); }
public void FromCsv() { var csvConnector = new CsvConnector(new CsvConnectorConfig { Alias = "csv" }); var connectEngine = new ConnectEngine(); connectEngine.AddConector(csvConnector); var results = connectEngine.Run("select * from csv.fromFile('employees.csv')").Cast <object>().ToList(); Assert.IsTrue(results.Count == 8); }
public void Select_From_Sqlite() { ConnectEngine connectEngine = new ConnectEngine(); connectEngine.AddConector(new SqliteConnectorConfig { Alias = "chinook", Database = "chinook.db" }); var table = connectEngine.Run("SELECT EmployeeId, Email FROM chinook.employees"); Assert.AreEqual(8, table.Count); Assert.AreEqual((Int64)1, table[0][0]); Assert.AreEqual("*****@*****.**", table[0][1]); Assert.AreEqual((Int64)2, table[1][0]); Assert.AreEqual("*****@*****.**", table[1][1]); }
public void Select_From_Csv() { ConnectEngine connectEngine = new ConnectEngine(); connectEngine.AddConector(new CsvConnectorConfig { Alias = "csv" }); var table = connectEngine.Run("SELECT id,email FROM csv.fromFile('employees.csv')"); Assert.AreEqual(8, table.Count); Assert.AreEqual("27", table[0][0]); Assert.AreEqual("*****@*****.**", table[0][1]); Assert.AreEqual("175", table[1][0]); Assert.AreEqual("*****@*****.**", table[1][1]); }
public void Select_From_Sqlite() { ConnectEngine connectEngine = new ConnectEngine(); connectEngine.AddConector(new SqliteConnectorConfig { Alias = "chinook", Database = "chinook.db" }); var result = connectEngine.Run("SELECT EmployeeId, Email FROM chinook.employees").Cast <object>().ToList(); var itemType = result[0].GetType(); Assert.AreEqual(8, result.Count); Assert.AreEqual(1, result[0].GetValue <int>("EmployeeId")); Assert.AreEqual("*****@*****.**", result[0].GetValue <string>("Email")); Assert.AreEqual(2, result[1].GetValue <int>("EmployeeId")); Assert.AreEqual("*****@*****.**", result[1].GetValue <string>("Email")); }
public void Select_From_Csv() { ConnectEngine connectEngine = new ConnectEngine(); connectEngine.AddConector(new CsvConnectorConfig { Alias = "csv" }); var result = connectEngine.Run("SELECT id,email FROM csv.fromFile('employees.csv')").Cast <object>().ToList(); var itemType = result[0].GetType(); Assert.AreEqual(8, result.Count); Assert.AreEqual("27", result[0].GetValue <string>("id")); Assert.AreEqual("*****@*****.**", result[0].GetValue <string>("email")); Assert.AreEqual("175", result[1].GetValue <string>("id")); Assert.AreEqual("*****@*****.**", result[1].GetValue <string>("email")); }
public void Select_From_Csv_Join_Sqlite() { ConnectEngine connectEngine = new ConnectEngine(); connectEngine.AddConector(new CsvConnectorConfig { Alias = "csv" }); connectEngine.AddConector(new SqliteConnectorConfig { Alias = "chinook", Database = "chinook.db" }); var table = connectEngine.Run(@" SELECT e2.EmployeeId, e1.last_name FROM csv.fromFile('employees.csv') e1 INNER JOIN chinook.employees e2 ON e2.Email = e1.email "); Assert.AreEqual(8, table.Count); Assert.AreEqual((Int64)1, table[0][0]); Assert.AreEqual("Adams", table[0][1]); Assert.AreEqual((Int64)2, table[1][0]); Assert.AreEqual("Edwards", table[1][1]); }
public void Select_From_Csv_Join_Sqlite() { ConnectEngine connectEngine = new ConnectEngine(); connectEngine.AddConector(new CsvConnectorConfig { Alias = "csv" }); connectEngine.AddConector(new SqliteConnectorConfig { Alias = "chinook", Database = "chinook.db" }); var result = connectEngine.Run(@" SELECT e2.EmployeeId, e1.last_name FROM csv.fromFile('employees.csv') e1 INNER JOIN chinook.employees e2 ON e1.Email = e2.email ").Cast <object>().ToList(); var itemType = result[0].GetType(); Assert.AreEqual(8, result.Count); Assert.AreEqual(1, result[0].GetValue <int>("e2.EmployeeId")); Assert.AreEqual("Adams", result[0].GetValue <string>("e1.last_name")); Assert.AreEqual(2, result[1].GetValue <int>("e2.EmployeeId")); Assert.AreEqual("Edwards", result[1].GetValue <string>("e1.last_name")); }