Class IMAPAdapter

x.__init__(...) initializes x; see help(type(x)) for signature

Overrides: object.__init__

(inherited documentation)

IMAP4 Pool connection method

imap connection lacks of self cursor command. A custom command should be provided as a replacement for connection pooling to prevent uncaught remote session closing

Overrides: ConnectionPool.reconnect

Auto create common IMAP fileds

This function creates fields definitions "statically" meaning that custom fields as in other adapters should not be supported and definitions handled on a service/mode basis (local syntax for Gmail(r), Ymail(r)

Returns a dictionary with tablename, server native mailbox name pairs.

Overrides: BaseAdapter.create_table

Search and Fetch records and return web2py rows

Overrides: BaseAdapter.select

Overrides: BaseAdapter.insert

Overrides: BaseAdapter.update

Overrides: BaseAdapter.count

Overrides: BaseAdapter.delete

Overrides: BaseAdapter.BELONGS

Overrides: BaseAdapter.CONTAINS

Overrides: BaseAdapter.GT

Overrides: BaseAdapter.GE

Overrides: BaseAdapter.LT

Overrides: BaseAdapter.LE

Overrides: BaseAdapter.NE

Overrides: BaseAdapter.EQ

Overrides: BaseAdapter.AND

Overrides: BaseAdapter.OR

Overrides: BaseAdapter.NOT

drivers

IMAP server adapter

  This class is intended as an interface with
email IMAP servers to perform simple queries in the
web2py DAL query syntax, so email read, search and
other related IMAP mail services (as those implemented
by brands like Google(r), and Yahoo!(r)
can be managed from web2py applications.

The code uses examples by Yuji Tomita on this post:
http://yuji.wordpress.com/2011/06/22/python-imaplib-imap-example-with-gmail/#comment-1137
and is based in docs for Python imaplib, python email
and email IETF's (i.e. RFC2060 and RFC3501)

This adapter was tested with a small set of operations with Gmail(r). Other
services requests could raise command syntax and response data issues.

It creates its table and field names "statically",
meaning that the developer should leave the table and field
definitions to the DAL instance by calling the adapter's
.define_tables() method. The tables are defined with the
IMAP server mailbox list information.

.define_tables() returns a dictionary mapping dal tablenames
to the server mailbox names with the following structure:

{<tablename>: str <server mailbox name>}

Here is a list of supported fields:

Field       Type            Description
################################################################
uid         string
answered    boolean        Flag
created     date
content     list:string    A list of dict text or html parts
to          string
cc          string
bcc         string
size        integer        the amount of octets of the message*
deleted     boolean        Flag
draft       boolean        Flag
flagged     boolean        Flag
sender      string
recent      boolean        Flag
seen        boolean        Flag
subject     string
mime        string         The mime header declaration
email       string         The complete RFC822 message**
attachments <type list>    Each non text part as dict
encoding    string         The main detected encoding

*At the application side it is measured as the length of the RFC822
message string

WARNING: As row id's are mapped to email sequence numbers,
make sure your imap client web2py app does not delete messages
during select or update actions, to prevent
updating or deleting different messages.
Sequence numbers change whenever the mailbox is updated.
To avoid this sequence numbers issues, it is recommended the use
of uid fields in query references (although the update and delete
in separate actions rule still applies).

# This is the code recommended to start imap support
# at the app's model:

imapdb = DAL("imap://user:password@server:port", pool_size=1) # port 993 for ssl
imapdb.define_tables()

Here is an (incomplete) list of possible imap commands:

# Count today's unseen messages
# smaller than 6000 octets from the
# inbox mailbox

q = imapdb.INBOX.seen == False
q &= imapdb.INBOX.created == datetime.date.today()
q &= imapdb.INBOX.size < 6000
unread = imapdb(q).count()

# Fetch last query messages
rows = imapdb(q).select()

# it is also possible to filter query select results with limitby and
# sequences of mailbox fields

set.select(<fields sequence>, limitby=(<int>, <int>))

# Mark last query messages as seen
messages = [row.uid for row in rows]
seen = imapdb(imapdb.INBOX.uid.belongs(messages)).update(seen=True)

# Delete messages in the imap database that have mails from mr. Gumby

deleted = 0
for mailbox in imapdb.tables
    deleted += imapdb(imapdb[mailbox].sender.contains("gumby")).delete()

# It is possible also to mark messages for deletion instead of ereasing them
# directly with set.update(deleted=True)


# This object give access
# to the adapter auto mailbox
# mapped names (which native
# mailbox has what table name)

imapdb.mailboxes <dict> # tablename, server native name pairs

# To retrieve a table native mailbox name use:
imapdb.<table>.mailbox

### New features v2.4.1:

# Declare mailboxes statically with tablename, name pairs
# This avoids the extra server names retrieval

imapdb.define_tables({"inbox": "INBOX"})

# Selects without content/attachments/email columns will only
# fetch header and flags

imapdb(q).select(imapdb.INBOX.sender, imapdb.INBOX.subject)

Value:

('imaplib')

types

Value:

{'bigint': <type 'long'>, 'blob': <type 'str'>, 'boolean': <type 'bool'>, 'date': <type 'datetime.date'>, 'datetime': <type 'datetime.datetime'>, 'id': <type 'long'>, 'integer': <type 'int'>, 'list:string': <type 'str'>, ...

REGEX_URI

Value:

re.compile(r'^(?P<user>[^:]+)(:(?P<password>[^@]*))?@(?P<host>[^:@]+)( :(?P<port>[0-9]+))?$')