MySQL Connector/Python revealed : SQL and NoSQL data storage using MySQL for Python programmers /: SQL and NoSQL data storage using MySQL for Python programmers. (2018)

• Record Type: Book
• Further Information: Note: Jesper Wisborg Krogh.
• Authors: Krogh, Jesper Wisborg
• Contents: 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
• Publisher Details: United States : Apress
• Publication Date: 2018
• Copyright Date: 2018
• Extent: 1 online resource
• Subjects: 005.74; Computer science; Python (Computer program language); COMPUTERS / Databases / General; Python (Computer program language); Computer Science; Database Management; Python; Open Source; Computers -- Programming Languages -- Python; Computers -- Programming -- Open Source; Programming & scripting languages: general; Computer programming / software development; Database management; Python (Computer program language); Open source software; Computer programming; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484236949; 1484236947
• Related ISBNs: 9781484236932; 1484236939
• Notes: Note: Online resource; title from PDF title page (Ebsco, viewed August 7, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.