inpsPyPI Package Documentation
A PyPI package for Python 3.10+ that provides useful tools for data conversion and validation, a custom EasySQL class for simplified SQLite operations, a custom excel file handler, and a custom file IO handler.
Select a module to begin
Email validation, PH mobile phone checking, string character checks, and socket connectivity.
Simplified SQLite database helper with dictionary-based CRUD operations.
Read and write Excel sheet columns across single or all workbook sheets.
bake
Utility builder function to structure dictionary responses for Flask jsonify payloads.
Functions
Wraps input data into a {"response_data": message} dictionary.
Usage Example
from inpsPyPI import bake
response = bake("Operation successful")
# {'response_data': 'Operation successful'}
Check
Utility class for email address validation, mobile number checks, string content evaluation, and network connection testing.
Methods
Checks if a string is a valid Philippine mobile number starting with 09, +639, or 639.
Evaluates whether string contains digits, symbols, or whitespace characters.
Attempts socket connection to Google DNS (8.8.8.8) to verify internet connectivity.
Check.Email
Validates emails against domain lists using partial split matching or full domain matching.
from inpsPyPI import Check
Check.Email.add_valid_domain_name("gmail")
Check.Email.add_valid_domain_extension("com")
is_valid = Check.Email.is_valid("[email protected]") # True
Cipher
Class providing classic text encryption algorithms.
Methods
Rearranges uppercase string characters by even and odd indices.
Applies Caesar shift substitution across alphabetic characters.
Substitutes characters based on an alphabet re-ordered by a keyword.
Keyword substitution cipher with key-letter index shifting.
Convert
Utility class for string formatting, Base64 encoding/decoding, Hex, Binary, and type conversions.
Methods
Reverses input string sequence.
Capitalizes first character while lowercasing trailing characters.
Encodes or decodes text to/from UTF-8 Base64.
Converts strings to and from Hexadecimal and Binary representations.
Dictionarily
Wrapper class around Python dictionaries adding custom sorting routines.
Methods
Inserts a key-value entry into dictionary content.
Sorts dictionary entries alphabetically or prioritizing numeric keys first.
Returns the internal dictionary content.
EasySQL
Custom SQLite helper class simplifying table creation, dictionary insertion, queries, and row deletions.
Methods
Creates a database table using column name keys and data type definition values.
Inserts a record using a dictionary mapping column names to row values.
Queries and returns all rows from the specified table.
Deletes matching records using dictionary WHERE conditions.
Usage Example
from inpsPyPI import EasySQL
db = EasySQL("app_db")
db.create_table("users", {"id": "INTEGER PRIMARY KEY", "name": "TEXT"})
db.insert_to_table("users", {"id": 1, "name": "Alice"})
rows = db.get_table_values("users")
excellent_reader
Custom Excel file handler using openpyxl for batch column reading and writing across single or multiple sheets.
Functions
Reads column data from a specific sheet index, skipping a customizable number of header rows.
Reads column data across all sheets within an Excel workbook file.
Writes list or single values to target Excel columns and saves workbook changes.
Memory
In-memory list container wrapper with utility management methods.
Methods
Adds or removes elements from internal memory storage.
Checks existence or counts total items in storage.
SimpleFileHandler
Custom file IO handler wrapper for reading, writing, and appending UTF-8 text files.
Methods
Writes text content to a target file path using UTF-8 encoding.
Reads and returns complete string content from a file path.
Appends text content to an existing file.
sort
Module containing 17 high-performance sorting algorithm implementations.
Functions
Comparison-based iterative exchange sorting algorithms.
Efficient logarithmic divide-and-conquer and hybrid sorting algorithms.
Non-comparison distribution sorting algorithms.
Stackily
Custom LIFO stack data structure implementation.
Methods
Pushes item onto stack, pops top element, or peeks at top item.
Returns stack size, empty state check, or converts stack items to a list.