{"action":"created","issue":{"url":"https://api.github.com/repos/Prodiguer/synda/issues/43","repository_url":"https://api.github.com/repos/Prodiguer/synda","labels_url":"https://api.github.com/repos/Prodiguer/synda/issues/43/labels{/name}","comments_url":"https://api.github.com/repos/Prodiguer/synda/issues/43/comments","events_url":"https://api.github.com/repos/Prodiguer/synda/issues/43/events","html_url":"https://github.com/Prodiguer/synda/issues/43","id":161888797,"number":43,"title":"'synda metric' not returning any result","user":{"login":"jripsl","id":6390160,"avatar_url":"https://avatars.githubusercontent.com/u/6390160?v=3","gravatar_id":"","url":"https://api.github.com/users/jripsl","html_url":"https://github.com/jripsl","followers_url":"https://api.github.com/users/jripsl/followers","following_url":"https://api.github.com/users/jripsl/following{/other_user}","gists_url":"https://api.github.com/users/jripsl/gists{/gist_id}","starred_url":"https://api.github.com/users/jripsl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jripsl/subscriptions","organizations_url":"https://api.github.com/users/jripsl/orgs","repos_url":"https://api.github.com/users/jripsl/repos","events_url":"https://api.github.com/users/jripsl/events{/privacy}","received_events_url":"https://api.github.com/users/jripsl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-06-23T10:22:15Z","updated_at":"2016-06-23T12:32:01Z","closed_at":null,"body":"```\r\n$ synda queue\r\nstatus      count  size\r\ndone          132  343.4 GB\r\nrunning        10  15.2 GB\r\nwaiting       174  464.0 GB \r\n```\r\n\r\n```\r\n$ synda metric\r\n....\r\n```"},"comment":{"url":"https://api.github.com/repos/Prodiguer/synda/issues/comments/228035503","html_url":"https://github.com/Prodiguer/synda/issues/43#issuecomment-228035503","issue_url":"https://api.github.com/repos/Prodiguer/synda/issues/43","id":228035503,"user":{"login":"jripsl","id":6390160,"avatar_url":"https://avatars.githubusercontent.com/u/6390160?v=3","gravatar_id":"","url":"https://api.github.com/users/jripsl","html_url":"https://github.com/jripsl","followers_url":"https://api.github.com/users/jripsl/followers","following_url":"https://api.github.com/users/jripsl/following{/other_user}","gists_url":"https://api.github.com/users/jripsl/gists{/gist_id}","starred_url":"https://api.github.com/users/jripsl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jripsl/subscriptions","organizations_url":"https://api.github.com/users/jripsl/orgs","repos_url":"https://api.github.com/users/jripsl/repos","events_url":"https://api.github.com/users/jripsl/events{/privacy}","received_events_url":"https://api.github.com/users/jripsl/received_events","type":"User","site_admin":false},"created_at":"2016-06-23T12:32:01Z","updated_at":"2016-06-23T12:32:01Z","body":"\r\nSome informations are missing in the table.\r\n\r\nHere is a fix for 3.3 and 3.4:\r\n\r\nRun queries below\r\n\r\n```\r\n$ sqlite3 $HOME/sdt/db/sdt.db \"update file set duration=cast(((julianday(end_date) - julianday(start_date)) * 86400.0) as integer) where status = 'done';\"\r\n$ sqlite3 $HOME/sdt/db/sdt.db \"update file set duration=1 where duration=0 and status='done';\"\r\n$ sqlite3 $HOME/sdt/db/sdt.db \"update file set rate=size/duration where status='done';\"\r\n```\r\n\r\n'synda metric' command should work after that.\r\n\r\n"}}
{"actor":{"display_login":"jripsl"}}