A light-weight (out-of-the box) tool for pushing SQL (MySQL) queries, a markup-language for structured txt files and running data loggers in python.
Python Quick SQL
A light-weight (out-of-the box) tool for pushing SQL (MySQL and SQLite) queries, markup-language for structured txt files and running data loggers in python.
pip install pyquicksql==1.1.1
Designed as a purely light-weight and object-oriented aproach to sending MySQL queries to a database server from python. Current modules offer partialy oo aproaches, resulting in over-complicated syntax for simple sql queries. The goal is that this module will offer ease-of-use in comparison to other modules while providing faster development time.
- MySQL (v.7.0)
server = Server('0.0.0.0.0', 800, username, password) database = Database('users', 'credentials', True) connector = Connect(server, database)
result = connector.lookup(unknown_column, known_colum, known_element)
result = connector.push(columns, elements)
result = connector.swap(unknown_data, known_data)
result = connector.remove(column, element)
The logger offers developers who wish to log all sql traffic localy within their project OR for those who do not wish to overcomplicate their projects with SQL queries and use standard txt files. The goal is to offer a basic but efficient markup language which mimics relational tables found within MySQL for faster lookup times for values. This is (yet another) out-of-the-box module the package promises, to speed up development time by offering individuals who do not know how to make their own relational markup language.
l = Logger(directory) <- directory must be an active file path
backup = l.getLogs()
l.log(Server, Database, Message)
value = l.index(0)
value = l.lookup(column, element, starting)
The 'Data Markup' is a markup-language designed with Rust and interface with python to offer the speed that it cannot. The language offers relational column-element formating for standard txt files for faster data lookup and retreival.
value = l.parse(line, Request)
Functionality of all classes are not limited to this README, I encourage your to view the source
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.