Advertisement
Guest User

Untitled

a guest
Apr 3rd, 2019
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. ----------------------------------------- udaexec.inc
  2. # Application Configuration
  3. [CONFIG]
  4. appName=StatisticsMacrosFactory
  5. version=0.1
  6. logConsole=False
  7. dataSourceName=vmtest
  8.  
  9. # Default Data Source Configuration
  10. [DEFAULT]
  11. method=odbc
  12. charset=UTF8
  13.  
  14. # Data Source Definition
  15. [TDPROD]
  16. system=dbc
  17. username=dbc
  18. password=dbc
  19.  
  20. ----------------------------------------- execute commands:
  21. pip install teradata
  22. ----------------------------------------- app.py
  23. import teradata
  24.  
  25. udaExec = teradata.UdaExec ()
  26. with udaExec.connect("${dataSourceName}") as session:
  27. table_columns = {}
  28. for row in session.execute("SELECT TableName, ColumnName, ColumntType FROM dbc.columns WHERE DatabaseName = '${dataSourceName}';"):
  29. table_columns[row[0]] = table_columns[row[0]].append((row[1], row[2]))
  30. print(table_columns)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement