Harshakvarma

We are implementing database dumping which is straightforward but can be tedious to setup. Here's our setup:

1. Create AWS user for db backups (e.g. db-backups-{{app}})
   • Save credentials in a secure location
   • If adding db scrubbing, use a separate user (e.g db-scrubs-{{app}})
2. Create bucket for S3 access logging (e.g. s3-access-log-{{app}})
3. Create consistently named bucket for db dumps (e.g. db-backups-{{app}})
   • Enable logging to s3-access-log-{{app}} with prefix of db-backups-{{app}}
4. Add IAM policy for bucket access

• Select user -> Choose "Add inline policy"

Harshakvarma

I got it working
```python
import base64
import urllib.request
import ssl

try:
    import json
except ImportError:
    import simplejson as json

Harshakvarma

import os
import time
import logging
from datetime import datetime

#logs
logger = logging.getLogger(__name__)
logger.setLevel(logging.INFO)

# create a file handler

Harshakvarma

import os
import time
import logging
from datetime import datetime

#logs
logger = logging.getLogger(__name__)
logger.setLevel(logging.INFO)

# create a file handler

Harshakvarma

Sample crontab

https://crontab.guru/ - online crontab generator

1. Empty temp folder every Friday at 5pm

# ┌───────────── minute (0 - 59)
# │ ┌───────────── hour (0 - 23)
# │ │ ┌───────────── day of month (1 - 31)
# │ │ │ ┌───────────── month (1 - 12)
# │ │ │ │ ┌───────────── day of week (0 - 6) (Sunday to Saturday;

Harshakvarma

Archwomen.ics file

BEGIN:VCALENDAR
PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
VERSION:2.0
BEGIN:VEVENT
CREATED:20170220T182458Z
LAST-MODIFIED:20170220T182458Z
DTSTAMP:20170220T182458Z

Harshakvarma

const USER = require("../../src/db/userDB");
const moment = require("moment");
const Sequelize = require('sequelize');
const config = require("config");
const plaid  = require('plaid');
const util   = require('util');
const pe = require('parse-error');

var PLAID_CLIENT_ID  = config.get("plaidCred.PLAID_CLIENT_ID");
var PLAID_SECRET     = config.get("plaidCred.PLAID_SECRET");

Harshakvarma

const USER = require("../../src/db/userDB");
const moment = require("moment");
const Sequelize = require('sequelize');
const config = require("config");
const plaid  = require('plaid');
const util   = require('util');
const pe = require('parse-error');

var PLAID_CLIENT_ID  = config.get("plaidCred.PLAID_CLIENT_ID");
var PLAID_SECRET     = config.get("plaidCred.PLAID_SECRET");

Harshakvarma

const USER = require("../../src/db/userDB");
const moment = require("moment");
const Sequelize = require('sequelize');
const config = require("config");
const plaid  = require('plaid');
const util   = require('util');
const pe = require('parse-error');

var PLAID_CLIENT_ID  = config.get("plaidCred.PLAID_CLIENT_ID");
var PLAID_SECRET     = config.get("plaidCred.PLAID_SECRET");

Harshakvarma

{
  "editor.fontFamily": "FiraCode-Retina",
  "editor.fontLigatures": true,
  "terminal.integrated.shell.osx": "/bin/zsh",
  "workbench.activityBar.visible": true,
  "window.zoomLevel": 0,
  "[typescript]": {
    "editor.defaultFormatter": "vscode.typescript-language-features"
  },
  "workbench.editor.showTabs": true,