MySQL Connector/Python revealed : SQL and NoSQL data storage using MySQL for Python programmers /

Move data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database. This book takes you from the initial installation of the conne...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Krogh, Jesper Wisborg (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [United States] : Apress, 2018.
Temas:
MySQL (Electronic resource)
Python (Computer program language)
Python (Langage de programmation)
Programming & scripting languages: general.
Computer programming > software development.
Databases.
COMPUTERS > Databases > General.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Getting Ready; Chapter 1: Introduction and Installation; Introduction; Versions; Community and Enterprise Editions; APIs; Downloading; Installation; pip
  • All Platforms; Microsoft Windows
  • MySQL Installer; Linux
  • MySQL Yum Repository; Verifying the Installation; MySQL Server; Installation; Configuration; Creating the Application User; Installing the world Sample Database; Code Examples; Summary; Part II: The Legacy APIs; Chapter 2: Connecting to MySQL.
  • Creating the Connection from PythonSyntax; Common Connection Options; Connection Examples; Reconfiguration and Reconnect; Connection Best Practices; Configuration Files; Alternatives to Hardcoding the Configuration; Using MySQL Configuration Files; General Configuration; Connection; Character Set; Query Behavior; Warnings; Summary; Chapter 3: Basic Query Execution; Simple Execution; Executing the Query: cmd_query(); Retrieving Rows
  • get_rows(); Automatic Conversion into Native Python Types; Retrieving Rows
  • get_rows() With Limit; Retrieving Rows
  • get_row(); Consuming Results; Cursors.
  • InstantiationMySQLCursor
  • Execution Flow; MySQLCursor
  • Query Execution; MySQLCursor
  • Properties; column_names; description; lastrowid; rowcount; statement; with_rows; The Dictionary and Named Tuple Cursor Subclasses; Handling User Input; Validating the Input; Query Parameterization; Prepared Statements; Summary; Chapter 4: Advanced Query Execution; Multi-Query Execution; Multiple Queries with Support for Results; Connection
  • cmd_query_iter(); Cursor
  • execute(); Multiple Queries Based on a Template; Extended Inserts; Buffered Results; Stored Procedures; Loading Data Using a CSV File.
  • Loading a Server-Side FileLoading an Application-Side File; Load Data Example; Connection Properties; Transactions; Default Database; Time Zones; Other Connection Utility Methods; Connection Methods; cmd_change_user(); cmd_reset_connection() and reset_session(); is_connected(); ping(); Server Information Methods; Column Information; Field Types; MySQL Column Flags; The C Extension; The mysql.connector.connect() Function; The _mysql_connector Module; Summary; Chapter 5: Connection Pooling and Failover; Connection Pooling
  • Background; The pooling. MySQLConnectionPool Class.
  • The pooling. PooledMySQLConnection ClassConfiguration Options; Using Connection Pools; Creating a Connection Pool; Using Connection Pool Connections; Using the mysql.connector.connect() Function; Using the get_connection() Method; Executing Queries; Reconfiguring the Connections; Connection Failover; Failover Configuration; Coding for Failover; Failover Example; Summary; Part III: The X DevAPI; Chapter 6: The X DevAPI; The MySQL X Plugin; The mysqlx Module; Creating a Session; Passing Individual Options; Passing an URI; Connection Examples; Working with the Session; Transactions.

Ejemplares similares