Python 官方文档:入门教程 => 点击学习
#!/usr/bin/env python import timefrom datetime import datetimeimport calendarimport Mysqldbimport sys class GetDayMonth
#!/usr/bin/env python
import time
from datetime import datetime
import calendar
import Mysqldb
import sys
class GetDayMonth(object):
def getLastDayOfLastMonth(self,step):
d = datetime.now()
year = d.year
month = d.month
if month == 1:
month = 12
year -= 1
else:
month -= step
days = calendar.monthrange(year, month)[1]
return datetime(year, month, days).strftime('%Y-%m-%d')
def getFirstDayOfLastMonth(self,step):
d = datetime.now()
year = d.year
month = d.month
if month == 1:
month = 12
year -= 1
else:
month -= step
return datetime(year, month, 1).strftime('%Y-%m-%d')
def getLastMonth(self,step):
d = datetime.now()
year = d.year
month = d.month
if month == 1:
month = 12
year -= 1
else:
month -= step
return datetime(year, month, 1).strftime('%Y%m')
class mysqlExe(object):
def init(self,host,port,user,passwd,db,charset='utf8'):
try:
self.conn = Mysqldb.connect(host,user,passwd,db,int(port))
except MySQLdb.Error as e:
errORMsg = 'Cannot connect to server\nERROR(%s):%s' % (e.args[0],e.args[1])
print errormsg
exit(2)
self.cursor = self.conn.cursor()
def Creat_table(self,sql):
try:
self.cursor.execute(sql)
self.conn.commit()
except:
self.conn.rollback()
print "sql execute error"
exit(2)
def __del__(self):
self.conn.close()
self.cursor.close()
if name == 'main':
d = GetDayMonth()
table_name = sys.argv[1]
first_day_month = d.getFirstDayOfLastMonth(1)
last_day_month = d.getLastDayOfLastMonth(1)
last_3Day_month = d.getLastDayOfLastMonth(3)
last_month = d.getLastMonth(1)
mysql_exec = MysqlExe('127.0.0.1',3306,'root','XXXX','guanba_data')
sql_create = "create table guanba_data.%s_%s like guanba_data.%s"%(table_name,last_month,table_name)
sql_insert = "insert into guanba_data.%s_%s select * from guanba_data.%s where create_time >= unix_timestamp('%s 00:00:00') and create_time <= unix_timestamp('%s 23:59:59')"%(table_name,last_month,table_name,first_day_month,last_day_month)
sql_del = "delete from guanba_data.%s where create_time <= unix_timestamp('%s 23:59:59')"%(table_name,last_3day_month)
mysql_exec.Creat_table(sql_create)
mysql_exec.Creat_table(sql_insert)
mysql_exec.Creat_table(sql_del)
--结束END--
本文标题: python按月分表
本文链接: https://www.lsjlt.com/news/185163.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
一口价域名售卖能注册吗?域名是网站的标识,简短且易于记忆,为在线用户提供了访问我们网站的简单路径。一口价是在域名交易中一种常见的模式,而这种通常是针对已经被注册的域名转售给其他人的一种方式。
一口价域名买卖的过程通常包括以下几个步骤:
1.寻找:买家需要在域名售卖平台上找到心仪的一口价域名。平台通常会为每个可售的域名提供详细的描述,包括价格、年龄、流
443px" 443px) https://www.west.cn/docs/wp-content/uploads/2024/04/SEO图片294.jpg https://www.west.cn/docs/wp-content/uploads/2024/04/SEO图片294-768x413.jpg 域名售卖 域名一口价售卖 游戏音频 赋值/切片 框架优势 评估指南 项目规模
0