Essential SQLAlchemy

Author: Jason Myers
Publisher: "O'Reilly Media, Inc."
ISBN: 1491916559
Category : Computers
Languages : en
Pages : 204

Book Description
Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata. SQL is a powerful language for querying and manipulating data, but it’s tough to integrate it with your application. SQLAlchemy helps you map Python objects to database tables without substantially changing your existing Python code. If you’re an intermediate Python developer with knowledge of basic SQL syntax and relational theory, this book serves as both a learning tool and a handy reference. Essential SQLAlchemy includes several sections: SQLAlchemy Core: Provide database services to your applications in a Pythonic way with the SQL Expression Language SQLAlchemy ORM: Use the object relational mapper to bind database schema and operations to data objects in your application Alembic: Use this lightweight database migration tool to handle changes to the database as your application evolves Cookbook: Learn how to use SQLAlchemy with web frameworks like Flask and libraries like SQLAcodegen

Essential SQLAlchemy

Author: Rick Copeland
Publisher: "O'Reilly Media, Inc."
ISBN: 1449390846
Category : Computers
Languages : en
Pages : 232

Book Description
Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the "cool" features. SQLAlchemy includes both a database server-independent SQL expression language and an object-relational mapper (ORM) that lets you map "plain old Python objects" (POPOs) to database tables without substantially changing your existing Python code. Essential SQLAlchemy demonstrates how to use the library to create a simple database application, walks you through simple queries, and explains how to use SQLAlchemy to connect to multiple databases simultaneously with the same Metadata. You also learn how to: Create custom types to be used in your schema, and when it's useful to use custom rather than built-in types Run queries, updates, and deletes with SQLAlchemy's SQL expression language Build an object mapper with SQLAlchemy, and understand the differences between this and active record patterns used in other ORMs Create objects, save them to a session, and flush them to the database Use SQLAlchemy to model object oriented inheritance Provide a declarative, active record pattern for use with SQLAlchemy using the Elixir extension Use the SQLSoup extension to provide an automatic metadata and object model based on database reflection In addition, you'll learn how and when to use other extensions to SQLAlchemy, including AssociationProxy, OrderingList, and more. Essential SQLAlchemy is the much-needed guide for every Python developer using this code library. Instead of a feature-by-feature documentation, this book takes an "essentials" approach that gives you exactly what you need to become productive with SQLAlchemy right away.

Essential SQLAlchemy, 2nd Edition

Author: Jason Myers. Rick Copeland
Publisher:
ISBN: 9781491916544
Category :
Languages : en
Pages :

Book Description

Essential SQLAlchemy

Author: Jason Myers
Publisher: "O'Reilly Media, Inc."
ISBN: 1491916567
Category : Python (Computer program language)
Languages : en
Pages : 208

Book Description
"Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata. SQL is a powerful language for querying and manipulating data, but it's tough to integrate it with your application. SQLAlchemy helps you map Python objects to database tables without substantially changing your existing Python code. If you're an intermediate Python developer with knowledge of basic SQL syntax and relational theory, this book serves as both a learning tool and a handy reference. Essential SQLAlchemy includes several sections: SQLAlchemy Core: Provide database services to your applications in a Pythonic way with the SQL Expression Language; SQLAlchemy ORM: Use the object relational mapper to bind database schema and operations to data objects in your application; Alembic: Use this lightweight database migration tool to handle changes to the database as your application evolves; and Cookbook: Learn how to use SQLAlchemy with web frameworks like Flask and libraries like SQLAcodegen."--Publisher's description

Flask Web Development

Author: Miguel Grinberg
Publisher: "O'Reilly Media, Inc."
ISBN: 1491991690
Category :
Languages : en
Pages : 301

Book Description
Take full creative control of your web applications with Flask, the Python-based microframework. With the second edition of this hands-on book, youâ??ll learn Flask from the ground up by developing a complete, real-world application created by author Miguel Grinberg. This refreshed edition accounts for important technology changes that have occurred in the past three years. Explore the frameworkâ??s core functionality, and learn how to extend applications with advanced web techniques such as database migrations and an application programming interface. The first part of each chapter provides you with reference and background for the topic in question, while the second part guides you through a hands-on implementation. If you have Python experience, youâ??re ready to take advantage of the creative freedom Flask provides. Three sections include: A thorough introduction to Flask: explore web application development basics with Flask and an application structure appropriate for medium and large applications Building Flasky: learn how to build an open source blogging application step-by-step by reusing templates, paginating item lists, and working with rich text Going the last mile: dive into unit testing strategies, performance analysis techniques, and deployment options for your Flask application

