nanusdad

Inserting data into mongo collection from JSON file

var file = cat('./20-new.json');  # file name
use testdb                        # db name
var o = JSON.parse(file);         # convert string to JSON
db.forms.insert(o)                # collection name

Inserting data using 'meteor mongo' into collection from JSON file

nanusdad

1. Save Excel worksheet as .csv file

• might need to change new line characters
• if saving on Mac - open in vi and run %s/^M/\r/g ( ctrl+M )

2. Use the following example to load in CSV file from mysql prompt -

    load data infile '/tmp/tc_t.csv' 
    into table new_test_categories 
 fields terminated by ',' 

nanusdad

cd ~/build-output-directory/android/

jarsigner -verbose -sigalg SHA1withRSA -digestalg SHA1 unaligned.apk your-app-name

$ANDROID_HOME/build-tools/23.0.0/zipalign 4 unaligned.apk production.apk

# To unsign APK
zip -d yourapp.apk "META-INF*"

# Creating keystore and then signing app for Play Store

nanusdad

Export to CSV from MySQL

SELECT * FROM books INTO OUTFILE '/tmp/books.csv'  
FIELDS TERMINATED BY ','  
ENCLOSED BY '"'  
LINES TERMINATED BY '\n'

Note fields in books table

DESC books;

nanusdad

function callToEngine(argument) {
    var Future = Npm.require('fibers/future');

    var fut = new Future();


    ///do stuff

    engine.on('close', function(code)
            {

nanusdad

• From - https://github.com/Kunena/Kunena-Forum/wiki/Create-a-new-branch-with-git-and-manage-branches

git checkout -b [name_of_your_new_branch]

• Push the branch on github :

git push origin [name_of_your_new_branch]

• When you want to commit something in your branch, be sure to be in your branch.

nanusdad

Using Git to manage Meteor app code

meteor create app
cd app
git init
git remote add origin PATH/TO/REPO
git fetch
git checkout -t origin/master

nanusdad

• Install svnserve server in newbox
• Check working directory is fully checked-in at oldbox to subversion, and back it up.
• Dump the subversion repository. This is done with an svnadmin command: at oldbox svnadmin dump /export/svnrepo/reponame | gzip -9 - > reponame.dump.gz
• Create the new subversion repository ---- at newbox To create a repository ‘newrepo’ run the svnadmin create command from $SVNHOME/bin. Provide fullpath to the repository at newbox. svnadmin create /export/svnrepo/newrepo .
• Copy the reponame.dump.gz file up to the newbox server.
• Load the dumpfile into the new repository: at newbox zcat reponame.dump.gz | svnadmin load /export/svnrepo/newrepo

nanusdad

sudo apt-get update  
sudo apt-get install apache2
sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql
sudo mysql_install_db
sudo /usr/bin/mysql_secure_installation
sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt

sudo vi /etc/apache2/mods-enabled/dir.conf 
	#add index.php to start of line

nanusdad

var fs = require('fs');
var express = require('express');

var securityOptions = {
	key: fs.readFileSync('/certs/domain.com.key'),
	cert: fs.readFileSync('/certs/domain.com.chained.crt'),
	requestCert: true
};

// .......................................................