You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafficcontrol.apache.org by GitBox <gi...@apache.org> on 2018/09/13 02:43:20 UTC
[GitHub] rob05c edited a comment on issue #2232: Rewrite Traffic Ops
CRConfig Table Endpoints in Go
rob05c edited a comment on issue #2232: Rewrite Traffic Ops CRConfig Table Endpoints in Go
URL: https://github.com/apache/trafficcontrol/issues/2232#issuecomment-398070296
# 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
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services