Rewrite Traffic Ops CRConfig Table Endpoints in Go

[rob05c]

One of the first steps to Self Service Change Integrity is to change the CRConfig to select the latest timestamps for each delivery service, which requires all tables queried for the CRConfig deliveryservices key insert-not-update, which requires those endpoints be written in Go.

The following tables are queried in the CRConfig:

• cachegroup
• cdn
• deliveryservice
• deliveryservice_regex
• deliveryservice_server
• parameter
• profile
• profile_parameter
• regex
• server
• staticdnsentry
• type
• status
• snapshot

This case is part of Self Service, and represents the overarching task of rewriting those tables in Go; but individual issues and PRs for each table should be in https://github.com/apache/incubator-trafficcontrol/projects/5

• if you've verified a route does not use one of the CRConfig tables (above), follow it with a bullet noting that. Be sure to verify any tables the route does use do not link a CRConfig table, in those tables' traffic_ops/app/lib/Schema/Result
• if there is an unmerged PR, follow with a bullet linking the PR
• if the route is in Go, in master, check it off

NOTE: this checklist should be current as of 07-12-19 (cachegroup_fallbacks omitted because that functionality was added to the cachegroups endpoint)

• get /api/1.1/asns
• get /api/1.2/asns
• get /api/1.1/asns/:id
• post /api/1.1/asns
• put /api/1.1/asns/:id
• delete /api/1.1/asns/:id
• get /api/1.1/caches/stats
  • Add TO Go caches/stats endpoint #2278
• get /api/1.1/cachegroups
• get /api/1.1/cachegroups/trimmed
• get /api/1.1/cachegroups/:id
• post /api/1.1/cachegroups
• put /api/1.1/cachegroups/:id
• delete /api/1.1/cachegroups/:id
• post /api/1.1/cachegroups/:id/deliveryservices
  • Add TO Go cachegroups/id/deliveryservices #2300
• post /api/1.1/cachegroups/:id/queue_update
• get /api/1.1/cdns
• get /api/1.1/cdns/:id
• get /api/1.1/cdns/name/:name
• post /api/1.1/cdns
• put /api/1.1/cdns/:id
• delete /api/1.1/cdns/:id
• delete /api/1.1/cdns/name/:name
• post /api/1.1/cdns/:id/queue_update
• get /api/1.1/cdns/health
  • Add TO Go cdns/health and cdns/{name}/health #2305
• get /api/1.1/cdns/:name/health
  • Add TO Go cdns/health and cdns/{name}/health #2305
• get /api/1.1/cdns/capacity
  • Add TO Go cdns/capacity #2306
• get /api/1.1/cdns/routing
  • Add TO Go cdns/routing - DO NOT MERGE #2307
• get /api/1.1/cdns/:name/snapshot
• get /api/1.1/cdns/:name/snapshot/new
• put /api/1.1/cdns/:id/snapshot
• put /api/1.1/snapshot/:cdn_name
• get /api/1.1/cdns/metric_types/:metric_type/start_date/:start_date/end_date/:end_date
• get /api/1.1/cdns/name/:name/dnsseckeys
  • Add TO Go cdns/name/dnsseckeys #2317
• post /api/1.1/cdns/dnsseckeys/generate
• get /api/1.1/cdns/name/:name/dnsseckeys/delete
• get /api/1.1/cdns/name/:name/sslkeys
• get /api/1.1/cdns/configs
• get /api/1.1/cdns/:name/configs/routing
  • Add TO Go cdns/configs/routing #2450
• get /api/1.1/cdns/:name/configs/monitoring
• get /api/1.1/cdns/domains
• get /api/1.1/logs
  • Add TO Go Logs #2356
• get /api/1.1/logs/:days/days
  • Add TO Go Logs #2356
• get /api/1.1/logs/newcount
  • Add TO Go Logs #2356
