[
https://issues.apache.org/jira/browse/TC-102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeremy Mitchell closed TC-102.
------------------------------
> API changes to reflect true datatypes
> -------------------------------------
>
> Key: TC-102
> URL: https://issues.apache.org/jira/browse/TC-102
> Project: Traffic Control
> Issue Type: Improvement
> Components: Traffic Ops, Traffic Ops API
> Affects Versions: 2.0.0
> Reporter: Jeremy Mitchell
> Assignee: Jeremy Mitchell
> Labels: postgres
> Fix For: 2.0.0
>
>
> With the move from MySQL to Postgres, the API will reflect the true data
> types of each value as represented in the database. For example, the Postgres
> version of the TO database now has boolean columns (rather than using
> smallint). These values should be represented in the API as booleans
> (true|false) as opposed to "0"|"1" as before.
> Also, in the old MySQL TO, ints or numbers were represented as "age":"23" in
> the API. That should change to "age":23
> These are the datatypes available in json and they should be taken advantage
> of when possible:
> Boolean: true|false
> String: double-quoted Unicode with backslash escaping
> Number: double- precision floating-point format
> Array: an ordered sequence of values
> Object: an unordered collection of key:value pairs
> Null
> I'm creating this issue as a catch-all for any changes required to reflect
> the true data types in the api.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
