Skip to main content

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)

Table of built distributions (wheels) for mysqleasy 0.0.1
File Actions
mysqleasy-0.0.1-cp312-cp312-win_amd64.whl CPython 3.12 CPython 3.12 Windows x86-64 Details for mysqleasy-0.0.1-cp312-cp312-win_amd64.whl
mysqleasy-0.0.1-cp312-cp312-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl CPython 3.12 CPython 3.12 Linux glibc 2.17+ x86-64, Linux glibc 2.5+ x86-64 Details for mysqleasy-0.0.1-cp312-cp312-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl
mysqleasy-0.0.1-cp311-cp311-win_amd64.whl CPython 3.11 CPython 3.11 Windows x86-64 Details for mysqleasy-0.0.1-cp311-cp311-win_amd64.whl
mysqleasy-0.0.1-cp311-cp311-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl CPython 3.11 CPython 3.11 Linux glibc 2.5+ x86-64, Linux glibc 2.17+ x86-64 Details for mysqleasy-0.0.1-cp311-cp311-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl
mysqleasy-0.0.1-cp310-cp310-win_amd64.whl CPython 3.10 CPython 3.10 Windows x86-64 Details for mysqleasy-0.0.1-cp310-cp310-win_amd64.whl
mysqleasy-0.0.1-cp310-cp310-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl CPython 3.10 CPython 3.10 Linux glibc 2.17+ x86-64, Linux glibc 2.5+ x86-64 Details for mysqleasy-0.0.1-cp310-cp310-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl
mysqleasy-0.0.1-cp39-cp39-win_amd64.whl CPython 3.9 CPython 3.9 Windows x86-64 Details for mysqleasy-0.0.1-cp39-cp39-win_amd64.whl
mysqleasy-0.0.1-cp39-cp39-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl CPython 3.9 CPython 3.9 Linux glibc 2.17+ x86-64, Linux glibc 2.5+ x86-64 Details for mysqleasy-0.0.1-cp39-cp39-manylinux1_x86_64.manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_5_x86_64.whl

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.

Release history Release notifications | RSS feed

This release

0.0.1 This release

8 release files No provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page