import Foundation
import ServiceStack
public class QueryCustomers : QueryDb<Customer>
{
public var customerId:String
public var companyNameContains:String
public var countryIn:[String] = []
required public init(){ super.init() }
private enum CodingKeys : String, CodingKey {
case customerId
case companyNameContains
case countryIn
}
required public init(from decoder: Decoder) throws {
try super.init(from: decoder)
let container = try decoder.container(keyedBy: CodingKeys.self)
customerId = try container.decodeIfPresent(String.self, forKey: .customerId)
companyNameContains = try container.decodeIfPresent(String.self, forKey: .companyNameContains)
countryIn = try container.decodeIfPresent([String].self, forKey: .countryIn) ?? []
}
public override func encode(to encoder: Encoder) throws {
try super.encode(to: encoder)
var container = encoder.container(keyedBy: CodingKeys.self)
if customerId != nil { try container.encode(customerId, forKey: .customerId) }
if companyNameContains != nil { try container.encode(companyNameContains, forKey: .companyNameContains) }
if countryIn.count > 0 { try container.encode(countryIn, forKey: .countryIn) }
}
}
public class Customer : Codable
{
public var customerId:String
public var companyName:String
public var address:String
public var city:String
public var region:String
public var postalCode:String
public var country:String
public var phone:String
public var fax:String
public var orders:[Order] = []
required public init(){}
}
public class Order : Codable
{
public var orderId:Int
public var customerId:String
public var orderDate:Date
public var total:Double
required public init(){}
}
To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /jsv/reply/QueryCustomers HTTP/1.1
Host: sharpscript.net
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length
{
customerId: String,
companyNameContains: String,
countryIn:
[
String
],
skip: 0,
take: 0,
orderBy: String,
orderByDesc: String,
include: String,
fields: String,
meta:
{
String: String
}
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length
{
offset: 0,
total: 0,
results:
[
{
customerId: String,
companyName: String,
address: String,
city: String,
region: String,
postalCode: String,
country: String,
phone: String,
fax: String,
orders:
[
{
orderId: 0,
customerId: String,
orderDate: 0001-01-01,
total: 0
}
]
}
],
meta:
{
String: String
},
responseStatus:
{
errorCode: String,
message: String,
stackTrace: String,
errors:
[
{
errorCode: String,
fieldName: String,
message: String,
meta:
{
String: String
}
}
],
meta:
{
String: String
}
}
}