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 2020/08/26 06:17:06 UTC

[GitHub] [trafficcontrol] srijeet0406 opened a new pull request #4989: Find a better way to determine last status change

srijeet0406 opened a new pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989


   <!--
   ************ STOP!! ************
   If this Pull Request is intended to fix a security vulnerability, DO NOT submit it! Instead, contact
   the Apache Software Foundation Security Team at security@trafficcontrol.apache.org and follow the
   guidelines at https://www.apache.org/security/ regarding vulnerability disclosure.
   -->
   ## What does this PR (Pull Request) do?
   <!-- Explain the changes you made here. If this fixes an Issue, identify it by
   replacing the text in the checkbox item with the Issue number e.g.
   
   - [x] This PR fixes #9001 OR is not related to any Issue
   
   ^ This will automatically close Issue number 9001 when the Pull Request is
   merged (The '#' is important).
   
   Be sure you check the box properly, see the "The following criteria are ALL
   met by this PR" section for details.
   -->
   
   - [x] This PR fixes #1636  <!-- You can check for an issue here: https://github.com/apache/trafficcontrol/issues -->
   
   
   ## Which Traffic Control components are affected by this PR?
   <!-- Please delete all components from this list that are NOT affected by this
   Pull Request. Also, feel free to add the name of a tool or script that is
   affected but not on the list.
   
   Additionally, if this Pull Request does NOT affect documentation, please
   explain why documentation is not required. -->
   
   - CDN in a Box
   - Traffic Ops
   - Traffic Portal
   - CI tests
   
   ## What is the best way to verify this PR?
   <!-- Please include here ALL the steps necessary to test your Pull Request. If
   it includes tests (and most should), outline here the steps needed to run the
   tests. If not, lay out the manual testing procedure and please explain why
   tests are unnecessary for this Pull Request. -->
   
   Run local TO and TP and create a server. Notice that the `status_last_updated` field gets set to the current time in the DB.
   Now, go to TP, and select the `Status Last Updated` as one of the display columns for the servers table. Notice that it shows the correct time elapsed since you created the server.
   Now, update this server changing any field, EXCEPT the `status` of the server. Notice that the `status_last_updated` value DOES NOT change.
   Now, update the server by changing the server's status (you will have to do this from the backend call, since TP doesn't let you do it from the front end). 
   Notice that the `status_last_updated` time gets changed to the current time this time around.
   
   Also, make sure unit tests and API tests pass.
   
   ## If this is a bug fix, what versions of Traffic Control are affected?
   <!-- If this PR fixes a bug, please list here all of the affected versions - to
   the best of your knowledge. It's also pretty helpful to include a commit hash
   of where 'master' is at the time this PR is opened (if it affects master),
   because what 'master' means will change over time. For example, if this PR
   fixes a bug that's present in master (at commit hash '1df853c8'), in v4.0.0,
   and in the current 4.0.1 Release candidate (e.g. RC1), then this list would
   look like:
   
   - master (1df853c8)
   
   If you don't know what other versions might have this bug, AND don't know how
   to find the commit hash of 'master', then feel free to leave this section
   blank (or, preferably, delete it entirely).
    -->
   - master
   
   ## The following criteria are ALL met by this PR
   <!-- Check the boxes to signify that the associated statement is true. To
   "check a box", replace the space inside of the square brackets with an 'x'.
   e.g.
   
   - [ x] <- Wrong
   - [x ] <- Wrong
   - [] <- Wrong
   - [*] <- Wrong
   - [x] <- Correct!
   
   -->
   
   - [x] This PR includes tests OR
   - [x] This PR does not include documentation
   - [x] This PR includes an update to CHANGELOG.md
   - [x] This PR includes any and all required license headers
   - [x] This PR ensures that database migration sequence is correct
   - [x] This PR **DOES NOT FIX A SERIOUS SECURITY VULNERABILITY** (see [the Apache Software Foundation's security guidelines](https://www.apache.org/security/) for details)
   
   
   ## Additional Information
   <!-- If you would like to include any additional information on the PR for
   potential reviewers please put it here.
   
   Some examples of this would be:
   
   - Before and after screenshots/gifs of the Traffic Portal if it is affected
   - Links to other dependent Pull Requests
   - References to relevant context (e.g. new/updates to dependent libraries,
   mailing list records, blueprints)
   
   Feel free to leave this section blank (or, preferably, delete it entirely).
   -->
   
   <!--
   Licensed to the Apache Software Foundation (ASF) under one
   or more contributor license agreements.  See the NOTICE file
   distributed with this work for additional information
   regarding copyright ownership.  The ASF licenses this file
   to you under the Apache License, Version 2.0 (the
   "License"); you may not use this file except in compliance
   with the License.  You may obtain a copy of the License at
   
       http://www.apache.org/licenses/LICENSE-2.0
   
   Unless required by applicable law or agreed to in writing,
   software distributed under the License is distributed on an
   "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
   KIND, either express or implied.  See the License for the
   specific language governing permissions and limitations
   under the License.
   -->
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] mitchell852 commented on pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
mitchell852 commented on pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#issuecomment-683126148


   sorry, conflict in our favorite file :)


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] mitchell852 commented on pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
mitchell852 commented on pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#issuecomment-684000915


   for some reason the column filter is not working in TP on this field:
   
   ![image](https://user-images.githubusercontent.com/251272/91760392-88bb0f80-eb90-11ea-93f9-0dac8d746865.png)
   
   I have a server i just changed the status of and it's not showing up. So i'm wondering if the data format needs to be changed to that of LastUpdated:
   
   lastUpdated: "2020-08-28 20:53:55+00",
   statusLastUpdated: "2020-08-28T20:53:55.75928Z"
   
   I'm not sure if that will solve the TP grid problem but maybe consistent is better anyhow?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] ocket8888 commented on pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
ocket8888 commented on pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#issuecomment-684028111


   The data will compare properly if you coerce it to a Date. If you look in the servers table controller, when I set `$scope.servers` I map the returned servers array and apply a conversion to Date objects on the Last Updated field. So no, it's not that the Last Updated format works (in fact it's worse than the statusLastUpdated field, I had to do some string manipulation to get the `Date` constructor to work), it's just that it can only filter Dates by date.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] srijeet0406 commented on a change in pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
