import Foundation
import ServiceStack
public class QueryPlayer : QueryDb<Player>
{
required public init(){ super.init() }
required public init(from decoder: Decoder) throws {
try super.init(from: decoder)
}
public override func encode(to encoder: Encoder) throws {
try super.encode(to: encoder)
}
}
public class Player : AuditBase
{
public var id:Int
// @Required()
public var firstName:String?
public var lastName:String
public var email:String
public var phoneNumbers:[Phone] = []
public var gameItems:[PlayerGameItem] = []
public var profile:Profile
public var profileId:Int
public var savedLevelId:String
public var rowVersion:UInt64
required public init(){ super.init() }
private enum CodingKeys : String, CodingKey {
case id
case firstName
case lastName
case email
case phoneNumbers
case gameItems
case profile
case profileId
case savedLevelId
case rowVersion
}
required public init(from decoder: Decoder) throws {
try super.init(from: decoder)
let container = try decoder.container(keyedBy: CodingKeys.self)
id = try container.decodeIfPresent(Int.self, forKey: .id)
firstName = try container.decodeIfPresent(String.self, forKey: .firstName)
lastName = try container.decodeIfPresent(String.self, forKey: .lastName)
email = try container.decodeIfPresent(String.self, forKey: .email)
phoneNumbers = try container.decodeIfPresent([Phone].self, forKey: .phoneNumbers) ?? []
gameItems = try container.decodeIfPresent([PlayerGameItem].self, forKey: .gameItems) ?? []
profile = try container.decodeIfPresent(Profile.self, forKey: .profile)
profileId = try container.decodeIfPresent(Int.self, forKey: .profileId)
savedLevelId = try container.decodeIfPresent(String.self, forKey: .savedLevelId)
rowVersion = try container.decodeIfPresent(UInt64.self, forKey: .rowVersion)
}
public override func encode(to encoder: Encoder) throws {
try super.encode(to: encoder)
var container = encoder.container(keyedBy: CodingKeys.self)
if id != nil { try container.encode(id, forKey: .id) }
if firstName != nil { try container.encode(firstName, forKey: .firstName) }
if lastName != nil { try container.encode(lastName, forKey: .lastName) }
if email != nil { try container.encode(email, forKey: .email) }
if phoneNumbers.count > 0 { try container.encode(phoneNumbers, forKey: .phoneNumbers) }
if gameItems.count > 0 { try container.encode(gameItems, forKey: .gameItems) }
if profile != nil { try container.encode(profile, forKey: .profile) }
if profileId != nil { try container.encode(profileId, forKey: .profileId) }
if savedLevelId != nil { try container.encode(savedLevelId, forKey: .savedLevelId) }
if rowVersion != nil { try container.encode(rowVersion, forKey: .rowVersion) }
}
}
public class Phone : Codable
{
public var kind:PhoneKind
public var number:String
public var ext:String
required public init(){}
}
public enum PhoneKind : String, Codable
{
case Home
case Mobile
case Work
}
public class PlayerGameItem : Codable
{
public var id:Int
// @References(typeof(Player))
public var playerId:Int
// @References(typeof(GameItem))
public var gameItemName:String
required public init(){}
}
public class Profile : AuditBase
{
public var id:Int
public var role:PlayerRole
public var region:PlayerRegion
public var username:String
public var highScore:Int
public var gamesPlayed:Int
public var energy:Int
public var profileUrl:String
public var coverUrl:String
public var meta:[String:String]
required public init(){ super.init() }
private enum CodingKeys : String, CodingKey {
case id
case role
case region
case username
case highScore
case gamesPlayed
case energy
case profileUrl
case coverUrl
case meta
}
required public init(from decoder: Decoder) throws {
try super.init(from: decoder)
let container = try decoder.container(keyedBy: CodingKeys.self)
id = try container.decodeIfPresent(Int.self, forKey: .id)
role = try container.decodeIfPresent(PlayerRole.self, forKey: .role)
region = try container.decodeIfPresent(PlayerRegion.self, forKey: .region)
username = try container.decodeIfPresent(String.self, forKey: .username)
highScore = try container.decodeIfPresent(Int.self, forKey: .highScore)
gamesPlayed = try container.decodeIfPresent(Int.self, forKey: .gamesPlayed)
energy = try container.decodeIfPresent(Int.self, forKey: .energy)
profileUrl = try container.decodeIfPresent(String.self, forKey: .profileUrl)
coverUrl = try container.decodeIfPresent(String.self, forKey: .coverUrl)
meta = try container.decodeIfPresent([String:String].self, forKey: .meta) ?? [:]
}
public override func encode(to encoder: Encoder) throws {
try super.encode(to: encoder)
var container = encoder.container(keyedBy: CodingKeys.self)
if id != nil { try container.encode(id, forKey: .id) }
if role != nil { try container.encode(role, forKey: .role) }
if region != nil { try container.encode(region, forKey: .region) }
if username != nil { try container.encode(username, forKey: .username) }
if highScore != nil { try container.encode(highScore, forKey: .highScore) }
if gamesPlayed != nil { try container.encode(gamesPlayed, forKey: .gamesPlayed) }
if energy != nil { try container.encode(energy, forKey: .energy) }
if profileUrl != nil { try container.encode(profileUrl, forKey: .profileUrl) }
if coverUrl != nil { try container.encode(coverUrl, forKey: .coverUrl) }
if meta != nil { try container.encode(meta, forKey: .meta) }
}
}
public enum PlayerRole : String, Codable
{
case Leader
case Player
case NonPlayer
}
public enum PlayerRegion : Int, Codable
{
case Africa = 1
case Americas = 2
case Asia = 3
case Australasia = 4
case Europe = 5
}
public class Todo : Codable
{
public var id:Int
public var text:String
public var isFinished:Bool
required public init(){}
}
To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/QueryPlayer HTTP/1.1
Host: blazor-gallery.servicestack.net
Accept: text/csv
Content-Type: text/csv
Content-Length: length
{"skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length
{"offset":0,"total":0,"results":[{"id":0,"firstName":"String","lastName":"String","email":"String","phoneNumbers":[{"kind":"Home","number":"String","ext":"String"}],"gameItems":[{"id":0,"playerId":0,"gameItemName":"String"}],"profile":{"id":0,"role":"Leader","region":"Africa","username":"String","highScore":0,"gamesPlayed":0,"energy":0,"profileUrl":"String","coverUrl":"String","meta":{"String":"String"},"createdDate":"0001-01-01T00:00:00","createdBy":"String","modifiedDate":"0001-01-01T00:00:00","modifiedBy":"String","deletedDate":"0001-01-01T00:00:00","deletedBy":"String"},"profileId":0,"savedLevelId":"00000000-0000-0000-0000-000000000000","rowVersion":0,"createdDate":"0001-01-01T00:00:00","createdBy":"String","modifiedDate":"0001-01-01T00:00:00","modifiedBy":"String","deletedDate":"0001-01-01T00:00:00","deletedBy":"String"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}