• get /api/1.1/servers/:id/configfiles/ats
• get /api/1.1/profiles/:id/configfiles/ats/:filename
• get /api/1.1/servers/:id/configfiles/ats/:filename
• get /api/1.1/cdns/:id/configfiles/ats/:filename
• get /api/1.1/dbdump
• get /api/1.1/deliveryservices
• get /api/1.1/deliveryservices/:id
• post /api/1.1/deliveryservices
• put /api/1.1/deliveryservices/:id
• put /api/1.1/deliveryservices/:id/safe
  • Add TO Go put deliveryservices/id/safe #2455
• delete /api/1.1/deliveryservices/:id
• get /api/1.1/servers/:id/deliveryservices
• post /api/1.1/deliveryservices/:xml_id/servers
• delete /api/1.1/deliveryservice_server/:dsId/:serverId
• get /api/1.1/deliveryservices/:id/health
  • Add TO Go deliveryservices/id/health #2458
• get /api/1.1/deliveryservices/:id/capacity
  • Add TO Go deliveryservices/id/capacity #2459
• get /api/1.1/deliveryservices/:id/routing
• get /api/1.1/deliveryservices/:id/state
• post /api/1.1/deliveryservices/request
• get /api/1.1/steering/:id/targets
  • Add Traffic Ops Golang Steering Targets #2803
• get /api/1.1/steering/:id/targets/:target_id
  • Add Traffic Ops Golang Steering Targets #2803
• post /api/1.1/steering/:id/targets
  • Add Traffic Ops Golang Steering Targets #2803
• put /api/1.1/steering/:id/targets/:target_id
  • Add Traffic Ops Golang Steering Targets #2803
• delete /api/1.1/steering/:id/targets/:target_id
  • Add Traffic Ops Golang Steering Targets #2803
