def cursorToTable(targetCursor):
"""Converts the given cursor object into a table
input : A Cursor object which is the result of a query
Returns : A table filled with the information from cursor"""
desc=targetCursor.description
headerList=[];
for field in desc:
headerList.append( field[0])
resultTable=idLogTable(headerList)
rowList=targetCursor.fetchall()
for row in rowList:
lRow=list(row)
resultTable.addRow(lRow)
return resultTable
for col_idx in xrange(1, len(rowList) + 1):
col = get_column_letter(col_idx)
entrySheet.cell("%s%s" % (col, row)).value = str(rowList[col_idx - 1])
wb.save(filename=path)
def saveAsPDF(table, path):
return
def saveAsXML(table, path):
return
def saveAsHTML(table, path):
return
if __name__ == "__main__":
print "hello"
dummyTable = idLogTable(["id", "username", "category", "blabla", "created"])
dummyTable.setHeaders(["id", "username", "category", "content", "created"])
dummyTable.addRow([1, "alpsayin", "farnell", "raspberry pi siparisleri verildi", datetime.now()])
dummyTable.addRow([2, "alpsayin", "farnell", "raspberry pi siparisleri elimize ulasti", datetime.now()])
dummyTable.addRow([3, "umutgultepe", "g-man", "some entry", datetime.now()], 6)
# dummyTable.printTable()
saveAsTXT(dummyTable, "alp.txt")
saveAsXLSX(dummyTable, "alp.xlsx")
print "bye bye"