srijeet0406 commented on a change in pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#discussion_r479527159



##########
File path: traffic_ops/traffic_ops_golang/server/servers.go
##########
@@ -102,9 +102,102 @@ SELECT
 	s.type AS server_type_id,
 	s.upd_pending AS upd_pending,
 	s.xmpp_id,
-	s.xmpp_passwd
+	s.xmpp_passwd,
+    s.status_last_updated

Review comment:
       hmm, I ran `go fmt` on it 🤔 




----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] srijeet0406 commented on pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
srijeet0406 commented on pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#issuecomment-684039794


   Resolved in `97bca2f`


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] mitchell852 commented on pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
mitchell852 commented on pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#issuecomment-684044688


   Can you update `dateCellFormatter` as well to this?
   
   ```
   	/**
   	 * Formats the contents of the 'lastUpdated' and 'statusLastUpdated' column cells as "relative to now".
   	 */
   	function dateCellFormatter(params) {
   		return params.value ? dateUtils.getRelativeTime(params.value) : params.value;
   	}
   ```
   
   so `dateUtils.getRelativeTime` doesn't try to parse a null which displays "Invalid Date"


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] srijeet0406 commented on pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
srijeet0406 commented on pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#issuecomment-683130163


   @mitchell852 fixed 👍 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] mitchell852 merged pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
mitchell852 merged pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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



[GitHub] [trafficcontrol] mitchell852 commented on a change in pull request #4989: Find a better way to determine last status change

Posted by GitBox <gi...@apache.org>.
mitchell852 commented on a change in pull request #4989:
URL: https://github.com/apache/trafficcontrol/pull/4989#discussion_r479525590



##########
File path: traffic_ops/traffic_ops_golang/server/servers.go
##########
@@ -102,9 +102,102 @@ SELECT
 	s.type AS server_type_id,
 	s.upd_pending AS upd_pending,
 	s.xmpp_id,
-	s.xmpp_passwd
+	s.xmpp_passwd,
+    s.status_last_updated

Review comment:
       format problem?




----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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