public void Enum()
{
var q = new SqlQuerySpec("state = @state",
new SqlParameterCollection
{
new SqlParameter("@state", State.Processing),
});
var sql = q.ToSqlQuery();
Assert.AreEqual("state = 20", sql);
}
public void Stamps()
{
var q = new SqlQuerySpec("epoch = @stamp, epoch2 in (@stamp2)",
new SqlParameterCollection
{
new SqlParameter("@stamp", new Stamp(new DateTime(2000, 1, 1))),
new SqlParameter("@stamp2", new SimpleStamp(new DateTime(2001, 1, 1))),
});
var sql = q.ToSqlQuery();
Assert.AreEqual("epoch = 946684800, epoch2 in (9466848002)", sql);
}
public void EmptyList()
{
var ids = new List <State>();
var q = new SqlQuerySpec("items in @ids",
new SqlParameterCollection
{
new SqlParameter("@ids", ids),
});
var sql = q.ToSqlQuery();
Assert.AreEqual("items in (null)", sql);
}
public void Escaping()
{
var q = new SqlQuerySpec("select * from c where c.entity = @entity and c.message = @message")
{
Parameters = new SqlParameterCollection
{
new SqlParameter("@entity", Robot.Entity),
new SqlParameter("@message", @"\'\\''")
}
};
var sql = q.ToSqlQuery();
Assert.AreEqual(@"select * from c where c.entity = 'oogi2/robot' and c.message = '\\\'\\\\\'\''", sql);
}
public void ListOfStrings()
{
var ids = new List <string> {
"abra", "ca", "da'bra"
};
var q = new SqlQuerySpec("items in @ids",
new SqlParameterCollection
{
new SqlParameter("@ids", ids),
});
var sql = q.ToSqlQuery();
Assert.AreEqual("items in ('abra','ca','da\\'bra')", sql);
}
public void ListOfInts()
{
var ids = new List <int> {
4, 5, 2
};
var q = new SqlQuerySpec("items in @ids",
new SqlParameterCollection
{
new SqlParameter("@ids", ids),
});
var sql = q.ToSqlQuery();
Assert.AreEqual("items in (4,5,2)", sql);
}
public void ListOfFloats()
{
var ids = new List <float> {
6.3f, 8.2f
};
var q = new SqlQuerySpec("items in @ids",
new SqlParameterCollection
{
new SqlParameter("@ids", ids),
});
var sql = q.ToSqlQuery();
Assert.AreEqual("items in (6.3,8.2)", sql);
}
public void ListOfEnums()
{
var ids = new List <State> {
State.Ready, State.Finished
};
var q = new SqlQuerySpec("items in @ids",
new SqlParameterCollection
{
new SqlParameter("@ids", ids),
});
var sql = q.ToSqlQuery();
Assert.AreEqual("items in (10,30)", sql);
}
public void Classic()
{
var q = new SqlQuerySpec("a = @a, b = @b, c = @c, d = @d, e = @e, f = @f",
new SqlParameterCollection
{
new SqlParameter("@a", "!''!"),
new SqlParameter("@b", 'x'),
new SqlParameter("@c", null),
new SqlParameter("@d", true),
new SqlParameter("@e", 13),
new SqlParameter("@f", 13.99)
});
var sql = q.ToSqlQuery();
Assert.AreEqual("a = '!\\'\\'!', b = 'x', c = null, d = true, e = 13, f = 13.99", sql);
}
public void Nulls()
{
string a = null;
float? b = null;
Guid? c = null;
var q = new SqlQuerySpec("a = @a, b = @b, c = @c",
new SqlParameterCollection
{
new SqlParameter("@a", a),
new SqlParameter("@b", b),
new SqlParameter("@c", c)
});
var sql = q.ToSqlQuery();
Assert.AreEqual("a = null, b = null, c = null", sql);
}
public void Classic()
{
var q = new SqlQuerySpec("a = @a, b = @b, c = @c, d = @d, e = @e, f = @f, g = @g, h = @h",
new SqlParameterCollection
{
new SqlParameter("@a", "!''!"),
new SqlParameter("@b", 'x'),
new SqlParameter("@c", null),
new SqlParameter("@d", true),
new SqlParameter("@e", 13),
new SqlParameter("@f", 13.99),
new SqlParameter("@g", Guid.Empty),
new SqlParameter("@h", new Uri("https://www.goto10.cz"))
});
var sql = q.ToSqlQuery();
Assert.AreEqual("a = '!\\'\\'!', b = 'x', c = null, d = true, e = 13, f = 13.99, g = '00000000-0000-0000-0000-000000000000', h = 'https://www.goto10.cz/'", sql);
}