Hi All, My python skills are limited but I have managed to generate a couple of lists using python and the psycopg2 library by querying a postgress table and it's columns. I would like to use the two generated lists from the python script to create a file called upgrade_email_addresses.sql (and then later on use the psql "postgress cli" with the -f flag against this .sql file) which will be used to update the users database with the correct email addresses.
Is there a way to generate a file from two lists? This is what I need to do ... I have two lists such like: listUsernames = ['adal', '', 'pascalb', 'ritchied', 'torvaldsl', ... ] listEmailaddress = ['[email protected]', '[email protected]', '[email protected]', '[email protected]', ... ] So in my python script I would like to generate a text file (upgrade_email_addresses.sql) in the file system say in /tmp or /home, that will contain the following lines by perhaps looping against the lists in some way to create the lines in the external file: UPDATE users set email='[email protected]' WHERE username='adal'; UPDATE users set email='[email protected]' WHERE username='pascalb'; UPDATE users set email='[email protected]' WHERE username='ritchied'; UPDATE users set email='[email protected]' WHERE username='torvaldsl'; .... .... Any help would be much appreciated. I was thinking I could run the UPDATE queries in the psycopg2 console function directly in my python script but haven't been able to do that but now I'm thinking creating a upgrade_email_addresses.sql file and then calling psql cli against that would be easier. Regards Tahir _______________________________________________ Tutor maillist - [email protected] To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
