def getminline(stockno): conn = sqlite3API.get_conn('stock.db') sql_tid='select dataTime,lastPrice from t_399006 limit 100' info_tid=sqlite3API.fetchmany(conn,sql_tid) info_tid=sqlite3API.fetchmany(conn,sql_tid) info_x = [] info_y = [] for info in info_tid: info_x.append(info[0]) info_y.append(info[1]) return str({"x":info_x,"y":info_y})
def getAllPositionFromSqlite(): conn = sqlite3API.get_conn('stock.db') sql_tid = ''' select mairu_dongjie,jiaoyi_shichang,maichu_dongjie,shijia,shizhi,chengbenjia,yingkui,tangqian_chicang,yingkui_bili,gudong_daima,gufen_yue,gufen_keyong,code,name from chicang ; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid) # print(info_tid) list_dic = [] # dic = dict() for info_temp in info_tid: temp_item = { '买入冻结': info_temp[0], '交易市场': info_temp[1], '卖出冻结': info_temp[2], '参考市价': info_temp[3], '参考市值': info_temp[4], '参考成本价': info_temp[5], '参考盈亏': info_temp[6], '当前持仓': info_temp[7], '盈亏比例(%)': info_temp[8], '股东代码': info_temp[9], '股份余额': info_temp[10], '股份可用': info_temp[11], '证券代码': info_temp[12], '证券名称': info_temp[13] } # dic[info_temp[12]]=temp_item # print(temp_item) list_dic.append(temp_item) return list_dic
def checkTraderNone(code_position): conn = sqlite3API.get_conn('stock.db') sql_tid = ''' select gufen_keyong from chicang where code = '%s'; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid % code_position) if info_tid and info_tid[0][0] > 0: return True else: return False
def checkFadingJiari(str_time=str(datetime.datetime.now())[:10]): conn = sqlite3API.get_conn('stock.db') sql_tid = ''' select isOpen from trade_calender where calendarDate = '%s'; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid % str_time) if info_tid and info_tid[0][0] == 1: return True else: return False
def getKeyongGufen(code): conn = sqlite3API.get_conn('stock.db') sql_tid = ''' select gufen_keyong from chicang where code = '%s' ; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid % code) if info_tid and len(info_tid) > 0: return info_tid[0][0] else: return 0
def checkExistsCode(code): conn = sqlite3API.get_conn('stock.db') sql_tid = ''' select code from chicang where code = '%s' ; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid % code) if info_tid and len(info_tid) > 0: return True else: return False
def bisi_reply_mulit(userid='marx88', total=1): # mysql = mysqlAPI('test') # info_tid = mysql.select_mysql('select id from bisi_discuz where reply_num > 40 order by RAND() limit ' + str(total)) # info_content = mysql.select_mysql('select content from reply_content order by RAND() limit ' + str(total*3)) # mysql.close_mysql() sql_tid = 'select id,title from bisi_discuz where reply_num > 10 order by RANDOM() limit ' + str( total) sql_content = 'select content from reply_content order by RANDOM() limit ' + str( total * 3) conn = sqlite3API.get_conn(DB_FILE_PATH) info_tid = sqlite3API.fetchmany(conn, sql_tid) info_content = sqlite3API.fetchmany(conn, sql_content) data = userid info_user = sqlite3API.fetchone( conn, "select url,user,password from master where user=?", data) url = info_user[0] user = info_user[1] password = info_user[2] # print (password) discuz = DiscuzAPI(url, user, password) discuz.login() discuz.sign() #访问他人空间得2金钱 discuz.access() #发记录 discuz.speak(msg=str(random.randint(0, 10000))) total = len(info_content) for tid in info_tid: # print(info_content[random.randint(0,total-1)][0]) msg = info_content[random.randint(0, total - 1)][0] try: discuz.reply(tid[0], msg='%s,%s' % (tid[1], msg)) except: pass time.sleep(random.randint(65, 70))
def selectSqliteTest(): conn = sqlite3API.get_conn('stock.db') sql_tid = 'select dataTime,lastPrice from t_399006 limit 100' info_tid = sqlite3API.fetchmany(conn, sql_tid) info_x = [] info_y = [] for info in info_tid: info_x.append(info[0]) info_y.append(info[1]) print(info_x, info_y)
def getCixinCode(): conn = sqlite3API.get_conn('stock.db') sql_tid = ''' select code from stock_info where substr(stock_info.timeToMarket,1,4) || '-' || substr(stock_info.timeToMarket,5,2) || '-' || substr(stock_info.timeToMarket,7,2) > date('now','-300 days') --and substr(code,1,1) != '3' ; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid) stock_list = [] for info_temp in info_tid: stock_list.append(info_temp[0]) return stock_list
def getPositionHuatai(): conn = sqlite3API.get_conn('stock.db') sql_tid=''' select * from position ; ''' info_tid=sqlite3API.fetchmany(conn,sql_tid) dic = dict() for info_temp in info_tid: dic[info_temp[0]] = [info_temp[1],info_temp[2],info_temp[3],info_temp[4],info_temp[5]] return dic
def getPosition(): conn = sqlite3API.get_conn('stock.db') sql_tid = ''' select code,gufen_keyong from chicang ; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid) # print(info_tid) dic = dict() stock_list = [] for info_temp in info_tid: dic[info_temp[0]] = str(info_temp[1]) stock_list.append(info_temp[0]) # print('OK' if '6013192' in dic.keys() else '') # print(dic.keys()) return dic
def test_sqlite(): stock_list = [ '002858', '603041', '002857', '603388', '603178', '002816', '603031', '603701', '603991', '002806', '603319', '002796', '603090', '603038', '603990', '603029', '002800', '603908', '002810', '002837', '002835', '603738', '002805', '603960', '603266', '603037', '603819', '603633', '603887', '002856', '603033', '603663', '002830', '603637', '603089', '603032', '002808' ] conn = sqlite3API.get_conn('stock.db') sql_tid = "select code,timeToMarket from stock_info where code in ('" + "','".join( stock_list) + "')" info_tid = sqlite3API.fetchmany(conn, sql_tid) print(type(info_tid)) print(info_tid) dic = dict() for info_temp in info_tid: dic[info_temp[0]] = info_temp[1] print(dic)
def gettimeToMarket(): conn = sqlite3API.get_conn('stock.db') #sql_tid ="select code,timeToMarket from stock_info where code in ('" + "','".join(stock_list) + "')" sql_tid = ''' select stock_info.code,stock_info.timeToMarket from liutong_from_qq inner join stock_info on liutong_from_qq.code = stock_info.code where liutong_from_qq.liutong<13 and substr(liutong_from_qq.code,1,1) != '3' and substr(stock_info.timeToMarket,1,4) || '-' || substr(stock_info.timeToMarket,5,2) || '-' || substr(stock_info.timeToMarket,7,2) > date('now','-270 days') order by liutong_from_qq.liutong limit 40; ''' info_tid = sqlite3API.fetchmany(conn, sql_tid) dic = dict() stock_list = [] for info_temp in info_tid: dic[info_temp[0]] = str(info_temp[1]) stock_list.append(info_temp[0]) return dic, stock_list
def getPositionHistory(): conn = sqlite3API.get_conn('stock.db') sql_tid=''' select * from position_history ; ''' info_tid=sqlite3API.fetchmany(conn,sql_tid) dic = dict() for info_temp in info_tid: dic[info_temp[0]] = [info_temp[1],info_temp[2],info_temp[3],info_temp[4],info_temp[5],info_temp[6]] dic[info_temp[0]] = { 'name':info_temp[1], 'num':info_temp[2], 'start_price':info_temp[3], 'start_time':info_temp[4], 'end_price':info_temp[5], 'end_time':info_temp[6], 'bizhong':info_temp[7] } return dic