python复制表1000个

关注

原创最新推荐文章于 2025-07-03 14:17:42 发布 2k 阅读 AI 写同款· GEO 优化 ›

AI权益加码！Claude Code、Cursor等20+工具免费用！购周边限时加赠Coding Plan Lite，畅享主流AI工具！学习进阶更高效！阅读详情

#!/usr/bin/python
# -*- coding: utf-8 -*-

import sqlite3
import os
import datetime


server_root_path = os.path.dirname(os.path.abspath(__file__))

#server_root_path = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

class ConnSql(object):
    def __init__(self, db_path=r'{}'.format(server_root_path), db_name='test'):
        self.db_path = '{}/{}.db'.format(db_path, db_name)
        print(server_root_path, self.db_path )
        self.cxn = None
        self.cur = None
    def __del__(self):
        print ('__del__ called')
    def conn_db(self):
        self.cxn = sqlite3.connect(self.db_path)
        self.cur = self.cxn.cursor()
        print('connect ok!')

    def close_db(self):
        if self.cxn and self.cur:
            self.cur.close()
            self.cxn.close()
            print('close ok!')

    def create_table(self, create_teble_sql):
        self.cur.execute(create_teble_sql)

    def search_info(self, search_sql):
        # get_info = self.cur.execute('''
        #         select * from users
        #     ''')
        get_info = self.cur.execute(search_sql)
        print(get_info)
        return get_info
    def update_info(self, update_sql):
        # self.cur.execute('''
        #         insert into users (name) values ('test_name1')
        #     ''')
        self.cur.execute(update_sql)
        self.cxn.commit()
        print('update info ok!')






def sql_main():
    sql_obj = ConnSql(db_name="auxdb100w")
    sql_obj.conn_db()

    in_date = '2015-01-01'
    for i in range(1,1000):
	dt = datetime.datetime.strptime(in_date, "%Y-%m-%d")
	out_date = (dt + datetime.timedelta(days=i)).strftime("%Y%m%d")
	print(out_date)
	sql='''insert into t_date (directory) values ('%s')''' % (out_date)
        print sql
        sql_obj.update_info(update_sql=sql)
        sql='''create table t_%s as select * from t_x''' % (out_date)
        print sql
        info = sql_obj.search_info(search_sql=sql)


    sql_obj.close_db()
    del sql_obj

if __name__ == '__main__':
    sql_main()