import pandas as pd
#import sqlite3
import pymysql

# 連接資料庫
#conn = sqlite3.connect("/var/lib/mysql/textbook3.db")
conn = pymysql.connect(
    host = "localhost",
    user = "gourmand",
    password = "yummy5!",
    database = "textbook3"
) 
#cursor = conn.cursor() 
#cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
projects = pd.read_sql_query("SELECT * FROM project_v2 WHERE delete_timestamp IS NULL", conn)
#print(cursor.fetchall())
print(projects)