MySQL easy
MySQL easy is a tool to augment your database development using MySQL.
It is also an intelligent code generator. It generates code for you in SQL or in Python based on your table structure and relationships between the table. This tool will help debug larger database applications easily and write code in matter of clicks that you may require few days of effort.
Pre-requisite
pymysql => pip install pymysql mysql => pip install mysql-connector-python redis => pip install redis
SQL code
Sample code that you can use to create a table named user with three columns user_id, last_name and first_name.
CREATE TABLE `user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(70) DEFAULT NULL,
`last_name` varchar(70) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
Code generation
Use MySQLeasy to generate code for your table. Once python class for user is generated run it.
Python code
Following code will insert a new user John Smith. Then search the records with last name Smith. Then update the first name to Mike in the first row. Update the records in database and at the end close the connection.
from mysqleasy.Connection import Connection as Connection
from mysqleasy.Access import Access as Access
connector = "mysqlconnector"
db_config = {'host': 'your_database_host_address', 'user': 'your_database_user_name', 'password': 'your_database_password'}
conn = Connection.create(connector, db_config)
last_row_id = user.insert(conn, first_name = "John", last_name = "Smith")
columns, users = user.search(conn, last_name='Smith')
user_list = [o for o in Access.iter_object(columns, users)]
last_row_id, count_affected = user.insertupdate_multiple(conn, [('Mike', 'Smith', 1)])
conn.commit()
conn.close()
Metadata
Release files for mysqleasy 0.0.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distributions (wheels)
Total release size: 5.3 MB
Release files / mysqleasy-0.0.1-cp312-cp312-win_amd64.whl
| Download URL | mysqleasy-0.0.1-cp312-cp312-win_amd64.whl |
|---|---|
| Size | 154.8 kB |
| Tags | CPython 3.12 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
abcd7043c854ebe2aaca54e8997bb246fa81dfef3472d228e12c9baaaae41599
|
|
BLAKE2b-256 checksum How to use checksums |
69a871612e368c5ff9d1d61854934b58ce6d4ba6924c62d53d6099793c89a668
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Release files / mysqleasy-0.0.1-cp312-cp312-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl
| Download URL | mysqleasy-0.0.1-cp312-cp312-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 1.2 MB |
| Tags | CPython 3.12 Linux glibc 2.17+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
1e081e915e24fa35b38597993df933aa0e6c2d8b01272b52d24d726d4e31a0cb
|
|
BLAKE2b-256 checksum How to use checksums |
fe0c53ae757c004e08650d965bf4eec75596a0276e3bde1479428c5e6b14df53
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Release files / mysqleasy-0.0.1-cp311-cp311-win_amd64.whl
| Download URL | mysqleasy-0.0.1-cp311-cp311-win_amd64.whl |
|---|---|
| Size | 154.9 kB |
| Tags | CPython 3.11 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
d941af8d7e370984176f45e4a06f94d496d8c59ea8095c14cc5cdfd836ad3aa4
|
|
BLAKE2b-256 checksum How to use checksums |
a5efb8c81b1d937bd0df936b67a452eb1d01205faa61beeac9e6f2e2d96656f2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Release files / mysqleasy-0.0.1-cp311-cp311-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl
| Download URL | mysqleasy-0.0.1-cp311-cp311-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 1.2 MB |
| Tags | CPython 3.11 Linux glibc 2.17+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
c4bc77cd9325d3c8402f70450d74e32f2057add7ea08a7e1c27bf5fe11c65999
|
|
BLAKE2b-256 checksum How to use checksums |
743a9880f7a0a305867536c4f8b54da71d1b264af426077641a6a91d4ad89623
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Release files / mysqleasy-0.0.1-cp310-cp310-win_amd64.whl
| Download URL | mysqleasy-0.0.1-cp310-cp310-win_amd64.whl |
|---|---|
| Size | 153.6 kB |
| Tags | CPython 3.10 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
387f481bcc2b761c40f4f3d96de902bfeed6d5e7438b61d9ef88849edb84fdc0
|
|
BLAKE2b-256 checksum How to use checksums |
0826a24430d9a070dc1158e5ae6dcba7ecadd3f10f51cade86442ed8da699363
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Release files / mysqleasy-0.0.1-cp310-cp310-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl
| Download URL | mysqleasy-0.0.1-cp310-cp310-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 1.1 MB |
| Tags | CPython 3.10 Linux glibc 2.17+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
241155141da65765cce85704073e34ff80204a7e5e62341ff06c36df6c56579b
|
|
BLAKE2b-256 checksum How to use checksums |
197fe38afa0c5d2e3cedf3e2cd0173ddcc070510ab3fc78e9d6a63e1727cdf63
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Release files / mysqleasy-0.0.1-cp39-cp39-win_amd64.whl
| Download URL | mysqleasy-0.0.1-cp39-cp39-win_amd64.whl |
|---|---|
| Size | 154.9 kB |
| Tags | CPython 3.9 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
143a1027892a74cee4e30e17337310f8d5b15a81175f0c7d61acf9bc95495215
|
|
BLAKE2b-256 checksum How to use checksums |
fa1f433a4dbda75762224e4a0149977c7cdf2969c4467a0a1e77a1d53ad1d33a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Release files / mysqleasy-0.0.1-cp39-cp39-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl
| Download URL | mysqleasy-0.0.1-cp39-cp39-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl |
|---|---|
| Size | 1.1 MB |
| Tags | CPython 3.9 Linux glibc 2.17+ x86-64 Linux glibc 2.5+ x86-64 |
|
SHA-256 checksum How to use checksums |
bda1c34f342d6b2db722a909db6b4a3ea8baae31976323025e0a67c80b31a766
|
|
BLAKE2b-256 checksum How to use checksums |
af02dbdcec89a3ae769af42b0e10df6d4467c3eaad0f098441162ffc54c06df7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.7
|
Security for mysqleasy 0.0.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.