• get /api/1.1/deliveryservices/xmlId/:xmlid/sslkeys
• post /api/1.1/deliveryservices/sslkeys/generate
• post /api/1.1/deliveryservices/sslkeys/add
• get /api/1.1/deliveryservices/xmlId/:xmlid/sslkeys/delete
• post /api/1.1/deliveryservices/xmlId/:xmlId/urlkeys/generate
• post /api/1.1/deliveryservices/xmlId/:xmlId/urlkeys/copyFromXmlId/:copyFromXmlId
• get /api/1.1/deliveryservices/xmlId/:xmlId/urlkeys
• get /api/1.1/deliveryservices/:id/urlkeys
• get /api/1.1/deliveryservices_regexes
• get /api/1.1/deliveryservices/:dsId/regexes
• get /api/1.1/deliveryservices/:dsId/regexes/:id
• post /api/1.1/deliveryservices/:dsId/regexes
• put /api/1.1/deliveryservices/:dsId/regexes/:id
• delete /api/1.1/deliveryservices/:dsId/regexes/:id
• get /api/1.1/deliveryservice_matches
• get /api/1.1/deliveryserviceserver
• post /api/1.1/deliveryserviceserver
• get /api/1.1/divisions
• get /api/1.1/divisions/:id
• get /api/1.1/divisions/name/:name
• put /api/1.1/divisions/:id
• post /api/1.1/divisions
• delete /api/1.1/divisions/:id
• delete /api/1.1/divisions/name/:name
• get /api/1.1/federations
• post /api/1.1/federations
• put /api/1.1/federations
• delete /api/1.1/federations
• get /api/1.1/cdns/:name/federations
• get /api/1.1/cdns/:name/federations/:fedId
• post /api/1.1/cdns/:name/federations
• put /api/1.1/cdns/:name/federations/:fedId
• delete /api/1.1/cdns/:name/federations/:fedId
• get /api/1.1/federations/:fedId/users
• post /api/1.1/federations/:fedId/users
• delete /api/1.1/federations/:fedId/users/:userId
• get /api/1.1/federations/:fedId/deliveryservices
• post /api/1.1/federations/:fedId/deliveryservices
• delete /api/1.1/federations/:fedId/deliveryservices/:dsId
• get /api/1.1/federations/:fedId/federation_resolvers
• post /api/1.1/federations/:fedId/federation_resolvers
• post /api/1.1/federation_resolvers
• delete /api/1.1/federation_resolvers/:id
• get /api/1.1/hwinfo/dtdata
• get /api/1.1/hwinfo
• get /api/1.1/osversions
• post /api/1.1/isos
• get /api/1.1/jobs
• get /api/1.1/jobs/:id
• get /api/1.1/user/current/jobs
• post /api/1.1/user/current/jobs
• get /api/1.1/parameters
• get /api/1.1/parameters/:id
• post /api/1.1/parameters
• put /api/1.1/parameters/:id
• delete /api/1.1/parameters/:id
• post /api/1.1/parameters/validate
• get /api/1.1/profiles/:id/parameters
• get /api/1.1/profiles/:id/unassigned_parameters
• get /api/1.1/profiles/name/:name/parameters
• get /api/1.1/parameters/profile/:name
• post /api/1.1/profiles/name/:name/parameters
• post /api/1.1/profiles/:id/parameters
• get /api/1.1/profileparameters
• post /api/1.1/profileparameters
• post /api/1.1/profileparameter
• post /api/1.1/parameterprofile
• delete /api/1.1/profileparameters/:profile_id/:parameter_id
• get /api/1.1/cachegroups/:id/parameters
• get /api/1.1/cachegroups/:id/unassigned_parameters
• get /api/1.1/cachegroup/:parameter_id/parameter
• get /api/1.1/cachegroupparameters
• post /api/1.1/cachegroupparameters
• delete /api/1.1/cachegroupparameters/:cachegroup_id/:parameter_id
• get /api/1.1/cachegroups/:parameter_id/parameter/available
• get /api/1.1/phys_locations
• get /api/1.1/phys_locations/trimmed
• get /api/1.1/phys_locations/:id
• post /api/1.1/phys_locations
• post /api/1.1/regions/:region_name/phys_locations
• put /api/1.1/phys_locations/:id
• delete /api/1.1/phys_locations/:id
• get /api/1.1/profiles
• get /api/1.1/profiles/trimmed
• get /api/1.1/profiles/:id
• post /api/1.1/profiles
• put /api/1.1/profiles/:id
• delete /api/1.1/profiles/:id
• post /api/1.1/profiles/name/:profile_name/copy/:profile_copy_from
• get /api/1.1/profiles/:id/export
• post /api/1.1/profiles/import
• get /api/1.1/parameters/:id/profiles
• get /api/1.1/parameters/:id/unassigned_profiles
• get /api/1.1/regions
• get /api/1.1/regions/:id
• get /api/1.1/regions/name/:name
• put /api/1.1/regions/:id
• post /api/1.1/regions
• post /api/1.1/divisions/:division_name/regions
• delete /api/1.1/regions/:id
• delete /api/1.1/regions/name/:name
• get /api/1.1/roles
• get /api/1.1/capabilities
• get /api/1.1/capabilities/:name
• put /api/1.1/capabilities/:name
• post /api/1.1/capabilities
• delete /api/1.1/capabilities/:name
• get /api/1.1/api_capabilities
• get /api/1.1/api_capabilities/:id
• put /api/1.1/api_capabilities/:id
• post /api/1.1/api_capabilities
• delete /api/1.1/api_capabilities/:id
• get /api/1.1/servers
• get /api/1.1/servers/:id
• post /api/1.1/servers
• put /api/1.1/servers/:id
• delete /api/1.1/servers/:id
• get /api/1.1/deliveryservices/:id/servers
• get /api/1.1/deliveryservices/:id/unassigned_servers
• get /api/1.1/deliveryservices/:id/servers/eligible
• get /api/1.1/servers/details
• get /api/1.1/servers/hostname/:name/details
• get /api/1.1/servers/totals
• get /api/1.1/servers/status
• post /api/1.1/servers/:id/queue_update
• put /api/1.1/servers/:id/status
• get /api/1.1/servers/checks
• get /api/1.1/servercheck/aadata
• post /api/1.1/servercheck
• get /api/1.1/stats_summary
• post /api/1.1/stats_summary/create
• get /api/1.1/statuses
• get /api/1.1/statuses/:id
• put /api/1.1/statuses/:id
• post /api/1.1/statuses
• delete /api/1.1/statuses/:id
• get /api/1.1/staticdnsentries
• get /api/1.1/system/info
• get /api/1.1/tenants
• get /api/1.1/tenants/:id
• put /api/1.1/tenants/:id
• post /api/1.1/tenants
• delete /api/1.1/tenants/:id
• get /api/1.1/types
• get /api/1.1/types/trimmed
• get /api/1.1/types/:id
• post /api/1.1/types
• put /api/1.1/types/:id
• delete /api/1.1/types/:id
• get /api/1.1/users
• get /api/1.1/users/:id
• put /api/1.1/users/:id
• post /api/1.1/users
• post /api/1.1/users/register
• get /api/1.1/users/:id/deliveryservices
• get /api/1.1/user/:id/deliveryservices/available
• post /api/1.1/deliveryservice_user
  • Add TO Go post deliveryservice_user #2457
