短域名生成源码

import string
import random
import sqlite3

# 初始化数据库
conn = sqlite3.connect('short_urls.db')
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS url_mappings (short_url TEXT PRIMARY KEY, long_url TEXT)''')
conn.commit()

# 短域名字符集
CHARSET = string.ascii_letters + string.digits

def generate_short_url():
    while True:
        short_url = ''.join(random.choice(CHARSET) for _ in range(6))
        c.execute('SELECT * FROM url_mappings WHERE short_url = ?', (short_url,))
        if not c.fetchone():
            return short_url

def store_mapping(short_url, long_url):
    c.execute('INSERT INTO url_mappings (short_url, long_url) VALUES (?, ?)', (short_url, long_url))
    conn.commit()

# 示例使用
long_url = 'https://www.example.com/very/long/url'
short_url = generate_short_url()
store_mapping(short_url, long_url)
print(f'Short URL for {long_url} is {short_url}')