#!/usr/bin/env python
# -*- encoding: utf-8 -*-
'''
@Contact :   liuyuqi.gov@msn.cn
@Time    :   2023/02/26 13:12:22
@License :   Copyright © 2017-2022 liuyuqi. All Rights Reserved.
@Desc    :   根据list.txt生成执行sql，然后导入sqlite实现批量导入系统
前期检测list.txt各行是否有效，并维护这个列表
'''

import os,sys,re

# 最新的id
initId=65

def gen(id:int, url:str):
    '''生成sql'''
    mount_path= url.split("//")[1].split(":")[0]
    print("-----------------"+mount_path)
    sql = "INSERT INTO \"main\".\"x_storages\" (\"id\", \"mount_path\", \"order\", \"driver\", \"cache_expiration\", \"status\", \"addition\", \"remark\", \"modified\", \"disabled\", \"order_by\", \"order_direction\", \"extract_folder\", \"web_proxy\", \"webdav_policy\", \"down_proxy_url\") VALUES (%s, '/NetDriverA/%s', 0, 'AList V3', 30, 'work', '{\"root_folder_path\":\"/\",\"url\":\"%s\",\"password\":\"\",\"access_token\":\"\"}', '%s', '2023-02-26 20:47:36.498219296+08:00', 0, '', '', '', 0, '302_redirect', '');"
    sql=sql % (id, mount_path, url, url)
    sql=sql.replace(r'\"','"')
    with open('result.sql','a+',encoding='utf-8') as file:
        file.write(sql+"\r\n")
    
if __name__=='__main__':
    with open('list.txt','r',encoding='utf-8') as file:
        lines = file.readlines()
        for line in lines:
            gen(initId, line)
            initId=initId+1
            # break
        print("最后更新id为："+str(initId))