iframe-proxy | Sunbelt Computer Software

History

57 lines (49 loc) · 1.94 KB

Raw

#------------------------------------------------------------------------------

# universal_rowids.py

# This script demonstrates the use of universal rowids. Universal rowids are

# used to identify rows in index organized tables.

# This script requires cx_Oracle 6.0 and higher.

#------------------------------------------------------------------------------

import datetime

import cx_Oracle as oracledb

import sample_env

DATA = [

(1, "String #1", datetime.datetime(2017, 4, 4)),

(2, "String #2", datetime.datetime(2017, 4, 5)),

(3, "A" * 250, datetime.datetime(2017, 4, 6))

]

# truncate table so sample can be rerun

connection = oracledb.connect(sample_env.get_main_connect_string())

cursor = connection.cursor()

print("Truncating table...")

cursor.execute("truncate table TestUniversalRowids")

# populate table with a few rows

print("Populating table...")

for row in DATA:

print("Inserting", row)

cursor.execute("insert into TestUniversalRowids values (:1, :2, :3)", row)

connection.commit()

# fetch the rowids from the table

rowids = [r for r, in cursor.execute("select rowid from TestUniversalRowids")]

# fetch each of the rows given the rowid

for rowid in rowids:

print("-" * 79)

print("Rowid:", rowid)

cursor.execute("""

select IntCol, StringCol, DateCol

from TestUniversalRowids

where rowid = :rid""",

rid = rowid)

int_col, string_col, dateCol = cursor.fetchone()

print("IntCol:", int_col)

print("StringCol:", string_col)

print("DateCol:", dateCol)

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

universal_rowids.py

Latest commit

History

universal_rowids.py

File metadata and controls