• delete /api/1.1/deliveryservice_user/:dsId/:userId
  • Add TO Go delete deliveryservice_user #2456
• get /api/1.1/user/current
• put /api/1.1/user/current
• post /api/1.1/user/current/update
• post /api/1.1/user/login
• post /api/1.1/user/login/token
• post /api/1.1/user/logout
• post /api/1.1/user/reset_password
• get /api/1.1/keys/ping
• get /api/1.1/riak/ping
• get /api/1.1/riak/bucket/:bucket/key/:key/values
• get /api/1.1/to_extensions
• post /api/1.1/to_extensions
• post /api/1.1/to_extensions/:id/delete
• get /api/1.1/traffic_monitor/stats
• get /api/1.1/ping

[DylanVolz]

Here is the expected form of the above routes comma delimited as Method,Route

GET,asns/?$
POST,asns/?$
GET,caches/stats/?$
GET,cachegroups/?$
GET,cachegroups/trimmed/?$
POST,cachegroups/?$
GET,cdns/?$
GET,cdns/name/{name}$
POST,cdns/?$
DELETE,cdns/name/{name}$
GET,cdns/health/?$
GET,cdns/{name}/health/?$
GET,cdns/capacity/?$
GET,cdns/routing/?$
GET,cdns/{name}/snapshot/?$
GET,cdns/{name}/snapshot/new/?$
PUT,snapshot/{cdnName}$
GET,cdns/metric_types/{metricType}/start_date/{startDate}/end_date/{endDate}$
GET,cdns/name/{name}/dnsseckeys/?$
POST,cdns/dnsseckeys/generate/?$
GET,cdns/name/{name}/dnsseckeys/delete/?$
GET,/internalcdns/dnsseckeys/refresh/?$
GET,cdns/name/{name}/sslkeys/?$
GET,cdns/configs/?$
GET,cdns/{name}/configs/routing/?$
GET,cdns/{name}/configs/monitoring/?$
GET,cdns/domains/?$
GET,logs/?$
GET,logs/{days}/days/?$
GET,logs/newcount/?$
GET,servers/#id/configfiles/ats/?$
GET,profiles/#id/configfiles/ats/#filename/?$
GET,servers/#id/configfiles/ats/#filename/?$
GET,cdns/#id/configfiles/ats/#filename/?$
GET,dbdump/?$
GET,deliveryservices/?$
POST,deliveryservices/?$
POST,deliveryservices/{xmlID}/servers/?$
POST,deliveryservices/request/?$
GET,/internalsteering/?$
GET,/internalsteering/{xmlID}$
PUT,/internalsteering/{xmlID}$
GET,deliveryservices/xmlId/#xmlid/sslkeys/?$
GET,deliveryservices/hostname/#hostname/sslkeys/?$
POST,deliveryservices/sslkeys/generate/?$
POST,deliveryservices/sslkeys/add/?$
GET,deliveryservices/xmlId/{xmlid}/sslkeys/delete/?$
POST,deliveryservices/xmlId/{xmlID}/urlkeys/generate/?$
POST,deliveryservices/xmlId/{xmlID}/urlkeys/copyFromXmlId/{copyFromXmlID}$
GET,deliveryservices/xmlId/{xmlID}/urlkeys/?$
GET,deliveryservices/{id}/urlkeys/?$
GET,deliveryservices_regexes/?$
GET,deliveryservice_matches/?$
GET,deliveryserviceserver/?$
POST,deliveryserviceserver/?$
GET,divisions/?$
POST,divisions/?$
DELETE,divisions/name/{name}$
GET,/internalfederations/?$
GET,federations/?$
POST,federations/?$
PUT,federations/?$
DELETE,federations/?$
GET,cdns/{name}/federations/?$
GET,cdns/{name}/federations/{fedID}$
POST,cdns/{name}/federations/?$
PUT,cdns/{name}/federations/{fedID}$
DELETE,cdns/{name}/federations/{fedID}$
GET,hwinfo/dtdata/?$
GET,hwinfo/?$
GET,osversions/?$
POST,isos/?$
GET,jobs/?$
GET,user/current/jobs/?$
POST,user/current/jobs/?$
GET,parameters/?$
POST,parameters/?$
POST,parameters/validate/?$
GET,profiles/name/{name}/parameters/?$
POST,profiles/name/{name}/parameters/?$
GET,profileparameters/?$
POST,profileparameters/?$
POST,profileparameter/?$
POST,parameterprofile/?$
DELETE,profileparameters/{profileID}/{parameterID}$
GET,cachegroup/{parameterID}/parameter/?$
GET,cachegroupparameters/?$
POST,cachegroupparameters/?$
DELETE,cachegroupparameters/{cachegroupID}/{parameterID}$
GET,cachegroups/{parameterID}/parameter/available/?$
GET,phys_locations/?$
GET,phys_locations/trimmed/?$
POST,phys_locations/?$
POST,regions/{regionName}/phys_locations/?$
GET,profiles/?$
GET,profiles/trimmed/?$
POST,profiles/?$
POST,profiles/name/{profileName}/copy/{profileCopyFrom}$
POST,profiles/import/?$
GET,regions/?$
POST,regions/?$
POST,divisions/{divisionName}/regions/?$
DELETE,regions/name/{name}$
GET,roles/?$
GET,capabilities/?$
GET,capabilities/{name}$
PUT,capabilities/{name}$
POST,capabilities/?$
DELETE,capabilities/{name}$
GET,api_capabilities/?$
GET,api_capabilities/{id}$
PUT,api_capabilities/{id}$
POST,api_capabilities/?$
DELETE,api_capabilities/{id}$
GET,servers/?$
POST,servers/?$
GET,servers/details/?$
GET,servers/hostname/{name}/details/?$
GET,servers/totals/?$
GET,servers/status/?$
GET,servers/checks/?$
GET,servercheck/aadata/?$
POST,servercheck/?$
GET,stats_summary/?$
POST,stats_summary/create/?$
GET,statuses/?$
POST,statuses/?$
GET,staticdnsentries/?$
GET,system/info/?$
GET,tenants/?$
POST,tenants/?$
GET,types/?$
GET,types/trimmed/?$
POST,types/?$
GET,users/?$
POST,users/?$
POST,users/register/?$
POST,deliveryservice_user/?$
GET,user/current/?$
PUT,user/current/?$
POST,user/current/update/?$
POST,user/login/?$
POST,user/login/token/?$
POST,user/logout/?$
POST,user/reset_password/?$
GET,keys/ping/?$
GET,riak/ping/?$
GET,riak/bucket/{bucket}/key/{key}/values/?$
GET,to_extensions/?$
POST,to_extensions/?$
POST,to_extensions/{id}/delete/?$
GET,traffic_monitor/stats/?$

