Python:Databases - Revision history

Hdridder: /* mariadb */

2026-01-14T13:58:14Z

mariadb

← Older revision		Revision as of 13:58, 14 January 2026
Line 102:		Line 102:

	=mariadb=		=mariadb=
	The mariadb module[https://mariadb.com/docs/connectors/mariadb-connector-python] works almost the same as the mysql.connecctor above.		The mariadb module[https://mariadb.com/docs/connectors/mariadb-connector-python][https://mariadb-corporation.github.io/mariadb-connector-python/] works almost the same as the mysql.connecctor above.

	<syntaxhighlight lang=python>		<syntaxhighlight lang=python>

2026-01-14T13:55:45Z

mariadb

← Older revision		Revision as of 13:55, 14 January 2026
Line 102:		Line 102:

	=mariadb=		=mariadb=
	The mariadb module works almost the same as the mysql.connecctor above.		The mariadb module[https://mariadb.com/docs/connectors/mariadb-connector-python] works almost the same as the mysql.connecctor above.

	<syntaxhighlight lang=python>		<syntaxhighlight lang=python>

2026-01-14T13:53:32Z

@@ Line 1: / Line 1: @@
 [[Category:Python]]
 = MySQL Connector =
@@ Line 101: / Line 100: @@
 cnx.close()
 </syntaxhighlight>
 = ODBC connections =

2020-07-25T13:22:04Z

MySQL Connector

← Older revision		Revision as of 13:22, 25 July 2020
Line 32:		Line 32:
	:Execute 'query'. Traverse the cursor to fetch the data. The cursor returns a tuple for each row by default.<br>		:Execute 'query'. Traverse the cursor to fetch the data. The cursor returns a tuple for each row by default.<br>
	:;cursor.rowcount		:;cursor.rowcount
	::The number of rows affected by this query.		::The number of rows fetched (SELECT) or affected (INSERT,UPDATE) by this query.
	:;cursor.column_names		:;cursor.column_names
	::The columnnames		::The columnnames

2020-07-09T15:29:31Z

← Older revision		Revision as of 15:29, 9 July 2020
Line 6:		Line 6:

	;import mysql.connector		;import mysql.connector
	:Load module for mysql		:Load module for mysql

	;cnx = mysql.connector.connect(**cnxconfig)		;cnx = mysql.connector.connect(**cnxconfig)
Line 30:		Line 30:

	;cursor.execute(query)		;cursor.execute(query)
	:Execute 'query'~~. Columnames are in the tuple cursor.column_names~~. Traverse the cursor to fetch the data. The cursor returns a tuple for each row.<br>		:Execute 'query'. Traverse the cursor to fetch the data. The cursor returns a tuple for each row by default.<br>
	:;cursor.rowcount		:;cursor.rowcount
	::The number of rows affected by this query.		::The number of rows affected by this query.
			:;cursor.column_names
			::The columnnames

	;cursor.fetchone()		;cursor.fetchone()
	:Return the next row from the cursor result.		:Return the next row from the cursor result.
Line 103:		Line 106:
	<syntaxhighlight lang=python>		<syntaxhighlight lang=python>
	import pyodbc		import pyodbc
	~~import sqlalchemy~~

	dsn = 'DSN=<name of ODBC-DNS>'		dsn = 'DSN=<name of ODBC-DNS>'
Line 113:		Line 115:

	result = cursor.execute(query)		result = cursor.execute(query)
			columnnames = [e[0] for e in cursor.description]
	for row in result:		for row in result:
	field1 = row[0]		field1 = row[0]

2020-07-05T13:06:40Z

MySQL Connector

← Older revision		Revision as of 13:06, 5 July 2020
Line 17:		Line 17:
	:Open Oracle database.		:Open Oracle database.

			;cnx.commit()
			:Commit all open transactions to the database

	;cursor = cnx.cursor()		;cursor = cnx.cursor()
	:Create a cursor that returns rows as [[Python:DataTypes#Tuple \| tuple]]		:Create a cursor that returns rows as [[Python:DataTypes#Tuple \| tuple]]

2020-07-05T12:17:29Z

← Older revision		Revision as of 12:17, 5 July 2020
Line 22:		Line 22:
	;cursor = cnx.cursor(dictionary=True)		;cursor = cnx.cursor(dictionary=True)
	:Create a cursor that returns rows as [[Python:DataTypes#Dictionary_or_dict \| dictionary]] { column1: value1, column2: value2 }		:Create a cursor that returns rows as [[Python:DataTypes#Dictionary_or_dict \| dictionary]] { column1: value1, column2: value2 }

			;cursor = cnx.cursor(buffered=True)
			:Create a cursor that retrieves the complete result at once so you can check rowcount immediately. Beware of overloading your memory if you expect large results.

	;cursor.execute(query)		;cursor.execute(query)

2020-05-23T14:02:37Z

← Older revision		Revision as of 14:02, 23 May 2020
Line 18:		Line 18:

	;cursor = cnx.cursor()		;cursor = cnx.cursor()
	:Create a cursor that returns rows ~~in a~~ [[Python:DataTypes#Tuple \| tuple]]		:Create a cursor that returns rows as [[Python:DataTypes#Tuple \| tuple]]

	;cursor = cnx.cursor(dictionary=True)		;cursor = cnx.cursor(dictionary=True)
	:Create a cursor that returns rows ~~in a~~ [[Python:DataTypes#Dictionary_or_dict \| dictionary]] { column1: value1, column2: value2 }		:Create a cursor that returns rows as [[Python:DataTypes#Dictionary_or_dict \| dictionary]] { column1: value1, column2: value2 }

	;cursor.execute(query)		;cursor.execute(query)

2020-04-17T12:18:28Z

ODBC connections

← Older revision		Revision as of 12:18, 17 April 2020
Line 112:		Line 112:
	</syntaxhighlight>		</syntaxhighlight>

	~~Wotks~~ with [[Pandas#Reading Data\|pandas.read_sql]] too.		Works with [[Pandas#Reading Data\|pandas.read_sql]] too.

	= MySqlAlchemy =		= MySqlAlchemy =

2019-10-14T13:50:02Z

@@ Line 92: / Line 92: @@
 cnx.close()
 </syntaxhighlight>
 = MySqlAlchemy =