Skip to main content
Python Software Foundation 20th Year Anniversary Fundraiser  Donate today!

Mysql connector skeleton for the x protocol

Project description

MySQL X connector for python

This repo contains a skeleton for mysqlx connector. User has to just create a specific table class which inherits provided table class. Users own table class can contain any kinds of methods to manipulate the table.

This connector uses environment variables to connect to the database. You need to set HOST, PORT, USER, and PASSWORD variables in the environment. By default MySQL uses port 33060 for the X protocol.

Examples

Simple table example:

from mysqlx_connector import Table, parse_results

class CityTable(Table):

	def get_cities(self):
		return parse_results(self._table.select().execute())

Usage of the created table:

city_table = CityTable('cities', 'exampleDatabase')

with city_table as table:
	for row in table.get_cities():
		print(row)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for mysqlx-connector, version 0.0.8
Filename, size File type Python version Upload date Hashes
Filename, size mysqlx_connector-0.0.8-py3-none-any.whl (14.2 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size mysqlx_connector-0.0.8.tar.gz (1.5 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page