DatePicker Widget using ipywidgets in Google Colab for SQLite query

Example: Using DatePicker in Google Colab

import ipywidgets as widgets
from IPython.display import display, clear_output

dp = widgets.DatePicker(
    description='Pick a Date',
    disabled=False
)

output_date_picker = widgets.Output()

def on_date_change(change):
    with output_date_picker:
        clear_output()
        if change['name'] == 'value' and change['new'] is not None:
            print("Selected Date: ", change['new'])

dp.observe(on_date_change, names='value')

display(dp, output_date_picker)

Downlaod Data in CSV file

!wget -O dt_table.csv https://www.plus2net.com/sql_tutorial/dt_table.php

• Downloads a CSV file named dt_table.csv from the URL.
• -O tells wget to save it with the specified filename.

Creating Pandas DataFrame

import pandas as pd  
df=pd.read_csv('dt_table.csv')  # use your system path if different
print(df.head())

• Loads the CSV file dt_table.csv into a DataFrame by using read_csv().
• Displays the first 5 rows for preview.

Create SQLite database using the DataFrame

import sqlite3

# Name of the table within the SQLite database
table_name = 'dt_table'

# Create an SQLite database connection
my_conn = sqlite3.connect('my_db.db')

# Write the DataFrame to an SQLite table
df.to_sql(table_name, my_conn, if_exists='replace', index=False)

# Close the connection
my_conn.close()

Get 5 records from SQLite Database

import sqlite3
my_path='my_db.db' # Change the path of your database

try:
    my_conn = sqlite3.connect(my_path) # connect to the database
except sqlite3.Error as my_error:
  print("error: ",my_error)
else:
    print("Connected to database successfully")

try:
    query="SELECT * FROM dt_table LIMIT 0,5" # SQL to get first 5 rows
    r_set=my_conn.execute(query)  # execute the query
    for row in r_set:
        print(row)    # Print each row
except sqlite3.Error as my_error:
  print("error: ",my_error)

Get the record of current date ( today )

try:
    query="SELECT * FROM dt_table WHERE `date`=date('now')" # select rows where date is today
    r_set = my_conn.execute(query)  # execute the query
    for row in r_set:
        print(row)    # print each matching row
except sqlite3.Error as my_error:
    print("error: ", my_error)

Integrating Datepicker for selection of Date

import ipywidgets as widgets
from IPython.display import display
import sqlite3
from datetime import datetime

Path the Database.

my_path = 'my_db.db'

Function to get data from Single selection of data

def get_records_by_single_date(date_str):
    my_conn = None
    try:
        my_conn = sqlite3.connect('my_db.db')
        cursor = my_conn.cursor()
        query = "SELECT * FROM dt_table WHERE date = ?"
        cursor.execute(query, (date_str,))
        records = cursor.fetchall()

        if records:
            print(f"Records for date {date_str}:")
            for row in records:
                print(row)
        else:
            print(f"No records found for date {date_str}.")

    except sqlite3.Error as my_error:
        print(f"Database error: {my_error}")
    finally:
        if my_conn:
            my_conn.close()
            print("Database connection closed.")

• Step 1: Define the function get_records_by_single_date(date_str) to accept a date string as input.
• Step 2: Initialize the database connection variable my_conn to None.
• Step 3: Use sqlite3.connect() to connect to the database file 'my_db.db'.
• Step 4: Create a cursor object using my_conn.cursor() to execute SQL queries.
• Step 5: Define a parameterized SQL query to fetch records from the table dt_table where the date matches the given value.
• Step 6: Execute the query using cursor.execute() and pass the date value as a parameter.
• Step 7: Fetch all matching records using fetchall().
• Step 8: If records are found, print them using a loop; otherwise, display a message indicating no records were found.
• Step 9: Handle any database errors using except block and display the error message.
• Step 10: Use finally block to ensure the database connection is closed, whether an error occurred or not.

To display the datepicker ( single )

single_date_picker = widgets.DatePicker(
    description='Select Date',
    disabled=False,
    value=datetime.now().date()
)

output_single_date = widgets.Output()

def on_date_change_single(change):
    with output_single_date:
        output_single_date.clear_output()
        if change['name'] == 'value' and change['new'] is not None:
            selected_date = change['new'].strftime('%Y-%m-%d')
            get_records_by_single_date(selected_date)

single_date_picker.observe(on_date_change_single, names='value')

display(single_date_picker, output_single_date)

Records from a range of date ( two datepickers )

def get_records_by_date_range(start_date_str, end_date_str):
    my_conn = None
    try:
        my_conn = sqlite3.connect('my_db.db')
        cursor = my_conn.cursor()
        query = "SELECT * FROM dt_table WHERE date BETWEEN ? AND ?"
        cursor.execute(query, (start_date_str, end_date_str))
        records = cursor.fetchall()

        if records:
            print(f"Records from {start_date_str} to {end_date_str}:")
            for row in records:
                print(row)
        else:
            print(f"No records found between {start_date_str} and {end_date_str}.")

    except sqlite3.Error as my_error:
        print(f"Database error: {my_error}")
    finally:
        if my_conn:
            my_conn.close()
            print("Database connection closed.")

start_date_picker = widgets.DatePicker(
    description='Start Date',
    disabled=False,
    value=datetime.now().date()
)

end_date_picker = widgets.DatePicker(
    description='End Date',
    disabled=False,
    value=datetime.now().date()
)

query_button = widgets.Button(description="Query Records")
output_date_range = widgets.Output()

def on_button_click(b):
    with output_date_range:
        output_date_range.clear_output()
        start_date = start_date_picker.value
        end_date = end_date_picker.value
        if start_date and end_date:
            get_records_by_date_range(start_date.strftime('%Y-%m-%d'), end_date.strftime('%Y-%m-%d'))
        else:
            print("Please select both start and end dates.")

query_button.on_click(on_button_click)

display(start_date_picker, end_date_picker, query_button, output_date_range)

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

← Subscribe to our YouTube Channel here