[rob05c]

Table Usage

get /api/1.1/cdns/domains
- DB: Profile, CDN

get /api/1.1/servers/:id/configfiles/ats
get /api/1.1/profiles/:id/configfiles/ats/:filename
get /api/1.1/servers/:id/configfiles/ats/:filename
get /api/1.1/cdns/:id/configfiles/ats/:filename

get /api/1.1/dbdump
- Ext: pg_dump

get /api/1.1/deliveryservices/:id/routing
- DB: Tenant, DeliveryService, DeliveryServiceRegex, Regex, Cdn, Type
- Ext: Router

get /api/1.1/deliveryservices/:id/state
- DB: Tenant, DeliveryService, CDN
- Ext: Monitor

post /api/1.1/deliveryservices/request
- Ext: Email

delete /api/1.1/divisions/name/:name
- DB: Division, Region

get /api/1.1/federations
- DB: TmUser, FederationTmUser, FederationDeliveryService, DeliveryService

post /api/1.1/federations
put /api/1.1/federations
delete /api/1.1/federations
get /api/1.1/cdns/:name/federations
get /api/1.1/cdns/:name/federations/:fedId
post /api/1.1/cdns/:name/federations
put /api/1.1/cdns/:name/federations/:fedId
delete /api/1.1/cdns/:name/federations/:fedId
get /api/1.1/federations/:fedId/users
post /api/1.1/federations/:fedId/users
delete /api/1.1/federations/:fedId/users/:userId
get /api/1.1/federations/:fedId/deliveryservices
post /api/1.1/federations/:fedId/deliveryservices
delete /api/1.1/federations/:fedId/deliveryservices/:dsId
get /api/1.1/federations/:fedId/federation_resolvers
post /api/1.1/federations/:fedId/federation_resolvers
post /api/1.1/federation_resolvers
delete /api/1.1/federation_resolvers/:id
- DB: TmUser, FederationTmUser, FederationDeliveryService, DeliveryService, FederationResolver, FederationFederationResolver

