Shulou(Shulou.com)06/02 Report--

This article shows you how to analyze the relevant functions of the Python module, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

The Python module function the connect () method is used to connect to the database and return a database connection object. If you want to connect to a MySQL database named fourm on a host.remote.com server, the connection string can be written as follows:

Db = MySQLdb.connect (host= "remote.com", user= "user"

Passwd= "xxx", db= "fourm") connect ()

The list of parameters is as follows:

Host, the hostname of the database server to which you are connected, defaults to local host (localhost).

User, the user name to connect to the database, defaults to the current user.

Passwd, connection password, no default value.

Db, the database name of the connection, has no default value.

Three steps to installing Python to a 64-bit Aix system

Introduction of simplified processing tools in Python package Management

Format of inline documents in the Python Docutils module

Examples of related code for the Python Docutils toolset

One of the frequently used modules in Python

Conv, a dictionary that maps text to a Python type. Default is MySQLdb.converters.conversions

The type used by cursorclass,cursor (). The default value is MySQLdb.cursors.Cursor.

Compress to enable protocol compression.

Named_pipe, in windows, is connected to a named pipe.

Init_command, once the connection is established, specify a statement for the database server to run.

Read_default_file, using the specified MySQL configuration file.

Read_default_group, the default group for reading.

Unix_socket, in unix, the socket used for connections, defaults to TCP.

Port, which specifies the connection port of the database server. The default is 3306.

The db.close () method of the connection object closes the database connection and releases related resources.

The db.cursor ([cursorClass]) method of the connection object returns a pointer object that is used to access and manipulate data in the database.

The db.begin () method of the connection object is used to start a transaction and close it if the AUTOCOMMIT of the database is turned on until the transaction calls commit () and rollback () finish.

The db.commit () and db.rollback () methods of the connection object represent transaction commit and fallback, respectively.

The cursor.close () method of the pointer object closes the pointer and releases related resources.

The cursor.execute (query [, parameters]) method of the pointer object performs the database query.

The cursor.fetchall () of the pointer object fetches all the rows in the pointer result set, and the returned result set is a tuples.

The cursor.fetchmany ([size=cursor.arraysize]) of the pointer object fetches multiple rows from the query result set, and we can specify the number of rows to fetch with optional parameters.

The cursor.fetchone () of the pointer object returns the next row from the query result set.

The cursor.arraysize property of the pointer object specifies the number of rows returned by the cursor.fetchmany () method, which affects the performance of fetchall (). The default value is 1.

The cursor.rowcount property of the pointer object indicates the number of rows that occurred in the last query or update. -1 indicates that the query has not started or the data has not been queried.

The above content is how to interpret the relevant functions of the Python module. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.