def getIndustry():
returnArray = []
tempData = sql.executeReturn("SELECT * FROM 'listIndustry'")
for i in tempData:
returnArray.append(i)
return returnArray
def getList():
returnArray = []
tempData = sql.executeReturn("SELECT * FROM 'list'")
for i in tempData:
returnArray.append(i[0])
return returnArray
def addList(tableName, data):
sql.execute('DROP TABLE IF EXISTS ' + tableName, None)
sql.execute('CREATE TABLE ' + tableName + '(CC0 TEXT)', None)
totalText = ''
for i in data:
totalText += '('
for j in i:
totalText += "'" + str(j) + "',"
totalText = totalText[0:len(totalText) - 1]
totalText += '),'
# tempArray.append(j)
# totalText += valuesText + ','
totalText = totalText[0:len(totalText) - 1]
sql.execute('INSERT INTO ' + tableName + ' VALUES ' + totalText, None)
def removeTicker(tickerName):
sql.execute("DELETE FROM list WHERE CC0 = ?", [tickerName])
def getAllTables():
allTables = sql.executeReturn(
"SELECT name FROM sqlite_master WHERE type = 'table';")
for i in allTables:
print(i)
def vacuum():
sql.execute("VACUUM", None)
def getTickerIndustryList(tickerName):
return sql.executeReturn("SELECT * FROM listIndustry WHERE C1 = '" +
tickerName + "'")[0]
def addTicker(tickerName):
sql.execute("INSERT INTO list VALUES (?)", [tickerName])
def deleteTickerIndustryList(tickerName):
sql.execute("DELETE FROM listIndustry WHERE C1 = ?", [tickerName])