JunChao imchao9

## proc_demo.proc
DELIMITER ;;
CREATE DEFINER=`root`@`%` PROCEDURE `proc_update`(in type int,in start int,in end int)
begin
set @start=start;
set @end=end;
while @start<@end
do
update tbl_material set file_type = type where id = @start;
set @start=@start+1;
end while;

## deletefile.sh
#! /bin/bash
lessonId=(1 2 3 4 5 6 7 8 9 10)
for id in ${lessonId[*]};
do
    find ./$id -type f  -not \( -name 'challenge.html' -or -name 'receive.html' -or -name 'reward.html' -or -name 'story.html' -or -name 'task.html'  \) -delete
    find . -type d  -not \( -name 'challenge' -or -name 'receive' -or -name 'reward' -or -name 'story' -or -name 'task'  \) -delete
    zip -r $id.zip $id
done

find . -type d  \( -name 'libs' -o -name 'node_modules'  \) -exec rm -rf {} \;

## qiniu_refresh_cache.sh
#! /bin/bash
read lesson
./qshell_darwin_amd64 listbucket [bucket name] $lesson/ filelist.log
egrep -o  '.*\.(png|jpg|js|mp4|an|html)' filelist.log > test.txt
sed 's/^/http:\/\/7xq5ra.com2.z0.glb.qiniucdn.com\/&/g' test.txt > refresh.log
./qshell_darwin_amd64 batchrefresh refresh.log

## wechat_ua
Mozilla/5.0wechat MicroMessenger (iPhone; CPU iPhone OS 7_0 like Mac OS X; en-us) AppleWebKit/537.51.1 (KHTML, like Gecko) Version/7.0 Mobile/11A465 Safari/9537.53

## gist:847072e5cb60b0526776
    function uploadUserAvatar() {
      var cdnUploadUrl = "http://up.qiniu.com";
      getToken(uploadFile);
    }

  function getToken(callback) {
    $.ajax({
      url: apiServer+'/program/cdn/upload/token',
      type:"get",
      success: function(data) {

## rdelete.sh
find . -name .DS_Store -exec rm -rf {} \;

## mongodb
var startTime = Date.parse(new Date("2016 02-01"))/1000;
var endTime = Date.parse(new Date("2016 02-16"))/1000;

db.getCollection('sqllogs').find(
{$and:[{"create_time":{$lt:endTime}},{"create_time":{$gt:startTime}},
{"content":/update.*praise_times.*35167.*/i}]}).sort({"create_time":1})

## mysql
      create_time时间格式

        SELECT DATE_FORMAT(create_time,'%Y%u') weeks,COUNT(id) COUNT FROM role GROUP BY weeks;

        SELECT DATE_FORMAT(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days;
        SELECT DATE_FORMAT(create_time,'%Y%m') months,COUNT(id) COUNT FROM role GROUP BY months


        create_time时间戳格式

## nodejs
process.on('uncaughtException', function(err) {
  //do something
  fs.appendFile("E:\\Work\\codemao\\code\\node\\electron-x32\\resources\\1.txt", err.stack, function(err1){
  });
});

## command
taskkill /F /im frontpg.exe
	DELIMITER ;;
	CREATE DEFINER=`root`@`%` PROCEDURE `proc_update`(in type int,in start int,in end int)
	begin
	set @start=start;
	set @end=end;
	while @start<@end
	do
	update tbl_material set file_type = type where id = @start;
	set @start=@start+1;
	end while;
	#! /bin/bash
	lessonId=(1 2 3 4 5 6 7 8 9 10)
	for id in ${lessonId[*]};
	do
	find ./$id -type f -not \( -name 'challenge.html' -or -name 'receive.html' -or -name 'reward.html' -or -name 'story.html' -or -name 'task.html' \) -delete
	find . -type d -not \( -name 'challenge' -or -name 'receive' -or -name 'reward' -or -name 'story' -or -name 'task' \) -delete
	zip -r $id.zip $id
	done

	find . -type d \( -name 'libs' -o -name 'node_modules' \) -exec rm -rf {} \;
	#! /bin/bash
	read lesson
	./qshell_darwin_amd64 listbucket [bucket name] $lesson/ filelist.log
	egrep -o '.*\.(png\|jpg\|js\|mp4\|an\|html)' filelist.log > test.txt
	sed 's/^/http:\/\/7xq5ra.com2.z0.glb.qiniucdn.com\/&/g' test.txt > refresh.log
	./qshell_darwin_amd64 batchrefresh refresh.log
	function uploadUserAvatar() {
	var cdnUploadUrl = "http://up.qiniu.com";
	getToken(uploadFile);
	}

	function getToken(callback) {
	$.ajax({
	url: apiServer+'/program/cdn/upload/token',
	type:"get",
	success: function(data) {
	var startTime = Date.parse(new Date("2016 02-01"))/1000;
	var endTime = Date.parse(new Date("2016 02-16"))/1000;

	db.getCollection('sqllogs').find(
	{$and:[{"create_time":{$lt:endTime}},{"create_time":{$gt:startTime}},
	{"content":/update.praise_times.35167.*/i}]}).sort({"create_time":1})
	create_time时间格式

	SELECT DATE_FORMAT(create_time,'%Y%u') weeks,COUNT(id) COUNT FROM role GROUP BY weeks;

	SELECT DATE_FORMAT(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days;
	SELECT DATE_FORMAT(create_time,'%Y%m') months,COUNT(id) COUNT FROM role GROUP BY months


	create_time时间戳格式
	process.on('uncaughtException', function(err) {
	//do something
	fs.appendFile("E:\\Work\\codemao\\code\\node\\electron-x32\\resources\\1.txt", err.stack, function(err1){
	});
	});