ofelix03

CREATE TABLE person(
	id SERIAL PRIMARY KEY,
	name VARCHAR,
	gender VARCHAR,
	age INTEGER
)

ofelix03

CREATE TABLE contact(
	id SERIAL PRIMARY KEY,
	phone_number VARCHAR,
	street_address VARCHAR,
	person_id INTEGER,
	CONSTRAINT fk_person
      FOREIGN KEY(person_id) 
	  REFERENCES contact(id)
)

ofelix03

--- seed person table with sample data from person.csv
COPY person(id, name, gender, age)
FROM '/path/to/person.csv'
DELIMITER ','
CSV HEADER;

--- seed contact table with sample data from contact.csv
COPY contact(id, phone_number, street_address, person_id)
FROM '/path/to/contact.csv'
DELIMITER ','

ofelix03

ofelix03

ofelix03

ofelix03

import hashlib

plaintext = "hello".encode()
d = hashlib.sha256(plaintext)

# generate binary hash of "hello" string
hash = d.digest()
print(hash)

# generate human readable hash of "hello" string

ofelix03

import hashlib

plaintext = "hello".encode()

# instantiate sha3_256 object
d = hashlib.sha3_256(plaintext)

# generate binary bash of "hello" string
hash = d.digest()
print(hash)

ofelix03

ofelix03

import os
import hashlib

salt = os.urandom(32)
plaintext = 'hellow0rld'.encode()

digest = hashlib.pbkdf2_hmac('sha256', plaintext, salt, 10000)

hex_hash = digest.hex()
print(hex_hash)