RSSFeeds Database Project

This project provides scripts and a database for querying and managing RSS feed information using Python and SQLite.

---

Prerequisites

• Python 3.7+ (comes with sqlite3 module)
• SQLite (for direct DB inspection, optional)

---

SQLite Installation

Windows

1. Download the SQLite tools zip for Windows.
2. Extract the contents to a folder (e.g., C:\sqlite).
3. Add the folder to your system PATH (optional, for command-line access).

Linux

sudo apt update
sudo apt install sqlite3

---

Setting Up the Python Virtual Environment

1. Open a terminal or command prompt in the project directory.

2. Create a virtual environment:

   python -m venv env

3. Activate the environment:

   • Windows (PowerShell):

     .\env\Scripts\Activate.ps1

   • Windows (cmd):

     .\env\Scripts\activate.bat

   • Linux/macOS:

     source env/bin/activate

4. Install dependencies (No Current Requirements):

   pip install -r requirements.txt

   Note: The built-in sqlite3 module does not need to be installed.

---

How to Execute the Python Script

1. Make sure your virtual environment is activated.

2. Run the desired script. For example:

   python SearchDB.py

   or

   python Query_All_Records.py

3. The script will connect to the SQLite database and output the results to the console.

---

Specifying Variables for Filtering

You can specify filter variables (such as subscription, catdesc, name, or id) by editing the script directly in the if __name__ == "__main__": section.
For example, in SearchDB.py:

# Query the database with optional parameters:
if __name__ == "__main__":
    # Get the directory where this script is located
    base_dir = Path(__file__).parent

    # Build paths relative to the script location
    db_path = base_dir / 'rssfeeds.db'
    sql_path = base_dir / 'SearchDB.sql'

    # Parameters for the search
    subscription = ''
    catdesc = ''
    name = ''
    id = None

    try:
        DBresults = searchDB(db_path, sql_path, subscription, catdesc, name, id)
        print(DBresults)
    except Exception as e:
        print(f"Error: {e}")

# Total number of records returned
    print(f"\033[92mRecord Count: {len(DBresults)}\033[0m")

Tip:

• Leave a variable as an empty string ('') or None if you do not want to filter by that field.
• You can combine filters as needed.

---

(Optional) Using Command-Line Arguments

If you want to allow users to specify filters from the command line, you can add argument parsing with the argparse module.
Example usage (after modifying the script):

python SearchDB.py --subscription No --catdesc News --name Fox --id 10

---

Notes

• You can modify the SQL queries in SearchDB.sql file to change what data is returned.
• Update the script parameters to filter results as needed.

---

License

MIT License