Changeset 191 for trunk/aeres/scripts

Timestamp:

04/26/12 18:23:25 (12 years ago)

Author:

pinsard

Message:

progress in populate directory

File:

• trunk/aeres/scripts/aeresrh.py (modified) (8 diffs)

trunk/aeres/scripts/aeresrh.py

@@ -1 +1 @@
 #!/usr/bin/env python
 # -*- coding: iso-8859-1 -*-
+
+__docformat__ = 'reStructuredText'
+__autodoc__ = ['aeresrh']
 
 """
@@ -53 +56 @@
  aeresrh.py --ifile ${PROJECT}/data/aeresrh.xls
 
+ aeresrh.py  --ifile ${HOME}/Downloads/personnel_franc\314\247oise.xls
+
 TODO
 ====
@@ -76 +81 @@
 
 $URL$
+
+- fplod 20120426
+
+  * big process in dictionnary using itertools
 
 - fplod 20120410
@@ -105 +114 @@
 
 import datetime
+
+import itertools
 
 try:
@@ -140 +151 @@
     """
     >>> people = {'pk1':{'firstname':'Brian', 'age':42}, 'pk2':{'firstname':'Alex', 'age':50}}
-    >>> find_in_dict(people, 'age', 42)
+    >>> result = find_in_dict(people, 'age', 42)
 
     http://stackoverflow.com/questions/8987631/searching-2-dimensional-dictionary
@@ -231 +242 @@
 
     surname = sh.col_values(colsurname)[firstrow:lastrow]
-    print ('surname 0000 %s ' % surname)
 
     if is_verbose == True:
@@ -248 +258 @@
         if is_verbose == True:
             print(' temp arrival AAA%sAAA' % temp[rownum])
-        #++ pb sh.datemodearrival = datetime.datetime(*xlrd.xldate_as_tuple(temp[rownum],sh.datemode))
         if temp[rownum] == '':
             print('eee : pas de date arrivee colonne %d ' % rownum)
         else:
-            print('iii : date arrivee pour %s ' % surname[rownum])
-            #arrival.append(datetime.datetime(*xlrd.xldate_as_tuple(temp[rownum],datemode)))
+            arrival.append(datetime.datetime(*xlrd.xldate_as_tuple(temp[rownum],datemode)))
 
     if is_verbose == True:
@@ -287 +295 @@
     firstname_id = build_firstname_id(firstname)
     #
-    author_id = []
+    # populate dictionary
+    keys_for_all = []
+    values_for_all = []
+    keys_for_one = ['surname', 'firstname', 'arrival', 'publi']
     for index in range(len(surname_id)):
-        author_id.append('{surname_id}_{firstname_id}'.format(surname_id=surname_id[index], firstname_id=firstname_id[index]))
-
-    print('author id 0 %s ' % author_id[0])
-
-    # populate dictionary
-    people = {}
-    keys = ('surname_id', 'firstname_id')
-    people = dict.fromkeys(author_id,keys)
-    people['COPPIN_elisabeth']
-    for index, oneauthor_id in enumerate(author_id):
-       people[oneauthor_id]
-       #people[oneauthor_id]['surname_id'] = surname_id[index]
-       #people[oneauthor_id]['firstname_id'] = firsname_id[index]
-    #   # people = {'pk1':{'firstname':'Brian', 'age':42}, 'pk2':{'firstname':'Alex', 'age':50}}
-
-    people['PINSARD_Francoise']
-    find_in_dict(people, 'surname', 'PINSARD')
+        values_for_one=[]
+        values_for_one.append(surname[index])
+        values_for_one.append(firstname[index])
+        values_for_one.append(arrival[index])
+        values_for_one.append(publi[index])
+        values_for_all.append(dict(itertools.izip(keys_for_one,values_for_one)))
+        keys_for_all.append('{surname_id}_{firstname_id}'.format(surname_id=surname_id[index], firstname_id=firstname_id[index]))
+
+
+    if is_verbose == True:
+        print ('len keys_for_all : %d ' % len(keys_for_all))
+        print ('person_id 0 : %s ' % keys_for_all[0])
+        for index, key_for_all in enumerate(keys_for_all):
+            print ('person_id (key) : %s ' % key_for_all)
+            print ('associated info : %s ' % values_for_all[index])
+
+    people = dict(itertools.izip(keys_for_all,values_for_all))
+
+    if is_verbose == True:
+        print (' result looking for key PINSARD_francoise : %s ' % people['PINSARD_francoise'])
+
+    if is_verbose == True:
+        result = find_in_dict(people, 'surname', 'PINSARD')
+        print (' result looking for PINSARD %s ' % result)
 
 # Run main, if called from the command line