Leo Neto oleoneto

Migrations & Seeding

What are migrations??

Migrations are a way to make database changes or updates, like creating or dropping tables, as well as updating a table with new columns with constraints via generated scripts. We can build these scripts via the command line using knex command line tool.

To learn more about migrations, check out this article on the different types of database migrations!

Creating/Dropping Tables

Libraries and Frameworks

CSS

<!-- Normalize css -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/normalize/7.0.0/normalize.min.css">

<!-- Google Fonts: Source Sans Pro and Open Sans -->

class Friend(models.Model):
    users = models.ManyToManyField(User)
    current_user = models.ForeignKey(User, related_name='owner', null=True)

    @classmethod
    def who_added_user(cls, user):
        users = []
        for friend in cls.objects.all():
 if user in friend.users.all():

	# https://gist.github.com/althonos/6914b896789d3f2078d1e6237642c35c

	[metadata]
	name = {name}
	version = file: {name}/_version.txt
	author = Martin Larralde
	author_email = martin.larralde@embl.de
	url = https://github.com/althonos/{name}
	description = {description}
	long_description = file: README.md

	const API_URL = '...';
	const TIMEOUT = 10; // seconds

	export default (path) => {
	/* global fetch */
	const req = fetch(API_URL + path);

	const timeout = new Promise((resolve, reject) => {
	return setTimeout(() => reject(new Error('request timeout')), TIMEOUT * 1000);
	});

	declare global {
	interface Array<T> {
	groupBy(prop: T): Array<T>;
	}
	}

	if (!Array.prototype.groupBy) {
	Array.prototype.groupBy = (prop: string) => {
	return this.reduce(function(groups, item) {
	const val = item[prop];

	# Configuration assumes use of Let's Encrypt
	# Site is ONLY served through HTTPS.
	# Site is served through .example.com and www.example.com
	# Leo N.

	server {
	listen 443 ssl;
	server_name example.com www.example.com;
	ssl_certificate /etc/letsencrypt/live/example.com/fullchain.pem;
	ssl_certificate_key /etc/letsencrypt/live/example.com/privkey.pem;

	# The MIT License
	# SPDX short identifier: MIT

	# Further resources on the MIT License
	# Copyright 2017 Denis Gladkikh (https://www.outcoldman.com/en/archive/2017/07/19/dbhist/)

	# Permission is hereby granted, free of charge, to any person obtaining a copy
	# of this software and associated documentation files (the "Software"), to deal
	# in the Software without restriction, including without limitation the rights
	# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

	// 🔥 Node 7.6 has async/await! Here is a quick run down on how async/await works

	const axios = require('axios'); // promised based requests - like fetch()

	function getCoffee() {
	return new Promise(resolve => {
	setTimeout(() => resolve('☕'), 2000); // it takes 2 seconds to make coffee
	});
	}

	class InitialMigration < ActiveRecord::Migration[5.0]
	def change
	enable_extension "pgcrypto" unless extension_enabled?("pgcrypto")
	end
	end