没有合适的资源?快使用搜索试试~ 我知道了~
首页Essential SQLAlchemy
Essential SQLAlchemy

介绍了 SQLAlchemy 使用方法,极大的方便 python 操作数据库的方法
资源详情
资源评论
资源推荐

978-1-491-91646-9
[LSI]
Essential SQLAlchemy
by Jason Myers and Rick Copeland
Copyright © 2016 Jason Myers and Rick Copeland. All rights reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are
also available for most titles (http://safaribooksonline.com). For more information, contact our corporate/
institutional sales department: 800-998-9938 or corporate@oreilly.com.
Editors: Dawn Schanafelt and Meghan Blanchette
Production Editor: Shiny Kalapurakkel
Copyeditor: Charles Roumeliotis
Proofreader: Jasmine Kwityn
Indexer: Angela Howard
Interior Designer: David Futato
Cover Designer: Karen Montgomery
Illustrator: Rebecca Demarest
June 2008: First Edition
December 2015: Second Edition
Revision History for the Second Edition
2015-11-20: First Release
See http://oreilly.com/catalog/errata.csp?isbn=9781491916469 for release details.
The O’Reilly logo is a registered trademark of O’Reilly Media, Inc. Essential SQLAlchemy, the cover image,
and related trade dress are trademarks of O’Reilly Media, Inc.
While the publisher and the authors have used good faith efforts to ensure that the information and
instructions contained in this work are accurate, the publisher and the authors disclaim all responsibility
for errors or omissions, including without limitation responsibility for damages resulting from the use of
or reliance on this work. Use of the information and instructions contained in this work is at your own
risk. If any code samples or other technology this work contains or describes is subject to open source
licenses or the intellectual property rights of others, it is your responsibility to ensure that your use
thereof complies with such licenses and/or rights.
www.it-ebooks.info

Table of Contents
Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
Introduction to SQLAlchemy. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Part I. SQLAlchemy Core
1.
Schema and Types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Types 1
Metadata 3
Tables 4
Columns 5
Keys and Constraints 6
Indexes 7
Relationships and ForeignKeyConstraints 7
Persisting the Tables 9
2.
Working with Data via SQLAlchemy Core. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
Inserting Data 13
Querying Data 17
ResultProxy 18
Controlling the Columns in the Query 20
Ordering 20
Limiting 21
Built-In SQL Functions and Labels 22
Filtering 24
ClauseElements 25
Operators 26
iii
www.it-ebooks.info
剩余207页未读,继续阅读



















安全验证
文档复制为VIP权益,开通VIP直接复制

评论1