public void Should_get_results()
{
var param = new TaskParams("path", "SELECT [dbms_id] FROM [msdb].[dbo].[MSdbms]", ConnectionString, "SqlServer", "name", "statsdudp");
var log = MockRepository.GenerateMock<ILog>();
var sqlServerClient = new SqlServerClient(log, param);
var results = sqlServerClient.Get();
Assert.That(results.Count, Is.EqualTo(8));
}
public void Should_get_result()
{
var name = Guid.NewGuid().ToString();
var param = new TaskParams("path", "SELECT COUNT(*) as count FROM [master].[dbo].[spt_monitor]", ConnectionString, "SqlServer", name, "Statsdudp");
var log = MockRepository.GenerateMock<ILog>();
var sqlServerClient = new SqlServerClient(log, param);
//Test
var results = sqlServerClient.Get();
//Asset
Assert.That(results.Count, Is.EqualTo(1));
Assert.That(results[0].Name, Is.EqualTo(name));
Assert.That(results.Count, Is.EqualTo(1));
}
public void Should_get_results()
{
var metricName = Guid.NewGuid().ToString();
var serverClientParams = new SqlServerClient
{
ConnectionString = e.Encrypt(ConnectionString),
Path = SimplePath,
Sql = "SELECT [dbms_id] FROM [msdb].[dbo].[MSdbms]",
ClientName = "GraphiteTcpClient",
};
var sqlServerClient = new SqlServerClient(log, serverClientParams,encryption);
var results = sqlServerClient.Get();
Assert.That(results.Count, Is.EqualTo(8));
}
public void Should_get_result_with_date_and_name_set_in_select()
{
var name = Guid.NewGuid().ToString();
var param = new TaskParams("path", "SELECT 234 , DATEADD(day,11,GETDATE()), 'someName'", ConnectionString, "SqlServer", name, "statsdudp");
var log = MockRepository.GenerateMock<ILog>();
var sqlServerClient = new SqlServerClient(log, param);
//Test
var results = sqlServerClient.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("someName"));
Assert.That(results[0].Path, Is.EqualTo("path"));
Assert.That(results[0].Value, Is.EqualTo(234));
}
public void Should_get_result()
{
var metricName = Guid.NewGuid().ToString();
var serverClientParams = new SqlServerClient
{
ConnectionString = e.Encrypt(ConnectionString),
Path = SimplePath,
Sql = SimpleQuery,
ClientName = "GraphiteTcpClient",
};
var sqlServerClient = new SqlServerClient(log, serverClientParams, encryption);
//Test
var results = sqlServerClient.Get();
//Asset
Assert.That(results.Count, Is.EqualTo(1));
Assert.That(results[0].Path, Is.EqualTo(SimplePath));
Assert.That(results[0].Value, Is.EqualTo("234"));
}
public void Should_get_result_with_date()
{
var name = Guid.NewGuid().ToString();
var param = new TaskParams(
"path", "SELECT 234 , DATEADD(day,11,GETDATE())", ConnectionString, "SqlServer", name, "statsdudp");
var log = MockRepository.GenerateMock<ILog>();
var sqlServerClient = new SqlServerClient(log, param);
//Test
var results = sqlServerClient.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.Day, Is.EqualTo(futureDate.Day));
Assert.That(results[0].TimeStamp.Hour, Is.EqualTo(futureDate.Hour));
Assert.That(results[0].TimeStamp.Minute, Is.EqualTo(futureDate.Minute));
Assert.That(results[0].TimeStamp.Year, Is.EqualTo(futureDate.Year));
}
public void Should_get_result_with_date()
{
var metricName = Guid.NewGuid().ToString();
var serverClientParams = new SqlServerClient
{
ConnectionString = e.Encrypt(ConnectionString),
Path = SimplePath,
Sql = SimpleQuery,
ClientName = "GraphiteTcpClient",
};
var sqlServerClient = new SqlServerClient(log, serverClientParams,encryption);
//Test
var results = sqlServerClient.Get();
//Asset
var futureDate = DateTime.Now.Add(new TimeSpan(11, 0, 0, 0));
Assert.That(results.Count, Is.EqualTo(1));
Assert.That(results[0].Path, Is.EqualTo(SimplePath));
Assert.That(results[0].Value, Is.EqualTo("234"));
Assert.That(results[0].TimeStamp.Day, Is.EqualTo(futureDate.Day));
Assert.That(results[0].TimeStamp.Hour, Is.EqualTo(futureDate.Hour));
Assert.That(results[0].TimeStamp.Minute, Is.EqualTo(futureDate.Minute));
Assert.That(results[0].TimeStamp.Year, Is.EqualTo(futureDate.Year));
}
public void Should_get_result_with_date_and_name_set_in_select()
{
var metricName = Guid.NewGuid().ToString();
var serverClientParams = new SqlServerClient
{
ConnectionString = e.Encrypt(ConnectionString),
Path = SimplePath,
Sql = "SELECT 234 , DATEADD(day,11,GETDATE()), 'someName'",
ClientName = "GraphiteTcpClient",
};
var sqlServerClient = new SqlServerClient(log, serverClientParams, encryption);
//Test
var results = sqlServerClient.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("someName"));
Assert.That(results[0].Path, Is.EqualTo(SimplePath));
Assert.That(results[0].Value, Is.EqualTo("234"));
}