Hi James,
Thanks for such a detailed response. I looked at all your links (and
already had come across some of them)
I guess that my question wasn't specific enough :-(
The table (and model) are existing.
However, the keys that I retrieve in the output I shared do not correspond
to (some of) the table fields.
So I am struggling to figure out how to push the values provided by key
names that do not match the fieldnames into my table.
If that would become really complicated I guess I could change the field
names in the model/table, but I rather not as the trick in itself would
help me with some other data as well (it's part of the learning curve I
guess :-) ).
Thanks!
Oscar
As an example;
the key Symbol needs to put it's value into field 'yahoo_symbol' in the
model/table
Le lundi 8 juin 2015 22:09:05 UTC+2, Oscar Buijten a écrit :
>
> Hi there,
> The python learning curve seems to be steeper than expected :-(
> As yesterday, help converting my php app into python/django will be
> appreciated.
>
> I have the following:
>
> -------------------- snip -------------------
> from django.core.management.base import BaseCommand, CommandError
> import json
> from collections import OrderedDict
> from yahoo_finance import Share
> from data.models import MyichiTickers, MyichiHistoricalData
>
> exchange = 'AMS'
> startdate = '2014-04-25'
> enddate = '2014-04-29'
> minimum_avg_daily_volume = '100000'
>
> class Command(BaseCommand):
> def handle(self, *args, **options):
> from yahoo_finance import Share
> from data.models import MyichiTickers
> tickers_for_exchange = MyichiTickers.objects.filter(exchange=exchange)[:2]
> if tickers_for_exchange:
> for tickerlist in tickers_for_exchange:
> ticker = Share(tickerlist.ticker)
> if ticker.get_avg_daily_volume() > minimum_avg_daily_volume:
> data = json.dumps(ticker.get_historical(startdate, enddate))
> data = json.loads(data)
> print data
>
> -------------------- snip -------------------
>
> It may not be perfect, but it works.
> I would need to get 'data' into the 'MyichiHistoricalData' model
>
> The output is like this;
> -------------------- snip -------------------
> [{u'High': u'6.565', u'Symbol': u'AGN.AS', u'Adj_Close': u'6.31564',
> u'Volume': u'4376000', u'Low': u'6.428', u'Date': u'2014-04-29', u'Close':
> u'6.551', u'Open': u'6.435'}, {u'High': u'6.479', u'Symbol': u'AGN.AS',
> u'Adj_Close': u'6.18742', u'Volume': u'3163200', u'Low': u'6.38', u'Date':
> u'2014-04-28', u'Close': u'6.418', u'Open': u'6.428'}, {u'High': u'6.535',
> u'Symbol': u'AGN.AS', u'Adj_Close': u'6.18259', u'Volume': u'4780100',
> u'Low': u'6.379', u'Date': u'2014-04-25', u'Close': u'6.413', u'Open':
> u'6.529'}]
> [{u'High': u'13.94', u'Symbol': u'AH.AS', u'Adj_Close': u'13.57496',
> u'Volume': u'2706600', u'Low': u'13.70', u'Date': u'2014-04-29', u'Close':
> u'13.92', u'Open': u'13.70'}, {u'High': u'13.735', u'Symbol': u'AH.AS',
> u'Adj_Close': u'13.34091', u'Volume': u'2784700', u'Low': u'13.56',
> u'Date': u'2014-04-28', u'Close': u'13.68', u'Open': u'13.565'}, {u'High':
> u'13.675', u'Symbol': u'AH.AS', u'Adj_Close': u'13.23364', u'Volume':
> u'3012500', u'Low': u'13.44', u'Date': u'2014-04-25', u'Close': u'13.57',
> u'Open': u'13.545'}]
> -------------------- snip -------------------
>
> Where I need help it so extract the keys and values and give them the
> correct model field names in order to save them.
>
> It should be easy really, bt several hours of readin, searching, trial &
> error haven't given me the trick yet....
>
> Any suggestions?
>
> Thanks!
>
> Oscar
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/e07755cc-69e2-4a64-b44c-04041ae6df32%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
