public void Should_get_multiple_results() { param.Sql = "SELECT 23 , 'name' FROM dual CONNECT BY level <= 8"; client = new OracleClient(log, param, encryption); var results = client.Get(); Assert.That(results.Count, Is.EqualTo(8)); }
public void Should_get_multiple_results() { var param = new TaskParams("path", "SELECT 23 , 'name' FROM dual CONNECT BY level <= 8", ConnectionString, "SqlServer", "name", "statsdudp"); var log = MockRepository.GenerateMock<ILog>(); var client = new OracleClient(log, param); var results = client.Get(); Assert.That(results.Count, Is.EqualTo(8)); }
public void Should_get_result() { var name = Guid.NewGuid().ToString(); param.Sql = string.Format("SELECT level, '{0}', to_date('2012-FEB-03 00:00:01', 'YYYY-MON-DD HH24:MI:SS') FROM dual CONNECT BY level <= 100", name); client = new OracleClient(log, param, encryption); //Test var results = client.Get(); //Asset Assert.That(results.Count, Is.EqualTo(100)); Assert.That(results[0].Name, Is.EqualTo(name)); Assert.That(results[0].TimeStamp, Is.EqualTo(new DateTime(2012, 02, 03, 00, 00, 01))); }
public void Should_get_result_with_date() { var name = Guid.NewGuid().ToString(); param.Sql = string.Format("SELECT '{0}', to_date('2012-FEB-03 00:00:01', 'YYYY-MON-DD HH24:MI:SS') , 234 FROM dual CONNECT BY level <= 1", name); client = new OracleClient(log, param, encryption); //Test var results = client.Get(); //Asset var futureDate = DateTime.Now.Add(new TimeSpan(11, 0, 0, 0)); Assert.That(results.Count, Is.EqualTo(1)); Assert.That(results[0].Name, Is.EqualTo(name)); Assert.That(results[0].Value, Is.EqualTo(234)); Assert.That(results[0].TimeStamp, Is.EqualTo(new DateTime(2012, 02, 03, 00, 00, 01))); }
public void Should_get_result_with_different_order() { var name = Guid.NewGuid().ToString(); param.Sql = string.Format("SELECT '{0}', to_date('2012-FEB-03 00:00:01', 'YYYY-MON-DD HH24:MI:SS'),level FROM dual CONNECT BY level <= 100", name); client = new OracleClient(log, param, encryption); //Test var results = client.Get(); //Asset Assert.That(results.Count, Is.EqualTo(100)); Assert.That(results[0].Name, Is.EqualTo(name)); Assert.That(results[0].TimeStamp, Is.EqualTo(new DateTime(2012, 02, 03, 00, 00, 01))); }
public void Should_get_result() { var name = Guid.NewGuid().ToString(); var sql = string.Format("SELECT level, '{0}', to_date('2012-FEB-03 00:00:01', 'YYYY-MON-DD HH24:MI:SS') FROM dual CONNECT BY level <= 100", name); var param = new TaskParams("path", sql, ConnectionString, "Oracle", name, "Statsdudp"); var log = MockRepository.GenerateMock<ILog>(); var client = new OracleClient(log, param); //Test var results = client.Get(); //Asset Assert.That(results.Count, Is.EqualTo(100)); Assert.That(results[0].Name, Is.EqualTo(name)); Assert.That(results[0].TimeStamp, Is.EqualTo(new DateTime(2012, 02, 03, 00, 00, 01))); }
public void Should_get_result_with_date_and_name_set_in_select() { var name = Guid.NewGuid().ToString(); param.Sql = string.Format("SELECT '{0}', to_date('2012-FEB-03 00:00:01', 'YYYY-MON-DD HH24:MI:SS') , 234 FROM dual CONNECT BY level <= 1", name); client = new OracleClient(log, param, encryption); //Test var results = client.Get(); //Asset Assert.That(results.Count, Is.EqualTo(1)); Assert.That(results[0].Name, Is.EqualTo(name)); Assert.That(results[0].Path, Is.EqualTo("path")); Assert.That(results[0].Value, Is.EqualTo(234)); }
public void Should_get_result_with_date_and_name_set_in_select() { var name = Guid.NewGuid().ToString(); var sql = string.Format("SELECT '{0}', to_date('2012-FEB-03 00:00:01', 'YYYY-MON-DD HH24:MI:SS') , 234 FROM dual CONNECT BY level <= 1", name); var param = new TaskParams("path", sql, ConnectionString, "Oracle", name, "Statsdudp"); var log = MockRepository.GenerateMock<ILog>(); var client = new OracleClient(log, param); //Test var results = client.Get(); //Asset Assert.That(results.Count, Is.EqualTo(1)); Assert.That(results[0].Name, Is.EqualTo(name)); Assert.That(results[0].Path, Is.EqualTo("path")); Assert.That(results[0].Value, Is.EqualTo(234)); }