| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 |
- #!/usr/bin/env python
- # Licensed to Cloudera, Inc. under one
- # or more contributor license agreements. See the NOTICE file
- # distributed with this work for additional information
- # regarding copyright ownership. Cloudera, Inc. licenses this file
- # to you under the Apache License, Version 2.0 (the
- # "License"); you may not use this file except in compliance
- # with the License. You may obtain a copy of the License at
- #
- # http://www.apache.org/licenses/LICENSE-2.0
- #
- # Unless required by applicable law or agreed to in writing, software
- # distributed under the License is distributed on an "AS IS" BASIS,
- # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- # See the License for the specific language governing permissions and
- # limitations under the License.
- from __future__ import print_function
- from builtins import range
- from py4j.java_gateway import JavaGateway
- gateway = JavaGateway()
- jdbc_driver = 'com.mysql.jdb.Driver'
- db_url = 'jdbc:mysql://localhost/hue'
- username = 'root'
- password = 'root'
- conn = gateway.jvm.java.sql.DriverManager.getConnection(db_url, username, password)
- try:
- stmt = conn.createStatement()
- try:
- rs = stmt.executeQuery('select username,email from auth_user')
- try:
- md = rs.getMetaData()
- for i in range(md.getColumnCount()):
- print(md.getColumnTypeName(i + 1))
- while next(rs):
- username = rs.getString("username")
- email = rs.getString("email")
- print(username, email)
- finally:
- rs.close()
- finally:
- stmt.close()
- finally:
- conn.close()
|