Renew GPG key

Given that your key has expired.

$ gpg --list-keys
$ gpg --edit-key KEYID

Use the expire command to set a new expire date:

arthuralvim / example.py

Created December 19, 2022 23:05 — forked from bblanchon/example.py

Django Subquery Aggregate (Count, Sum...)

	from django.db.models import OuterRef

	weapons = Weapon.objects.filter(unit__player_id=OuterRef('id'))
	units = Unit.objects.filter(player_id=OuterRef('id'))

	qs = Player.objects.annotate(weapon_count=SubqueryCount(weapons),
	rarity_sum=SubquerySum(units, 'rarity'))

arthuralvim / luigi_first_steps.md

Created August 18, 2021 14:18 — forked from tomsing1/luigi_first_steps.md

First steps with the Luigi workflow manager

As an introduction into Luigi, I am following this tutorial with some modifications, e.g. installation using conda.

The problems and solutions described in the examples below have led to the development of sciluigi,

arthuralvim / sqlalchemy_conftest.py

Created February 25, 2021 03:50 — forked from kissgyorgy/sqlalchemy_conftest.py

Python: py.test fixture for SQLAlchemy test in a transaction, create tables only once!

	from sqlalchemy import create_engine
	from sqlalchemy.orm import Session
	from myapp.models import BaseModel
	import pytest


	@pytest.fixture(scope="session")
	def engine():
	return create_engine("postgresql://localhost/test_database")

arthuralvim / kafka-cheat-sheet.md

Created February 2, 2021 23:13 — forked from ursuad/kafka-cheat-sheet.md

Quick command reference for Apache Kafka

Kafka Topics

List existing topics

bin/kafka-topics.sh --zookeeper localhost:2181 --list

Describe a topic

bin/kafka-topics.sh --zookeeper localhost:2181 --describe --topic mytopic

Purge a topic

bin/kafka-topics.sh --zookeeper localhost:2181 --alter --topic mytopic --config retention.ms=1000

... wait a minute ...

arthuralvim / postgres_queries_and_commands.sql

Created September 8, 2020 12:46 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- 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%'

arthuralvim / GetGmailEmails.gs

Created August 12, 2020 13:22 — forked from moayadhani/GetGmailEmails.gs

Get Gmail Emails By Assigned Label

	var ui = SpreadsheetApp.getUi();
	function onOpen(e){

	ui.createMenu("Gmail Manager").addItem("Get Emails by Label", "getGmailEmails").addToUi();

	}

	function getGmailEmails(){
	var input = ui.prompt('Label Name', 'Enter the label name that is assigned to your emails:', Browser.Buttons.OK_CANCEL);

arthuralvim / aws_create_site.yml

Created February 19, 2020 13:00 — forked from ruzickap/aws_create_site.yml

Ansible playbook which creates instances and tag volumes

	---
	- name: Create Instance in AWS
	hosts: localhost
	connection: local
	gather_facts: false

	vars:
	aws_access_key: "xxxxxx"
	aws_secret_key: "xxxxxx"
	security_token: "xxxxxx"

arthuralvim / ansible-aws-inventory-main.yml

Created February 13, 2020 14:03 — forked from nivleshc/ansible-aws-inventory-main.yml

The main inventory file - declare variables here. This calls the worker file (which must be prese

	---
	# Name: ansible-aws-inventory-main.yml
	# Description: this is the main file that calls the worker file (ansible-aws-inventory-worker.yml) to create an inventory of all the
	# specific aws resources.
	# Below are the resources that will be inventoried
	# - vpc
	# - subnet
	# - igw
	# - cgw
	# - vgw

arthuralvim / ansible-aws-inventory-worker.yml

Created February 13, 2020 14:03 — forked from nivleshc/ansible-aws-inventory-worker.yml

Ansible Inventory Worker file. This is the file which actually carries out all the inventory tasks. It is called by the main file

	# Name: ansible-aws-inventory-worker.yml
	# Description: this is the worker file that called the main file (ansible-aws-inventory-main.yml) to to create an inventory of all the
	# specific aws resources. This file, the worker file and the ansible inventory file must be placed in the same folder
	# Prerequisites:
	# - the worker file (ansible-aws-inventory-worker.yml) and the ansible hosts file must be present in the same folder as this file (ansible-aws-inventory-main.yml)
	# - this script requires read access to all resources it will be querying. An AWS IAM user account must be created with the necessary permissions and with access keys enabled.
	# At a minimum, to query all the resources mentioned above, the following permissions are required
	# - AmazonVPCReadOnlyAccess
	# - AmazonEC2ReadOnlyAccess
	# - ElasticLoadBalancingReadOnly