{"action":"closed","issue":{"url":"https://api.github.com/repos/Azure/azure-cli/issues/1764","repository_url":"https://api.github.com/repos/Azure/azure-cli","labels_url":"https://api.github.com/repos/Azure/azure-cli/issues/1764/labels{/name}","comments_url":"https://api.github.com/repos/Azure/azure-cli/issues/1764/comments","events_url":"https://api.github.com/repos/Azure/azure-cli/issues/1764/events","html_url":"https://github.com/Azure/azure-cli/issues/1764","id":201419700,"number":1764,"title":"[Sql] Expose convenience commnds from generics updates","user":{"login":"vishrutshah","id":8782776,"avatar_url":"https://avatars3.githubusercontent.com/u/8782776?v=3","gravatar_id":"","url":"https://api.github.com/users/vishrutshah","html_url":"https://github.com/vishrutshah","followers_url":"https://api.github.com/users/vishrutshah/followers","following_url":"https://api.github.com/users/vishrutshah/following{/other_user}","gists_url":"https://api.github.com/users/vishrutshah/gists{/gist_id}","starred_url":"https://api.github.com/users/vishrutshah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vishrutshah/subscriptions","organizations_url":"https://api.github.com/users/vishrutshah/orgs","repos_url":"https://api.github.com/users/vishrutshah/repos","events_url":"https://api.github.com/users/vishrutshah/events{/privacy}","received_events_url":"https://api.github.com/users/vishrutshah/received_events","type":"User","site_admin":false},"labels":[{"id":418940486,"url":"https://api.github.com/repos/Azure/azure-cli/labels/SQL","name":"SQL","color":"d4c5f9","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-01-17T22:07:42Z","updated_at":"2017-03-01T18:08:23Z","closed_at":"2017-03-01T18:08:23Z","body":"Most of the `az sql` commands only allows updates through generic --add / --set / --remove. We should expose convenience commands as arguments into each of those respective updates:\r\n\r\nExample for Sql (**Only generic options**):\r\n\r\n```\r\n(env) vishrut@visshamac azure-cli (sql-server-firewall-test) $ az sql server update -h\r\n\r\nCommand\r\n    az sql server update: Update an Azure SQL server.\r\n\r\nArguments\r\n    --resource-group -g [Required]: Name of resource group.\r\n    --server-name       [Required]: The name of the Azure SQL server.\r\n\r\nGeneric Update Arguments\r\n    --add                         : Add an object to a list of objects by specifying a path and key\r\n                                    value pairs.  Example: --add property.listProperty <key=value,\r\n                                    string or JSON string>.\r\n    --remove                      : Remove a property or an element from a list.  Example: --remove\r\n                                    property.list <indexToRemove> OR --remove propertyToRemove.\r\n    --set                         : Update an object by specifying a property path and value to set.\r\n                                    Example: --set property1.property2=<value>.\r\n\r\nGlobal Arguments\r\n    --debug                       : Increase logging verbosity to show all debug logs.\r\n    --help -h                     : Show this help message and exit.\r\n    --output -o                   : Output format.  Allowed values: json, jsonc, list, table, tsv.\r\n                                    Default: json.\r\n    --query                       : JMESPath query string. See http://jmespath.org/ for more\r\n                                    information and examples.\r\n    --verbose                     : Increase logging verbosity. Use --debug for full debug logs.\r\n```\r\n\r\nExample for Network (**Generic + Convenience options**):\r\n```\r\n(env) vishrut@visshamac azure-cli (sql-server-firewall-test) $ az network nic update -h\r\n\r\nCommand\r\n    az network nic update: Update a network interface.\r\n\r\nArguments\r\n    --internal-dns-name     : The internal DNS name label.\r\n    --ip-forwarding         : Enable IP forwarding.  Allowed values: false, true.\r\n    --network-security-group: Name or ID of an existing network security group to associate with the\r\n                              NIC.\r\n\r\nResource Id Arguments\r\n    --ids                   : One or more resource IDs. If provided, no other 'Resource Id'\r\n                              arguments should be specified.\r\n    --name -n               : The network interface (NIC).\r\n    --resource-group -g     : Name of resource group.\r\n\r\nGeneric Update Arguments\r\n    --add                   : Add an object to a list of objects by specifying a path and key value\r\n                              pairs.  Example: --add property.listProperty <key=value, string or\r\n                              JSON string>.\r\n    --remove                : Remove a property or an element from a list.  Example: --remove\r\n                              property.list <indexToRemove> OR --remove propertyToRemove.\r\n    --set                   : Update an object by specifying a property path and value to set.\r\n                              Example: --set property1.property2=<value>.\r\n\r\nGlobal Arguments\r\n    --debug                 : Increase logging verbosity to show all debug logs.\r\n    --help -h               : Show this help message and exit.\r\n    --output -o             : Output format.  Allowed values: json, jsonc, list, table, tsv.\r\n                              Default: json.\r\n    --query                 : JMESPath query string. See http://jmespath.org/ for more information\r\n                              and examples.\r\n    --verbose               : Increase logging verbosity. Use --debug for full debug logs.\r\n```\r\n\r\n**cc:**\r\n@troydai "}}
{"actor":{"display_login":"derekbekoe"}}