Derek Stephen McLean delboy1978uk
delboy1978uk
/ satis_github_auth.sh
Last active
August 29, 2015 14:27
— forked from h4cc/satis_github_auth.sh
Some notes on how to authenticate with composer/satis against github oauth, so the rate limit of 60 will be raised op to 5000. Can also be used for travis-ci.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Create a new Token | |
| curl -u 'githubuser' -d '{"note":"Your Application"}' https://api.github.com/authorizations | |
| # It is: "ebab4dc37e654bb230a9c69ebcd5f38e9a81e210" | |
| #{ | |
| # "created_at": "2013-01-04T18:00:28Z", | |
| # "app": { | |
| # "url": "http://developer.github.com/v3/oauth/#oauth-authorizations-api", |
delboy1978uk
/ Category.sql
Last active
August 29, 2015 14:23
— forked from ticean/Category.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SET @entityid = '3'; | |
| SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type' | |
| FROM catalog_category_entity e | |
| JOIN catalog_category_entity_varchar eav | |
| ON e.entity_id = eav.entity_id | |
| JOIN eav_attribute ea | |
| ON eav.attribute_id = ea.attribute_id | |
| WHERE e.entity_id = @entityid | |
| UNION |