def get_categories(db):

    cursor = db.execute("""
        SELECT name
        FROM categories
        ORDER BY name
    """)

    return [row[0] for row in cursor.fetchall()]
    
def add_category(db, name):

    db.execute("""
        INSERT OR IGNORE INTO categories (name)
        VALUES (?)
    """, (name,))

    db.commit() 
    
def rename_category_db(db, old_name, new_name):

    db.execute("""
        UPDATE categories
        SET name = ?
        WHERE name = ?
    """, (new_name, old_name))

    db.execute("""
        UPDATE ideas
        SET category = ?
        WHERE category = ?
    """, (new_name, old_name))

    db.commit()
    
def delete_category_db(db, name):

    cursor = db.execute("""
        SELECT COUNT(*)
        FROM ideas
        WHERE category = ?
    """, (name,))

    count = cursor.fetchone()[0]

    if count > 0:
        return False, count

    db.execute("""
        DELETE FROM categories
        WHERE name = ?
    """, (name,))

    db.commit()

    return True, 0
