구차니의 잡동사니 모음

mysql> desc archlog_useraccount;l

+----------------+-------------+------+-----+---------+----------------+

| Field          | Type        | Null | Key | Default | Extra          |

+----------------+-------------+------+-----+---------+----------------+

| idx            | int(11)     | NO   | PRI | NULL    | auto_increment |

| time_create    | datetime    | NO   |     | NULL    |                |

| time_lastlogin | datetime    | NO   |     | NULL    |                |

| time_lastmodi  | datetime    | NO   |     | NULL    |                |

| userid         | char(50)    | NO   |     | NULL    |                |

| passwd         | char(72)    | NO   |     | NULL    |                |

| passwd_plain   | char(12)    | NO   |     | NULL    |                |

| username       | varchar(30) | NO   |     | NULL    |                |

| birth          | datetime    | NO   |     | NULL    |                |

+----------------+-------------+------+-----+---------+----------------+

9 rows in set (0.01 sec)

CREATE TABLE IF NOT EXISTS `archlog_useraccount` (

`idx` int(11) NOT NULL,

  `time_create` datetime NOT NULL,

  `time_lastlogin` datetime NOT NULL,

  `time_lastmodi` datetime NOT NULL,

  `userid` char(50) NOT NULL,

  `passwd` char(72) NOT NULL,

  `passwd_plain` char(12) NOT NULL,

  `username` varchar(30) NOT NULL,

  `birth` datetime NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='user account table';

ALTER TABLE `archlog_useraccount`

 ADD PRIMARY KEY (`idx`), ADD UNIQUE KEY `idx` (`idx`,`userid`);

ALTER TABLE `archlog_useraccount`

MODIFY `idx` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

CREATE TABLE animals (

    grp ENUM('fish','mammal','bird') NOT NULL,

    id MEDIUMINT NOT NULL AUTO_INCREMENT,

    name CHAR(30) NOT NULL,

    PRIMARY KEY (grp,id)

) ENGINE=MyISAM; 

The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC. 

export LC_ALL=en_US.utf8

export LANG=en_US.utf8

$ cat mailer.py

#!/usr/bin/python

# -*- coding:utf-8 -*-

import smtplib

import sys

import os

from email.mime.multipart import MIMEMultipart

from email.MIMEText import MIMEText

from subprocess import Popen, PIPE

smtp_hostname="smtp.mailserver.com:port"

smtp_username="mailer@mailserver.com"

smtp_password="password"

toaddrs  = ['user1@mailserver.com','user2@mailserver.com','user2@mailserver.com']

project_name = os.path.basename(sys.argv[1])

subject = "["+project_name+"]"+" svn repository update required"

content = project_name + "\n" + "rev : " + sys.argv[2]+ "\n"

cmd_1 = ['svnlook','changed','-r',sys.argv[2],sys.argv[1]]

proc = Popen(cmd_1, stdout=PIPE)

difflist = proc.stdout.read()

cmd_2 = ['svnlook','info','-r',sys.argv[2],sys.argv[1]]

proc = Popen(cmd_2, stdout=PIPE)

svninfo = proc.stdout.read()

content = "[" + project_name + "]\n" + "rev : " + sys.argv[2]+ "\n" + difflist +"\n" + svninfo

msg = MIMEMultipart()

msg['From'] = smtp_username

msg['To'] = ", ".join(toaddrs)

msg['Subject'] = subject

msg.attach(MIMEText(content,_charset='utf-8'))

print msg.as_string()

server = smtplib.SMTP_SSL(smtp_hostname)

server.login(smtp_username,smtp_password)

server.sendmail(smtp_username, toaddrs, msg.as_string())

server.quit()