Maksim Gramin mgramin

SQL educational plan

0. Setup environment

Topics:

What is DBeaver (GUI tool for working with databases)?

Tasks:

Install DBeaver Community

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

Loading variables from .env files in Ansible

Ansible has various ways of looking up data from outside sources, including plain text password files, CSV files and INI files. But it doesn't seem to have a lookup for .env files, as used in Laravel projects, also available for PHP, Ruby, Node.js, Python and others.

One option is to launch Ansible with the Ruby dotenv command line script... But that requires Ruby, which seems like overkill to me.

So here is a simpler solution that I use. It consists of:

The .env file itself
A small shell script that loads the .env file into environment variables - ansible-playbook.sh

This file contains the review of the codebase as it was on 01.10.2017:

Project: https://github.com/mgramin/sql-boot

Language: Java

Main Contributor: https://www.github.com/mgramin

CLOC (cloc . on the root directory):

	#!/usr/bin/env python
	# an example how to use Faker to create fake data and inject them
	# in a mysql database

	import time
	import os

	import mysql.connector
	from mysql.connector import Error
	from faker import Faker

	from flask import Flask
	from flask_restful import Api, Resource, reqparse

	app = Flask(__name__)
	api = Api(app)

	users = [
	{
	"name": "Nicholas",
	"age": 42,

	---
	- name: Install docker
	gather_facts: No
	hosts: default

	tasks:
	- name: Install yum utils
	yum:
	name: yum-utils
	state: latest

	/*
	* DataGrip extension to export results to markdown.
	* The markdown table format is supported by Github and Jira. I haven't tested others.
	*
	* Tested on DataGrip 2016.2.2
	* - Open the File view. View -> Tool Windows -> Files
	* - Activate the "Scratches" tab. You should see "Files", "Scopes", and "Scratches".
	* - Copy this file to Extensions/Database Tools and SQL/data/extractors/Markdown.JavaScript.md.js
	* - Run a query with some results.
	* - Change the export format to Markdown.JavaScript.md.js and click "To Clipboard".

	import com.intellij.database.model.DasTable
	import com.intellij.database.model.ObjectKind
	import com.intellij.database.util.Case
	import com.intellij.database.util.DasUtil

	SEPARATOR = ","
	QUOTE = "\""
	NEWLINE = System.getProperty("line.separator")
	SEPARATOR = File.separator
	SPACING = " "

	SELECT LOWER(SUBSTR(COLUMN_NAME,0,1)) \|\| SUBSTR(REPLACE(INITCAP(COLUMN_NAME),'_',''),2)
	FROM ALL_TAB_COLS
	WHERE TABLE_NAME = 'ADC_DL_MODEL'
	;

	--from : HELLO_WORLD
	--to : helloWorld