public void Equality_comparison_is_expanded_correctly_for_case_statement()
{
using (var context = new ABContext())
{
var name = "ab";
var query =
from a in context.As
select a.Name == name;
var expectedSql =
@"SELECT
CASE
WHEN (([Extent1].[Name] = @p__linq__0) OR (([Extent1].[Name] IS NULL) AND (@p__linq__0 IS NULL)))
THEN cast(1 as bit)
WHEN ( NOT (([Extent1].[Name] = @p__linq__0) AND ((
CASE
WHEN ([Extent1].[Name] IS NULL)
THEN cast(1 as bit)
ELSE cast(0 as bit) END) =
(CASE
WHEN (@p__linq__0 IS NULL)
THEN cast(1 as bit)
ELSE cast(0 as bit)
END))))
THEN cast(0 as bit)
END AS [C1]
FROM [dbo].[A] AS [Extent1]";
QueryTestHelpers.VerifyDbQuery(query, expectedSql);
}
}
private Student GetStudent(string username, string password)
{
using (var db = new ABContext())
{
var student = db.Students.FirstOrDefault(u => u.email == username);
if (student != null)
{
if (student.password == password)
{
return(student);
}
}
}
return(null);
}
private User GetUser(string username, string password)
{
using (var db = new ABContext())
{
var user = db.Users.FirstOrDefault(u => u.username == username);
if (user != null)
{
if (user.password == password)
{
return(user);
}
}
}
return(null);
}
public void Null_checks_for_non_nullable_columns_are_eliminated_from_case_statement()
{
using (var context = new ABContext())
{
var name = "ab";
var query =
from b in context.Bs
select b.Name == name;
var expectedSql =
@"SELECT
CASE WHEN ([Extent1].[Name] = @p__linq__0) THEN cast(1 as bit) WHEN ( NOT (([Extent1].[Name] = @p__linq__0) AND (0 = (CASE WHEN (@p__linq__0 IS NULL) THEN cast(1 as bit) ELSE cast(0 as bit) END)))) THEN cast(0 as bit) END AS [C1]
FROM [dbo].[B] AS [Extent1]";
QueryTestHelpers.VerifyDbQuery(query, expectedSql);
}
}
public void Null_checks_for_nullable_parameters_are_not_eliminated()
{
using (var context = new ABContext())
{
int?aId = 1;
var query = context.As.Where(a => a.Id != aId);
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id],
[Extent1].[Name] AS [Name]
FROM [dbo].[A] AS [Extent1]
WHERE NOT (([Extent1].[Id] = @p__linq__0) AND (@p__linq__0 IS NOT NULL))";
QueryTestHelpers.VerifyDbQuery(query, expectedSql);
}
}
public void Null_checks_for_nullable_parameters_are_eliminated_when_other_operand_is_not_nullable()
{
using (var context = new ABContext())
{
int?aId = 1;
var query = context.As.Where(a => a.Id == aId);
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id],
[Extent1].[NullableId] AS [NullableId],
[Extent1].[Name] AS [Name]
FROM [dbo].[A] AS [Extent1]
WHERE [Extent1].[Id] = @p__linq__0";
QueryTestHelpers.VerifyDbQuery(query, expectedSql);
}
}
public void Duplicate_joins_are_not_created()
{
using (var context = new ABContext())
{
var query =
from a in context.As
where a.Name == context.Bs.FirstOrDefault().Name
select a;
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id],
[Extent1].[Name] AS [Name]
FROM [dbo].[A] AS [Extent1]
LEFT OUTER JOIN (SELECT TOP (1) [c].[Name] AS [Name]
FROM [dbo].[B] AS [c] ) AS [Limit1] ON 1 = 1
WHERE ([Extent1].[Name] = [Limit1].[Name]) OR (([Extent1].[Name] IS NULL) AND ([Limit1].[Name] IS NULL))";
QueryTestHelpers.VerifyDbQuery(query, expectedSql);
}
}
public void Inner_equality_comparisons_are_expanded_correctly()
{
using (var context = new ABContext())
{
var name1 = "ab1";
var name2 = "ab2";
var name3 = "ab3";
var query =
from a in context.As
where !(a.Name == name1 || a.Name != name2 || !(a.Name == name3))
select a;
var expectedSql =
@"SELECT
[Extent1].[Id] AS [Id],
[Extent1].[NullableId] AS [NullableId],
[Extent1].[Name] AS [Name]
FROM [dbo].[A] AS [Extent1]
WHERE NOT (
(([Extent1].[Name] = @p__linq__0) AND
((CASE
WHEN ([Extent1].[Name] IS NULL)
THEN cast(1 as bit)
ELSE cast(0 as bit)
END) =
(CASE
WHEN (@p__linq__0 IS NULL)
THEN cast(1 as bit)
ELSE cast(0 as bit)
END))) OR
( NOT (([Extent1].[Name] = @p__linq__1) OR
(([Extent1].[Name] IS NULL) AND (@p__linq__1 IS NULL)))) OR
( NOT (([Extent1].[Name] = @p__linq__2) OR (([Extent1].[Name] IS NULL) AND (@p__linq__2 IS NULL)))))";
QueryTestHelpers.VerifyDbQuery(query, expectedSql);
}
}
public ABTestsRepository(ABContext context)
{
this.context = context;
abtestEntity = context.Set <ABTest>();
}
/** Connects to a PLC:
*
* url = "S7:host"
* url = "MODBUS:host"
* url = "AB:host"
* url = "NI:device/options"
*
*/
public bool Connect(String url)
{
Console.WriteLine("Info:" + DateTime.GetMilliSecondsSinceEpoch() + ":Controller.connect():" + url);
connected = false;
if (url == null)
{
Console.WriteLine("Error:url == null");
return(false);
}
if (url.StartsWith("S7:"))
{
plc = ControllerType.S7;
String host = url.Substring(3);
lock (s7_connect_lock) {
try {
socket = new TcpSocket();
// socket.setSoTimeout(3000);
socket.Connect(host, 102);
//connect1
{
byte[] packet = S7Packet.makeConnectPacket1();
socket.Write(packet);
byte[] reply = new byte[1500];
int replySize = 0;
do
{
int read = socket.Read(reply, replySize, 1500 - replySize);
if (read == -1)
{
throw new Exception("bad read");
}
replySize += read;
} while (!S7Packet.isPacketComplete(Arrays <byte> .CopyOf(reply, replySize)));
}
//connect2
{
byte[] packet = S7Packet.makeConnectPacket2();
socket.Write(packet);
byte[] reply = new byte[1500];
int replySize = 0;
do
{
int read = socket.Read(reply, replySize, 1500 - replySize);
if (read == -1)
{
throw new Exception("bad read");
}
replySize += read;
} while (!S7Packet.isPacketComplete(Arrays <byte> .CopyOf(reply, replySize)));
}
} catch (Exception e) {
Console.WriteLine("Error:" + e.ToString());
return(false);
}
}
connected = true;
return(true);
}
if (url.StartsWith("MODBUS:"))
{
plc = ControllerType.MB;
String host = url.Substring(7);
try {
socket = new TcpSocket();
socket.Connect(host, 502);
// socket.setSoTimeout(3000);
} catch (Exception e) {
Console.WriteLine("Error:" + e.ToString());
return(false);
}
connected = true;
return(true);
}
if (url.StartsWith("AB:"))
{
ab_context = new ABContext();
plc = ControllerType.AB;
String host = url.Substring(3);
try {
socket = new TcpSocket();
socket.Connect(host, 44818);
// socket.setSoTimeout(3000);
//connect1
{
byte[] packet = ABPacket.makeConnectPacket(ab_context);
socket.Write(packet);
byte[] reply = new byte[1500];
int replySize = 0;
do
{
int read = socket.Read(reply, replySize, 1500 - replySize);
if (read == -1)
{
throw new Exception("bad read");
}
replySize += read;
} while (!ABPacket.isPacketComplete(Arrays <byte> .CopyOf(reply, replySize)));
ENIP ip = new ENIP();
ip.read(reply, 0);
ab_context.session = ip.session;
}
} catch (Exception e) {
Console.WriteLine("Error:" + e.ToString());
return(false);
}
connected = true;
return(true);
}
return(false);
}
