dimitrisdovinos’s gists

dimitrisdovinos / encrypt.rb

Created February 25, 2020 19:25

	require 'openssl'
	require 'base64'

	aes = OpenSSL::Cipher.new("AES-256-CBC")
	aes.encrypt
	aes.key = Base64.decode64("4VZS/oCY73fTENgF8LyLq00B+bsXEHLlAFpRhoDXTKc=")
	aes.iv = OpenSSL::Cipher.new("AES-256-CBC").random_iv

	cipher = aes.update("I'm scared if I stop all at once, the cumulative hangover will literally kill me.")
	cipher << aes.final

dimitrisdovinos / encrypted_details.csv

Last active February 22, 2020 16:09

id	Name	Bank Account Number	Blood type
1	hRsNNqk5KF6v3TJjoijW8BNGjrX4yGtaIaZD6cvm94Vt45nlaW0O7moiVWQ/pDac	5giriyTJzntm/sp7gSaBN5Wm8NUb+tv2THu6xkRRJgM=	TxQhCITXuitXKKkJ9RuKfQe87+wV8j+0SqSarU/kaKk=
2	Rz48IlQ0OeDpdLkdj+W7h5jTRyTs048HMqhpwGoKTsA=	mFRg/48E67WksVV8MoY2zbR/fWcLiXRODuV3ALXCo10=	TxQhCITXuitXKKkJ9RuKfQe87+wV8j+0SqSarU/kaKk=

dimitrisdovinos / unencrypted_bank_details.csv

Last active February 20, 2020 07:27

dimitrisdovinos / glue-data-schema.json

Created April 14, 2019 08:50

dimitrisdovinos / glue-sample-data-csv.txt

Last active April 13, 2019 16:33

	id,name,host_id,host_name,neighbourhood_group,neighbourhood,latitude,longitude,room_type,price,minimum_nights,number_of_reviews,last_review,reviews_per_month,calculated_host_listings_count,availability_365
	10595,"96m2, 3BR, 2BA, Metro, WI-FI etc...",37177,Emmanouil,,ΑΜΠΕΛΟΚΗΠΟΙ,37.98887924384334,23.764314563525055,Entire home/apt,71,1,17,2019-01-12,0.18,8,294
	10988,"75m2, 2-br, metro, wi-fi, cable TV",37177,Emmanouil,,ΑΜΠΕΛΟΚΗΠΟΙ,37.988434261427905,23.763446602200577,Entire home/apt,82,1,31,2017-11-23,0.40,8,0
	10990,"50m2, Metro, WI-FI, cableTV, more",37177,Emmanouil,,ΑΜΠΕΛΟΚΗΠΟΙ,37.98783415721626,23.76478728692748,Entire home/apt,47,1,27,2019-02-01,0.35,8,282
	10993,"Studio, metro, cable tv, wi-fi, etc",37177,Emmanouil,,ΑΜΠΕΛΟΚΗΠΟΙ,37.98860728307634,23.76422238412952,Entire home/apt,37,1,42,2019-02-02,0.54,8,286
	...

dimitrisdovinos / TextField.js

Created April 5, 2019 09:54

	<TextField
	error={errors.email && touched.email}
	label="email"
	name="email"
	className={classes.textField}
	value={values.email}
	onChange={handleChange}
	onBlur={handleBlur}
	helperText={(errors.email && touched.email) && errors.email}
	margin="normal"

dimitrisdovinos / formik-material-example.js

Last active May 8, 2020 14:03

	import React, { useState } from 'react';
	import { withStyles } from '@material-ui/core/styles';
	import TextField from '@material-ui/core/TextField';
	import Button from '@material-ui/core/Button';
	import Dialog from '@material-ui/core/Dialog';
	import DialogActions from '@material-ui/core/DialogActions';
	import DialogContent from '@material-ui/core/DialogContent';
	import DialogContentText from '@material-ui/core/DialogContentText';
	import DialogTitle from '@material-ui/core/DialogTitle';
	import axios from 'axios';

dimitrisdovinos / insert-into-final-table.sql

Created April 1, 2019 13:27

	insert into sales select nextval('sales_id_seq'), customer_first_name, customer_last_name, item_name, item_qty, total_spent
	from t_data;

dimitrisdovinos / extract last name.sql

Created April 1, 2019 13:20

update t_data set customer_last_name = split_part(customer, ' ', 2);

dimitrisdovinos / extract first and last name.sql

Created April 1, 2019 13:15

update t_data set customer_first_name = split_part(customer,' ',1) ;

Dimitris dimitrisdovinos