1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- Queries/Customers/GetCustomerList.cssql
@result CustomerListView
@model CustomerFilter
@project Customer c
@project CustomerAddress a
SELECT
@c.Col(m => m.Id) AS @R.Prop(m => m.CustomerId),
@c.Col(m => m.Email) AS @R.Prop(m => m.CustomerEmail),
@a.Col(m => m.Country) AS @R.Prop(m => m.CustomerCountry)
FROM
@c.Tbl()
INNER JOIN
@a.Tbl() ON @a.Col(m => m.Id) = @c.Col(m => m.AddressId)
WHERE
@c.Col(m => m.Created) >= @M.Par(m => m.MinAge)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- Commands/Customers/ChangeEmail.cssql
@model CustomerChangeEmailModel
@project Customer c
@project CustomerEvent e
UPDATE
@c.TblName()
SET
@c.ColName(m => m.Email) = @M.Par(m => m.NewEmail),
@c.ColName(m => m.IsEmailValidated) = 0
WHERE
@c.ColName(m => m.Id) = @M.Par(m => m.CustomerId)
INSERT INTO @e.TblName()
( @e.ColName(m => m.CustomerId), @e.ColName(m => m.Text) )
VALUES ( @M.Par(m => m.CustomerId), @M.Par(m => m.EventText) )