def _connect_to_db(self): # connect to db at class init and use it globally if DB == "mysql": class MySQLCursorDict(database.cursor.MySQLCursor): def _row_to_python(self, rowdata, desc=None): row = super(MySQLCursorDict, self)._row_to_python(rowdata, desc) if row: return dict(zip(self.column_names, row)) return None self.dbcon = database.connect( database=common.db_name, user=common.db_user, password=common.db_pass, host=common.db_address, buffered=True, charset="utf8", ) self.dbcur = self.dbcon.cursor(cursor_class=MySQLCursorDict, buffered=True) else: self.dbcon = database.connect(self.db) self.dbcon.row_factory = ( database.Row ) # return results indexed by field names and not numbers so we can convert to dict self.dbcon.text_factory = str self.dbcur = self.dbcon.cursor()
def onPlayBackStarted(self): xbmc.log("1Channel: Service: Playback started") self.tracking = self.check() if self.tracking: xbmc.log("1Channel: Service: tracking progress...") win = xbmcgui.Window(10000) self.title = win.getProperty("1ch.playing.title") self.imdb = win.getProperty("1ch.playing.imdb") self.season = win.getProperty("1ch.playing.season") self.year = win.getProperty("1ch.playing.year") self.episode = win.getProperty("1ch.playing.episode") if self.season or self.episode: self.video_type = "tvshow" else: self.video_type = "movie" self._totalTime = self.getTotalTime() sql = "SELECT bookmark FROM bookmarks WHERE video_type=? AND title=? AND season=? AND episode=? AND year=?" if DB == "mysql": sql = sql.replace("?", "%s") db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: db = database.connect(db_dir) cur = db.cursor() cur.execute(sql, (self.video_type, self.title, self.season, self.episode, self.year)) bookmark = cur.fetchone() db.close() if bookmark: bookmark = float(bookmark[0]) if not (self._sought and (bookmark - 30 > 0)): question = "Resume %s from %s?" % (self.title, format_time(bookmark)) resume = xbmcgui.Dialog() resume = resume.yesno(self.title, "", question, "", "Start from beginning", "Resume") if resume: self.seekTime(bookmark) self._sought = True
def mysql(u,username='******',password=''): try: mconn.connect(host=u,user=username, password=password) return True except Exception as e: pass return False
def ListAlbum(url): sql = 'SELECT distinct artist_url,album,img FROM songs where artist_url=? order by album' if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) sql = sql.replace('?','%s') else: db = database.connect( db_dir ) cur = db.cursor() cur.execute(sql, (url,)) favs = cur.fetchall() artist="" totalalbum = 0 addLink("Refresh Album Database",url,9,"") for row in favs: totalalbum=totalalbum+1 arturl = row[0] album = row[1] albumimg = row[2] addDir(album,arturl,7,albumimg) db.close() if(totalalbum==0): (SongList,xmlpath)=GetSongs(url) for albid,auth,alimg,alname,tracks in SongList: addDir(TAG_RE.sub('', alname),url,7,xmlpath+alimg)
def onPlayBackStarted(self): xbmc.log('1Channel: Service: Playback started') self.tracking = self.check() if self.tracking: xbmc.log('1Channel: Service: tracking progress...') win = xbmcgui.Window(10000) self.title = win.getProperty('1ch.playing.title') self.imdb = win.getProperty('1ch.playing.imdb') self.season = win.getProperty('1ch.playing.season') self.year = win.getProperty('1ch.playing.year') self.episode = win.getProperty('1ch.playing.episode') if self.season or self.episode: self.video_type = 'tvshow' else: self.video_type = 'movie' self._totalTime = self.getTotalTime() sql = 'SELECT bookmark FROM bookmarks WHERE video_type=? AND title=? AND season=? AND episode=? AND year=?' if DB == 'mysql': sql = sql.replace('?', '%s') db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: db = database.connect(db_dir) cur = db.cursor() cur.execute(sql, (self.video_type, self.title, self.season, self.episode, self.year)) bookmark = cur.fetchone() db.close() if bookmark: bookmark = float(bookmark[0]) if not (self._sought and (bookmark - 30 > 0)): question = 'Resume %s from %s?' % (self.title, format_time(bookmark)) resume = xbmcgui.Dialog() resume = resume.yesno(self.title, '', question, '', 'Start from beginning', 'Resume') if resume: self.seekTime(bookmark) self._sought = True
def ListArtist(url,arttype): sql = 'SELECT * FROM artist where art_type =? ORDER BY name' if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) sql = sql.replace('?','%s') else: db = database.connect( db_dir ) cur = db.cursor() cur.execute(sql, (arttype,)) favs = cur.fetchall() artist="" totalartist = 0 addLink("Refresh Artist Database",url+"|"+arttype,8,"") for row in favs: totalartist=totalartist+1 artistname = row[0] artisturl = row[1].replace(" ","%20") artistimg = row[2] addDir(artistname,artisturl,6,artistimg) db.close() if(totalartist==0): artistlist=GetArtist(url,arttype) for vurl,vimg,aname in artistlist: cursql="" addDir(TAG_RE.sub('', aname),vurl,6,vimg)
def __init__(self, db_host='localhost', db_user='', db_user_passwd='', db_name='', charset = '', debug = 0, db_port=3306, curstype='TUPLE'): """ 初始化数据库连接 @param db_host: 地址 @param db_user: 用户名 @param db_user_passwd: 密码 @param db_name: 数据库名称 @param charset: 字符集 @param debug: 调试模式 @param db_port: 端口号 """ try: if isinstance(db_host, unicode):db_host = db_host.encode('utf8') if isinstance(db_user, unicode):db_user = db_user.encode('utf8') if isinstance(db_user_passwd, unicode):db_user_passwd = db_user_passwd.encode('utf8') if isinstance(db_name, unicode):db_name = db_name.encode('utf8') if isinstance(charset, unicode):charset= charset.encode('utf8') if isinstance(db_port, unicode):db_port= db_port.encode('utf8') if isinstance(db_port, str):db_port= int(db_port) if charset != '': self.mdb = dblib.connect(host=db_host, port=db_port, user=db_user, passwd=db_user_passwd, db=db_name, charset=charset, use_unicode = False ) #, charset='utf8' self.charset = charset else: self.mdb = dblib.connect(db_host, db_user, db_user_passwd, db_name, db_port ) self.debug = debug #print "character_set_name:",self.mdb.character_set_name() except dblib.Error, error: print "Connect MySql[%s %s/%s %s] DB Error:"%(db_host,db_user,db_user_passwd,db_name),error,"\n"
def __init__(self, addon_id, sys_argv=''): #Check if a path has been set in the addon settings if common.db_path: self.path = xbmc.translatePath(common.db_path) else: self.path = xbmc.translatePath(common.default_path) self.addon_id = addon_id self.sys_argv = sys_argv self.cache_path = common.make_dir(self.path, '') self.addon = Addon(self.addon_id, self.sys_argv) self.db = os.path.join(self.cache_path, self.local_db_name) # connect to db at class init and use it globally if DB == 'mysql': class MySQLCursorDict(database.cursor.MySQLCursor): def _row_to_python(self, rowdata, desc=None): row = super(MySQLCursorDict, self)._row_to_python(rowdata, desc) if row: return dict(zip(self.column_names, row)) return None self.dbcon = database.connect(common.db_name, common.db_user, common.db_pass, common.db_address, buffered=True, charset='utf8') self.dbcur = self.dbcon.cursor(cursor_class=MySQLCursorDict, buffered=True) else: self.dbcon = database.connect(self.db) self.dbcon.row_factory = database.Row # return results indexed by field names and not numbers so we can convert to dict self.dbcon.text_factory = str self.dbcur = self.dbcon.cursor() self._create_favorites_tables()
def connect_db(): if DB == 'mysql': db = orm.connect(database=DB_NAME, user=DB_USER, password=DB_PASS, host=DB_ADDR, buffered=True) else: db = orm.connect(DB_DIR) db.text_factory = str return db
def __connect_to_db(self): if not self.db: if self.db_type == DB_TYPES.MYSQL: self.db = db_lib.connect(database=self.dbname, user=self.username, password=self.password, host=self.address, buffered=True) else: self.db = db_lib.connect(self.db_path) self.db.text_factory = str
def __init__(self): #Check if a path has been set in the addon settings db_path = common.addon.get_setting('local_db_location') if db_path: self.path = xbmc.translatePath(db_path) else: self.path = xbmc.translatePath('special://profile/addon_data/script.icechannel/databases') self.path = common.make_dir(self.path, '') self.db = os.path.join(self.path, self.local_db_name) # connect to db at class init and use it globally if DB == 'mysql': class MySQLCursorDict(database.cursor.MySQLCursor): def _row_to_python(self, rowdata, desc=None): row = super(MySQLCursorDict, self)._row_to_python(rowdata, desc) if row: return dict(zip(self.column_names, row)) return None self.dbcon = database.connect(database=common.addon.get_setting('db_name'), user=common.addon.get_setting('db_user'), password=common.addon.get_setting('db_pass'), host=common.addon.get_setting('db_address'), buffered=True, charset='utf8') self.dbcur = self.dbcon.cursor(cursor_class=MySQLCursorDict, buffered=True) else: self.dbcon = database.connect(self.db) self.dbcon.row_factory = database.Row # return results indexed by field names and not numbers so we can convert to dict self.dbcon.text_factory = str self.dbcur = self.dbcon.cursor() self._create_subscription_tables()
def ListSongs(artist_url,album): sql = 'SELECT artist_url,album, img, name,url FROM songs where artist_url=? and album =? ORDER BY name' if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) sql = sql.replace('?','%s') else: db = database.connect( db_dir ) cur = db.cursor() cur.execute(sql, (artist_url,album)) favs = cur.fetchall() artist="" totalsong = 0 xbmc.PlayList(0).clear() addLink("Play All",artist_url,10,"") for row in favs: totalsong=totalsong+1 arturl = row[0] album=row[1] songImg=row[2] songname = row[3] songurl = row[4].replace(" ","%20") addPlaylist(songname,songurl,songImg,"") songitem(songname,songurl,songImg,album,artist, totalsong) db.close()
def initDatabase(): print 'Building Khmermusic Database' if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) cur = db.cursor() cur.execute('CREATE TABLE IF NOT EXISTS artist ( name TEXT,artist_url VARCHAR(255) UNIQUE,img VARCHAR(255) ,art_type VARCHAR(255),PRIMARY KEY (url))') cur.execute('CREATE TABLE IF NOT EXISTS songs (artist_url VARCHAR(255), album TEXT,img VARCHAR(255) ,name TEXT, url VARCHAR(255) UNIQUE,PRIMARY KEY (url))') cur.execute('CREATE TABLE IF NOT EXISTS playlist (playlist_id,url VARCHAR(255), name UNIQUE)') else: if not os.path.isdir(os.path.dirname(db_dir)): os.makedirs(os.path.dirname(db_dir)) db = database.connect(db_dir) db.execute('CREATE TABLE IF NOT EXISTS artist (name,artist_url PRIMARY KEY,img, art_type)') db.execute('CREATE TABLE IF NOT EXISTS songs ( artist_url, album TEXT,img,name, url PRIMARY KEY)') db.execute('CREATE TABLE IF NOT EXISTS playlist (playlist_id INTEGER PRIMARY KEY AUTOINCREMENT,song_id,url, name)') db.commit() db.close()
def onPlayBackStopped(self): xbmc.log('1Channel: Playback Stopped') if self.tracking: playedTime = int(self._lastPos) watched_values = [.7, .8, .9] min_watched_percent = watched_values[int(ADDON.getSetting('watched-percent'))] percent = int((playedTime / self._totalTime) * 100) pTime = format_time(playedTime) tTime = format_time(self._totalTime) xbmc.log('1Channel: Service: %s played of %s total = %s%%' % (pTime, tTime, percent)) if playedTime == 0 and self._totalTime == 999999: raise RuntimeError('XBMC silently failed to start playback') elif ((playedTime / self._totalTime) > min_watched_percent) and ( self.video_type == 'movie' or (self.season and self.episode)): xbmc.log('1Channel: Service: Threshold met. Marking item as watched') if self.video_type == 'movie': videotype = 'movie' else: videotype = 'episode' ChangeWatched(self.imdb, videotype, self.title, self.season, self.episode, self.year, watched=7) if self.librarymode: dbidnum = xbmc.getInfoLabel('ListItem.DBID') if dbidnum != 0: if self.video_type == 'movie': jsonquery = '{"jsonrpc": "2.0", "method": "VideoLibrary.SetMovieDetails", "params": {"movieid" : %s, "playcount" : 1 }, "id": 1 }' else: jsonquery = '{"jsonrpc": "2.0", "method": "VideoLibrary.SetEpisodeDetails", "params": {"episodeid" : %s, "playcount" : 1 }, "id": 1 }' jsonquery = jsonquery % dbidnum xbmc.log('1Channel: Service: Updating Library. Json query is %s' % jsonquery) xbmc.executeJSONRPC(jsonquery) sql = 'DELETE FROM bookmarks WHERE video_type=? AND title=? AND season=? AND episode=? AND year=?' if DB == 'mysql': sql = sql.replace('?', '%s') db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: db = database.connect(db_dir) cur = db.cursor() cur.execute(sql, (self.video_type, unicode(self.title, 'utf-8'), self.season, self.episode, self.year)) db.commit() db.close() else: xbmc.log('1Channel: Service: Threshold not met. Saving bookmark') sql = 'REPLACE INTO bookmarks (video_type, title, season, episode, year, bookmark) VALUES(?,?,?,?,?,?)' if DB == 'mysql': sql = sql.replace('?', '%s') db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: sql = 'INSERT or ' + sql db = database.connect(db_dir) cur = db.cursor() cur.execute(sql, (self.video_type, unicode(self.title, 'utf-8'), self.season, self.episode, self.year, playedTime)) db.commit() db.close() self.reset()
def __init__(self): try: self.dbConnection = mysql.connect(host='localhost',user='******',db='dewi_experiments',buffered=True) except mysql.Error, e: self.dbConnection = mysql.connect(host='localhost',user='******',buffered=True) cursor = self.dbConnection.cursor() cursor.execute("CREATE DATABASE dewi_experiments DEFAULT CHARACTER SET 'utf8'") self.dbConnection.database = 'dewi_experiments'
def SaveData(SQLStatement): #8888 if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: db = database.connect( db_dir ) cursor = db.cursor() cursor.execute(SQLStatement) db.commit() db.close()
def initDatabase(): if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) cur = db.cursor() cur.execute('CREATE TABLE IF NOT EXISTS favorites (type VARCHAR(10), name TEXT, url VARCHAR(255) UNIQUE, imgurl VARCHAR(255))') else: if not os.path.isdir(os.path.dirname(db_dir)): os.makedirs(os.path.dirname(db_dir)) db = database.connect(db_dir) db.execute('CREATE TABLE IF NOT EXISTS favorites (type, name, url, imgurl)') db.commit() db.close()
def upgrade_db(): _1CH.log('Upgrading db...') for table in ('subscriptions', 'favorites'): sql = "UPDATE %s SET url = replace(url, 'http://www.1channel.ch', '')" % table if DB == 'mysql': db = orm.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDR, buffered=True) else: db = orm.connect(DB_DIR) cur = db.cursor() cur.execute(sql) db.commit() db.close()
def _insert_metadata(self, table): ''' Batch insert records into existing cache DB Used to add extra meta packs to existing DB Duplicate key errors are ignored Args: table (str): table name to select from/insert into ''' common.addon.log('Inserting records into table: %s' % table, 0) # try: if DB == 'mysql': try: from sqlite3 import dbapi2 as sqlite except: from pysqlite2 import dbapi2 as sqlite db_address = common.addon.get_setting('db_address') db_port = common.addon.get_setting('db_port') if db_port: db_address = '%s:%s' %(db_address,db_port) db_user = common.addon.get_setting('db_user') db_pass = common.addon.get_setting('db_pass') db_name = common.addon.get_setting('db_name') db = database.connect(db_name, db_user, db_pass, db_address, buffered=True) mysql_cur = db.cursor() work_db = sqlite.connect(self.work_videocache); rows = work_db.execute('SELECT * FROM %s' %table).fetchall() cur = work_db.cursor() rows = cur.execute('SELECT * FROM %s' %table).fetchall() if rows: cols = ','.join([c[0] for c in cur.description]) num_args = len(rows[0]) args = ','.join(['%s']*num_args) sql_insert = 'INSERT IGNORE INTO %s (%s) VALUES(%s)'%(table, cols, args) mysql_cur.executemany(sql_insert, rows) work_db.close() else: sql_insert = 'INSERT OR IGNORE INTO %s SELECT * FROM work_db.%s' % (table, table) common.addon.log('SQL Insert: %s' % sql_insert, 0) common.addon.log(self.work_videocache, 0) db = database.connect(self.videocache) db.execute('ATTACH DATABASE "%s" as work_db' % self.work_videocache) db.execute(sql_insert) # except Exception, e: # common.addon.log('************* Error attempting to insert into table: %s with error: %s' % (table, e), 4) # pass # return False db.commit() db.close() return True
def DeleteFav(name,url): builtin = 'XBMC.Notification(Remove Favorite,Removed '+name+' from Favorites,2000)' xbmc.executebuiltin(builtin) sql_del = 'DELETE FROM favorites WHERE name=%s AND url=%s' if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: db = database.connect( db_dir ) db.text_factory = str sql_del = sql_del.replace('%s','?') cursor = db.cursor() cursor.execute(sql_del, (name, url)) db.commit() db.close()
def onPlayBackStopped(self): try: xbmc.log('PrimeWire: Playback Stopped') except: pass if self.tracking: playedTime = int(self._lastPos) watched_values = [.7, .8, .9] min_watched_percent = watched_values[int(ADDON.getSetting('watched-percent'))] percent = int((playedTime / self._totalTime) * 100) pTime = format_time(playedTime) tTime = format_time(self._totalTime) try: xbmc.log('PrimeWire: Service: %s played of %s total = %s%%' % (pTime, tTime, percent)) except: pass if playedTime == 0 and self._totalTime == 999999: raise RuntimeError('XBMC silently failed to start playback') elif ((playedTime / self._totalTime) > min_watched_percent) and ( self.video_type == 'movie' or (self.season and self.episode)): try: xbmc.log('PrimeWire: Service: Threshold met. Marking item as watched') except: pass if self.video_type == 'movie': videotype = 'movie' else: videotype = 'episode' ChangeWatched(self.imdb, videotype, self.title, self.season, self.episode, self.year, watched=7) sql = 'DELETE FROM bookmarks WHERE video_type=? AND title=? AND season=? AND episode=? AND year=?' if DB == 'mysql': sql = sql.replace('?', '%s') db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: db = database.connect(db_dir) cur = db.cursor() cur.execute(sql, (self.video_type, unicode(self.title, 'utf-8'), self.season, self.episode, self.year)) db.commit() db.close() else: try: xbmc.log('PrimeWire: Service: Threshold not met. Saving bookmark') except: pass sql = 'REPLACE INTO bookmarks (video_type, title, season, episode, year, bookmark) VALUES(?,?,?,?,?,?)' if DB == 'mysql': sql = sql.replace('?', '%s') db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: sql = 'INSERT or ' + sql db = database.connect(db_dir) cur = db.cursor() cur.execute(sql, (self.video_type, unicode(self.title, 'utf-8'), self.season, self.episode, self.year, playedTime)) db.commit() db.close() self.reset()
def test_connect(self): """Interface exports the connect()-function""" self.assertTrue(inspect.isfunction(myconn.connect), "Module does not export the connect()-function") cnx = myconn.connect(use_pure=True, **tests.get_mysql_config()) self.assertTrue(isinstance(cnx, myconn.connection.MySQLConnection), "connect() not returning by default pure " "MySQLConnection object") if tests.MYSQL_CAPI: # By default use_pure=False cnx = myconn.connect(**tests.get_mysql_config()) self.assertTrue(isinstance(cnx, myconn.connection_cext.CMySQLConnection), "The connect()-method returns incorrect instance")
def conn(self): """ This is a cross between other connection properties I've seen and my own experimentation for dealing with an annoyingly intermittent connection. I guess it'd be nice if it could wait a while and try again in the event of a missing connection, but I suppose it just waits 60 seconds and then crashes. """ try: if self._db is None: self._db = sqlc.connect(user=self.login, password=self.passwd, host=self.host, database=self.database) except sqlc.Error as e: print ("MySQL exception #{0} getting connection: {1}".format(e.errno, e.msg)) if e.errno == 2003: exit(-1) except Exception as e: print ("Couldn't get connection property: {0}".format(e.message)) finally: return self._db
def SaveData(SQLStatement): #8888 if DB == 'mysql': db = database.connect(DB_NAME, DB_USER, DB_PASS, DB_ADDRESS, buffered=True) else: db = database.connect( db_dir ) cursor = db.cursor() #try: # builtin = 'XBMC.Notification(Save Favorite,Added to Favorites,2000)' # xbmc.executebuiltin(builtin) #except database.IntegrityError: # builtin = 'XBMC.Notification(Save Favorite,Item already in Favorites,2000)' # xbmc.executebuiltin(builtin) cursor.execute(SQLStatement) db.commit() db.close()
def conv_db_htmin2daily(db_table, inst_file, out_table = 'hist_fut_daily', database = 'hist_data'): conf_dict = {} instIDs = [] if inst_file == '': instIDs = get_col_dist_values(database + '.' + db_table, 'instID',{}) conf_dict = {'instIDs': instIDs} try: inst_file = 'instID_file.json' with open(inst_file, 'w') as ofile: json.dump(conf_dict, ofile) except: pass else: with open(inst_file, 'r') as infile: conf_dict = json.load(infile) instIDs = conf_dict['instIDs'] dbconfig = {'user': '******', 'password':'******', 'host':'localhost', 'database': database} cnx = mysqlconn.connect(**dbconfig) for inst in instIDs: mdf = load_hist_min(db_table, inst) if len(mdf) == 0: continue ddf = conv_min2daily(mdf) ddf.to_sql(name = out_table, flavor = 'mysql', con = cnx, if_exists='append') cnx.commit() print inst, len(ddf) cnx.close() return
def copia_tablas(): exporta = ['not_clasif', 'noticias', 'not_relacion', 'not_nombres_relaciones', \ 'not_importancia_noticias', 'not_importancia_ners', 'not_imagenes', 'ners']; try: con = my.connect(**con_data) except my.Error as err: print(format(err)) cur = con.cursor() for tabla in exporta: copia = "/var/www/noticias"+DIR_LOCAL+tabla+".sql" if os.path.exists(copia): try: os.remove(copia) except OSError as err: print(format(err)) sys.exit() q = "SELECT * INTO OUTFILE '%s' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' \ LINES TERMINATED BY '\n' FROM %s" % (copia, tabla) try: cur.execute(q) except my.Error as err: print(format(err)) sys.exit() print("%s copiada con exito a %s" % (tabla, copia))
def get_conexao(self): _host = 'localhost' _name = 'namedatabase' _user = '******' _passwd = 'passwd' db = msc.connect(host=_host, database=_name, user=_user, passwd=_passwd) return db
def main(): # Connect to the DB # host='24.205.232.5' conn = mysql.connect( host='127.0.0.1', user='******', passwd='tweetlection12', db='tweetlection' ) cursor = conn.cursor() tweets = None; # Pull the first 100 tweets try: cursor.execute( "SELECT text, retweet_count FROM tweets " "WHERE retweet_count > 1000 " "GROUP BY text " "HAVING max(retweet_count) " "ORDER BY retweet_count") tweets = cursor.fetchall() for tweet in tweets: print tweet except Exception, e: raise e
def load_hist_min(db_table, instID): dbconfig = {'user': '******', 'password':'******', 'host':'localhost', 'database': 'hist_data'} stmt = "select instID, exch, datetime, date, min_id, open, high, low, close, volume, openInterest from {dbtable} where instID='{inst}' ".format(dbtable=db_table, inst=instID) stmt += "order by date, min_id;" cnx = mysqlconn.connect(**dbconfig) df = pd.io.sql.read_sql(stmt, cnx, index_col = 'datetime') return df
def sql_read(self): sql_file_picked = [] sql_file_picked.append(AggregateFunctionsAndGroupBy.sql_files_list[int(self.picked_menu_number) - 1]) sql_file = [] for picked_file in sql_file_picked: file = open( "c:/Pycharm_Projects/week_8a_sql/queries/queries_02_aggregate_functions_and_group_by/" + picked_file, "r", ) sql_file.append(file.read()) file.close() connect = mysql_connector.connect( user="******", password="******", host="127.0.0.1", charset="utf8", use_unicode=True, autocommit=True, ) cursor = connect.cursor() for one_command in sql_file: for one_data in cursor.execute(one_command, multi=True): for cursor_message in cursor: print(cursor_message) connect.close()
from xml.etree import ElementTree as ET from mysql.connector import connect from mysql.connector.errors import IntegrityError import re import time import sys import os dir = '/home/andre/Desktop/Sistema/NFe' # Diretório para testes pretag = '{http://www.portalfiscal.inf.br/nfe}' mydb = connect(host='localhost', user='******', passwd='', database='rodabras') def ext_emitente(arq): dict = {} emit = arq.find(pretag + 'NFe').find(pretag + 'infNFe').find(pretag + 'emit') ender_emit = emit.find(pretag + 'enderEmit') cnpj_cpf = emit.find(pretag + 'CNPJ') if cnpj_cpf is not None: dict['cnpj_cpf'] = cnpj_cpf else: dict['cnpj_cpf'] = emit.find(pretag + 'CPF') dict['nome'] = emit.find(pretag + 'xNome') dict['fantasia'] = emit.find(pretag + 'xFant') dict['logradouro'] = ender_emit.find(pretag + 'xLgr') dict['numero'] = ender_emit.find(pretag + 'nro') dict['complemento'] = ender_emit.find(pretag + 'xCpl') dict['bairro'] = ender_emit.find(pretag + 'xBairro')
from jinja2 import Markup import mysql.connector as sql # infoDict['js']= Markup(js) ENV_FILE = find_dotenv() if ENV_FILE: load_dotenv(ENV_FILE) app = Flask(__name__) app.debug = True app.secret_key = "super secret key" # Here i am making a connection with mysql database hosted by the xampp server! db = sql.connect(host="localhost", user="******", password="", database="project_wang_reda") # Then i am making a cursor to execute sql commands in the following below functions and decorators cursor = db.cursor() @app.errorhandler(Exception) def handle_auth_error(ex): response = jsonify(message=str(ex)) response.status_code = (ex.code if isinstance(ex, HTTPException) else 500) return response oauth = OAuth(app) auth0 = oauth.register(
import mysql.connector as con import json import csv mydb = con.connect( host="localhost", user="******", passwd="MYSQL123", db="demo" ) cur=mydb.cursor() cur.execute("select * from json_to_db ") res=cur.fetchall() for x in res: print(x) print(res) li=[] for x,y in res: li.append(x) print(li) d0={} for word in li: if word not in d0: d0[word]=1 else: d0[word]+=1 print(d0) li2=list(d0.keys())
def update_null(): try: with connect(host=HOST, user=DB_USER, password=DB_PASS, database=DB_NAME, autocommit=True) as connection: with connection.cursor(buffered=True) as cursor: #fetch tables from database cursor.execute("SHOW TABLES") for table in cursor: print(table) #manually select table from options create_query = "SELECT * FROM {}" selected_table = input("Which table? ") cursor.execute(create_query.format(selected_table)) #fetch columns from table and create a list describe_query = "DESCRIBE {}" cursor.execute(describe_query.format(selected_table)) meta = cursor.fetchall() column_names = [] for row in meta: column_names.append(row[0]) #check for empty cell and insert value def update(): cursor.execute(create_query.format(selected_table)) update_query_total = "" for row in cursor: row_id = row[0] for cell, column in zip(list(row), column_names): if cell != None and cell != "": pass else: #skip if no value is entered value = input("Input %s for %s: " % (column, row_id)) if value == "": continue update_query = """ UPDATE {} SET {}="{}" WHERE {}={}; """.format( selected_table, #table that needs update column, #column that needs update value, #new value column_names[0], #where id_column row_id, #row_id ) update_query_total = update_query_total + update_query print(update_query_total) return (update_query_total) cursor.execute(update()) except Error as e: print("error: ", e)
import mysql.connector as mysql from mysql.connector import Error import config.db as db import dbconnect as sql import datos_fbgotw as medios import datos_mediamath as mm import datos_adform as adf import datos_mediosextras as mediosextras import datos_adsmovil as am import sys if __name__ == '__main__': # Iniciamos la conexion conn = mysql.connect(host='3.95.117.169', database='MediaPlatformsReports', user='******', password='******', autocommit=True) try: dfni = mediosextras.Spreadsheet(db.PHD_Medios_Externos['key'], db.PHD_Medios_Externos['DATA']) mediosextras.campanas(dfni, conn) mediosextras.metricas_campanas(dfni, conn, 'PHD') # mediosextras.diario_campanas(dfni, conn) except Exception as e: print('Error on line {}'.format(sys.exc_info()[-1].tb_lineno), type(e).__name__, e)
def _opendb(self): self.conn = connector.connect(**self.dbdesc['kwargs'])
import mysql.connector as mariadb mariadb_connection = mariadb.connect(user='******', password='******', database='mysql') cursor = mariadb_connection.cursor()
# Requires the Flask and MySQL libraries # To use this app: # pip install mysql-connector-python from flask import Flask, request from datetime import * import time from mysql.connector import connect import dbconfig from details import * app = Flask(__name__) con = connect(user=dbconfig.DB_USER, password=dbconfig.DB_PASS, database='wsoapp2', host=dbconfig.DB_HOST) cursor = con.cursor() error_msg = ["New service was successfully created!", "Another service is being held at the same time.", "Could not update song.", "The date field was not provided." ] @app.route('/details') #Calls getDetails() def details(): global cursor svc_id = request.args.get('svc_id') return getDetails(svc_id, cursor) #Home page of the website that lists services @app.route('/') def home(): global cursor
def DB_Connect(self): self.conn = mdb.connect(host="localhost", user="******", password="******", database="youtube_tutorial") self.cur = self.conn.cursor()
# Try entering the following in the search box: # 3 or 1=1 import bottle from datetime import datetime from mysql.connector import connect con = connect(user='******', password='******', database='simpledb') cursor = con.cursor() @bottle.route('/') def hello(): qty = 0 if 'qty' in bottle.request.params: qty = bottle.request.params['qty'] # SQL Injection vulnerability here: cursor.execute(""" select ProdId, ProdName, Quantity, ProdNextShipDate from product where Quantity < {0} """.format(qty)) # Also try ProdName = '{0}' # Retrieve results result = cursor.fetchall() table = """ <table> <tr> <td>Product ID`
def establishConnection(): return mc.connect(host='localhost', user='******', passwd='ayushi', db='attendance_management_system')
content = 'From the archive: ' + content elif post_type == 'Archive' and len(tweet_text) > 102: content = 'From the archive: ' + social_queue[n][0] buffer_post(platform, content, page_url) n = +1 def main_proc(): generate_media_queue() daily_loads() global cursor parser = ConfigParser() parser.read("whconfig.ini") wh_host = parser.get('MYSQL', 'host') wh_user = parser.get('MYSQL', 'user') wh_pass = parser.get('MYSQL', 'password') conn = mysql.connect(host=wh_host, user=wh_user, password=wh_pass, database='NovaraWH') cursor = conn.cursor() main_proc()
# ("Priyanka Das", 11, "D"), # ("Rupankar Das", 11, "C") # ] # #myCursor # for x in userData: # myCursor.execute(Q1, x) # myCursor.execute("SELECT * FROM table1 OREDER BY sec ASC/DESC ") # for x in myCursor: # print(x) import mysql.connector as mc db = mc.connect(host = "localhost", user = "******", password = "******", database = "testimonials") Cursor = db.cursor() executer = "DROP TABLE IF EXISTS users" Cursor.execute(executer) db.close()
import mysql.connector as mysql #Connecting to database db = mysql.connect(host="localhost", user="******", password="", database="college") #Creating handler to excute quarys command_handler = db.cursor(buffered=True) # Admin login def auth_admin(): username = input(str("Username : "******"Password : "******"admin": if password == "admin": admin_accs() else: print("Wrong password") else: print("Wrong cradentials") #Admin Work def admin_accs(): while 1: print("Admin Menu") print("1. New Student Entry") print("2. New teacher Entry")
import mysql.connector as conn import time while True: try: db = conn.connect(host="10.0.10.3", user="******", password="******", database="projekt") break except Exception: time.sleep(2) curr = db.cursor() curr.execute( "CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), login VARCHAR(255))" ) insert = "INSERT INTO users (name, login) VALUES (%s, %s)" val = [("Pawel", "paww"), ("Robert", "robb"), ("Jarek", "kwakwa")] curr.executemany(insert, val) db.commit() print(curr.rowcount, " was inserted") def print_menu(): print("1. SELECT") print("2. INSERT") print("3. UDATE") print("4. DELETE")
# -*- coding: utf-8 -*- """ Created on Tue Dec 18 22:20:57 2018 @author: Pippo """ #import pyodbc import mysql.connector as mariadb #import MySQLdb mariadb_connection = mariadb.connect(user='******', password='******', database='hausapp') c = mariadb_connection.cursor() c.execute("DESCRIBE gumtree;") rows = c.fetchall() for eachRow in rows: print(eachRow)
def get_mysql_connection(): mysqlClient = connect(user=MYSQL_USER, password=MYSQL_PASSWORD, host=MYSQL_HOST, database=MYSQL_DATABASE) return mysqlClient
#!/usr/bin/python2 import cgi import commands print 'content-type:text/html' print '' import mysql.connector as mariadb db = mariadb.connect(user='******', password='******', database='welkins') cursor = db.cursor() print ''' <!DOCTYPE html> <html> <head> <style> .but{ background:blue; color:white; text-align:center; text-decoration:none; border-radius:4px; border:2px groove blue; padding:4px; } </style>
from bs4 import BeautifulSoup import urllib.request from FoodParser import FoodParser import sys import fuzzywuzzy as fuzzywuzzy from fuzzywuzzy import process from fuzzywuzzy import fuzz import mysql.connector as mysql # connecting to the database using 'connect()' method # it takes 3 required parameters 'host', 'user', 'passwd' db = mysql.connect(host="localhost", user="******", passwd="3476269507", database="wegmansdb", auth_plugin='mysql_native_password') # # # creating an instance of 'cursor' class which is used to execute the 'SQL' statements in 'Python' class Parser: def __init__(self, url): self.urlData = url urlData = "" parsedIngredients = [] names = [] def ingredientParser(self):
def initialiser(): global conn, cur conn = mysql.connect(**config_mysql) cur = conn.cursor() cur.execute("USE gsb_formation")
# from binascii import a2b_base64 import mysql.connector as conn import os mimeMap = { 'html': 'text/html', 'css': 'text/css', 'js': 'text/javascript', 'json': 'text/json', 'txt': 'text/plain', 'ico': 'image/x-icon', 'jpg': 'image/jpg', 'png': 'image/png' } myDB = conn.connect(user='******', host='localhost', password='******', database='rahul7') myCrsr = myDB.cursor(dictionary=True) rExt = re.compile(r'(?<=\.).+') class Server(BaseHTTPRequestHandler): def _send_headers(self, ext): self.send_response(200) self.send_header('Content-Type', mimeMap[ext]) self.end_headers() def do_GET(self): self.path = '/templates/index.html' if self.path == '/' else '/templates' + self.path ext = re.findall(rExt, self.path)[0]
def __init__(self): try: self.cnx = mysqldb.connect(**dbcfg) self.cursor = self.cnx.cursor(dictionary=True) except mysqldb.Error: log.exception("An exception has occurred in {}: ".format(__name__))
import time import datetime import csv import pandas as pd from PIL import Image import numpy as np #========================= B A C K E N D ==========================# ########################## SQL ########################## import mysql.connector as msql from mysql.connector import Error try: conn = msql.connect(host='localhost', user='******', password='******', db='opencv') cursor = conn.cursor() except Error as e: print("Error while connecting to MySQL", e) ########################## Basic Methods ########################## def path_existence(path): """ This function will create the directory if it does not exist """ dir = os.path.dirname(path) if not os.path.exists(dir): os.makedirs(dir)
# -*- coding: utf-8 -*- import mysql.connector as db import pandas as pd import sys import hashlib import random import traceback NUMBER_OF_USERS = 116903 """def check_hex(val): try: hexval = int(val) """ conn = db.connect(host="localhost", user="******", passwd="PennConnect@123", database="pennconnect") print("connected!") cursor = conn.cursor() print("got cursor!") df_data = pd.read_csv(sys.argv[1]) print("loaded dataframe!") user_id = 1 i = 0 insert_sql = "UPDATE user SET major=\'{}\', degree_type=\'{}\', graduation_year=\'{}\' WHERE user_id=\'{}\'" while (user_id <= NUMBER_OF_USERS): random_major = df_data.sample(1)['Major'].iloc[0] print(random_major) degree_type = random.choice(['UG', 'MS', 'PHD']) graduation_year = random.choice(range(2025, 2018, -1)) try: print("query = " + insert_sql.format(random_major, degree_type,
#!/usr/bin/python2 import cgi,cgitb cgitb.enable() import mysql.connector as mariadb import commands print "Content-type:text/html" print "" web_data=cgi.FieldStorage() uip= web_data.getvalue('uip') password= web_data.getvalue('password') conn=mariadb.connect(user='******',password='******',database='autolab',host='localhost') cursor=conn.cursor() cursor.execute('select uip from user where uip="{}";'.format(uip)) out=cursor.fetchall() if len(out)>0: cursor.execute('delete from user where uip="{}");'.format(uip,password)) conn.commit() print "<body style="'background-color:linen;padding-top:100px;'"><center><h1 style="'color:blue;'"><h1>" print " User Removed." print "</h1></center></body>" print "<meta http-equiv='refresh' content='3;http://127.0.0.1/AutoLab/explore.html'>" else : print "<body style="'background-color:linen;padding-top:100px;'"><center><h1 style="'color:blue;'"><h1>" print " User Doesn't Exists." print "</h1></center></body>" print "<meta http-equiv='refresh' content='3;http://127.0.0.1/delete_client.html'>"
import mysql.connector as m mydb = m.connect(host = "localhost",user = "******", password = "******") mycursor = mydb.cursor() mycursor.execute("create database loginpage") # you should make the aboue statement( mycursor.execute("create database studentdb") ) as comments after you run it once (WHY? we cannot create the same database multiple times) mycursor.execute("show databases") for i in mycursor: print(i)
def main(currency): time.sleep(1) update_tables(currency) with open('config.json') as json_file: file = json.load(json_file) config = file['mysql'] # ============================================================================= # Data # ============================================================================= db_connection = sql.connect(host=config['host'], database=config['database'], user=config['user'], password=config['password'], port=9306) dataset = pd.read_sql_query( 'SELECT id, value from historic_%s order by id desc LIMIT 180' % currency, db_connection, coerce_float=False) db_connection.close() # ============================================================================= # Train & Test # ============================================================================= sc = MinMaxScaler(feature_range=(0, 1)) AUX1 = sc.fit_transform(np.array(dataset["value"]).reshape(-1, 1)) dataset["close_escalado"] = AUX1 train = dataset['close_escalado'] # Pasar a numpy train = np.array(train) # ============================================================================= # Variables para longitudes secuenciales # ============================================================================= predictor_range = 180 prediction_range = 45 # ============================================================================= # Secuencias # ============================================================================= X_train = train y_train = train[-45:] # for i in range(predictor_range, (train.shape[0] - prediction_range)): # X_train.append(train[i - predictor_range:i]) # y_train.append(train[i:i + prediction_range]) # X_train, y_train = np.array(X_train), np.array(y_train) X_train = np.reshape(X_train, (-1, 1, predictor_range)) # y_train = np.reshape(y_train, (-1,1,prediction_range)) y_train = np.reshape(y_train, (-1, prediction_range)) # ============================================================================= # Evaluacion modelo # ============================================================================= # Cojo la ultima secuencia del train, para predecir la siguiente cadena_ultima_X_Y = list(X_train[-1].reshape(-1)) + list( y_train[-1].reshape(-1)) cadena_ultima_X_Y = np.array(cadena_ultima_X_Y[-predictor_range:]).reshape( 1, 1, predictor_range) # ============================================================================= # Modelo DL # ============================================================================= model = tf.keras.models.load_model('CNN_%s.h5' % currency) model.compile(optimizer=tf.train.AdamOptimizer(), loss='mean_squared_error') hypams = { 'epochs': 1, 'batch_size': 32, 'verbose': 1, 'early_stopping': 5, 'min_delta': 0.000001 } callbacks = [ EarlyStopping(monitor='loss', min_delta=hypams['min_delta'], patience=hypams['early_stopping'], verbose=0, mode='min', restore_best_weights=True) ] model.fit(X_train, y_train, epochs=hypams['epochs'], verbose=hypams['verbose'], callbacks=callbacks, batch_size=hypams['batch_size']) # GENERAR PREDICCION prediction = sc.inverse_transform(model.predict(cadena_ultima_X_Y))[0] # GUARDAR PREDICCION EN LA BASE DE DATOS db_connection = sql.connect(host=config['host'], database=config['database'], user=config['user'], password=config['password'], port=9306) db_cursor = db_connection.cursor() first_date = dataset.iloc[0]['id'] first_value = dataset.iloc[0]['value'] date_range = np.array( [first_date + datetime.timedelta(minutes=i) for i in range(1, 46)]) db_cursor.execute( 'INSERT INTO prediction_%s_cnn (id, value) VALUES ("%s", %s) ON DUPLICATE KEY UPDATE value=%s' % (currency, first_date, first_value, first_value)) for n in range(len(prediction)): db_cursor.execute( 'INSERT INTO prediction_%s_cnn (id, value) VALUES ("%s", %s) ON DUPLICATE KEY UPDATE value=%s' % (currency, date_range[n], prediction[n], prediction[n])) db_connection.commit() db_connection.close() model.save("CNN_%s.h5" % currency)
#run this package First...it call trail module whose signup button calls signup page and generaUsernamePassword #submit button will be calling new page full of options to do like irctc # from ekanshDBMS import trial from tkinter import messagebox import mysql.connector as sq #====================================================================> conn = sq.connect(host="localhost", user="******", password="******", database="test2", auth_plugin='mysql_native_password') # catch(ModuleNotFoundError): # print("Handeled") #=====================================================================> def login_in(username, password): cursor = conn.cursor() cursor.execute( "select * from username where username='******'".format(username)) items = cursor.fetchall() for nm, pasd, email in items: nm = str(nm) pasd = str(pasd) # print(type(pasd)) if (nm == username and pasd == password): from ekanshDBMS.venv import AfterLoginSuccess #messagebox.showinfo("Success","Successful Login To YOUR ACCOUNT") #trial.root.destroy() #messagebox.showinfo("success", "All Done..Now Login")
def assistant(speech): cmd=str(speech) delete,p=0,0 if "note" in cmd: print("your voice will be converted to text & will be saved in dictate.txt file") time.sleep(5) print("start") say("start") note() p=1 if "what is the time" in cmd or "show me the time" in cmd or "time" in cmd: t = time.localtime() currenttime = time.strftime("%H:%M", t) a=str(currenttime) if int(a[:2])>0 and int(a[:2])<12: a=a+" AM " if int(a[:2])>=12 and int(a[:2])<24: h=str(int(a[:2])-12) a=h+a[2:]+" PM " atext='The time is '+str(a) say(atext) print(a) p=1 if "set" in cmd and "alarm" in cmd: stop = False tm=str(input("enter time:")) label=str(input("enter label of alarm:")) atext='The alarm is set' myobj = gTTS(text=atext, lang='en') myobj.save("time.mp3") a1="time" playaudio('time.mp3') time.sleep(2) c=0 while stop == False and c!=1: rn = str(datetime.datetime.now().time()) if tm==rn[:8]: print(label,rn[:8]) say("wake up wake up wake up wake up wake up wake up wake up wake up wake up wake up wake up wake up ") c,p=1,1 if "date" in cmd: today = datetime.date.today() atext='The date is '+str(today) say(atext) print("Today's date:", today) p=1 if "calendar" in cmd: today = datetime.date.today() say("calendar of the year is given below") y=str(today) year=y[0:4] print (calendar.calendar(int(year), 2, 1, 6)) p=1 if "who are you" in cmd or "what is your name" in cmd or "your name please" in cmd: print("Hello, my name is Catalina.") say("Hello, my name is Catalina.") p=1 if "translate" in cmd: d={"English":"en","Hindi":"hi","Kannada":"kn","Telugu":"te","Marathi":"mr","French":"fr", "Punjabi":"pa","Korean":"ko","Latin":"la","German":"de",'Malayalam':"ml",'Russian':"ru",'Gujarati':"gu"} lan="English" for i in d: if i in cmd: lan=str(i) else: a=10 l=str(d[lan]) text4=str(input("enter the text to know details:")) s = Translator().translate(text=text4, dest=l).text atext1=str(s) myobj = gTTS(text=atext1, lang=l,slow=False) myobj.save("lantranslate.mp3") playaudio('lantranslate.mp3') print("translated : ",s) p=1 if "one more" in cmd or "again" in cmd: p=1 con1=cs.connect(host="localhost",user="******",passwd="",database="catalina") cursor1=con1.cursor() query1="select * from history" cursor1.execute(query1) dat1=cursor1.fetchall() c,count=-1,0 while count!=6: recent=str((dat1[c])) if "again" not in recent[44:] or recent[44:] is not "" or "one more" not in recent[44:]: sp=recent[44:] assistant(sp) break else: c=c-1 count=count+1 con1.close() if "open" in cmd: p=1#'''or "Open"''': if "open file" in cmd : cmd=cmd[9:] cmd=cmd[1:] print(cmd) print("The file will only be searched in C disk") say("searching file in C disk. Wait .") findfile(cmd) if "" in cmd: cmd=cmd.lower() print(cmd) apps={"chrome":'C:/Program Files/Google/Chrome/Application/chrome.exe', 'powerpoint':'C:/Program Files/Microsoft Office/root/Office16/POWERPNT.exe', 'settings':'C:/Windows/System32/control.exe', 'word':'C:/Program Files/Microsoft Office/root/Office16/WINWORD.exe', 'access':'C:/Program Files/Microsoft Office/root/Office16/MSASCCESS.exe', 'excel':'C:/Program Files/Microsoft Office/root/Office16/EXCEL.exe', 'task manager':'C:/Windows/system32/Taskmgr.exe', 'onenote':'C:/Program Files/Microsoft Office/root/Office16/ONENOTE.exe', 'command prompt':'C:/Windows/system32/cmd.exe', 'onscreen keyboard':'C:/Windows/system32/osk.exe', 'notepad':'C:/Windows/system32/notepad.exe', 'paint':'C:\Windows\system32\mspaint.exe', 'this pc':'C:/'} for i in apps: if str(i) in cmd: p=1 text3="opening"+str(i) say(text3) os.startfile(apps[i]) else: say("i think software is not installed please install the software and then try again") p=1 if "open YouTube" in cmd or "video of" in cmd: if "video of" in cmd or "videos related to" in cmd or "videos" in cmd: url="https://www.youtube.com/results?search_query="+cmd webbrowser.open(url) p=1 if "history" in cmd: if "delete" in cmd : delhistory() p=1 else: say("fetching your data") con1=cs.connect(host="localhost",user="******",passwd="",database="catalina") cursor1=con1.cursor() query1="select * from history" cursor1.execute(query1) p=1 dat1=cursor1.fetchall() for i in dat1: print(i) con1.close() if "os" in cmd or "operating system" in cmd and "my" in cmd: import platform a=str(platform.platform()) say(a) print(a) p=1 if "show me" in cmd or "" in cmd: text3="I found this for you." if "images" in cmd or "photos" in cmd: r1=cmd r1=r1.lstrip("show me images of") url="https://www.google.com/search?q="+str(r1)+"&source=lnms&tbm=isch&sa" say("i found this ") webbrowser.open(url) p=1 if "news" in cmd: r1=cmd r1=r1.lstrip("show me news of") url="https://www.google.com/search?q="+str(r1)+"&tbm=nws&source=lnms&tbm=nws&sa" say("i found this ") webbrowser.open(url) p=1 if "what can you do" in cmd: say("i can do a lot like managing your activities, play a game, set a remainder,entertain,play a video, and a lot more") p=1 if "copy" in cmd: t=cmd[5:] pyperclip.copy(t) say('text copied') p=1 if "game" in cmd or "play" in cmd: if "game" in cmd or "a game" in cmd: url1="https://www.google.com/search?q=tic+tac+toe" url2="https://www.google.com/search?q=minesweeper" url3="https://www.google.com/search?q=play%20snake" url4="https://doodlecricket.github.io" url5="https://www.bing.com/fun/sudoku" url6="https://www.bing.com/fun/chess" r5=random.randint(0,5) url=[url1,url2,url3,url4,url5,url6] url=url[r5] say("OK let's play a game") print(p) p=1 webbrowser.open(url) if "video" in cmd or "music" in cmd or "song" in cmd: g=".mp4" q=5 lst=[] if 'music' in cmd or "song" in cmd: g=".mp3" if q==5: if " " in cmd : say("searching file in c disk") r1=5 for x,d,f in os.walk("c:\\"): for files in f: if g in files: location=str(os.path.join(x,files)) lst.append(location) p=1 w=random.randint(0,len(lst)-1) ob=lst[w] print("location:",ob) os.startfile(ob) if "image to text" in cmd: pr=0 try: from PIL import Image except ImportError: import Image import pytesseract import cv2 file=str(input("enter image name:")) if " " in cmd : say("searching file in c disk") for x,d,f in os.walk("c:\\"): if pr==0: for files in f: if files ==file and pr==0: location=str(os.path.join(x,files)) print("location of file------ ",location) img = cv2.imread(location) p,pr=1,1 print("____________________________IMAGE PROCESSED TO TEXT________________________________") print(pytesseract.image_to_string(Image.open(location))) project() break if "screenshot" in cmd or "take a photo of my screen" in cmd: time.sleep(5) if __name__ == '__main__': im = ImageGrab.grab() say("screenshot taken") n=str(input("enter name of the file:")) im.save(n+'.png') p=1 time.sleep(3) im.show() if "tell me a joke" in cmd or "make me laugh" in cmd or "make me smile" in cmd or " joke " in cmd: j1='''A snail walks into a bar and the barman tells him there's a strict policy about having snails in the bar and so kicks him out.A year later the same snail re-enters the bar and asks the barman "What did you do that for?''' j2='''Three mice are being chased by a cat. The mice were cornered when one of the mice turned around and barked, "Ruff! Ruff! Ruff!" The surprised cat ran away scared. Later when the mice told their mother what happened, she smiled and said, "You see, it pays to be bilingual!"''' j3='''A nervous old lady on a bus was made even more nervous by the fact that the driver periodically took his arm out of the window. When she couldn't stand it any longer, she tapped him on the shoulder and whispered on his ear: "Young man...you keep both hands on the wheel...I'll tell you when it's raining!"''' j4='''Customer: Waiter, waiter! There is a frog in my soup!!! Waiter: Sorry, sir. The fly is on vacation. ''' j=[j1,j2,j3,j4] w1=random.randint(0,3) select=j[w1] say(select) for i in select: print(i,end="") time.sleep(0.047) print() p=1 if "search for" in cmd: cmd=cmd.lstrip("search for") url="https://www.google.com/search?q="+cmd+"&source" say("i found this according to your search") p=1 webbrowser.open(url) if "credits" in cmd or "made" in cmd and "you" in cmd: say("this is an open source project made by varun, mayank, souranh hope you liked it") p=1 if "features" in cmd or "help" in cmd: features=["opening a file/app","entertain","search","weather","calculate","history","game","quiz","puzzle","video", "take screenshot","download video","show time","note","OCR from image","alarm","math problems",'Q and A',"and many more"] for i in features: say(i) print(i) p=1 if "feedback" in cmd: say("feel free to leave your feedback") os.startfile(cloc+"\\"+"main.html") p=1 if "hello" in cmd: say('hello, how can I help you') p=1 if "close" in cmd or "turn off"in cmd or "shutdown" in cmd and "computer" in cmd : os.system("shutdown -s") say("shutting down in minute") p=1 if "restart" in cmd and"computer" in cmd: os.system("shutdown /r /t 1") p=1 if "exit" in cmd or "quit" in cmd or"close" in cmd: exit() p=1 if "" in cmd and p==0: import wolframalpha client = wolframalpha.Client('42XG9Q-L76KJ35T39') try: res =client.query(cmd) output =next(res.results).text a=str(output) print(output) say(a) p=1 except: try: if p==0: a=wikipedia.summary(cmd) print(a) say('According to Wikipedia'+a) except: link='https://www.google.com/search?q='+str(cmd) webbrowser.open(link) p=1 if delete!=1: con=cs.connect(host="localhost",user="******",passwd="",database="catalina") cursor=con.cursor() a=datetime.date.today() timesave=datetime.datetime.now().time() rn = str(timesave) tm=rn[:10] data=[(str(a),str(tm),cmd)] query='insert into history(date,time,word) values(%s,%s,%s)' cursor.executemany(query,data) con.commit() con.close() p=1
#!/usr/bin/python2 import mysql.connector as mysql # pip install mysql-connector conn = mysql.connect(user='******', password='******', host='localhost', database='adhoc2') cur = conn.cursor() cur.execute("select name,email from student") output = cur.fetchall() print output print "1. insert, 2. exit" value = raw_input("enter choice") if value == '1': #cur=conn.cursor() cur.execute("insert into student (name,email) values ('abhi','gmail.com')") print('one row inserted') print(cur.rowcount) conn.commit() else: exit()