41 lines
1.0 KiB
Bash
Executable File
41 lines
1.0 KiB
Bash
Executable File
#!/bin/bash
|
|
|
|
# Get the directory where the script is located
|
|
SCRIPT_DIR=$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)
|
|
|
|
# Define the database file path in the script's directory
|
|
DB_PATH="$SCRIPT_DIR/test.db"
|
|
|
|
# Execute the SQL commands using sqlite3
|
|
sqlite3 "$DB_PATH" <<EOF
|
|
CREATE TABLE IF NOT EXISTS products (
|
|
id INTEGER PRIMARY KEY,
|
|
name TEXT,
|
|
price REAL
|
|
);
|
|
|
|
INSERT INTO products (name, price) VALUES
|
|
('Widget', 19.99),
|
|
('Gadget', 29.99),
|
|
('Gizmo', 39.99),
|
|
('Smart Watch', 199.99),
|
|
('Wireless Earbuds', 89.99),
|
|
('Portable Charger', 24.99),
|
|
('Bluetooth Speaker', 79.99),
|
|
('Phone Stand', 15.99),
|
|
('Laptop Sleeve', 34.99),
|
|
('Mini Drone', 299.99),
|
|
('LED Desk Lamp', 45.99),
|
|
('Keyboard', 129.99),
|
|
('Mouse Pad', 12.99),
|
|
('USB Hub', 49.99),
|
|
('Webcam', 69.99),
|
|
('Screen Protector', 9.99),
|
|
('Travel Adapter', 27.99),
|
|
('Gaming Headset', 159.99),
|
|
('Fitness Tracker', 119.99),
|
|
('Portable SSD', 179.99);
|
|
EOF
|
|
|
|
echo "Database setup complete. Products table created and data inserted in $DB_PATH."
|