hbasria

docker volume rm $(docker volume ls -qf dangling=true)

hbasria

from django.db import connection, models
 
class MyManager(Manager):
    def raw_as_qs(self, raw_query, params=()):
        """Execute a raw query and return a QuerySet.  The first column in the
        result set must be the id field for the model.
        :type raw_query: str | unicode
        :type params: tuple[T] | dict[str | unicode, T]
        :rtype: django.db.models.query.QuerySet
        """

hbasria

SELECT * FROM tree 
left join (
  SELECT 
    generate_series as id,
    case 
      when generate_series = 0 then 'CREATED'
      when generate_series = 1 then 'PENDING'
      when generate_series = 2 then 'RECEIVED'
      when generate_series = 3 then 'STARTED'
      when generate_series = 4 then 'RETRY'

hbasria

git branch -m old_branch new_branch         # Rename branch locally    
git push origin :old_branch                 # Delete the old branch    
git push --set-upstream origin new_branch   # Push the new branch, set local branch to track the new remote

hbasria

# Bulk deletes keys start with "prefix"  
EVAL "for i, name in ipairs(redis.call('KEYS', 'prefix*')) do redis.call('DEL', name); end" 0

# Bulk renames keys start with "prefix" to "postfix". 
# e.g. prefixwithtail -> postfixwithtail
EVAL "for i, name in ipairs(redis.call('KEYS', 'prefix*')) do local x = string.gsub(name, 'pre', 'post'); redis.call('RENAME', name, x); end" 0

hbasria

# knife cheat

## Search Examples

	knife search "name:ip*" 
	knife search "platform:ubuntu*"
	knife search "platform:*" -a macaddress
	knife search "platform:ubuntu*" -a uptime
	knife search "platform:ubuntu*" -a virtualization.system
	knife search "platform:ubuntu*" -a network.default_gateway

hbasria

CREATE OR REPLACE FUNCTION is_private_ip(p_prefix inet) RETURNS boolean AS
$BODY$
BEGIN

	RETURN (
	SELECT 
	CASE
		WHEN '10.0.0.0/8'::inet >> p_prefix::inet 
			OR '192.168.0.0/16'::inet >> p_prefix::inet 
			OR '172.16.0.0/12'::inet >> p_prefix::inet THEN True

hbasria

--select deps_save_and_drop_dependencies('public','test_table')

--select deps_restore_dependencies('public','test_table')

--select * from deps_saved_ddl

create table deps_saved_ddl
(
  deps_id serial primary key, 
  deps_view_schema varchar(255), 

hbasria

#result = dict_items(response, 'Body/findResponse/result/Interface')
def dict_items(dict, path, separator='/'):

    for item in path.split(separator):
        if item in dict:
            dict = dict[item]

            if type(dict) is str and len(dict)<=0:
                return None
        else:

hbasria

WITH weeks AS (
  SELECT distinct date_trunc('week', dates)::date AS start,
  daterange(date_trunc('week', dates)::date, (date_trunc('week', dates) + interval '7 days')::date) week
  FROM generate_series(date '2013-01-01', now(), '1 day')
  dates ORDER BY 1
)
SELECT weeks.start,
    count(whatever.*) as count
  FROM whatever
  JOIN weeks