get /api/1.1/hwinfo/dtdata
- DB: HwInfo, Server

get /api/1.1/osversions
- DB: Parameter, Server
- Ext: file:osversions.cfg

post /api/1.1/isos
- DB: Parameter
- Ext: mkisofs

get /api/1.1/jobs
- DB: DeliveryService, Tenant, Job

get /api/1.1/jobs/:id
- DB: DeliveryService, Job

get /api/1.1/user/current/jobs
- DB: Tenant, DeliveryService, Job, TmUser

post /api/1.1/user/current/jobs
- DB: Tenant, DeliveryService, Job, TmUser

post /api/1.1/parameters/validate
- DB: Parameter

get /api/1.1/cachegroups/:id/parameters
- DB: Parameter, CachegroupParameter

get /api/1.1/cachegroups/:id/unassigned_parameters
- DB: Parameter, CachegroupParameter

get /api/1.1/cachegroup/:parameter_id/parameter
- DB: Cachegroup, CachegroupParameter

get /api/1.1/cachegroupparameters
- DB: CachegroupParameter

post /api/1.1/cachegroupparameters
- DB: Cachegroup, Parameter, ProfileParameter, CachegroupParameter

delete /api/1.1/cachegroupparameters/:cachegroup_id/:parameter_id
- DB: Cachegroup, Parameter, CachegroupParameter

get /api/1.1/cachegroups/:parameter_id/parameter/available
- DB: Cachegroup, CachegroupParameter

post /api/1.1/regions/:region_name/phys_locations
- DB: PhysLocation, Region

post /api/1.1/profiles/name/:profile_name/copy/:profile_copy_from
- DB: Profile, ProfileParameter

