Skip to content

Instantly share code, notes, and snippets.

Altair Lage altairlage

View GitHub Profile
View queryResoltPostgresToCSV.txt
\copy (<SQL Query - no ;>) To '/home/user/query.csv' With header CSV delimiter as ';'
@altairlage
altairlage / ConnectPostgresFromLinux.txt
Created Apr 18, 2019
How to connect to a remote postgres database from linux
View ConnectPostgresFromLinux.txt
psql -h <endpoint/ip> -p <port> -d <dbname> -U <user> -W <password>
@altairlage
altairlage / temp-policy.json
Created Mar 18, 2019
Sample temp AWS IAM permissions policy
View temp-policy.json
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "VisualEditor0",
"Effect": "Allow",
"Action": [
"iot:UpdateThing",
"iot:GetThingShadow",
"iot:UpdateThingShadow",
View Install_VS2017_command_line.txt
References:
https://docs.microsoft.com/pt-br/visualstudio/install/use-command-line-parameters-to-install-visual-studio?view=vs-2017
https://docs.microsoft.com/pt-br/visualstudio/install/workload-and-component-ids?view=vs-2017
https://docs.microsoft.com/pt-br/visualstudio/install/workload-component-id-vs-community?view=vs-2017
https://docs.microsoft.com/en-us/visualstudio/install/use-command-line-parameters-to-install-visual-studio?view=vs-2017
Powershell commands:
setx /M PATH "%PATH%;C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin;
@altairlage
altairlage / graylog_role_request_notes.txt
Last active Feb 28, 2019
Graylog api role request notes
View graylog_role_request_notes.txt
Documentation:
http://docs.graylog.org/en/3.0/pages/configuration/rest_api.html
http://docs.graylog.org/en/2.3/pages/users_and_roles/permission_system.html
https://github.com/Graylog2/graylog2-server/issues/4133
https://github.com/Graylog2/graylog2-server/blob/2.3.1/graylog2-server/src/main/java/org/graylog2/shared/security/RestPermissions.java#L49
Internal API documentation:
https://<your graylog address>/api/api-browser/
Get permissions list:
@altairlage
altairlage / convert_from_bitbucket.txt
Created Dec 20, 2018
How to checkout from Mercurial Bitbucket and fully commit to a github repo
View convert_from_bitbucket.txt
1- Install mercurial
- apt-get install mercurial
2- Checkout bitbucket repo
- hg clone <repo url> -r <branch>
- EX - hg clone https://bitbucket.org/rptlab/reportlab -r default
3 - Create a git repo:
- cd reportlab
- git init
- git checkout -b master
@altairlage
altairlage / deleteIoTThingsByTypeOrName.py
Last active Feb 28, 2019
Delete AWS IoT things based on type or thing name detaching principals and deleting certificates (python 3 iot)
View deleteIoTThingsByTypeOrName.py
import logging
import argparse
import os
import botocore
import json
import boto3
logging.basicConfig(format='%(asctime)s : %(levelname)s : %(message)s', level=logging.INFO)
@altairlage
altairlage / listGithubOrgRepos.py
Last active Feb 28, 2019
List github repos under org creating a .csv file (github enterprise - python 3 - github api
View listGithubOrgRepos.py
import requests
import json
import argparse
import logging
github_api_url = "https://<github URL>/api/v3"
ghe_access_token = 'your github personal access token'
#logging.basicConfig(format='%(asctime)s : %(levelname)s : %(message)s', level=logging.INFO, filename='ghe_org_repo_list.log')
logging.basicConfig(format='%(asctime)s : %(levelname)s : %(message)s', level=logging.INFO)
You can’t perform that action at this time.