naveentnj/sql_python_parser

# Phone Book Application

This is a simple phone book application implemented in Python. The application provides CRUD (Create, Read, Update, Delete) operations and supports SQL-like querying.

## Features

- **Create:** Add new records to the phone book.
- **Read:** Retrieve records from the phone book with optional filtering.
- **Update:** Not implemented in this version.
- **Delete:** Remove records from the phone book based on a specified condition.

## Usage

1. **Initialize Phone Book:**
   ```python
   phone_book = PhoneBook(data=[
       {"name": "John", "email": "[email protected]", "phone1": "123-456-7890"},
       {"name": "Jane", "email": "[email protected]", "phone1": "555-1212"},
       {"name": "Doe", "email": "[email protected]", "phone1": "987-654-3210", "phone2": "098-765-4321"},
   ])

2. Perform SELECT Operation:

   # Select all records
   phone_book.select()
   
   # Select specific fields with a condition
   phone_book.select(fields="name, email", condition="name='Doe'")

3. Insert a New Record:

   phone_book.insert("Test", "[email protected]", "123-456-7890", "")

4. Delete Records:

   # Delete records based on a condition
   phone_book.delete(condition="name='John'")

5. View Updated Phone Book:

   phone_book.select()

Running the Examples

To run the provided examples, execute the script using a Python interpreter:

python your_script_name.py

Requirements

• Python 3.x