get /api/1.1/profiles/:id/export
- DB: Profile, ProfileParameter, Parameter

post /api/1.1/profiles/import
- DB: Cdn, Profile, ProfileTypeValue, Parameter, ProfileParameter

get /api/1.1/parameters/:id/profiles
- DB: Profile, ProfileParameter

get /api/1.1/parameters/:id/unassigned_profiles
- DB: Profile, ProfileParameter

post /api/1.1/divisions/:division_name/regions
- DB: Region, Division

delete /api/1.1/regions/name/:name
- DB: Region

get /api/1.1/roles
- DB: Role

get /api/1.1/capabilities
- DB: Capability

get /api/1.1/capabilities/:name
- DB: Capability

put /api/1.1/capabilities/:name
- DB: Capability

post /api/1.1/capabilities
- DB: Capability

delete /api/1.1/capabilities/:name
- DB: Capability, ApiCapability

get /api/1.1/api_capabilities
- DB: ApiCapability

get /api/1.1/api_capabilities/:id
- DB: ApiCapability

put /api/1.1/api_capabilities/:id
- DB: ApiCapability

post /api/1.1/api_capabilities
- DB: ApiCapability

delete /api/1.1/api_capabilities/:id
- DB: ApiCapability

get /api/1.1/servers/totals
- DB: ServerTypes, Server, Type

get /api/1.1/servers/status
- DB: Server, Status, Type

post /api/1.1/servers/:id/queue_update
- DB: Server

put /api/1.1/servers/:id/status
- DB: Server, Status, Type, Cachegroup

get /api/1.1/servers/checks
- DB: ToExtension, Server, Profile, Status, Cachegroup, Type

get /api/1.1/servercheck/aadata
- DB: Type, Server, ServerCheck

post /api/1.1/servercheck
- DB: ToExtension, Server

get /api/1.1/stats_summary
- DB: StatsSummary

post /api/1.1/stats_summary/create
- DB: StatsSummary

get /api/1.1/types/trimmed
- DB: Type

post /api/1.1/users/register
- DB: TmUser, Role, Tenant
- Ext: Email

put /api/1.1/user/current
- DB: Tenant, TmUser

post /api/1.1/user/current/update
- DB: Tenant, TmUser

post /api/1.1/user/login/token
- DB: Tenant, TmUser

post /api/1.1/user/logout
- nothing

post /api/1.1/user/reset_password
- DB: TmUser
- Ext: Email

get /api/1.1/to_extensions
- DB: ToExtension, Parameter, ProfileParameter

post /api/1.1/to_extensions
- DB: ToExtension, ServerCheck

post /api/1.1/to_extensions/:id/delete
- DB: ToExtension

get /api/1.1/traffic_monitor/stats
- DB: Server, Cdn
- Ext: Monitor

External

Commands

get /api/1.1/dbdump (pg_dump)
get /api/1.1/osversions (file:osversions.cfg)
post /api/1.1/isos (mkisofs)

Monitor

get /api/1.1/deliveryservices/:id/state
get /api/1.1/traffic_monitor/stats

Router

get /api/1.1/deliveryservices/:id/routing

Email

post /api/1.1/deliveryservices/request
post /api/1.1/users/register
post /api/1.1/user/reset_password

Observations

• Deliveryservices overlap almost 1:1 with (Riak,) Monitor, Router
• Most Delete check other tables, to ensure foreign keys
  • can we remove from Perl, and rely on DB for foreign key constraints?
• 30/110 endpoints use DeliveryServices table

Delivery Services Table

get /api/1.1/deliveryservices/:id/routing
get /api/1.1/deliveryservices/:id/state
get /api/1.1/federations
post /api/1.1/federations
put /api/1.1/federations
delete /api/1.1/federations
get /api/1.1/jobs
get /api/1.1/jobs/:id
get /api/1.1/user/current/jobs
post /api/1.1/user/current/jobs