Category: Life

#!/usr/bin/env python
#-*- coding:utf-8 -*-
#author: jpuyy.com date
#modified by xx at date
#import time
#from dateutil import tz

from datetime import datetime, timedelta, tzinfo

class GMT8(tzinfo):
    delta = timedelta(hours=8)
    def utcoffset(self, dt):
        return self.delta
    def tzname(self, dt):
        return "GMT+8"
    def dst(self, dt):
        return self.delta

class GMT(tzinfo):
    delta = timedelta(0)
    def utcoffset(self, dt):
        return self.delta
    def tzname(self, dt):
        return "GMT+0"
    def dst(self, dt):
        return self.delta

a = "2014-12-13T10:42:28.000Z"
from_tzinfo = GMT()
local_tzinfo = GMT8()

gmt_time = datetime.strptime(a, '%Y-%m-%dT%H:%M:%S.%fZ')
gmt_time = gmt_time.replace(tzinfo=from_tzinfo)
local_time = gmt_time.astimezone(local_tzinfo)

print gmt_time
print local_time

获得 0 或 1

Math.floor(Math.random() * 2)

身份证打印   100%视图下   宽85.6mm   高54mm

语法检查

–syntax-check

列出执行的任务

–list-tasks

在 monitor 字段后添加 object_id 字段

alter table `url_monitor` add column object_id int not null default 0 after `monitor`;

字段名搞错，现在更改字段名，把 extr 改为 extra

alter table project_name change extr extra varchar(30);

更改字段的类型

alter table project_name modify extra varchar(10);

删除字段

alter table `my_crontable` drop `expression`;

    // connect to database
    include("conectar.php");

    $fp = fopen('exporterrors.csv', 'w');

    $queryString = "SELECT * FROM url_monitor where monitor='off' order by object_id";
    $rows = mysql_query($queryString);

    while ($row = mysql_fetch_assoc($rows)) {
        fputcsv($fp, $row);
    }

    fclose($fp);