timmy 修订了这个 Gist 9 months ago. 转到此修订
4 files changed, 42 insertions
generate_multiple_uuids.py(文件已创建)
| @@ -0,0 +1,6 @@ | |||
| 1 | + | from uuid import uuid4 | |
| 2 | + | ||
| 3 | + | # 產生 5 個唯一識別碼 | |
| 4 | + | uuids = [uuid4() for _ in range(5)] | |
| 5 | + | for i, uid in enumerate(uuids, start=1): | |
| 6 | + | print(f"UUID {i}: {uid}") | |
generate_uuid4.py(文件已创建)
| @@ -0,0 +1,7 @@ | |||
| 1 | + | from uuid import uuid4 | |
| 2 | + | ||
| 3 | + | # 產生 UUID4 | |
| 4 | + | unique_id = uuid4() | |
| 5 | + | ||
| 6 | + | print(f"UUID4: {unique_id}") | |
| 7 | + | print(f"UUID4(字串格式): {str(unique_id)}") | |
sqlite_uuid_example.py(文件已创建)
| @@ -0,0 +1,24 @@ | |||
| 1 | + | import sqlite3 | |
| 2 | + | from uuid import uuid4 | |
| 3 | + | ||
| 4 | + | # 建立 SQLite 連線 | |
| 5 | + | conn = sqlite3.connect(":memory:") | |
| 6 | + | cursor = conn.cursor() | |
| 7 | + | ||
| 8 | + | # 建立帶有 UUID 的表 | |
| 9 | + | cursor.execute(""" | |
| 10 | + | CREATE TABLE users ( | |
| 11 | + | id TEXT PRIMARY KEY, | |
| 12 | + | name TEXT | |
| 13 | + | ) | |
| 14 | + | """) | |
| 15 | + | ||
| 16 | + | # 插入一筆帶有 UUID 的資料 | |
| 17 | + | user_id = str(uuid4()) | |
| 18 | + | cursor.execute("INSERT INTO users (id, name) VALUES (?, ?)", (user_id, "Alice")) | |
| 19 | + | ||
| 20 | + | # 查詢結果 | |
| 21 | + | cursor.execute("SELECT * FROM users") | |
| 22 | + | print(cursor.fetchall()) | |
| 23 | + | ||
| 24 | + | conn.close() | |
uuid_short_format.py(文件已创建)
| @@ -0,0 +1,5 @@ | |||
| 1 | + | from uuid import uuid4 | |
| 2 | + | ||
| 3 | + | unique_id = uuid4() | |
| 4 | + | short_id = unique_id.hex # 轉換為 32 字符的十六進位字串 | |
| 5 | + | print(f"短格式 UUID: {short_id}") | |