| #!/usr/bin/python |
| # Copyright 2013 Cloudera, Inc. |
| # |
| # Licensed 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. |
| |
| import MySQLdb as mdb |
| import sys |
| import os |
| |
| if len(sys.argv) < 6: |
| sys.exit("usage: %s <job_name> <build_number> <workload> <iteration> <runtime>" % sys.argv[0]) |
| |
| host = os.environ["MYSQLHOST"] |
| user = os.environ["MYSQLUSER"] |
| pwd = os.environ["MYSQLPWD"] |
| db = os.environ["MYSQLDB"] |
| |
| con = mdb.connect(host, user, pwd, db) |
| print "Connected to mysql" |
| with con: |
| cur = con.cursor() |
| job_name = sys.argv[1] |
| build_number = sys.argv[2] |
| workload = sys.argv[3] |
| iteration = sys.argv[4] |
| runtime = sys.argv[5] |
| cur.execute("INSERT INTO kudu_perf_tpch VALUES(%s, %s, %s, %s, %s, DEFAULT)", |
| (job_name, build_number, workload, iteration, runtime)) |
| rows = cur.fetchall() |
| |