Python操作PDF檔案合併提取加密解密

CREATE TABLE IF NOT EXISTS meals (name TEXT) STRICT
CREATE TABLE IF NOT EXISTS ingredients (name TEXT, meal_id INTEGER, FOREIGN KEY(meal_id) REFERENCES meals(rowid)) STRICT

import pypdf
reader = pypdf.PdfReader('Recursion_Chapter1.pdf')
print(len(reader.pages))  # 輸出：18

import pypdf

PDF_FILENAME = 'Recursion_Chapter1.pdf'
TEXT_FILENAME = 'recursion.txt'

text = ''
try:
    reader = pypdf.PdfReader(PDF_FILENAME)
    for page in reader.pages:
        text += page.extract_text()
except Exception as e:
    print(f"Error: {e}")
    import pdfminer.high_level
    text = pdfminer.high_level.extract_text(PDF_FILENAME)

with open(TEXT_FILENAME, 'w') as f:
    f.write(text)

pip install PyPDF2

import PyPDF2

pdf_file = 'example.pdf'
pdf_reader = PyPDF2.PdfReader(pdf_file)

text = ''
for page in pdf_reader.pages:
    text += page.extract_text()

with open('extracted_text.txt', 'w') as f:
    f.write(text)

with open('cleaned_text.txt', 'w') as f:
    f.write(cleaned_text)

import PyPDF2

pdf_file = 'example.pdf'
pdf_reader = PyPDF2.PdfReader(pdf_file)

image_num = 0
for page in pdf_reader.pages:
    for image in page.images:
        with open(f'{image_num}_page{page.page_number}_{image.name}', 'wb') as f:
            f.write(image.data)
        image_num += 1

import pypdf

# 開啟 PDF 檔案
with open('example.pdf', 'rb') as file:
    pdf = pypdf.PdfReader(file)

# 迭代每個頁面
for i, page in enumerate(pdf.pages):
    # 迭代每個圖片
    for image in page.images:
        # 儲存圖片
        with open(f'{i}_{image.name}', 'wb') as image_file:
            image_file.write(image.data)

import pypdf

# 建立新 PDF 檔案
writer = pypdf.PdfWriter()

# 追加頁面
writer.append('example.pdf', (0, 5))

