SV.Db.Sloth.WebApi
0.0.2.2
See the version list below for details.
dotnet add package SV.Db.Sloth.WebApi --version 0.0.2.2
NuGet\Install-Package SV.Db.Sloth.WebApi -Version 0.0.2.2
<PackageReference Include="SV.Db.Sloth.WebApi" Version="0.0.2.2" />
paket add SV.Db.Sloth.WebApi --version 0.0.2.2
#r "nuget: SV.Db.Sloth.WebApi, 0.0.2.2"
// Install SV.Db.Sloth.WebApi as a Cake Addin #addin nuget:?package=SV.Db.Sloth.WebApi&version=0.0.2.2 // Install SV.Db.Sloth.WebApi as a Cake Tool #tool nuget:?package=SV.Db.Sloth.WebApi&version=0.0.2.2
sv.db
slothful vic try make db code be sloth flash, because vic lazy, so it can not be fastest, but maybe like flash
What can sv.db do
1. db to entity
Like DapperAOT, use Source Generators generating the necessary code during build to help you use sql more easy.
And Theoretically, you also can do Native AOT deployment
Code exmples:
public async Task<object> OldWay()
{
var a = factory.GetConnection(StaticInfo.Demo);
using var dd = await a.ExecuteReaderAsync("""
SELECT count(1)
FROM Weather;
SELECT *
FROM Weather;
""");
var t = await dd.QueryFirstOrDefaultAsync<int>();
var r = await dd.QueryAsync<string>().ToListAsync();
return new { TotalCount = t, Rows = r };
}
2. make select more easy and more complex condition
With define some simple rules for select, we can convert select to db / api / es ....
Theoretically, we can do like:
http query string / body |------> select statement |------> db (sqlite / mysql/ sqlserver / PostgreSQL)
Expression code |------> |------> es
|------> mongodb
|------> more .....
So we can use less code to do some simple select
2.1 complex condition and page for api
Code exmples:
[HttpGet]
public async Task<object> Selects()
{
return await this.QueryByParamsAsync<Weather>();
}
[Db("Demo")]
[Table(nameof(Weather))]
public class Weather
{
[Select]
public string Name { get; set; }
[Select(Field = "Value")]
public string V { get; set; }
}
You can use such query string to query api
curl --location 'http://localhost:5259/weather?where=not (name like '%e%')&TotalCount=true'
Response
{
"totalCount": 1,
"rows": [
{
"name": "H",
"v": "mery!"
}
]
}
2.2 complex condition and page for Expression code
Code exmples:
You can use such code to query Weather which name no Contains 'e'
[HttpGet("expr")]
public async Task<object> DoSelects()
{
return await factory.From<Weather>().Where(i => !i.Name.Like("e")).WithTotalCount().ExecuteQueryAsync<dynamic>();
}
[Db("Demo")]
[Table(nameof(Weather))]
public class Weather
{
[Select]
public string Name { get; set; }
[Select(Field = "Value as v")]
public string V { get; set; }
}
Doc
Query in api
Both has func support use query string or body to query
body or query string will map to Dictionary<string, string>
to handle
operater
such filter operater just make api more restful (Where=urlencode(complex condition)
will be more better)
{{nl}}
is null- query string
?name={{nl}}
- body
{"name":"{{nl}}"}
- query string
{{eq}}
Equal =- query string
?name=xxx
- body
{"name":"xxx"}
- query string
{{lt}}
LessThan or Equal ⇐- query string
?age={{lt}}30
- body
{"age":"{{lt}}30"}
- query string
{{le}}
LessThan <- query string
?age={{le}}30
- body
{"age":"{{le}}30"}
- query string
{{gt}}
GreaterThan or Equal >=- query string
?age={{gt}}30
- body
{"age":"{{gt}}30"}
- query string
{{gr}}
GreaterThan >- query string
?age={{gr}}30
- body
{"age":"{{gr}}30"}
- query string
{{nq}}
Not Equal !=- query string
?age={{nq}}30
- body
{"age":"{{nq}}30"}
- query string
{{lk}}
Prefix Like 'e%'- query string
?name={{lk}}e
- body
{"name":"{{lk}}e"}
- query string
{{rk}}
Suffix Like '%e'- query string
?name={{rk}}e
- body
{"name":"{{rk}}e"}
- query string
{{kk}}
Like '%e%'- query string
?name={{kk}}e
- body
{"name":"{{kk}}e"}
- query string
{{in}}
in array (bool/number/string)- query string
?name={{in}}[true,false]
- body
{"name":"{{in}}[\"s\",\"sky\"]"}
- query string
{{no}}
not- query string
?age={{no}}{{lt}}30
- body
{"age":"{{no}}{{lt}}30"}
- query string
Func Fields:
Fields
return some Fields , no Fields orFields=*
is return all- query string
?Fields=name,age,json(data,'$.age')
- body
{"Fields":"name,age,json(data,'$.age')"}
- query string
TotalCount
return total count- query string
?TotalCount=true
- body
{"TotalCount":"true"}
- query string
NoRows
no return rows- query string
?NoRows=true
- body
{"NoRows":"true"}
- query string
Offset
Offset Rows index- query string
?Offset=10
- body
{"Offset":10}
- query string
Rows
Take Rows count, default is 10- query string
?Rows=100
- body
{"Rows":100}
- query string
OrderBy
sort result- query string
?OrderBy=name asc,age desc,json(data,'$.age') desc
- body
{"OrderBy":"name asc,age desc,json(data,'$.age') desc"}
- query string
Where
complex condition filter- query string
?Where=urlencode( not(name like 'H%') or name like '%v%' )
- body
{"Where":"not(name like 'H%') or name like '%v%'"}
- operaters
- bool
- example
true
orfalse
- example
- number
- example
12323
or1.324
or-44.4
- example
- string
- example
'sdsdfa'
or'sds\'dfa'
or"dsdsdsd"
or"fs\"dsf"
- example
= null
is null- example
name = null
- example
=
Equal- example
name = 'sky'
- example
<=
LessThan or Equal- example
age <= 30
- example
<
LessThan- example
age < 30
- example
>=
GreaterThan or Equal- example
age >= 30
- example
>
GreaterThan- example
age > 30
- example
!=
Not Equal- example
age != 30
- example
like 'e%'
Prefix Like- example
name like 'xx%'
- example
like '%e'
Suffix Like- example
name like '%xx'
- example
like '%e%'
Like- example
name like '%xx%'
- example
in ()
in array (bool/number/string)- example
in (1,2,3)
orin ('sdsdfa','sdfa')
orin (true,false)
- example
not
- example
not( age <= 30 )
- example
and
- example
age <= 30 and age > 60
- example
or
- example
age <= 30 or age > 60
- example
()
- example
(age <= 30 or age > 60) and name = 'killer'
- example
- bool
- support json
- example
json(data,'$.age') > 60
- example
- query string
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
-
net8.0
- SV.Db.Sloth (>= 0.0.2.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
0.0.2.15 | 57 | 11/27/2024 |
0.0.2.14 | 73 | 11/26/2024 |
0.0.2.13 | 81 | 11/7/2024 |
0.0.2.12 | 79 | 10/31/2024 |
0.0.2.11 | 79 | 10/24/2024 |
0.0.2.10 | 118 | 10/19/2024 |
0.0.2.9 | 84 | 10/17/2024 |
0.0.2.8 | 85 | 10/16/2024 |
0.0.2.7 | 86 | 10/16/2024 |
0.0.2.6 | 97 | 10/16/2024 |
0.0.2.5 | 85 | 10/16/2024 |
0.0.2.4 | 89 | 10/14/2024 |
0.0.2.3 | 90 | 10/12/2024 |
0.0.2.2 | 84 | 10/12/2024 |
0.0.2.1 | 88 | 10/12/2024 |
0.0.2.1-beta | 79 | 10/12/2024 |
0.0.2-beta | 83 | 10/10/2024 |
0.0.1-beta | 80 | 10/10/2024 |