Skip to content

Instantly share code, notes, and snippets.

View jrodl3r's full-sized avatar

John Rodler jrodl3r

View GitHub Profile
@jrodl3r
jrodl3r / seed.ts
Created November 1, 2019 20:56
ElasticSearch - Seed Firebase Data
const admin = require('firebase-admin');
const faker = require('faker');
const serviceAccount = require('../tmp/serviceAccountKey.json');
admin.initializeApp({
credential: admin.credential.cert(serviceAccount)
});
const db = admin.firestore();
@jrodl3r
jrodl3r / serviceAccountKey.json
Created November 1, 2019 22:59
ElasticSearch - Firebase Admin Tools Service Key
{
"type": "service_account",
"project_id": "project_id",
"private_key_id": "private_key_id",
"private_key": "private_key",
"client_email": "client_email",
"client_id": "client_id",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
@jrodl3r
jrodl3r / index.js
Created February 10, 2020 23:35
DynamoDB2Excel
'use strict'
var AWS = require('aws-sdk');
var S3 = new AWS.S3();
var excel = require('excel4node');
var workbook = new excel.Workbook();
var worksheet = workbook.addWorksheet('Sheet 1');
exports.handler = (event, context, callback) => {
var docClient = new AWS.DynamoDB.DocumentClient({ region: 'us-east-2' });
var params = { TableName: 'Users' };
@jrodl3r
jrodl3r / index.js
Created February 12, 2020 03:03
DynamoDB2ExcelMailer
'use strict'
var AWS = require('aws-sdk');
var S3 = new AWS.S3();
var SES = new AWS.SES({region: 'us-east-1'});
var nodemailer = require('nodemailer');
var excel = require('excel4node');
var workbook = new excel.Workbook();
var worksheet = workbook.addWorksheet('Sheet 1');
exports.handler = (event, context, callback) => {