Administrace komentářů

Traceback (most recent call last):
  File "trhy.py", line 163, in module
    text = nazev_krivky+'\n'+str(krivky[index_krivek][0]),#prvni zaznam z kazde krivky
TypeError: 'Decimal' object does not support indexing

Traceback (most recent call last):
  File "trhy.py", line 133, in module
    text=str(datumy[0]),
TypeError: 'datetime.datetime' object is unsubscriptable

Traceback (most recent call last):
  File "trhy.py", line 163, in module
    text = nazev_krivky+'\n'+str(krivky[index_krivek][0]),#prvni zaznam z kazde krivky
TypeError: 'float' object is unsubscriptable

...
spojeni_db = mysql.connect('localhost', 'uzivatel', 'heslo', 'moje_db')

# prepare a cursor object using cursor() method
ukazatel_db = spojeni_db.cursor()

# Prepare SQL query.
dotaz = "SELECT * FROM trhy WHERE YEAR(datum)=2012 ORDER BY datum ASC" #\
#       WHERE INCOME > '%d'" % (1000)
try:
   # Execute the SQL command
   ukazatel_db.execute(dotaz)
   # Fetch all the rows in a list of lists.
   vysledek = ukazatel_db.fetchall()
   nazev_pole = ukazatel_db.description
   print "%s %s %s %s %s %s %s %s %s" % \
   (nazev_pole[0][0], nazev_pole[1][0], nazev_pole[2][0], nazev_pole[3][0], nazev_pole[4][0], nazev_pole[5][0], nazev_pole[6][0], nazev_pole[7][0], nazev_pole[8][0])
   for zaznam in vysledek:
      datumy = zaznam[0]
      eur_usd = zaznam[1]
      usd_jpy = zaznam[2]
      gbp_usd = zaznam[3]
      usd_chf = zaznam[4]
      gold = zaznam[5]
      sp500 = zaznam[6]
      tbonds_30y = zaznam[7]
      oil_brent = zaznam[8]
      #print type(gold)
      # Now print fetched result
      #print "%s %s %s %s %s %s %s %s %s" % \
      #       (datumy, eur_usd, usd_jpy, gbp_usd, usd_chf, gold, sp500, tbonds_30y, oil_brent)
      #print "%s" % (gold)
except:
   print "Error: unable to fetch data"

# disconnect from server
spojeni_db.close()


#+++ DATA PRO KRIVKY +++
#++++++++++++++++++++++++++++++++++++++++++++++++++++


oil_brent = [107.38, 111.31, 111.63, 113.69, 113.41, 110.58, 111.09, 111.49, 111.04, 111.05, 112.16, 111.84, ]

t_bonds_30y = [7.01, 7.02, 6.97, 6.94, 6.98, 6.87, 6.9, 6.9, 7, 7.05, 6.99, 7.01, ]

sp500 = [1257.6, 1278.34, 1277.06, 1277.3, 1281.06, 1321.2, 1318.45, 1314.94, 1313.01, 1312.41, 1328.04, 1324.09, ]

gold = [1730.00, 1730.00, 1730.00, 1730.00, 1730.00, 1730.00, 1717.20, 1722.90, 1726.00, 1742.50, 1746.70, 1747.80, ]

usd_chf = [1.0634, 1.0739, 1.0647, 1.0534, 1.0513, 1.0845, 1.0861, 1.0951, 1.0896, 1.0867, 1.0957, 1.0912, ]

gbp_usd = [1.5471, 1.5658, 1.5606, 1.5519, 1.5501, 1.5638, 1.5689, 1.5721, 1.5704, 1.5762, 1.585, 1.5836, ]

usd_jpy = [0.0130, 0.0130, 0.0130, 0.0130, 0.0130, 0.0129, 0.0129, 0.0130, 0.0131, 0.0131, 0.0131, 0.0131, ]

eur_usd = [1.2922, 1.307, 1.2984, 1.2839, 1.2804, 1.3095, 1.3104, 1.3213, 1.3136, 1.3083, 1.3196, 1.3159, ]

datumy = ['2012 - January - 02', '2012 - January - 03', '2012 - January - 04', '2012 - January - 05', '2012 - January - 06', '2012 - January - 25', '2012 - January - 26', '2012 - January - 27', '2012 - January - 30', '2012 - January - 31', '2012 - February - 01', '2012 - February - 02', ] 


#seznam "krivky" nesmi mit vyssi pocet prvku nez je jednotlivych krivek!
krivky=[eur_usd, usd_jpy, gbp_usd, usd_chf, gold, t_bonds_30y, sp500, oil_brent,]
...