IamSmith

<?php
require_once("PHPExcel/PHPExcel.php");
$phpExcel = new PHPExcel();

$styleArray = array(
	'font' => array(
		'bold' => true,
	)
);

c0ldlimit

import StringIO
from flask import Flask, Response


@app.route('/some_dataframe.csv')
def output_dataframe_csv():
    
    output = StringIO.StringIO()
    some_dataframe.to_csv(output)

niksumeiko

#!/bin/bash
# Sometimes you need to move your existing git repository
# to a new remote repository (/new remote origin).
# Here are a simple and quick steps that does exactly this.
#
# Let's assume we call "old repo" the repository you wish
# to move, and "new repo" the one you wish to move to.
#
### Step 1. Make sure you have a local copy of all "old repo"
### branches and tags.

hootlex

##Windows users:

• Download wamp: http://www.wampserver.com/en/
• Download and extract cmder mini: https://github.com/cmderdev/cmder/releases/download/v1.1.4.1/cmder_mini.zip
• Update windows environment variable path to point to your php install folder (inside wamp installation dir) (here is how you can do this http://stackoverflow.com/questions/17727436/how-to-properly-set-php-environment-variable-to-run-commands-in-git-bash)

cmder will be refered as console

##Mac Os, Ubuntu and windows users continue here:

• Create a database locally named homestead utf8_general_ci

spalladino

# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

jeremycg

from twython import Twython
import csv
twitter = Twython(APP_KEY, APP_SECRET,
                  OAUTH_TOKEN, OAUTH_TOKEN_SECRET)
                  
followers = twitter.get_followers_list(screen_name = "yourusername", count = 200)
following = twitter.get_friends_ids(screen_name = "yourusername")
with open("twitter.csv", 'w', newline='') as csvfile:
    writer = csv.writer(csvfile, delimiter=',')
    writer.writerow(["name", "tweets", "following", "followers", "I'm following"])

oanhnn

Problem

I have two Github accounts: oanhnn (personal) and superman (for work). I want to use both accounts on same computer (without typing password everytime, when doing git push or pull).

Solution

Use ssh keys and define host aliases in ssh config file (each alias for an account).

How to?

1. Generate ssh key pairs for accounts and add them to GitHub accounts.

dasdachs

#!/usr/bin/env python
from io import TextIOWrapper
import csv

from flask import Flask, request, redirect, url_for
from flask_sqlalchemy import SQLAlchemy


# Create Flaskk app, config the db and load the db object
# http://flask-sqlalchemy.pocoo.org/2.1/quickstart/#a-minimal-application

devdrops

Mysqldump from Docker container

docker exec -i mysql_container mysqldump -uroot -proot --databases database_name --skip-comments > /path/to/my/dump.sql

OBS

• This will generate a dump.sql file in your host machine. Awesome, eh?
• Avoid using --compact on your dump. This will make MySQL check your constraints which will cause troubles when reading your file (damm you MySQL). And don't use --force to fix this scenario: recreate your dump without --compact ¯_(ツ)_/¯

debashisbarman

sudo iptables -t nat -L
sudo iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-ports 8000