query.py 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. #!/usr/bin/env python
  2. # Licensed to Cloudera, Inc. under one
  3. # or more contributor license agreements. See the NOTICE file
  4. # distributed with this work for additional information
  5. # regarding copyright ownership. Cloudera, Inc. licenses this file
  6. # to you under the Apache License, Version 2.0 (the
  7. # "License"); you may not use this file except in compliance
  8. # with the License. You may obtain a copy of the License at
  9. #
  10. # http://www.apache.org/licenses/LICENSE-2.0
  11. #
  12. # Unless required by applicable law or agreed to in writing, software
  13. # distributed under the License is distributed on an "AS IS" BASIS,
  14. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  15. # See the License for the specific language governing permissions and
  16. # limitations under the License.
  17. from __future__ import print_function
  18. from builtins import range
  19. from py4j.java_gateway import JavaGateway
  20. gateway = JavaGateway()
  21. jdbc_driver = 'com.mysql.jdb.Driver'
  22. db_url = 'jdbc:mysql://localhost/hue'
  23. username = 'root'
  24. password = 'root'
  25. conn = gateway.jvm.java.sql.DriverManager.getConnection(db_url, username, password)
  26. try:
  27. stmt = conn.createStatement()
  28. try:
  29. rs = stmt.executeQuery('select username,email from auth_user')
  30. try:
  31. md = rs.getMetaData()
  32. for i in range(md.getColumnCount()):
  33. print(md.getColumnTypeName(i + 1))
  34. while next(rs):
  35. username = rs.getString("username")
  36. email = rs.getString("email")
  37. print(username, email)
  38. finally:
  39. rs.close()
  40. finally:
  41. stmt.close()
  42. finally:
  43. conn.close()