# 儲存 PDF 檔案
with open('new_pdf.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立新 PDF 檔案
writer = pypdf.PdfWriter()

# 追加頁面
writer.append('example1.pdf', (0, 5))
writer.append('example2.pdf', (0, 3))

# 儲存 PDF 檔案
with open('merged_pdf.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立新 PDF 檔案
writer = pypdf.PdfWriter()

# 追加頁面
writer.append('example.pdf', (0, 5), rotate=90)

# 儲存 PDF 檔案
with open('cropped_pdf.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立新 PDF 檔案
writer = pypdf.PdfWriter()

# 追加頁面
writer.append('example.pdf', (0, 5), scale=0.5)

# 儲存 PDF 檔案
with open('transformed_pdf.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfWriter 物件
writer = pypdf.PdfWriter()

# 將多個 PDF 檔案合併成一個檔案
writer.append('file1.pdf')
writer.append('file2.pdf')
writer.append('file3.pdf')

# 將合併後的檔案儲存到新的 PDF 檔案中
with open('output.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfWriter 物件
writer = pypdf.PdfWriter()

# 將一個 PDF 檔案新增到 writer 中
writer.append('file.pdf')

# 在第 3 頁插入空白頁
writer.insert_blank_page(2)

# 在檔案末尾新增空白頁
writer.add_blank_page()

# 將修改後的檔案儲存到新的 PDF 檔案中
with open('output.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfWriter 物件
writer = pypdf.PdfWriter()

# 將一個 PDF 檔案新增到 writer 中
writer.append('file.pdf')

# 旋轉所有頁面 90 度
for i in range(len(writer.pages)):
    writer.pages[i].rotate(90)

# 將修改後的檔案儲存到新的 PDF 檔案中
with open('output.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfWriter 物件
writer = pypdf.PdfWriter()

# 將多個 PDF 檔案合併成一個檔案
writer.append('file1.pdf')
writer.append('file2.pdf')

# 旋轉所有頁面 90 度
for i in range(len(writer.pages)):
    writer.pages[i].rotate(90)

# 將合併和旋轉後的檔案儲存到新的 PDF 檔案中
with open('output.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfWriter 物件
writer = pypdf.PdfWriter()

# 附加一個 PDF 檔案到 PdfWriter 物件中
writer.append('Recursion_Chapter1.pdf')

# 在 PDF 檔案的末尾新增一個空白頁
writer.add_blank_page()

# 在頁面索引 2 處插入一個空白頁
writer.insert_blank_page(index=2)

# 將 PdfWriter 物件儲存到一個新的 PDF 檔案中
with open('with_blanks.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfWriter 物件
writer = pypdf.PdfWriter()

# 附加一個 PDF 檔案到 PdfWriter 物件中
writer.append('Recursion_Chapter1.pdf')

# 載入水印 PDF 檔案
watermark_page = pypdf.PdfReader('watermark.pdf')

# 將水印應用到每個頁面中
for page in writer.pages:
    page.merge_page(watermark_page, over=False)

# 將 PdfWriter 物件儲存到一個新的 PDF 檔案中
with open('with_watermark.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfWriter 物件
writer = pypdf.PdfWriter()

# 附加一個 PDF 檔案
writer.append('example.pdf')

# 加密 PDF 檔案
writer.encrypt('swordfish', algorithm='AES-256')

# 將加密的 PDF 檔案寫入一個新檔案
with open('encrypted.pdf', 'wb') as file:
    writer.write(file)

import pypdf

# 建立一個 PdfReader 物件
reader = pypdf.PdfReader('encrypted.pdf')

# 檢查檔案是否已經加密
if reader.is_encrypted:
    # 嘗試解密檔案
    if reader.decrypt('swordfish'):
        print("File decrypted successfully.")
    else:
        print("Failed to decrypt file.")
else:
    print("File is not encrypted.")

import pypdf
import os

# 取得當前工作目錄中的所有PDF檔案
pdf_filenames = [filename for filename in os.listdir('.') if filename.endswith('.pdf')]

# 對PDF檔名進行排序
pdf_filenames.sort(key=str.lower)

# 建立一個PdfWriter物件來儲存輸出PDF
writer = pypdf.PdfWriter()

# 迴圈遍歷每個PDF檔案
for filename in pdf_filenames:
    # 建立一個PdfReader物件來讀取當前PDF檔案
    pdf_reader = pypdf.PdfReader(filename)
    
    # 複製除第一頁以外的所有頁面到輸出PDF中
    for page_num in range(1, len(pdf_reader.pages)):
        writer.add_page(pdf_reader.pages[page_num])

# 將輸出PDF儲存到檔案中
with open('combined.pdf', 'wb') as file:
    writer.write(file)

import sqlite3

def check_cat_vaccinations(db_file):
    """檢查貓咪疫苗接種情況並輸出玄貓生日。"""
    try:
        conn = sqlite3.connect(db_file)
        cursor = conn.cursor()

        # 查詢未接種指定疫苗的貓咪
        cursor.execute("""
            SELECT name FROM cats 
            WHERE rabies IS NULL OR FeLV IS NULL OR FVRCP IS NULL
        """)
        unvaccinated_cats = cursor.fetchall()

        if unvaccinated_cats:
            print("未接種疫苗的貓咪：")
            for cat in unvaccinated_cats:
                print(f"- {cat[0]}")
        else:
            print("所有貓咪都已接種疫苗。")

        # 查詢玄貓的生日
        cursor.execute("SELECT birthday FROM cats WHERE name = '玄貓'")
        birthday = cursor.fetchone()

        if birthday:
            print(f"\n玄貓的生日是：{birthday[0]}")
        else:
            print("\n找不到玄貓的生日資訊。")

    except sqlite3.Error as e:
        print(f"資料函式庫錯誤：{e}")
    finally:
        if conn:
            conn.close()

# 使用範例
check_cat_vaccinations('sweigartcats.db')

import sqlite3

def manage_meal_ingredients(db_file):
    """管理餐點和食材資料函式庫。"""
    try:
        conn = sqlite3.connect(db_file)
        cursor = conn.cursor()

        # 建立表格
        cursor.execute("CREATE TABLE IF NOT EXISTS meals (name TEXT UNIQUE) STRICT")
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS ingredients (
                name TEXT, 
                meal_id INTEGER, 
                FOREIGN KEY(meal_id) REFERENCES meals(rowid)
            ) STRICT
        """)
        conn.commit()

        while True:
            user_input = input("> ")
            if user_input.lower() == 'quit':
                break

            if ':' in user_input:
                try:
                    meal_name, ingredients_str = user_input.split(':', 1)
                    ingredients = [ingr.strip() for ingr in ingredients_str.split(',')]

                    # 插入餐點
                    cursor.execute("INSERT INTO meals (name) VALUES (?)", (meal_name,))
                    meal_id = cursor.lastrowid

                    # 插入食材
                    for ingredient in ingredients:
                        cursor.execute("INSERT INTO ingredients (name, meal_id) VALUES (?, ?)", (ingredient, meal_id))
                    conn.commit()
                    print(f"Meal added: {meal_name}")

                except sqlite3.IntegrityError:
                    print(f"Error: Meal '{meal_name}' already exists.")
                except Exception as e:
                    print(f"Error: {e}")

            else:
                # 查詢餐點或食材
                cursor.execute("SELECT rowid FROM meals WHERE name = ?", (user_input,))
                meal_id = cursor.fetchone()

                if meal_id:
                    meal_id = meal_id[0]
                    cursor.execute("SELECT name FROM ingredients WHERE meal_id = ?", (meal_id,))
                    ingredients = cursor.fetchall()
                    print(f"Ingredients of {user_input}:")
                    for ingredient in ingredients:
                        print(f"  * {ingredient[0]}")

                else:
                    cursor.execute("SELECT meal_id FROM ingredients WHERE name = ?", (user_input,))
                    meal_ids = cursor.fetchall()
                    if meal_ids:
                        print(f"Meals that use {user_input}:")
                        for meal_id in meal_ids:
                           meal_id = meal_id[0]
                           cursor.execute("SELECT name FROM meals WHERE rowid = ?", (meal_id,))
                           meal_name = cursor.fetchone()[0]
                           print(f"  * {meal_name}")
                    else:
                         print("Not found in meals or ingredients.")

    except sqlite3.Error as e:
        print(f"資料函式庫錯誤：{e}")
    finally:
        if conn:
            conn.close()

# 使用範例
manage_meal_ingredients('meals.db')