SQL Cookbook

Author: Anthony Molinaro
Publisher: "O'Reilly Media, Inc."
ISBN: 0596009763
Category : Computers
Languages : en
Pages : 632

Book Description
A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.

Globalization

Author: George Ritzer
Publisher: John Wiley & Sons
ISBN: 1119315204
Category : Political Science
Languages : en
Pages : 406

Book Description
A concise exploration of globalization and its role in the contemporary era Driven by technological advancements and global corporations, more and more people are swept up by globalizing processes, creating new winners and losers. Globalization: The Essentials explores the flows, structures, processes, and consequences of globalization in the modern economic, political, and cultural landscape. This comprehensive introduction offers balanced coverage of areas such as global economic and cultural flows, environmental sustainability, the impact of technology, and racial, economic, and gender inequality — providing readers with foundational knowledge of globalization. Extensively revised and updated, this second edition includes expanded coverage of human trafficking and migration, global climate change, fake news and information wars, and transnational social movements with increased emphasis on examples from Central and South America, Africa, and Asia: Offers a straightforward approach to the multiple facets of globalization and their positive and negative influences on contemporary society Employs unique metaphors and a coherent narrative structure to promote intuitive understanding of abstract concepts Introduces cutting-edge research, updated statistics, and real-world examples in areas such as rising global populism, social justice movements, blockchain technology, and cryptocurrencies Provides an efficient and flexible pedagogical structure, allowing integration with instructor’s own course material Emphasizing student comprehension, a wide range of source material is incorporated including empirical research, relevant theories, newspaper and magazine articles, and popular books and monographs. Examples of current research and recent global developments, such as emerging economies and global health concerns, encourage classroom discussion and promote independent study. Globalization: The Essentials — a compact edition of the authors’ full-sized textbook Globalization: A Basic Text — provides concise coverage of the central concepts of this dynamic field. Offering a multidisciplinary approach, this textbook is an invaluable primary or supplemental resource for undergraduate study in any social science field, as well as coursework on economics, migration, inequality and stratification, and politics.

Head First Python

Author: Paul Barry
Publisher: "O'Reilly Media, Inc."
ISBN: 1491919493
Category : Computers
Languages : en
Pages : 624

Book Description
Want to learn the Python language without slogging your way through how-to manuals? With Head First Python, you’ll quickly grasp Python’s fundamentals, working with the built-in data structures and functions. Then you’ll move on to building your very own webapp, exploring database management, exception handling, and data wrangling. If you’re intrigued by what you can do with context managers, decorators, comprehensions, and generators, it’s all here. This second edition is a complete learning experience that will help you become a bonafide Python programmer in no time. Why does this book look so different? Based on the latest research in cognitive science and learning theory, Head First Pythonuses a visually rich format to engage your mind, rather than a text-heavy approach that puts you to sleep. Why waste your time struggling with new concepts? This multi-sensory learning experience is designed for the way your brain really works.

The Hitchhiker's Guide to Python

Author: Kenneth Reitz
Publisher: "O'Reilly Media, Inc."
ISBN: 1491933224
Category : Computers
Languages : en
Pages : 331

Book Description
The Hitchhiker's Guide to Python takes the journeyman Pythonista to true expertise. More than any other language, Python was created with the philosophy of simplicity and parsimony. Now 25 years old, Python has become the primary or secondary language (after SQL) for many business users. With popularity comes diversityâ??and possibly dilution. This guide, collaboratively written by over a hundred members of the Python community, describes best practices currently used by package and application developers. Unlike other books for this audience, The Hitchhikerâ??s Guide is light on reusable code and heavier on design philosophy, directing the reader to excellent sources that already exist.

Python for Finance

Author: Yves Hilpisch
Publisher: "O'Reilly Media, Inc."
ISBN: 1492024295
Category : Computers
Languages : en
Pages : 720

Book Description
The financial industry has recently adopted Python at a tremendous rate, with some of the largest investment banks and hedge funds using it to build core trading and risk management systems. Updated for Python 3, the second edition of this hands-on book helps you get started with the language, guiding developers and quantitative analysts through Python libraries and tools for building financial applications and interactive financial analytics. Using practical examples throughout the book, author Yves Hilpisch also shows you how to develop a full-fledged framework for Monte Carlo simulation-based derivatives and risk analytics, based on a large, realistic case study. Much of the book uses interactive IPython Notebooks.