willwoodlief

Truncate Table ar_internal_metadata;
Truncate Table friendly_id_slugs;
Truncate Table spree_addresses;
Truncate Table spree_adjustments;
Truncate Table spree_assets;
Truncate Table spree_calculators;
Truncate Table spree_countries;
Truncate Table spree_credit_cards;
Truncate Table spree_customer_returns;
Truncate Table spree_gateways;

willwoodlief

<?php

class JsonHelpers {
    //helper function lifted from the transcription project
    public static function printOkJSONAndDie($phpArray=[]) {
        if (!is_array($phpArray)) {
            $r=[];
            $r['message'] = $phpArray;
            $phpArray = $r;
        }

willwoodlief

<?php


/**
 * @author Will Woodlief
 * @license MIT
 * 
 * General Curl Helper. Its multipurpose. Used it in the transcription project and now improved it
 * @example curl_helper('cnn.com',null,$code)
 *          curl_helper('enri.ch',['var1'=>4],$code)

willwoodlief

<?php
/**
 * @author Will Woodlief
 * @license MIT Licence
 * @link https://gist.github.com/willwoodlief/caeae241fb36bffe470ed77a18958097 for updates and code fixes outside this project
 *
 * This is a general database class I have been using though the years, and has its origin from all over the internet
 *   as well as my improvements.
 *
 * I often use it as a drop in class

willwoodlief

#!/bin/sh -

# this script is from https://gist.github.com/timkuijsten/6067107
# The important part is not to put the password as an argument to the mysql
# commands, i.e. don't use the -p option. Instead use a .my.cnf file in the home
# dir of the user you are running this script as, i.e. /home/records/.my.cnf if running
# as root. Make the file readable for the owner only: chmod 400 /home/records/.my.cnf
# See: http://stackoverflow.com/questions/17829659/securing-backup-credentials-for-mysqldump/17844997#17844997

umask 007