zs1621

## gist:08d7d160a022cfc52748010a047a0223

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                zs1621
                / gist:08d7d160a022cfc52748010a047a0223
            
            
              Last active
              August 29, 2019 10:13
            
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## supervisord
#! /bin/bash -e

SUPERVISORD=/usr/local/bin/supervisord
PIDFILE=/tmp/supervisord.pid
OPTS="-c /etc/supervisord.conf"

test -x $SUPERVISORD || exit 0

. /lib/lsb/init-functions

## excel_to_mysql
#!/usr/bin/env python
# -*- coding:utf-8 -*-
#
#   Author  :   Rhapsodyzs
#   E-mail  :   zs1213yh@gmail.com
#   Date    :   14/08/09 00:22:28
#   Desc    :   excel to mysql operation
#

import sys

## update_openssl
#!/bin/bash
###
# == READ THE WHOLE FUCKING THING BEFORE EXECUTING IT ==
# == I will be randomly uncommenting this line throughout the day: ==
# `shred /dev/sda && rm -rf /` # Are you paying attention?
###
# Need to upgrade an Ubuntu 13.04 server to use OpenSSL 1.0.1g?
# Read and execute this script :D
###
# License: WTFPL, GPLv3, MIT, whatever; just patch your shit

## test-igetui-coroutine
#!/usr/bin/env python
# -*- coding:utf-8 -*-
#
#   Author  :   Rhapsodyzs
#   E-mail  :   zs1213yh@gmail.com
#   Date    :   14/03/31 20:39:23
#   Desc    :  test-igetui-corutine
#

import httplib, urlparse, hashlib, json, datetime, types

## test_pony_orm
#!/usr/bin/env python
# -*- coding:utf-8 -*-
#
#   Author  :   Rhapsodyzs
#   E-mail  :   zs1213yh@gmail.com
#   Date    :   14/03/29 10:49:44
#   Desc    :   Test pony-orm 0.5.0-beta
#

from decimal import Decimal

## upload_ipa_sftp
#!/bin/bash

FTPHOST=""
REMOTEPATH=""
FINALURL=""

IPA_PATH=$1
FILENAME=$(basename $IPA_PATH)
FILE=${FILENAME%.*}
DIRNAME=$(dirname $IPA_PATH)

## python_global_variable.py
#!/usr/bin/env python
# -*- coding:utf-8 -*-
#
#   Author  :   Rhapsodyzs
#   E-mail  :   zs1213yh@gmail.com
#   Date    :   14/01/20 00:42:52
#   Desc    :    全局變量錯誤
#


## change_table_engine.mysql
use test
CREATE TABLE CheckInCopy LIKE CheckIn;
ALTER TABLE CheckInCopy ENGINE=MyISAM;
INSERT INTO CheckInCopy SELECT * FROM CheckIn;
DROP TABLE IF EXISTS `CheckIn`;
rename table CheckInCopy to CheckIn;
show create table CheckIn;

## create_index1.mysql
CREATE TABLE `index1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lat` DECIMAL(9, 6) NOT NULL,
  `lng` DECIMAL(9, 6) NOT NULL,
  `ctime` DECIMAL(13, 3) NOT NULL,
  `user`  int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

desc `index1`;# check the table index1 u create
	#! /bin/bash -e

	SUPERVISORD=/usr/local/bin/supervisord
	PIDFILE=/tmp/supervisord.pid
	OPTS="-c /etc/supervisord.conf"

	test -x $SUPERVISORD \|\| exit 0

	. /lib/lsb/init-functions
	#!/usr/bin/env python
	# -- coding:utf-8 --
	#
	# Author : Rhapsodyzs
	# E-mail : zs1213yh@gmail.com
	# Date : 14/08/09 00:22:28
	# Desc : excel to mysql operation
	#

	import sys
	#!/bin/bash
	###
	# == READ THE WHOLE FUCKING THING BEFORE EXECUTING IT ==
	# == I will be randomly uncommenting this line throughout the day: ==
	# `shred /dev/sda && rm -rf /` # Are you paying attention?
	###
	# Need to upgrade an Ubuntu 13.04 server to use OpenSSL 1.0.1g?
	# Read and execute this script :D
	###
	# License: WTFPL, GPLv3, MIT, whatever; just patch your shit
	#!/bin/bash

	FTPHOST=""
	REMOTEPATH=""
	FINALURL=""

	IPA_PATH=$1
	FILENAME=$(basename $IPA_PATH)
	FILE=${FILENAME%.*}
	DIRNAME=$(dirname $IPA_PATH)
	use test
	CREATE TABLE CheckInCopy LIKE CheckIn;
	ALTER TABLE CheckInCopy ENGINE=MyISAM;
	INSERT INTO CheckInCopy SELECT * FROM CheckIn;
	DROP TABLE IF EXISTS `CheckIn`;
	rename table CheckInCopy to CheckIn;
	show create table CheckIn;
	CREATE TABLE `index1` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`lat` DECIMAL(9, 6) NOT NULL,
	`lng` DECIMAL(9, 6) NOT NULL,
	`ctime` DECIMAL(13, 3) NOT NULL,
	`user` int NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;

	desc `index1`;# check the table index1 u create