Skip to content

Instantly share code, notes, and snippets.

View dimitrisdovinos's full-sized avatar

Dimitris dimitrisdovinos

7 followers · 7 following
View GitHub Profile
@dimitrisdovinos
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
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
dimitrisdovinos / unencrypted_bank_details.csv
Last active February 20, 2020 07:27
id Name Bank Account Number Bloot type
1 Dimitris Dovinos 6666666666 -A
2 Archer Sterling 9999999999 B
@dimitrisdovinos
dimitrisdovinos / glue-data-schema.json
Created April 14, 2019 08:50
{
"StorageDescriptor": {
"cols": {
"FieldSchema": [
{
"name": "id",
"type": "bigint",
"comment": ""
},
{
@dimitrisdovinos
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
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
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
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
dimitrisdovinos / extract last name.sql
Created April 1, 2019 13:20
update t_data set customer_last_name = split_part(customer, ' ', 2);
@dimitrisdovinos
dimitrisdovinos / extract first and last name.sql
Created April 1, 2019 13:15
update t_data set customer_first_name = split_part(customer,' ',1) ;