order |
Order clause asc sort |
2 |
Success |
order |
Order clause desc sort |
1 |
Success |
order |
Order clause no sort |
2 |
Success |
order |
Order clause with include |
3 |
Success |
order |
Order clause with include and identical columns |
5 |
Success |
order |
Order clause with paginated include and ambiguous columns |
0 |
Success |
order |
Order clause with paginated include and identical columns |
0 |
Success |
order |
Order clause with paginated include and identical columns desc sort with specified table names |
0 |
Success |
order |
Order with maxrows and calculated property |
2 |
Success |
findonebyxxx |
Can change delimieter for dynamic finders |
24 |
Success |
findonebyxxx |
Can pass in commas |
16 |
Success |
findonebyxxx |
Explicit arguments |
6 |
Success |
findonebyxxx |
One value |
6 |
Success |
findonebyxxx |
Pass through order |
4 |
Success |
findonebyxxx |
Passing array |
12 |
Success |
findonebyxxx |
Passing where clause |
4 |
Success |
findonebyxxx |
Text data type |
2 |
Success |
findonebyxxx |
Two values |
6 |
Success |
findonebyxxx |
Two values with explicit arguments |
2 |
Success |
findonebyxxx |
Two values with named arguments |
3 |
Success |
findonebyxxx |
Two values with space |
2 |
Success |
findonebyxxx |
Unlimited properties for dynamic finders |
3 |
Success |
from |
$index Hint |
0 |
Success |
from |
From clause |
1 |
Success |
from |
From clause with include |
0 |
Success |
from |
From clause with include and index hints |
0 |
Success |
from |
From clause with index hint on unsupportive db |
0 |
Success |
from |
From clause with mapped table |
0 |
Success |
from |
Mysql from clause with index hint |
0 |
Success |
from |
Sqlserver from clause with index hint |
0 |
Success |
finders |
Allow negative values in where clause |
1 |
Success |
finders |
Exists any record |
1 |
Success |
finders |
Exists by key invalid |
2 |
Success |
finders |
Exists by key valid |
3 |
Success |
finders |
Exists by where one record invalid |
2 |
Success |
finders |
Exists by where one record valid |
1 |
Success |
finders |
Exists by where two records valid |
1 |
Success |
finders |
Exists no records |
4 |
Success |
finders |
Find All |
4 |
Success |
finders |
Find All inbuilt return Type takes precedence over return As |
2 |
Success |
finders |
Find All return As invalid throws error |
2 |
Success |
finders |
Find All return As objects no Records returns correct type |
5 |
Success |
finders |
Find All return As query no Records returns correct type |
2 |
Success |
finders |
Find All return As structs no Records returns correct type |
1 |
Success |
finders |
Find All supports inbuilt return Type |
2 |
Success |
finders |
Find All with include soft deletes |
5 |
Success |
finders |
Find All with softdeleted associated rows |
11 |
Success |
finders |
Find All By XXX |
10 |
Success |
finders |
Find By Key |
4 |
Success |
finders |
Find By Key norecords returns correct type |
6 |
Success |
finders |
Find By Key returns empty query when record not found with return as equal query |
2 |
Success |
finders |
Find By Key returns false when passed blank string |
1 |
Success |
finders |
Find By Key returns false when record not found |
1 |
Success |
finders |
Find By Key returns object when key has leading space |
3 |
Success |
finders |
Find By Key with include soft deletes |
8 |
Success |
finders |
Find One |
3 |
Success |
finders |
Find One norecords returns correct type |
5 |
Success |
finders |
Find One returns empty array for included model when none exist |
6 |
Success |
finders |
Find One returns empty query when record not found with return as equal query |
2 |
Success |
finders |
Find One returns false when record not found |
2 |
Success |
finders |
Find One returns false when record not found with inner join include |
5 |
Success |
finders |
Find One returns false when record not found with outer join include |
5 |
Success |
finders |
Find One with include soft deletes |
9 |
Success |
finders |
Select distinct addresses |
2 |
Success |
finders |
Select users groupby address |
1 |
Success |
group |
Distinct works with group by |
2 |
Success |
group |
Group by calculated property |
2 |
Success |
group |
Group functionality works with pagination |
3 |
Success |
group |
Max works with group functionality |
1 |
Success |
group |
Simple group by |
1 |
Success |
binarydata |
Insert |
28 |
Success |
binarydata |
Update |
20 |
Success |
changes |
All Changes |
3 |
Success |
changes |
Binary compare |
22 |
Success |
changes |
Changed From |
3 |
Success |
changes |
Changed Properties |
2 |
Success |
changes |
Changed Properties change and back |
3 |
Success |
changes |
Changed Properties without changes |
1 |
Success |
changes |
Clearing all change info |
3 |
Success |
changes |
Clearing property change info |
3 |
Success |
changes |
Comparing existing properties only |
4 |
Success |
changes |
Date compare |
3 |
Success |
changes |
Float compare |
15 |
Success |
changes |
Has Changed |
3 |
Success |
changes |
Has Changed with new |
7 |
Success |
changes |
Is New |
5 |
Success |
changes |
Is New with find |
2 |
Success |
changes |
Is Peristed |
6 |
Success |
changes |
Is Persisted with find |
2 |
Success |
changes |
XXX Changed From |
2 |
Success |
changes |
XXX Has Changed |
6 |
Success |
pagination |
5 records 2 perpage 3 pages |
15 |
Success |
pagination |
Compound keys |
10 |
Success |
pagination |
Exist early if no records match where clause |
2 |
Success |
pagination |
Incorrect number of record returned when where clause satisfies records beyond the first identifier value |
12 |
Success |
pagination |
Make sure that remapped columns containing desc and asc work |
21 |
Success |
pagination |
Specify where on joined table |
52 |
Success |
pagination |
With parameterize set to false with numeric |
8 |
Success |
pagination |
With parameterize set to false with string |
19 |
Success |
pagination |
With renamed primary key |
21 |
Success |
new |
Override created at with allow explicit timestamps |
10 |
Success |
new |
Override updated at with allow explicit timestamps |
13 |
Success |
updates |
Columns that are not null should allow for blank string during update |
10 |
Success |
updates |
Dynamic update with named argument |
16 |
Success |
updates |
Dynamic update with unnamed argument |
13 |
Success |
updates |
Update |
14 |
Success |
updates |
Update all |
7 |
Success |
updates |
Update all for soft deleted records |
8 |
Success |
updates |
Update by key |
12 |
Success |
updates |
Update by key for soft deleted records |
49 |
Success |
updates |
Update one |
14 |
Success |
updates |
Update one for soft deleted records |
31 |
Success |
findone |
Do not use query param for nulls |
4 |
Success |
findone |
Parsing numbers in where |
4 |
Success |
findone |
Request query cache should be cleared after change |
13 |
Success |
findone |
Self join |
5 |
Success |
findone |
Self join with other associations |
22 |
Success |
create |
Auto incrementing primary key should be set |
7 |
Success |
create |
Columns that are not null should allow for blank string during create |
7 |
Success |
create |
Composite key values should be set when they both exist |
6 |
Success |
create |
Non auto incrementing primary key should not be changed |
6 |
Success |
create |
Override created at with allow explicit timestamps |
12 |
Success |
create |
Override updated at with allow explicit timestamps |
12 |
Success |
create |
Save null strings |
10 |
Success |
create |
Saving a new model without properties should not throw errors |
12 |
Success |
properties |
Update Property |
10 |
Success |
properties |
Update Property dynamic method |
7 |
Success |
properties |
Update Property With Dynamic Args |
11 |
Success |
properties |
Updating properties |
8 |
Success |
findall |
Convert handle to allowed variable |
3 |
Success |
findall |
Custom query and orm query in transaction |
3 |
Success |
findall |
Findall returnas sql |
2 |
Success |
findall |
In operator with numbers |
3 |
Success |
findall |
In operator with quoted strings |
2 |
Success |
findall |
In operator with spaces |
3 |
Success |
findall |
In operator with spaces and equals comma value combo with brackets |
3 |
Success |
findall |
Maxrows change should break cache |
4 |
Success |
findall |
Moving aggregate functions in where to having |
8 |
Success |
findall |
Paginated finder calls with no records include column names |
3 |
Success |
findall |
Select ambiguous column name using alias |
5 |
Success |
findall |
Select calculated property when implicitly selecting fields |
4 |
Success |
findall |
Uppercase table name containing or substring |
4 |
Success |
select |
Association with expanded aliases disabled |
1 |
Success |
select |
Association with expanded aliases enabled |
0 |
Success |
select |
Select argument on calculated property |
15 |
Success |
select |
Table name with star translates to all fields |
0 |
Success |
select |
Wrong table alias in select throws error |
1 |
Success |
where |
In statement respect parenthesis commas and single quotes |
5 |
Success |
where |
In statement should not error |
3 |
Success |
where |
Numeric value for string property |
0 |
Success |
where |
Should not strip extra whitespace from values |
4 |
Success |