Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Hard one :-)</p> <pre><code>import email, getpass, imaplib, os detach_dir = '.' # directory where to save attachments (default: current) user = raw_input("Enter your GMail username:") pwd = getpass.getpass("Enter your password: ") # connecting to the gmail imap server m = imaplib.IMAP4_SSL("imap.gmail.com") m.login(user,pwd) m.select("[Gmail]/All Mail") # here you a can choose a mail box like INBOX instead # use m.list() to get all the mailboxes resp, items = m.search(None, "ALL") # you could filter using the IMAP rules here (check http://www.example-code.com/csharp/imap-search-critera.asp) items = items[0].split() # getting the mails id for emailid in items: resp, data = m.fetch(emailid, "(RFC822)") # fetching the mail, "`(RFC822)`" means "get the whole stuff", but you can ask for headers only, etc email_body = data[0][1] # getting the mail content mail = email.message_from_string(email_body) # parsing the mail content to get a mail object #Check if any attachments at all if mail.get_content_maintype() != 'multipart': continue print "["+mail["From"]+"] :" + mail["Subject"] # we use walk to create a generator so we can iterate on the parts and forget about the recursive headach for part in mail.walk(): # multipart are just containers, so we skip them if part.get_content_maintype() == 'multipart': continue # is this part an attachment ? if part.get('Content-Disposition') is None: continue filename = part.get_filename() counter = 1 # if there is no filename, we create one with a counter to avoid duplicates if not filename: filename = 'part-%03d%s' % (counter, 'bin') counter += 1 att_path = os.path.join(detach_dir, filename) #Check if its already there if not os.path.isfile(att_path) : # finally write the stuff fp = open(att_path, 'wb') fp.write(part.get_payload(decode=True)) fp.close() </code></pre> <p>Wowww! That was something. ;-) But try the same in Java, just for fun!</p> <p>By the way, I tested that in a shell, so some errors likely remain.</p> <p>Enjoy</p> <p><strong>EDIT:</strong></p> <p>Because mail-box names can change from one country to another, I recommend doing <code>m.list()</code> and picking an item in it before <code>m.select("the mailbox name")</code> to avoid this error:</p> <blockquote> <p>imaplib.error: command SEARCH illegal in state AUTH, only allowed in states SELECTED</p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. POHow can I download all emails with attachments from Gmail?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USHonest Abe
    1. USe-satis
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can I download all emails with attachments from Gmail?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COTHat's awesome, guys! Well done! :D :D
      singulars
      1. PO
      1. USIvan Vučica
    2. COThanks J.F. Wrote that wuick and dirty, you gave it value :-D
      singulars
      1. PO
      1. USe-satis
    3. COThis is a good answer. It dies with a malloc error on large attachments. Python(57780) malloc: *** mmap(size=9658368)
      singulars
      1. PO
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload