chrisarusso

html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,input,select,textarea,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{margin:0px;padding:0px;border:0px;outline:0px;font-size:100%;vertical-align:baseline;background:transparent;line-height:inherit;}ol,ul,ul,ul li{list-style:none;}blockquote,q{quotes:none;}blockquote:before,blockquote:after,q:before,q:after{content:'';content:none;}:focus{outline:0px;}ins{text-decoration:none;}del{text-decoration:line-through;}table{border-collapse:collapse;border-spacing:0px;}input,select,textarea,body{font:13px/20px "Helvetica Neue",Helvetica,Arial,sans-serif;}

#blocks td.region{font-weight:bold;}#blocks tr.region-message{font-weight:normal;color:#999;}#blocks tr.region-populated{display:none;}div#edit-openid-identifier-wrapper{display:block;}html.js #user-login-form div#edit-openid-identif

chrisarusso

mysql> select ttd.tid Term_ID, tv.name AS Vocabulary, ttd.name as Term_Name from taxonomy_term_data ttd, taxonomy_vocabulary tv where tv.vid = ttd.vid and ttd.name in (select name from taxonomy_term_data ttd2 group by name having count(*) > 1) order by Term_Name;
+---------+-----------------------+-----------------------------------------+
| Term_ID | Vocabulary            | Term_Name                               |
+---------+-----------------------+-----------------------------------------+
|     601 | Article Tags          | Antitrust                               |
|     451 | Professional Practice | Antitrust                               |
|    1036 | Sectors               | Capital Markets                         |
|     214 | Professional Practice | Capital Markets                         |
|     456 | Sectors               | Consumer Discretionary                  |

chrisarusso

mysql> select tv.name as Vocab, ttd.name as Term_name, ti.nid from taxonomy_vocabulary tv, taxonomy_term_hierarchy tth, taxonomy_term_data ttd, taxonomy_index ti where ti.tid = ttd.tid and ttd.tid = tth.tid and tv.vid = ttd.vid and tth.parent = 0 and tv.vid = 11;
+---------+----------------------------+------+
| Vocab   | Term_name                  | nid  |
+---------+----------------------------+------+
| Sectors | Consumer Discretionary     | 1436 |
| Sectors | Consumer Staples           | 1436 |
| Sectors | Energy                     | 1436 |
| Sectors | Financials                 | 1436 |
| Sectors | Health Care                | 1436 |
| Sectors | Industrials                | 1436 |

chrisarusso

<?php


$db_url = 'mysql://root@localhost/mitpress';
ini_set('memory_limit', '256M');
$conf['preprocess_css'] = $conf['preprocess_js'] = 0;

chrisarusso

<?php

$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'cognet',
      'username' => '',
      'password' => '',

chrisarusso

drush sql-dump --result-file

`drush sql-connect` < /whatever_the_result_file_is.sql


root@li117-183:/home/deploy/escp/prod/drupalroot# drush sql-connect
mysql --database=prod_compostpedallers_com --host=localhost --user=prod_user --password='t33p33b3mad!'
root@li117-183:/home/deploy/escp/prod/drupalroot# mysql --database=prod_compostpedallers_com --host=localhost --user=prod_user --password='t33p33b3mad!' < wgatevsf.sl^C

rsync files from prod to dev. remove the -n to allow it to actually happen

chrisarusso

ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAxcD34AvOB4E0wjeD8eUV3gmAkvLhII83YamJa/AGDOTAmnCRrxw/ZFJIYfZX+UHddJ5HEMT+fMj1s3Oh4oppO/1Eluaxl5k+UlW+QYyt1T642hruRxgGuIhN6E0PhZ1mM9veaied9PDhCAD3WSsEXaKuarkvYxEVYb3oPYN18KWzRYq3r6VWdoy8ZHm8pxKSB/wH9TkglQEEWNLaelylwyh5k4hXkEwf0OhALpfXgWFjvSqjDqKh9GplTSfM/FU29Bb6rZDflwFaOAu9EjDfFKrfb4KxZQNAUijXacuniOmVfh7+97GR/9U58IeC0szg+6HNpaalY3HR6mdYkKSapw== chris@chris-laptop

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCz2CitZuFHxo6pgYNTIgxwaKQqOAVdd4emwtOqbNt6OA/di/6+zQ5KdojtAFp3D3jomXOkM6rlHCVYnDtZcjIorwx5Ls0qJPZ2PVVZOdoVmd2qZz54RsUGPRGWIPzzI0xGgmjNJdvP8uWrFzoMAIPY+SSCgIXFEip+Ki532vkq3KenHcsoXC9ymg7bhMUbLb4mVthxGh8RxdLAK4sKeEaayZgbeDRmfObhq1d/mfccoudenWL2vpLWG5UgcBJdZwkcaFUUQhmSL8prWsKSoV+TQ8+G511HUeoRGNlV0ZAndJt6pi3nJ7Ft5/TI/6ySvhAnOWvvmfcwDyntwTiDuhGD [email protected]

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDR6LTMDPlImct6GtNf4pX0lb9JrwJ0Y9/5leOi1DkO6J4h5dAMRZbG92wE2HNBxNX7z10MGMKZvHB6U/L6UjTF3Wyn73BQVc8LiMxVXKoxail5nMYJASHBuoU3m3m8stAWIGhtoDSth7k9ym6WMY/IySOhyvBnOcS27SH8TVXI2nWf9FDl65

chrisarusso

<html>
<head>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.css"/>
<script src="http://cdn.leafletjs.com/leaflet-0.7.3/leaflet.js"></script>
<script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
<script src="leaflet-providers.js"></script>
</head>
<body>
<div id="map" style="width: 100%; height: 300px;"></div>
<script type="text/javascript">

chrisarusso

MacBook-Pro:durhamatletico.github.io chris$ _scripts/build.sh 
_scripts/build.sh: line 5: csvgrep: command not found
_scripts/build.sh: line 5: csv2json: command not found
_scripts/build.sh: line 7: csvgrep: command not found
_scripts/build.sh: line 7: csv2json: command not found
_scripts/build.sh: line 9: csvgrep: command not found
_scripts/build.sh: line 9: csv2json: command not found
_scripts/build.sh: line 11: csvgrep: command not found
_scripts/build.sh: line 11: csv2json: command not found
Traceback (most recent call last):

chrisarusso

MacBook-Pro:durhamatletico.github.io chris$ pip install csvkit --user
You are using pip version 7.0.3, however version 7.1.0 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
Collecting csvkit
  Downloading csvkit-0.9.1.tar.gz
Collecting xlrd>=0.7.1 (from csvkit)
  Downloading xlrd-0.9.4.tar.gz (322kB)
    100% |████████████████████████████████| 323kB 215kB/s 
Collecting sqlalchemy>=0.6.6 (from csvkit)
  Downloading SQLAlchemy-1.0.8.tar.gz (4.6MB)