Syntax

1. #
   # Import Python modules
   # -------------------------------------------
   import sys
   import sdb.sql
   #
   # Connect to the database
   # -------------------------------------------
   database_user = sys.argv [1]
   database_user_password = sys.argv [2]
   database_name = sys.argv [3]
   session = sdb.sql.connect (database_user, database_user_password, database_name)
   select = """
     SELECT * FROM hotel.room"""
   #
   # Execute a SELECT statement
   # Result: An object of the SapDB_ResultSet class
   # -----------------------------------------------
   cursor = session.sql (select)
   #
   # You can use an object of the class SapDB_ResultSet in a for loop
   # in the same way as any other iterator.
   # -----------------------------------------------
   for row in cursor:
     hno, type, free, price = row
     print "%6d %s %d %6d" % (hno, type, free, price)
   #
   # You can use a for statement to
   # execute an SQL statement and to group the result rows
   # in columns.
   # -------------------------------------------------
   for hno, type, free, price in session.sql (select):
     print "%6d %s %d %6d" % (hno, type, free, price)
   #
   # Close connection to the database
   # --------------------------------------------
   session.release ()