From e046bb92df0ea62cc36626491edbf04811894392 Mon Sep 17 00:00:00 2001
From: Yuval Adam <yuv.adm@gmail.com>
Date: Sat, 9 Oct 2010 17:30:06 +0200
Subject: added get_tables()

---
 dbutils.py | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/dbutils.py b/dbutils.py
index f073548..2dd8e66 100644
--- a/dbutils.py
+++ b/dbutils.py
@@ -3,8 +3,8 @@ import dbconfig
 
 connStr = '%s/%s@%s' % (dbconfig.USER, dbconfig.PASS, dbconfig.SID)
 
-with cx_Oracle.connect(connStr) as conn:
-    cur = conn.cursor()
-    cur.execute('SELECT COUNT(*) FROM D_CARRIL_PM_2008_01')
-    for s in cur.fetchall():
-        print s
+def get_tables():
+    with cx_Oracle.connect(connStr) as conn:
+        cur = conn.cursor()
+        cur.execute('SELECT owner, table_name FROM all_tables')
+        return [table for owner, table in cur.fetchall()]
-- 
cgit v1.3.1