xexi’s gists

xexi / js extract file ext

Last active July 31, 2017 07:59

js extract file ext

xexi / extract YMD from different date format

Last active July 20, 2017 01:22

extract YMD from different date format

	//var date1 = '20170602110357';
	//var date2 = '2016-05-13 04:06:10'
	//var date3 = '2014-02-27T22:00:00.000Z'
	//var date4 = '2016/03/22 23:11:06'

	function escapeRegExp(s) {
	return s.replace(/([.*+?^=!:${}()\|\[\]\/\\])/g, "\\$1");
	}

	function replaceAll(s, find, replace) {

xexi / checkNested.js

Created July 18, 2017 06:41

javascript-test-for-existence-of-nested-object-key

	function checkNested(obj /, level1, level2, ... levelN/) {
	var args = Array.prototype.slice.call(arguments, 1);

	for (var i = 0; i < args.length; i++) {
	if (!obj \|\| !obj.hasOwnProperty(args[i])) {
	return false;
	}
	obj = obj[args[i]];
	}
	return true;

xexi / mongo_shell_distinct

Last active July 18, 2017 06:42

mongo_shell_distinct

	db.collection.aggregate( [
	{ $match: { 'dept': "service", 'condition': '0' } },
	{ $group: { _id: { first: "$distinct_col1", second: "$distinct_col1" }, // distinct option
	id_tag : { $min: "$tag" }, // projection
	count: { $sum:1 } // group count
	}
	},
	{ $sort: { '_.id.regdate': 1 }}, // make sure sort by group id // 1 asc
	{ $skip: 0 },
	{ $limit: 5 },

xexi / node_mongo_find_like

Created February 9, 2017 05:57

	db.collection('my_collection').find( { 'findData': 'MorefindOption',
	$or : [
	{ 'name' : { $regex: 'searchWord' , $options: 'ix' } },
	{ 'adress' : { $regex: 'searchWord' , $options: 'ix' } }
	] })


	// more option available at google search -> mongodb regex option
	// -> in mongo cli { name : /.searchWord./i }

xexi / js_num_desc_arr

Created February 6, 2017 05:37

	var n = 5;
	var nn = [n];
	for (var i = 1; i < 5; i++) {
	nn.push(nn[0] - i);
	}
	console.log(JSON.stringify(nn));

xexi / mongo_find_max_field

Created February 3, 2017 07:00

db.collection.find({ "findData": "blabla" }).sort({"orderData": -1}).limit(1)

xexi / node_mongo_find_exists_field

Created February 2, 2017 08:43

db.collection('myCollection').find( { 'findData': { $exists: true } }).toArray( (err, results) => {});

xexi / js how to check empty in an array?

Last active February 2, 2017 08:28

	var arr = [];

	// for any falsy value (0, "", NaN, null, undefined, or of course, false):

	if (!myarray[0]){
	// isEmpty
	} else {
	// notEmpty
	}

xexi / node_mongo_bulk_find_n_upsert

Created February 2, 2017 07:49

	let bulk = db.collection('myCollection').initializeOrderedBulkOp();

	for(let i=0; i < arr.length; i++){
	bulk.find( {findData: arr[i]} ).upsert().updateOne(
	{
	$set: { modData: 'yolo' }
	}
	);
	}

synth xexi