def main():
table_name = sys.argv[1]
corpus = ReviewCorpus.load("model/" + table_name)
read_con = MySQLdb.connect(
host=DB_SERVER, port=DB_SERVER_PORT, user=DB_USER, passwd=DB_PASSWORD, db=DB_NAME, charset="utf8mb4"
)
write_con = MySQLdb.connect(
host=DB_SERVER, port=DB_SERVER_PORT, user=DB_USER, passwd=DB_PASSWORD, db=DB_NAME, charset="utf8mb4"
)
read_cursor = read_con.cursor()
read_cursor.execute(SQL_QUERY % (table_name))
write_cursor = write_con.cursor()
for _ in range(read_cursor.rowcount):
record = read_cursor.fetchone()
hotel_review = format_review(record[1])
tfidf_score = 0
if hotel_review:
tfidf_score = corpus.tfidf_score(hotel_review)
write_cursor.execute(SQL_UPDATE % (table_name, tfidf_score, record[0]))
write_con.commit()
print "[%f]%s" % (tfidf_score, record[1])
write_cursor.close()
write_con.close()
read_cursor.close()
read_con.close()
def _open(self, conv='', host='', user='', passwd='', db='', port=0):
"""Open database connection. In case of errors exceptions are thrown."""
if conv=='':
self._db = MySQLdb.connect(host, user, passwd, db, port, connect_timeout = DB_TIMEOUT)
else:
self._db = MySQLdb.connect(conv=conv, host=host, user=user, passwd=passwd, db=db, port=port, connect_timeout = DB_TIMEOUT)
self._db.set_character_set('utf8')
def another_page():
print('anotherpage')
scoop = {'postername': MySQLdb.escape_string(request.form['postername']),
'activity': MySQLdb.escape_string(request.form['activity']),
'rank': request.form['rank']
}
if request.method == 'POST':
db = utils.db_connect()
cur = db.cursor(cursorclass=MySQLdb.cursors.DictCursor)
query = "INSERT INTO club_name (postername) VALUES ('" + MySQLdb.escape_string(request.form['postername']) + "')"
# Print query to console (useful for debugging)
print query
cur.execute(query)
id=cur.lastrowid
#db.commit()
query2 = "INSERT INTO activity (club_id, activity, rank) VALUES (" + str(id) + ", '" + MySQLdb.escape_string(request.form['activity']) + "', '" + request.form['rank'] + "')"
# Print query to console (useful for debugging)
print query2
cur.execute(query2)
db.commit()
cur.execute('SELECT DISTINCT cn.postername, a.activity, a.rank FROM club_name cn NATURAL JOIN activity a')
rows = cur.fetchall()
return render_template('another_page.html', club_name=rows, activity = rows, scoop = scoop)
def index(req):
send = []
post_data = str(req.form.list)[8:-7]
if(post_data[0] == 'R'):
generateStandard()
db = MySQLdb.connect("localhost", "erik", "erik", db_name)
cursor = db.cursor()
cursor.execute("SELECT DISTINCT(user_id) FROM {}".format(table_name))
send = cursor.fetchall()
db.close()
elif post_data[0] == 'S':
tmp = post_data.split(',')
getSubtract(tmp[1], tmp[2])
else:
user_id = int(post_data)
db = MySQLdb.connect("localhost", "erik", "erik", db_name)
cursor = db.cursor()
cursor.execute("SELECT image_id, browser FROM {} WHERE user_id='{}'".format(table_name, user_id))
data = cursor.fetchall()
db.close()
generatePictures(data, user_id)
send = gen_hash_codes(data)
send_string = json.dumps(send)
return send_string
def get_qsyk_and_insert(self, docid):
cover_img = MySQLdb.escape_string(docid['cover_img'])
docid = docid['docid']
if self.db_has_exist(docid):
return
url = "http://c.3g.163.com/nc/article/%s/full.html" % str(docid)
data = utils.download_page(url, True)
if data:
data = data[docid]
if data:
ptime = data['ptime']
today = ptime.split(' ')[0]
imgs = data['img']
body = data['body'].encode('utf-8')
title = data['title'].replace(' ', '').replace('（', '-').replace('(', '-').replace(')', '').replace('）', '')
for img in imgs:
body = body.replace(img['ref'], "<img src=\"" + img['src'] + "\"/><hr>")
body = body.replace('%', '%%')
body = MySQLdb.escape_string(body)
sql = "insert into wangyi(item_type, title, url, docid, cover_img, ptime, today, body) values('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')" % (self._item_type, title, url, docid, cover_img, ptime, today, body)
utils.insert_mysql(sql)
def main():
conn = MySQLdb.connect (host=settings.MYSQL_HOST, user=settings.MYSQL_USER, passwd=settings.MYSQL_PASSWORD, db=settings.MYSQL_DATABASE)
cursor = conn.cursor()
TABLES = ['agency', 'calendar', 'calendar_dates', 'fare_attributes','fare_rules','routes','shapes', 'stops', 'stop_times', 'trips']
for table in TABLES:
print 'processing %s' % table
f = open('gtfs/%s.txt' % table, 'r')
reader = csv.reader(f)
columns = reader.next()
for row in reader:
insert_row = []
for value in row:
if not is_numeric(value) or value.find('E') != -1:
insert_row.append('"' + MySQLdb.escape_string(value) + '"')
else:
insert_row.append(value)
insert_sql = "INSERT INTO %s (%s) VALUES (%s);" % (table, ','.join(columns), ','.join(insert_row))
cursor.execute(insert_sql)
conn.commit()
cursor.close ()
conn.close ()
def insertSimToDB(pulseseq, params, dec):
""" create an entry for a Simulation """
if not mysql:
return
entry_ps = repr(pulseseq.seq)
entry_params = MySQLdb.escape_string(repr(params.__dict__))
entry_hspace = MySQLdb.escape_string(repr(params.hspace.__dict__))
entry_dec = MySQLdb.escape_string(repr(dec.__dict__))
dbx = MySQLdb.connect(user="tiqcspice", passwd="tiqc_cluster1", db="tiqcspice", host="marvin")
db = dbx.cursor()
sql = "insert into Simulation (name, pulseseq, params, hspace, decoherence) values ('%s', '%s','%s','%s','%s')" % (
dec.doSQLname,
entry_ps,
entry_params,
entry_hspace,
entry_dec,
)
try:
db.execute(sql)
except Exception, e:
print "ERROR in sql insertSimToDB:", e
def connect(self, charSet=None, dbase=None):
try:
if charSet == None and dbase == None:
return self.__connections.getConnection()
if dbase == None:
dbase = self.dbName
# bit ugly but mysqldb docs dont say what the default value for charset is,
# then i could just set the default val for charSet
if charSet != None:
con = mdb.connect(
self.host,
self.user,
self.passwd,
db=dbase,
port=self.port,
charset=charSet)
else:
con = mdb.connect(
self.host,
self.user,
self.passwd,
db=dbase,
port=self.port)
return con
except mdb.Error as dbError:
self.onDBError(dbError)
def putFBrefs(df,auth=authent_local,blocsz=2000):
con = mdb.connect(**auth)
# add as refs table to local db
vals= [ tuple([ None if pd.isnull(v) else v for v in rw]) for rw in df.values ]
sql="""INSERT INTO pub(pubid,title,ref,abstract)
VALUES(
%s,%s,%s,%s)
"""
nadds=len(vals)*1.0
nblocs=int(np.ceil(nadds/blocsz))
print('Adding to references to local db')
with con:
cur=con.cursor()
cur.execute("DROP TABLE IF EXISTS pub")
cur.execute("""CREATE TABLE pub(
pubid INT PRIMARY KEY,
title TEXT,
ref TEXT,
abstract TEXT)
""")
#chunk up to keep from bombing
c=0
for i in range(nblocs):
con = mdb.connect(**auth)
with con:
cur=con.cursor()
if (c+blocsz)>nadds:
cur.executemany(sql,vals[c:])
else:
cur.executemany(sql,vals[c:(c+blocsz)])
c+=blocsz
print('Done')
def save_character(json_data):
json_dict = simplejson.loads(json_data)
username = MySQLdb.escape_string(json_dict['username'])
world_id = MySQLdb.escape_string(json_dict['world_id'])
# TODO save the character
return simplejson.dumps({"success": "true"})
def create_databases(installer_json, config_json):
db_conf = installer_json['database']
db = MySQLdb.connect(host="localhost", user=db_conf['user'], passwd=db_conf['pass'])
cur = db.cursor()
prefix = installer_json['prefix_name']
platforms = config_json['platforms']
sql_path = '../sql/'
for platform in platforms:
path = sql_path + platform + '.sql'
try:
with open(path):
db_name = prefix + '_' + platform + '_main'
print '* Creating ' + platform + ' Database.'
#Step 1
cur.execute('CREATE DATABASE IF NOT EXISTS ' + db_name + ' DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci')
db_platform = MySQLdb.connect(host="localhost", user=db_conf['user'], passwd=db_conf['pass'], db= db_name)
cur_platform = db_platform.cursor()
fo = open(path, "r")
db_script = fo.read()
fo.close()
if(db_script != ''):
cur_platform.execute(db_script)
except IOError:
print '*** Warning: Problem creating ' + platform + ' Database.'
def criartabela_venda(self):
if not os.path.exists('agenciaBeta1.db'):
print 'Banco de Dados existente'
conexao = MySQLdb.connect(self.host,self.user,self.passwd,self.database )
print 'Banco de Dados ja instalado'
conexao = MySQLdb.connect(host="localhost", user="root",passwd="carros", db="agenciaBeta1")
cursor = conexao.cursor()
sql = """create table venven(
codigovenda int(10) PRIMARY kEY Auto_increment NOT NULL UNIQUE,
codigo varchar(60) NOT NULL ,
codigoveiculo varchar(10) NOT NULL ,
codigovendedor varchar(60) NOT NULL ,
formadepagamento varchar(50) not null,
financeira varchar(50)not null,
data varchar(20))"""
print'l'
try:
print ' testando 1'
cursor.execute(sql)
conexao.commit()
print 'testando 2'
except MySQLdb.Error, e:
if e.args[0] == 1050:
print 'Tratando o erro'
self.addTreeViewCliente()
def criartabela_troca(self):
if not os.path.exists('agenciaBeta1.db'):
print 'Banco de Dados existente troca'
conexao = MySQLdb.connect(self.host,self.user,self.passwd,self.database )
print 'Banco de Dados ja instalado troca'
#trocar aqui na linha de baixo o db
conexao = MySQLdb.connect(host="localhost", user="root",passwd="carros", db="agenciaBeta1")
cursor = conexao.cursor()
sqlt = """create table trocae(
codigotroca int(10) PRIMARY kEY Auto_increment NOT NULL UNIQUE,
codigocliente varchar(60) NOT NULL ,
codigoveiculo varchar(10) NOT NULL ,
codigovendedor varchar(60) NOT NULL ,
placa varchar(10) NOT NULL ,
modelo varchar(60) NOT NULL ,
marca varchar(60) NOT NULL ,
ano varchar(60) NOT NULL ,
proprietario varchar(60) NOT NULL ,
valor float(10) ,
data varchar(20))"""
try:
#verifica se o database nomeado acima ja foi criado
print ' uuuu troca'
cursor.execute(sqlt)
conexao.commit()
print 'trocado'
except MySQLdb.Error, e:
if e.args[0] == 1150:
print 'Tratando o erro'
self.addTreeViewCliente()
def getQiubaiDb(password='-'):
setDelimiter('try database connect')
userName='root'
hostName='114.215.108.67'
dbName='test'
portName=3306
try:
conn=mydb.connect(host=hostName,user=userName,passwd=password,db=dbName,port=portName)
except mydb.OperationalError:
while True:
password=raw_input('password for %s:'%userName)
try:
conn=mydb.connect(host=hostName,user=userName,passwd=password,db=dbName,port=portName)
break
except mydb.OperationalError:
continue
curs=conn.cursor()
searchDbSql='SELECT * FROM qiubai'
try:
curs.execute(searchDbSql)
except:
setDelimiter('no DB qiubai found')
setQiubaiDb(curs)
setDelimiter('database well connect')
return (conn,curs)
def fpost():
post = MySQLdb.escape_string(smart_str(request.form['post_text']))
user = MySQLdb.escape_string(smart_str(request.form['user']))
lv = MySQLdb.escape_string(smart_str(request.form['lvalue']))
la = MySQLdb.escape_string(smart_str(request.form['ladr']))
pic = request.files['file']
if pic:
ur = secure_filename(pic.filename)
if '.' not in ur:
ur = "." + ur
if len(get_post_all(user)) > 0:
ur = str(get_post_all(user)[-1][0] + 1) + ur
else:
ur = "1" + ur
pic.save(os.path.join(app.config['UPLOAD_FOLDER'], ur))
ur = "pics/" + ur
else:
ur = "__empty__"
if posting(user, MySQLdb.escape_string(post), ur):
if la:
if la[:7] != "http://":
la = "http://" + la
pi = int(get_post_all(user)[-1][0])
if lv:
put_link(pi, la, lv)
else:
put_link(pi, la)
session['user'] = user
return redirect(url_for("hom"))
def putFBgenerefs(df,auth=authent_local,blocsz=10000):
con = mdb.connect(**auth)
# add as gene references table to local db
vals= [ tuple([ None if pd.isnull(v) else v for v in rw]) for rw in df.values ]
sql="""INSERT INTO generefs(pubid,FBid,symb)
VALUES(
%s,%s,%s)
"""
nadds=len(vals)*1.0
nblocs=int(np.ceil(nadds/blocsz))
print('Adding gene references to local db')
with con:
cur=con.cursor()
cur.execute("DROP TABLE IF EXISTS generefs")
cur.execute("""CREATE TABLE generefs(
generef_id INT AUTO_INCREMENT PRIMARY KEY,
pubid INT,
FBid VARCHAR(50),
symb VARCHAR(100))
""")
#chunk up to keep from bombing
c=0
for i in range(nblocs):
con = mdb.connect(**auth)
with con:
cur=con.cursor()
if (c+blocsz)>nadds:
cur.executemany(sql,vals[c:])
else:
cur.executemany(sql,vals[c:(c+blocsz)])
c+=blocsz
print('Done')
def redirect_short(short):
val = ["shorts.html/" + short]
write_log(["V"],request,val)
if short[len(short)-1] == '_':
db = MySQLdb.connect(host="localhost", user="ashwin_chandak", passwd="ivB2hnBX",db="ashwin_chandak") # database info
cur = db.cursor()
cur.execute("SELECT * FROM clicks WHERE short_id = '%s'" % short[0:len(short)-1])
short_stats = cur.fetchall()
return flask.render_template('stats.html',short_url = short[0:len(short)-1], number_clicks = len(short_stats),stats = short_stats)
# retrieve short string from url
db = MySQLdb.connect(host="localhost", user="ashwin_chandak", passwd="ivB2hnBX",db="ashwin_chandak") # database info
db.autocommit(True)
cur = db.cursor()
cur.execute("SELECT * FROM links WHERE short = '%s'" % short)
# redirect if it's exist
if cur.rowcount > 0:
results = cur.fetchone()
long_url= results[2]
app.logger.debug("redirect to " + long_url)
#Get IP address and json of geolocationdata, so that latitude and longitude entries can be stored in db
ip_address = get_ip(request)
geodata = get_geolocation(ip_address)
cur.execute("INSERT INTO clicks (`short_id`,`ip_address`,`lat`,`long`) VALUES ('%s','%s',%s,%s)" % ( short,ip_address,geodata.get('latitude','NONE'),geodata.get('longitude','NONE')))
return redirect(long_url)
# return 404 if not found
abort(404)
def web_db_insert(self,item):
# try:
# db.insert('t_hh_dianping_tuangou_deal_info',**data)
# except:
# pass
key_str = ','.join('`%s`' % k for k in item.keys())
value_str = ','.join(
'NULL' if v is None or v == 'NULL' else "'%s'" % MySQLdb.escape_string('%s' % v) for v in
item.values())
kv_str = ','.join(
"`%s`=%s" % (k, 'NULL' if v is None or v == 'NULL' else "'%s'" % MySQLdb.escape_string('%s' % v))
for (k, v)
in item.items())
# print kv_str
# print key_str
sql = "INSERT INTO t_hh_dianping_shop_info_pet_hospital(%s) VALUES(%s)" % (key_str, value_str)
sql = "%s ON DUPLICATE KEY UPDATE %s" % (sql, kv_str)
print sql
# with open('eeeeddddd','a') as f:
# f.write(sql+'\n')
# time.sleep(100)
try:
db.query(sql.replace('NULL','0'))
except:
pass
def setUp(self):
_skip_if_no_MySQLdb()
import MySQLdb
try:
# Try Travis defaults.
# No real user should allow root access with a blank password.
self.db = MySQLdb.connect(host='localhost', user='root', passwd='',
db='pandas_nosetest')
except:
pass
else:
return
try:
self.db = MySQLdb.connect(read_default_group='pandas')
except MySQLdb.ProgrammingError as e:
raise nose.SkipTest(
"Create a group of connection parameters under the heading "
"[pandas] in your system's mysql default file, "
"typically located at ~/.my.cnf or /etc/.my.cnf. ")
except MySQLdb.Error as e:
raise nose.SkipTest(
"Cannot connect to database. "
"Create a group of connection parameters under the heading "
"[pandas] in your system's mysql default file, "
"typically located at ~/.my.cnf or /etc/.my.cnf. ")
def upload(upload_rows,table):
try:
if "adconnect" in table:
db = mdb.connect(host="localhost", user="root", db='nami_adconnect_backup')
cur = db.cursor()
query = "REPLACE INTO `nami_adconnect_backup`.`" + table + """`(`DATE`,`PUB_NAME`,`SOURCE_NAME`,`BUDGET DEPLETED / MISCONFIGURATION`,`DAYPART BLOCK`,`CPIP FILTER`,`GEO FILTER`,`IP BLOCK`,`KEYWORD BLOCK`,`REFERER BLOCK`,`MISSING UA/REF`,`IE USER AGENT FILTER`,`CHROME USER AGENT FILTER`,`FIREFOX USER AGENT FILTER`,`SAFARI USER AGENT FILTER`,`OTHER USER AGENT FILTER`,`MAXQUERY THROTTLE`,`FEED FILTERS/TOLERANCES`,`FEED CALLS`,`TIMEOUTS`,`VALID FEED CALLS`,`CALLS PER QUERY`,`FEED COVERAGE`,`VALID FEED COVERAGE`,`PUBLISHER REQUEST RATIO`,`AD RETURN RATIO`,`AD AVAILABLE RATIO`,`CPC CLIPPED`,`EXCESS ADS`,`PUBLISHER USED LISTINGS`,`PUBLISHER COVERAGE`,`AVG PUBLISHER LISTINGS`,`AVG USED LISTINGS`,`GROSS CLICKS`,
`INCOMPLETE URL`,`CLICK TIME FILTER`,`INTERASP FILTER`,`IP MISMATCH`,`UA MISMATCH`,`REFERER MISMATCH`,`CPL FILTER`,`CPQ FILTER`,`CPIP FILTER 2`,`CLICK CAP FILTER`,`COOKIE FILTERED`,`DOMAIN FILTER`,`BACKBUTTON FILTER`,`NO FLASH FILTER`,`OFFSCREEN FILTERED`,`ADVANCED JS FILTERED`,`IFRAME FILTERED`,`TOTAL FILTERED CLICKS`,`ROLLOVER REDIRECT DROPS`,`COOKIE REDIRECT DROPS`,`REFPAGE REDIRECT DROPS`,`JS REDIRECT DROPS`,`TOTAL DROPPED`,`SYSTEM ERRORS`,`TOTAL ERRORS AND DROPS`,`OFFSCREEN`,`ONSCREEN`,`NOSCREEN`,`ROLLOVER CLICKS`,`NON-ROLLOVER CLICKS`,`COOKIE PASS`,`COOKIE FAIL`,`IFRAME PASS`,`IFRAME FAIL`,`ADVANCED JS PASS`,`NATURALPLUS COMPLETE`,`REF ASSIGN JS`,
`NATURAL JS`,`COMPLETED REFPAGE`,`FINAL REDIRECT`,`MAX JS NEG PLUS`,`ESTIMATED NET CLICKS`,`GOOD CLICK RATIO`,`ESTIMATED GROSS REVENUE`,`AVG ESTIMATED GROSS CPC`,`ASP ESTIMATED REVENUE`,`ESTIMATED PUBLISHER REVENUE`,`AVG ESTIMATED PUBLISHER CPC`,`ESTIMATED PUBLISHER ECPM`,`VALID NET CLICKS`,`VALID CLICKS PER PUBLISHER USED LISTINGS`,`VALID CLICK RATIO`,`VALID GROSS REVENUE`,`VALID ASP NET REVENUE`,`VALID PUBLISHER NET REVENUE`,`VALID REVENUE RATIO`,`VALID AVG GROSS CPC`,`VALID AVG PUBLISHER CPC`,`VALID PUBLISHER ECPM`) VALUES (%s,
%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"""
elif "advertiser" in table:
db = mdb.connect(host="localhost", user="root", db='nami_admanager_backup', port=2000)
cur = db.cursor()
query = "REPLACE INTO `nami_admanager_backup`.`" + table + "`(`Date`,`Advertiser`,`Campaign`,`Adgroup`,`Ad`,`Matches`,`Impressions`,`Clicks`,`Conversions`,`Spend`,`Cost`,`CPC`,`Matches_CTR`,`Impressions_CTR`) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
if len(upload_rows)>1000:
chunked = chunk(upload_rows,1000)
for id,row in enumerate(chunked):
cur.executemany(query,row)
db.commit()
print("%s - SUCCESSFULLY INSERTED %s OUT OF %s ROWS INTO DATABASE"%(datetime.now(),len(row),len(upload_rows)))
else:
cur.executemany(query,upload_rows)
db.commit()
print("%s - SUCCESSFULLY INSERTED %s ROWS INTO DATABASE"%(datetime.now(),len(upload_rows)))
except:
print(traceback.print_exc())
def __init__(self, dbname,uname,passwd):
self.__con= MySQLdb.connect('localhost','root', 'root')
self.__cursor=self.__con.cursor()
query="show databases"
self.__cursor.execute(query)
rows=self.__cursor.fetchall()
found=False
for row in rows:
if (str(row[0])==dbname):
found=True
break
#if the database does not exist create it
if(found==False):
query='select user from mysql.user'
self.__cursor.execute(query)
rows=self.__cursor.fetchall()
found=False
for row in rows:
if(str(row[0])==uname):
found=True
break
if(found==False):
query="create user "+uname+"@localhost identified by '"+passwd+"'"
self.__cursor.execute(query)
query='CREATE DATABASE '+str(dbname)
self.__cursor.execute(query)
query="GRANT ALL PRIVILEGES ON "+dbname+".* To "+uname+"@localhost"
self.__cursor.execute(query)
#close the root connection and connect to the database
self.__con.close()
self.__con=MySQLdb.connect('localhost',uname,passwd,dbname)
self.__cursor=self.__con.cursor()
self.__con.commit()
return
def main():
localfile = 'local.txt'
with open(localfile) as f:
g = f.read()
if g == 'True':
local = True
else:
local = False
if local == False:
fldr = 'mlb-dfs/'
serverinfo = security('mysql', fldr)
con = MySQLdb.connect(host=serverinfo[2], user=serverinfo[0], passwd=serverinfo[1], db='MurrDogg4$dfs-mlb')
else:
fldr = ''
con = MySQLdb.connect('localhost', 'root', '', 'dfs-mlb') #### Localhost connection
gameday = datetime.date.today()
datestr = datestring(gameday)[1]
gameList = getSchedule(datestr)
addtoDb(con, gameList, datestr)
return
def read_volt(config):
data = []
chandata = []
#Read from DB
db = MySQLdb.connect("localhost","monitor","1234","smartRectifier")
curs = db.cursor()
cmd = "SELECT srVBat FROM sensorDataCurrent ORDER BY srVBat ASC LIMIT 1"
curs.execute(cmd)
value = curs.fetchone()
db.close()
data.append(value[0])
#Update data to NULL
db = MySQLdb.connect("localhost","monitor","1234","smartRectifier")
curs = db.cursor()
with db:
cmd = 'UPDATE sensorDataCurrent SET srVBat = NULL WHERE name = "currentData"'
curs.execute(cmd)
db.close()
for i in range(len(data)):
chandata.append({"name": "Battery Voltage",
"mode": "float",
"unit": "Custom",
"customunit": "Volt",
"LimitMode": 1,
"LimitMaxError": 70.0,
"LimitMaxWarning": 50.0,
"LimitMinWarning": 40.0,
"LimitMinError": 30.0,
"value": float(data[i])})
return chandata
def connect_to_sql(self, sql_connect, db_name="", force_reconnect=False, create_db=True):
"""
Connect to SQL database or create the database and connect
:param sql_connect: the variable to set
:param db_name: the name of the database
:param force_reconnect: force the database connection
:param create_db: create the database
:return the created SQL connection
"""
print self
if sql_connect is None or force_reconnect:
try:
sql_connect = MySQLdb.connect(host=config.SQL_HOST, user=config.SQL_USERNAME, passwd=config.SQL_PASSWORD, db=db_name)
return sql_connect
except Exception, e:
# Create the database
if e[0] and create_db and db_name != "":
if sql_connect is None:
sql_connect = MySQLdb.connect(host=config.SQL_HOST, user=config.SQL_USERNAME, passwd=config.SQL_PASSWORD)
utils.log("Creating database " + db_name)
cur = sql_connect.cursor()
cur.execute("CREATE DATABASE " + db_name)
sql_connect.commit()
sql_connect.select_db(db_name)
return sql_connect
else:
utils.log("Could not connect to MySQL: %s" % e)
return None
def upload_meta(articleExists, url, title, author, domain, time_pub, text):
gTime = strftime("%Y-%m-%d %H:%M:%S", gmtime())
conn = MySQLdb.connect(host="newshub.c5dehgoxr0wn.us-west-2.rds.amazonaws.com",
user="newshub", passwd="columbiacuj", db="Newshub", charset="utf8")
cursor = conn.cursor()
# since we cannot get the author attribute, so we use the word "author" instead
value = ['', title, author, domain, url, time_pub, gTime, text]
if(articleExists == True):
cursor.execute("insert into articles values (%s, %s, %s, %s, %s, %s, %s, %s)", value);
else:
cursor.execute("insert into deletions values (%s, %s, %s, %s, %s, %s, %s, %s)", value);
conn.commit()
cursor.close()
conn.close()
if(articleExists == True):
print "upload an updated article"
else:
conn = MySQLdb.connect(host="newshub.c5dehgoxr0wn.us-west-2.rds.amazonaws.com",
user="newshub", passwd="columbiacuj", db="Newshub", charset="utf8")
cursor = conn.cursor()
cursor.execute("delete from articles where URL=%s", url)
conn.commit()
cursor.close()
conn.close()
print "move a deleted article"
def signin():
user = MySQLdb.escape_string(smart_str(request.form['Username']))
password = MySQLdb.escape_string(smart_str(request.form['Password']))
if sign_in(user, password):
posts = fget_post_all(user)
return render_template("home.html", posts=posts, Username=user)
return render_template("main-page.html")
def SaveToken_old(token,typeToken,useruid):#typeToken is 0 for facebook token , 1 for twitter token
#check if the token is present in the database
db=MySQLdb.connect(host=HOST,user=DBUSER,passwd=DBPASS,db=DBNAME, use_unicode=True,charset="utf8")
#db=MySQLdb.connect(HOST,DBUSER,DBPASS,DBNAME)
cursor=db.cursor(MySQLdb.cursors.DictCursor)
sql="SELECT count(*) as total FROM accesstoken where accesstoken='"+token+"';"
rowcount=0
try:
queryEsit=cursor.execute(sql)
results=cursor.fetchall()
dicti=results[0]
rowcount=dicti['total']
except:
rowcount=0
cursor.close()
db.close()
if rowcount>0:return
db=MySQLdb.connect(host=HOST,user=DBUSER,passwd=DBPASS,db=DBNAME, use_unicode=True,charset="utf8")
#db=MySQLdb.connect(HOST,DBUSER,DBPASS,DBNAME)
cursor=db.cursor(MySQLdb.cursors.DictCursor)
sql="INSERT INTO accesstoken (accesstoken,type,user_uid) VALUES ('%s',%d,%d);"%(token,typeToken,useruid)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
cursor.close()
db.close()
def fun():
user = MySQLdb.escape_string(smart_str(request.form['user']))
unf = MySQLdb.escape_string(smart_str(request.form['unf']))
if unfollow(user, unf):
posts = fget_post_all(user)
return render_template("home.html", posts=posts, Username=user)
return render_template("main-page.html")
def open_master_connection():
"""
Open a connection on the master
"""
if options.defaults_file:
conn = MySQLdb.connect(read_default_file = options.defaults_file)
config = ConfigParser.ConfigParser()
try:
config.read(options.defaults_file)
except:
pass
username = config.get('client','user')
password = config.get('client','password')
port_number = int(config.get('client','port'))
else:
username = options.user
port_number = options.port
if options.prompt_password:
password=getpass.getpass()
else:
password=options.password
conn = MySQLdb.connect(
host = options.host,
user = username,
passwd = password,
port = options.port,
unix_socket = options.socket)
return conn, username, password, port_number
def run(request):
PATH_VAR=request.path
path=PATH_VAR.split('/')
path_var=path[1]
output= None
status=database_status(path_var)
if status == "disable":
p= subprocess.Popen(["/bin/bash","/home/tcs/DEVOPS_MIGRATION/myproject/vm_launch.sh",path_var,' &'], stdout=subprocess.PIPE)
output, err = p.communicate()
print output
cnx = MySQLdb.connect(user='root', passwd="test",db="Devops")
cur = cnx.cursor()
cur.execute("update devops_images set status='running' where image_name="+`str(path_var)`)
cnx.commit()
elif status == "running":
p= subprocess.Popen(["/bin/bash","/home/tcs/DEVOPS_MIGRATION/myproject/vm_terminate.sh",path_var], stdout=subprocess.PIPE)
output, err = p.communicate()
cnx = MySQLdb.connect(user='root', passwd="test",db="Devops")
cur = cnx.cursor()
cur.execute("update devops_images set status='disable' where image_name="+`str(path_var)`)
cnx.commit()
t = loader.get_template('click.html')
files_path=database_path()
# bashCommand = "sh /home/tcs/test-launch.sh "+path_var
# os.system(bashCommand)
if status=="running":
c = RequestContext(request,{'path':path_var,'button_name':'Terminate','test':files_path})
return HttpResponse(t.render(c))
else:
#print "OUTPUT HI"
c = RequestContext(request,{'path':path_var,'button_name':'Deploy','test':files_path})
return HttpResponse(t.render(c))
