| #!/usr/bin/env groovy | |
| import java.lang.management.* | |
| import javax.management.ObjectName | |
| import javax.management.remote.JMXConnectorFactory as JmxFactory | |
| import javax.management.remote.JMXServiceURL as JmxUrl | |
| def serverUrl = 'service:jmx:rmi:///jndi/rmi://localhost:9987/jmxrmi' | |
| String beanName = "com.somecompany.Scheduler:k=ScheduledTasks" | |
| def server = JmxFactory.connect(new JmxUrl(serverUrl)).MBeanServerConnection | |
| def gmxb = new GroovyMBean(server, beanName) |
| /* | |
| Функция для одновременной подсветки ссылок с одинаковым href, | |
| на вход принимает: | |
| 1) selector — джеквери-селектор ссылок, чтобы | |
| была возможность включить дублирующую подсветку в определённом фрагменте; | |
| 2) hoverClass — какой класс добавить по ховеру и псевдо-ховеру. | |
| Инициализация для всего документа: | |
| doubleHover('a', 'hover'); |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| @mixin linear-gradient($angle, $color-stops...) { | |
| $_angle-with-vendor-prefix: ""; | |
| $_angle: ""; | |
| @if $angle == "to top" or $angle == "bottom" { | |
| $_angle-with-vendor-prefix: bottom; | |
| $_angle: to top; | |
| } @else if $angle == "to right" or $angle == "left" { | |
| $_angle-with-vendor-prefix: left; | |
| $_angle: to right; | |
| } @else if $angle == "to bottom" or $angle == "top" { |
| -- Decoding | |
| SELECT CONVERT_FROM(DECODE(field, 'BASE64'), 'UTF-8') FROM table; | |
| -- Encoding | |
| SELECT ENCODE(CONVERT_TO(field, 'UTF-8'), 'base64') FROM table; |
| # | |
| # Working with branches | |
| # | |
| # Get the current branch name (not so useful in itself, but used in | |
| # other aliases) | |
| branch-name = "!git rev-parse --abbrev-ref HEAD" | |
| # Push the current branch to the remote "origin", and set it to track | |
| # the upstream branch | |
| publish = "!git push -u origin $(git branch-name)" |
-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;-- Then change column name of your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;
| # If you have an API that returns JSON but want the reponse as raw text you | |
| # can override Angulars built in JSON response parser by using an identity | |
| # function as response transformer function | |
| $http.get("/myapi", | |
| { transformResponse: (d, h) -> return d } # return raw response | |
| ) | |
| .success((data, status, headers) -> | |
| # data is now pure text | |
| alert("Response is text: #{angular.isString(data)}") |
Located in alphabetical order (not prefer)
Cab), also designed as a more modern replacement, written in Cgolang)
| <!DOCTYPE html> | |
| <html ng-app> | |
| <head> | |
| <title>Example</title> | |
| </head> | |
| <body> | |
| <nav class="main-nav" data-main-menu data-root="index"></nav> | |
| <script type="text/javascript" src="angular.js"></script> |