Effortlessly manage SQLite databases with this versatile command-line tool built in Python. Simplify tasks such as creating databases, managing tables, manipulating data, and encrypting/decrypting sql files, all through a user-friendly command line interface.
- Database Creation: Easily create new SQLite database files with a simple command.
- Table Management: Create tables with customizable headers, modify header names, and even remove entire tables.
- Data Manipulation: Add, search, modify, and remove rows of data within tables.
- Database Encryption Encrypt and decrypt SQL database files with password protection.
- User-Friendly Interface: Utilizes the Click library to ensure a smooth and user-friendly command-line experience.
- Flexibility: The tool provides multiple commands to perform different database operations.
- Python (3.6 or higher) installed on your system.
- The click, tabulate and cryptography library. Install it using:
pip install click tabulate cryptography
- Clone this repository:
git clone https://github.com/TechWhizKid/sqlite3dbee.git
- Navigate to the cloned directory:
cd sqlite3dbee-main
- Run the tool:
python sqlite3dbee.py [OPTIONS] [COMMAND] <filename> [ARGS]
Below are the available commands and their usage examples:
Usage: sqlite3dbee.py [OPTIONS] [COMMAND] <filename> [ARGS]
Command-line interface for managing an SQLite database.
Options:
--help Show help message and exit.
Commands:
mkdb Create a new SQLite database file.
adth Create a table with specified headers.
adtd Add a new row of data to the table.
mdth Modify a table header name.
mdtd Modify rows in the table based on criteria.
sctr Search for rows in the table based on criteria.
rmtr Remove rows from the table based on criteria.
rmtc Remove a column from a table in the database.
lkdb Lock the SQLite database with encryption.
ukdb Unlock the SQLite database with decryption.
help Show this message and exit.
xmpl Shows a help message with usage example.
- Create a new SQL database file:
sqlite3dbee.py mkdb database.sql
- Insert new table headers:
sqlite3dbee.py adth database.sql "Name" "Age" "UserName" "UserID"
- Add data to the table:
sqlite3dbee.py adtd database.sql "Name":"Robby Russel" "Age":"25" "UserName":"robby_fr" "UserID":"1029384756"
- Search for data in table:
sqlite3dbee.py sctr database.sql
sqlite3dbee.py sctr database.sql "Age = '26'"
- Remove a row of data from the table:
sqlite3dbee.py rmtr database.sql "UserName = 'robby_fr'"
- Modify table data:
sqlite3dbee.py mdtd database.sql "Age = '25'" "Age = '26'"
- Remove a table column and its data:
sqlite3dbee.py rmtc database.sql "UserName"
- Modify a table header name:
sqlite3dbee.py mdth database.sql "Name" "RealName"
- Lock the database file
sqlite3dbee.py lkdb database.sql "123456" "123456"
- Unlock the database file
sqlite3dbee.py ukdb database.sql "123456"
This project is licensed under the MIT License
Empower your SQLite database management with this intuitive command-line tool. Whether you're a developer or a data enthusiast, this tool simplifies your interactions with SQLite databases.