Re: [cx-oracle-users] New Book - Python Programming with Oracle Database

[ray t. <ray...@gm...>]

Table of contents, see below.  I'll look into providing an excerpt.  Also,
most code examples from the book are available at:
http://www.championwriters.com/books/Python/Oracle_Python_Source.zip.

-Ray

*Table of Contents*

Chapter 1 - Appetizers (p17)
 Python
 Oracle Database
 Python-Oracle Interaction
  SQL Method
  Object Relational Mapper Method
 Summary

Chapter 2 - Installation (p23)
 Python Installation
  Linux
  Windows
 Cx_Oracle Installation
  Linux
  Windows
 SQLAlchemy Installation
  Linux or Windows
 Summary

Chapter 3 - Python Quickstart (p29)
 Program Execution
  Interactive Interpreter
  Running the Script from the Shell
  Running the Program as an Argument to the Interpreter
  Running the Program Using the ‘Shebang’/‘Pound-Bang’ Syntax
 Everything is an Object. The Object is Everything
 Whitespace Matters (No semicolons or braces!)
  Multiline Statements
 Variables Do Not Require a Prefix
 Python is Dynamically, Strongly Typed
 Data Types
  Numerics
  Strings
  Lists
  Tuple – A Type of List
  Dictionary
  Files
 Control Statements
  If/Elif/Else
  While
  For
 Functions
  Defining the Function
  Calling the Function
  Passing Parameters in Order
  Passing Parameters by Name
  Mixing Order and Name When Passing Parameters
  Passing Parameters Using a Tuple
  Passing Parameters Using a Dictionary
 Namespaces
  Global Namespace
  Local Namespace
 Using Modules
 Classes – A Special Type of Object
 Building a Class
  Self
 Instantiating a Class
 Summary

Chapter 4 - Oracle Quickstart (p53)
 What is the Oracle Database?
 Creating a Database User for the Examples in this Book
 SQL*Plus
  Connecting to the Database with SQL*Plus
 Oracle Datatypes
  Character Datatypes
  Numeric Datatypes
  Date Datatypes
  Large Object Datatypes (LOBs)
 SQL
  SQL – Data Definition Language (DDL)
  SQL – Data Manipulation Language (DML)
   Insert
   Commit/Rollback
   Update
   Delete
  SQL – Querying
 The ‘Dual’ Table
 Getting the Current Date - Sysdate and Dual
 Summary

Chapter 5 - Using SQL with Python to Interact with Oracle (p71)
 First Program – Hello World
 Exploring the Syntax of the cx_Oracle Module
  Connect
  Net Service Name Syntax
  EZ Connect Syntax
  Using the ‘makedsn’ method
  Obtaining the Database Version
  Obtaining the Net Service Name
  Obtaining the Username and Password
  Cursor
  Parse
  Execute
  Fetch
 Hello World 2.0
 What to Do When Things Go Wrong
 Working with Large Object (LOB) Data
 Summary

Chapter 6 - Performing DBA Tasks with the Oracle Database Using Python (p93)
 Simple HTML Users/Privileges/Roles Report
 Generating DDL for Source Code
 Extending extract_source.py with if __name__
 Connecting to the Database Using a SYSDBA Connection
 Summary

Chapter 7 - Using PL/SQL with Python (p107)
 Calling PL/SQL from Python
 Using Callproc and Callfunc to Call PL/SQL
 Summary

Chapter 8 - Using an Object-Relational Mapper to Connect Python and Oracle
(p115)
 Simple Movie Table Using SQLAlchemy
 SQLAlchemy - More Detail
 Ordering Output
 Summary

Appendix A - Python Syntax Reference (p135)

Appendix B - Useful Python Methods (p143)

Index (p167)



On Mon, Aug 31, 2009 at 9:08 AM, Boyd, Craig1 <cra...@ci...> wrote:

>  Ray,
>
> I looked on Amazon and it looks promising.  I am not a huge football fan,
> but I will try not to judge a book by it's cover.  ;-)
> Could you publish a Table of Contents so that I/we could get a better feel
> of what you discuss in your book?  An excerpt or sample chapter would be
> nice, but I won't push it.
>
> Thanks,
>
> Craig*bert*
>
>
>  ------------------------------
> *From:* ray terrill [mailto:ray...@gm...]
> *Sent:* Monday, August 31, 2009 8:17 AM
> *To:* cx-...@li...
> *Subject:* [cx-oracle-users] New Book - Python Programming with Oracle
> Database
>
> Hello, fellow Python/Oracle hackers!
>
> Over the previous year, I've been working on a book to help provide the
> additional understanding I sought for when looking to use the Python
> programming language with the Oracle Database (note that this is nothing
> against the cx_Oracle documentation, which is some of the best documentation
> I've encountered while working with an open source product, or any
> enterprise-capable product for that matter).  As of early last week, the
> book, Python Programming with Oracle Database, is finally available for
> purchase from Amazon.com (see link below).
>
> The book covers the use of both the cx_Oracle module (likely familiar to
> most of you), as well as an object-relational mapper (in SQLAlchemy) for
> those from object-oriented backgrounds.  Each of the concepts explained in
> the chapters is accompanied by a clear, concise example, as well as a
> thorough explanation of the Python syntax used to implement the concept in
> practice.  For those just beginning the Python/Oracle journey, the book also
> offers separate Python and Oracle quickstart sections, meant to provide the
> reader with enough knowledge to begin to effectively use Python and Oracle,
> opening the door for further learning opportunities down the road.
>
> The book is currently available at:
>
> <a href=
> http://www.amazon.com/Python-Programming-Oracle-Database-Terrill/dp/1608300137/ref=sr_1_1?ie=UTF8&s=books&qid=1251139465&sr=8-1
> >
> http://www.amazon.com/Python-Programming-Oracle-Database-Terrill/dp/1608300137/ref=sr_1_1?ie=UTF8&s=books&qid=1251139465&sr=8-1
> </a>
>
> Quick word about Me:
> I'm an OCP-Certified Oracle DBA, and I use cx_Oracle heavily in the course
> of my job as a DBA for a Fortune 1000 company.  This is the first book I've
> written, and though I would describe my Oracle skills to be first-rate, I
> consider myself an amateur as a Python programmer.  Feel free to contact me
> with any questions or feedback you may have about the book at rayjohnterrill
> at gmail dot com.
>
> Thanks,
> -Ray Terrill
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>