Exemplo n.º 1
0
    def __init__(self,_parent=None,**kwargs):
        from os                             import environ                  as os_environ
        from sys                            import path                     as py_path
        py_path.append(                         os_environ['HOME'] + '/.scripts')
        
        # SEE file_server for latest implementation

        if _parent:            
            self._parent                    =   _parent
            if hasattr(_parent,'T'):
                self.T                      =   _parent.T
            if hasattr(_parent,'PG'):
                self.PG                     =   _parent.PG


        if not _parent or not hasattr(_parent,'T'):
            from System_Control                 import System_Lib
            self.T                          =   System_Lib().T
        else:
            self.T                          =   _parent.T
            from System_Control                 import System_Reporter
            self.Reporter                   =   System_Reporter(self)


        for k in kwargs.keys():
            if k in ['username','pw']:
                self.T.update(                  {k: kwargs[k]})

            if not hasattr(self.T,'username') or not hasattr(self.T,'pw'):
                from __settings__ import default_user,default_pw
                self.username                   =   default_user
                self.pw                         =   default_pw
            else:
                self.username                   =   self.T.username
                self.pw                         =   self.T.pw


        if self.T.config.gmail._has_key('attachments_dir'):
                attachments_path            =   self.T.config.gmail.attachments_dir.replace('~/','%s/' % self.T.os.environ['HOME'])
        else:
            attachments_path                =   self.T.os.environ['HOME'] + '/.gmail/attachments/'
        if not self.T.os.path.exists(           attachments_path):
            self.T.os.mkdir(                    attachments_path)


        self.T                              =   self.T.To_Class_Dict(  self,
                                                                dict_list=[self.T.__dict__,locals()],
                                                                update_globals=True)
        self.Google                         =   self
        self.Voice                          =   self.Voice(self)
        self.Gmail                          =   self.Gmail(self)
Exemplo n.º 2
0
class Google:

    def __init__(self,_parent=None,**kwargs):
        from os                             import environ                  as os_environ
        from sys                            import path                     as py_path
        py_path.append(                         os_environ['HOME'] + '/.scripts')
        
        # SEE file_server for latest implementation

        if _parent:            
            self._parent                    =   _parent
            if hasattr(_parent,'T'):
                self.T                      =   _parent.T
            if hasattr(_parent,'PG'):
                self.PG                     =   _parent.PG


        if not _parent or not hasattr(_parent,'T'):
            from System_Control                 import System_Lib
            self.T                          =   System_Lib().T
        else:
            self.T                          =   _parent.T
            from System_Control                 import System_Reporter
            self.Reporter                   =   System_Reporter(self)


        for k in kwargs.keys():
            if k in ['username','pw']:
                self.T.update(                  {k: kwargs[k]})

            if not hasattr(self.T,'username') or not hasattr(self.T,'pw'):
                from __settings__ import default_user,default_pw
                self.username                   =   default_user
                self.pw                         =   default_pw
            else:
                self.username                   =   self.T.username
                self.pw                         =   self.T.pw


        if self.T.config.gmail._has_key('attachments_dir'):
                attachments_path            =   self.T.config.gmail.attachments_dir.replace('~/','%s/' % self.T.os.environ['HOME'])
        else:
            attachments_path                =   self.T.os.environ['HOME'] + '/.gmail/attachments/'
        if not self.T.os.path.exists(           attachments_path):
            self.T.os.mkdir(                    attachments_path)


        self.T                              =   self.T.To_Class_Dict(  self,
                                                                dict_list=[self.T.__dict__,locals()],
                                                                update_globals=True)
        self.Google                         =   self
        self.Voice                          =   self.Voice(self)
        self.Gmail                          =   self.Gmail(self)

    def _get_input(question):
        return raw_input(question)

    class Voice:

        def __init__(self,_parent):

            self                            =   _parent.T.To_Sub_Classes(self,_parent)

            # self._parent                    =   _parent
            # self.T                          =   _parent.T

            # self.Voice                      =   self
            # from googlevoice                import Voice
            # from googlevoice.util           import input
            # self.Voice                      =   Voice()
            # self.Voice.login(                   )

        def _msg(self,phone_num,msg):
            # _out                        =   self.Voice.send_sms(phone_num, msg)
            # assert _out==None
            return

    class Gmail:

        def __init__(self,_parent,**kwargs):
            import                              gmail_client                as GC
            import                              codecs

            self                            =   _parent.T.To_Sub_Classes(self,_parent)
            if hasattr(_parent,'PG'):
                self.PG                     =   _parent.PG
            
            # self._parent                    =   _parent
            # self.T                          =   _parent.T

            all_imports                     =   locals().keys()
            excludes                        =   ['self','_parent']
            new_imports                     =   [it for it in all_imports if not excludes.count(it)]
            for k in new_imports:
                self.T.update(                  {k:locals()[k]} )
            globals().update(                   self.T.__dict__)


        def _run_cmd(cmd):
            p = self.T.sub_popen(cmd,stdout=self.T.sub_PIPE,
                                 shell=True,executable='/bin/zsh')
            (_out,_err) = p.communicate()
            assert _err is None
            return _out.rstrip('\n')

        def _make_pgsql_tbl(self):
            cmd = """
                DROP TABLE IF EXISTS gmail;
                CREATE TABLE gmail
                    (
                        orig_msg jsonb,
                        all_mail_uid bigint,
                        g_msg_id bigint,
                        msg_id text
                    );
                """
            self.T.conn.set_isolation_level(0)
            self.T.cur.execute(cmd)
        def _unix_time(self,dt):
            epoch                       =   self.T.DT.datetime.utcfromtimestamp(0)
            delta                       =   dt - epoch
            return delta.total_seconds()
        def _fetch_msg_grp(self,msgs,grp_size):
            pt                          =   0
            while pt < len(msgs):
                msg_grp                 =   msgs[pt:pt+grp_size]
                res                     =   map(lambda m: m.fetch(),msg_grp)
                yield msg_grp
                pt                     +=   grp_size
        def _get_msg_ids(self,msg):
            if msg['headers'].has_key('Message-ID'):
                return msg['headers']['Message-ID']
            else:
                K                       =   msg['headers'].keys()
                dict_for_lower          =   dict(zip([it.lower() for it in K],K))
                if dict_for_lower.has_key('message-id'):
                    return msg['headers'][dict_for_lower['message-id']]
                else:
                    return 'None'
        def _msg_to_json(self,msg):
            """Cleaning/Adjusting msg contents to fit into JSON serializable"""

            D                           =   msg.__dict__

            D['body']                   =   self.T.codecs.encode(
                                                self.T.codecs.decode(D['body'],'ascii','ignore'),
                                                'ascii','ignore')
            D['html']                   =   self.T.codecs.encode(
                                                self.T.codecs.decode(D['html'],'ascii','ignore'),
                                                'ascii','ignore')

            if D.has_key('attachments'):
                'md5sum -b /home/ub2/.gmail/attachments/%(_key)s | cut -d \  -f1'
                attachment_json         =   []
                for A in msg.attachments:

                    attach_id           =   str(self.T.get_guid().hex)
                    file_dict           =   {'name'           :   A.name,
                                             'size_in_kb'     :   A.size,
                                             'content_type'   :   A.content_type}
                    
                    if A.size > 0:
                        f_path          =   self.T.attachments_path + attach_id
                        A.save(             f_path)
                        file_dict.update(   {'md5' : run_cmd('md5sum -b %s | cut -d \  -f1' % f_path) })
                        saved_size      =   self.T.os.path.getsize(f_path)
                        assert saved_size==A.size

                    AD                  =   dict({  attach_id       : file_dict })
                    attachment_json.append( AD)

                D['attachments']        =   attachment_json
            else:
                del D['attachments']

            items_to_delete             =   ['mailbox','gmail','message']
            for it in items_to_delete:
                if D.has_key(it):
                    del D[it]
            D['sent_at']                =   D['sent_at'] if type(D['sent_at'])==int else int(self._unix_time(msg.sent_at))
            D['_labels']                =   list(D['_labels'])
            D['_flags']                 =   list(D['_flags'])

            ## Confirm all elements of msg object are expected (and will fit into JSON)
        #     for k,v in msg.iteritems():
        #         if ["<type 'str'>","<type 'int'>","<type 'list'>","<type 'dict'>","<type 'NoneType'>"].count(str(type(v)))==0:
        #             print 'unexpected data type in msg class'
        #             raise SystemError

            return self.T.json.dumps(           D, ensure_ascii=False)

        def misc_queries(self):
            a="""
                select *
                from (
                    select
                    --  trim('"' from (orig_msg::json->'uid')::text)::integer _uid,
                    --  trim('"' from (orig_msg::json->'message_id')::text)::bigint _gmail_id,
                    --  to_timestamp((orig_msg::json->'sent_at')::text::double precision) _sent,
                    --  trim('"' from (orig_msg::json->'to'::text)::text) _to,
                    --  trim('"' from (orig_msg::json->'cc'::text)::text) _cc,
                    --  trim('"' from (orig_msg::json->'fr'::text)::text) _fr,
                    --  trim('"' from (orig_msg::json->'subject')::text) _subject,
                    --  orig_msg::json->'attachments' _attachments,
                        orig_msg::json->'_labels' _labels,
                        orig_msg::json->'_flags' _flags,
                        orig_msg
                    from gmail
                ) f1
                --where _sent < date 'May 1, 2007'
                --order by _sent
                limit 5
            """

        def all_mail(self,method='full'):
            """Copy all messages to pgsql@system:gmail"""
            import json as J
            from re import sub as re_sub

            def check_setup(method='full'):

                if method=='full':
                    if not self.PG.F.tables_exists('gmail'):
                        self.PG.F.functions_create_batch_groups(sub_dir='../sql_exts',
                                                                grps=['gmail_tables'],
                                                                files=['1_gmail.sql'])

                elif method=='quick':
                    if not self.PG.F.tables_exists('gmail_chk'):
                        self.PG.F.functions_create_batch_groups(sub_dir='../sql_exts',
                                                                grps=['gmail_tables'],
                                                                files=['2_gmail_chk.sql'])

            def full_sync(msg_num,all_mail_uids,g_msg_ids,msg_ids):

                msgs_as_json            =   map(lambda m: self._msg_to_json(m),msg_grp)

                cmd                     =   unicode("",encoding='utf8',errors='ignore')
                for i in range(msg_num):
                    D                   =   {'orig_msg'     :   msgs_as_json[i],
                                             'all_mail_uid' :   all_mail_uids[i],
                                             'g_msg_id'     :   g_msg_ids[i],
                                             'msg_id'       :   msg_ids[i]}


                    upsert              =   """
                        INSERT into gmail (
                            orig_msg,
                            all_mail_uid,
                            g_msg_id,
                            msg_id
                            )
                        SELECT to_json($txt$%(orig_msg)s$txt$::text)::jsonb,%(all_mail_uid)s,%(g_msg_id)s,'%(msg_id)s'
                        FROM
                            (
                            SELECT array_agg(all_mail_uid) all_uids FROM gmail
                            ) as f1,
                            (
                            SELECT array_agg(g_msg_id) all_g_m_ids FROM gmail
                            ) as f2
                            -- msg_id ignored as sampling showed such value was not unique to each msg
                            -- (
                            -- SELECT array_agg(msg_id) all_m_ids FROM gmail
                            -- ) as f3
                        WHERE
                            (
                                not all_uids @> array['%(all_mail_uid)s'::bigint]
                            AND not all_g_m_ids @> array['%(g_msg_id)s'::bigint]
                            --AND not all_m_ids @> array['%(msg_id)s'::text]
                            )
                        OR
                            (
                               all_uids is null
                            OR all_g_m_ids is null
                            --OR all_m_ids is null
                            )
                        ;
                        """
                    _out                =   upsert % D
                    _out                =   re_sub(r'[^\x00-\x7F]+',' ', _out)
                    cmd                +=   unicode(self.T.codecs.encode(_out,'ascii','ignore'),errors='ignore')
                    # cmd                +=   unicode(upsert,errors='ignore') if type(upsert) is not unicode else upsert


                self.T.conn.set_isolation_level(0)
                self.T.cur.execute(         cmd)

            def quick_sync(msg_num,all_mail_uids,g_msg_ids,msg_ids):
                cmd                     =   unicode("",encoding='utf8',errors='ignore')
                for i in range(msg_num):
                    D                   =   {'all_mail_uid' :   all_mail_uids[i],
                                             'g_msg_id'     :   g_msg_ids[i],
                                             'msg_id'       :   msg_ids[i],
                                             'UPDATE_TABLE' :   'gmail_chk'}


                    upsert              =   """
                        INSERT into %(UPDATE_TABLE)s (
                            all_mail_uid,
                            g_msg_id,
                            msg_id
                            )
                        SELECT %(all_mail_uid)s,%(g_msg_id)s,'%(msg_id)s'
                        FROM
                            (
                            SELECT array_agg(all_mail_uid) all_uids FROM %(UPDATE_TABLE)s
                            ) as f1,
                            (
                            SELECT array_agg(g_msg_id) all_g_m_ids FROM %(UPDATE_TABLE)s
                            ) as f2
                            -- msg_id ignored as sampling showed such value was not unique to each msg
                            -- (
                            -- SELECT array_agg(msg_id) all_m_ids FROM %(UPDATE_TABLE)s
                            -- ) as f3
                        WHERE
                            (
                                not all_uids @> array['%(all_mail_uid)s'::bigint]
                            AND not all_g_m_ids @> array['%(g_msg_id)s'::bigint]
                            )
                        OR
                            (
                               all_uids is null
                            OR all_g_m_ids is null
                            );
                        """
                    _out                =   upsert % D
                    _out                =   re_sub(r'[^\x00-\x7F]+',' ', _out)
                    cmd                +=   unicode(self.T.codecs.encode(_out,'ascii','ignore'),errors='ignore')
                    # cmd                +=   unicode(upsert,errors='ignore') if type(upsert) is not unicode else upsert


                self.T.conn.set_isolation_level(0)
                self.T.cur.execute(         cmd)

            start                       =   self.T.time.time()

            g                           =   self.T.GC.login(self.T.config.gmail.username, 
                                                            self.T.config.gmail.pw)
            all_mail                    =   g.all_mail().mail()

            check_setup(                    method)

            # START PROCESSING FROM WHERE PREVIOUS PROCESSING ENDED
            df                          =   self.T.pd.DataFrame(data={'msg':all_mail})
            df['g_uid']                 =   df.msg.map(lambda m: int(m.uid))

            if method=='full':
                UPDATE_TABLE            =   'gmail'
                UPDATE_COUNT            =   25
            elif method=='quick':
                UPDATE_TABLE            =   'gmail_chk'
                UPDATE_COUNT            =   25

            qry                         =   "select all_mail_uid from %s" % UPDATE_TABLE
            pdf                         =   self.T.pd.read_sql(qry,self.T.eng)
            pg_all_mail_uids            =   pdf.all_mail_uid.tolist()

            # df['cnt'] = ndf.msg.map(lambda s: pg_all_mail_uids.count(s))


            idx                         =   df[df.g_uid.isin(pg_all_mail_uids)].index.tolist()
            df                          =   df.drop(idx,axis=0).reset_index(drop=True)

            remaining_msgs              =   df.msg.tolist()

            M                           =   self._fetch_msg_grp(remaining_msgs,UPDATE_COUNT)

            while True:
                try:
                    msg_grp             =   M.next()
                except StopIteration:
                    break
                msg_num                 =   len(msg_grp)

                msgs_as_dict            =   map(lambda m: m.__dict__,msg_grp)
                all_mail_uids           =   map(lambda m: m.uid, msg_grp)
                g_msg_ids               =   map(lambda m: int(m['message_id']),msgs_as_dict)
                msg_ids                 =   map(lambda m: self._get_msg_ids(m),msgs_as_dict)

                if method=='full':
                    full_sync(msg_num,all_mail_uids,g_msg_ids,msg_ids)
                elif method=='quick':
                    quick_sync(msg_num,all_mail_uids,g_msg_ids,msg_ids)

            end                         =   self.T.time.time()
            print 'total time (seconds):',end-start

        def create_account(self,**kwargs):
            """ Keyword Args:
                    first_name,last_name,
                    user_name,password,
                    recovery_phone,recovery_email
            """

            def setup_account_info():
                # SETUP VARS WITH ACCOUNT INFO
                account_info_dict           =   {'first_name'               :   'FirstName',
                                                 'last_name'                :   'LastName',
                                                 'user_name'                :   'GmailAddress',
                                                 'password'                 :   'Passwd',
                                                 'recovery_phone'           :   'RecoveryPhoneNumber',
                                                 'recovery_email'           :   'RecoveryEmailAddress'}
                account_info_keys           =   account_info_dict.keys()
                T                           =   {}

                if hasattr(self.T,'id') and hasattr(self.T.id,'details'):
                    for k,v in self.T.id.details.__dict__.iteritems():
                        T.update(               {k.strip('_')               :   v})
                        kwargs.update(          {k.strip('_')               :   v})

                for k,v in kwargs.iteritems():
                    if account_info_keys.count(k):
                        T.update(               {account_info_dict[k]       :   v})

                # FILL IN ANY MISSING INFO

                if not T.has_key('FirstName') or not T.has_key('LastName'):
                    g                       =   self.T.randrange(0,2)
                    gender                  =   'Female' if g==0 else 'Male'
                    name                    =   self.T.Identity.F.name_female() if g==0 else self.T.Identity.F.name_male()
                    while len(name.split())!=2:
                        name                =   self.T.Identity.F.name_female() if g==0 else self.T.Identity.F.name_male()
                    first,last              =   name.split()
                    T.update(                   {'FirstName':first,'LastName':last,'gender_num':g,'gender':gender})

                if not T.has_key('GmailAddress'):
                    _user                   =   str(self.T.get_guid().hex)[:10]
                    _pw                     =   str(self.T.get_guid().hex)
                    T.update(                   {'GmailAddress':_user,'Passwd':_pw,'PasswdAgain':_pw})

                T.update(                       {'birth_month'              :   self.T.randrange(1,13),
                                                 'BirthDay'                 :   self.T.randrange(1,29),
                                                 'BirthYear'                :   self.T.randrange(1925,1990)})
                birth_month_dict            =   {10:'a',11:'b',12:'c'}
                if birth_month_dict.keys().count(T['birth_month']):
                    T['birth_month']        =   birth_month_dict[ T['birth_month'] ]

                if not T.has_key('RecoveryPhoneNumber'):
                    T.update(                   {'RecoveryPhoneNumber'      :   '6177024233'})

                if not T.has_key('RecoveryEmailAddress'):
                    T.update(                   {'RecoveryEmailAddress'     :   '*****@*****.**'})

                return T

            if not hasattr(self,'T'):
                self.T.py_path.append(          self.T.os_environ['BD'] + '/real_estate/autoposter')
                from auto_poster            import Auto_Poster
                AP                          =   Auto_Poster(None,no_identity=True)
                self.T.update(                  {'Identity'             :   AP.Identity})
                self.T.update(                  AP.T.__getdict__())

            T                               =   setup_account_info()
            self.T.excluded_defaults        =   ['user-agent','no_java']
            self.T.br                       =   self.T.scraper('chrome',dict=self.T).browser
            start_page                      =   ''.join(['https://accounts.google.com/SignUp?',
                                                         'continue=https%3A%2F%2Fwww.google.com%2F%3Fgws_rd%3Dssl&hl=en'])
            self.T.br.open_page(                start_page)
            self.T.br.wait_for_page(            )

            min_wait                        =   4

            form_parts                      =   ['FirstName','LastName','GmailAddress','Passwd','PasswdAgain']
            for it in form_parts:
                self.T.br.click_element_id_and_type(it,T[it])
                self.T.delay(                   self.T.randrange(min_wait,10))


            self.T.br.window.find_element_by_xpath('//*[@id=":0"]').click()
            self.T.delay(                       self.T.randrange(min_wait+3,min_wait+9))
            self.T.br.window.find_element_by_xpath('//*[@id=":%(birth_month)s"]' % T).click()
            self.T.delay(                       self.T.randrange(min_wait,9))

            form_parts                      =   ['BirthDay','BirthYear']
            for it in form_parts:
                self.T.br.click_element_id_and_type(it,T[it])
                self.T.delay(                   self.T.randrange(min_wait,10))

            # Gender
            self.T.br.window.find_element_by_xpath('//*[@id=":d"]').click()        # Menu
            if T['gender_num']==0:
                self.T.br.window.find_element_by_xpath('//*[@id=":e"]').click()    # Female
            else:
                self.T.br.window.find_element_by_xpath('//*[@id=":f"]').click()    # Male

            # Phone // Current Email
            self.T.br.click_element_id_and_type('RecoveryPhoneNumber',T['RecoveryPhoneNumber'])
            self.T.delay(                       self.T.randrange(min_wait,10))
            self.T.br.click_element_id_and_type('RecoveryEmailAddress',T['RecoveryEmailAddress'])
            self.T.delay(                       self.T.randrange(min_wait,10))

            # CAPTCHA
            self.T.br.zoom(                     '200%')
            start_size                      =   self.T.br.window.get_window_size()
            self.T.br.window.set_window_size(   630,280)
            K                               =   self.T.br.window.find_element_by_id('recaptcha_challenge_image')
            start_location                  =   self.T.br.window.get_window_position()
            self.T.br.scroll_to_element(        "recaptcha_challenge_image")
            self.T.br.post_screenshot(          )
            self.T.br.window.set_window_size(   start_size['width'],start_size['height'])
            self.T.br.zoom(                     '100%')

            # Communicate CAPTCHA
            self.T.update(                      {'line_no'                  :   self.T.I.currentframe().f_back.f_lineno})
            self._parent.Reporter._growl(       '%(line_no)s GOOG@%(user)s<%(guid)s>: NEED CAPTCHA' % self.T,
                                                'http://sys.sanspaper.com/tmp/phantomjs.html' )

            # Receive & Enter Input
            captcha_input                   =   get_input("Captcha code?\n")
            self.T.br.click_element_id_and_type('recaptcha_response_field',captcha_input)

            # VERIFY INFORMATION
            most_vars_inputted              =   ['FirstName','LastName','GmailAddress',
                                                 'BirthDay','BirthYear','RecoveryPhoneNumber','RecoveryEmailAddress']
            for it in most_vars_inputted:
                assert self.T.br.get_element_id_val(it) == str(T[it])
            month_dict                      =   {1:'January',2:'February',3:'March',4:'April',5:'May',6:'June',
                                                 7:'July',8:'August',9:'September','a':'October','b':'November','c':'December'}
            assert self.T.br.window.find_element_by_xpath('//*[@id=":0"]').text == month_dict[ T['birth_month'] ]
            gender_dict                     =   { 0:'Female',1:'Male'}
            assert self.T.br.window.find_element_by_xpath('//*[@id=":d"]').text == gender_dict[ T['gender_num'] ]

            self.T.br.scroll_and_click_id(      "TermsOfService")
            self.T.br.scroll_and_click_id(      "submitbutton")
            self.T.br.wait_for_page(            )

            # IF ASKED TO 'Verify your account'
            if self.T.br.source().count('Verify your account'):
                assert self.T.br.get_element_id_val('signupidvinput') == str(T['RecoveryPhoneNumber'])
                self.T.br.scroll_and_click_id(  'signupidvmethod-voice')
                self.T.br.scroll_and_click_id(  'next-button')
                self.T.br.wait_for_page(        )
                if self.T.br.source().count('This phone number cannot be used for verification.'):
                    print 'Verification Error'
                    i_trace()
                    a=0
                    raise SystemExit

            # COPY USER_DATA_DIR TO IDENTITIES
            cmds                            =   ['cp -r %s %s;' % ( self.T.br.window_cfg['user-data-dir'].rstrip('/'),
                                                                    self.T.br.window_cfg['SAVE_DIR'].rstrip('/'))]
            (_out,_err)                     =   self.T.exec_cmds(cmds)
            assert not _out
            assert _err is None

            # UPDATE COOKIES
            self.T.br.update_cookies(           )

            T['guid']                       =   T['GmailAddress']
            T['email']                      =   T['GmailAddress'] + '@gmail.com'
            T['pw']                         =   T.pop('Passwd')
            details                         =   {'_name'                :   '%s %s' % (T['FirstName'],T['LastName']),}
            details.update(                     {'_recovery_phone'      :   T['RecoveryPhoneNumber'],})
            details.update(                     {'_recovery_email'      :   T['RecoveryEmailAddress'],})
            birth_month_dict                =   {10:'a',11:'b',12:'c'}
            birth_month_dict_rev            =   dict(zip(birth_month_dict.values(),birth_month_dict.keys()))
            T['birth_month']                =   T['birth_month'] if not birth_month_dict_rev.has_key(T['birth_month']) else birth_month_dict_rev[T['birth_month']]
            details.update(                     {'_birthday'            :   '%04d.%02d.%02d' % (int(T['BirthYear']),
                                                                                                int(T['birth_month']),
                                                                                                int(T['BirthDay'])),})
            details.update(                     {'_gender'              :   gender_dict[ T['gender_num'] ],})
            T['details']                    =   self.T.json.dumps(details)

            qry                             =   """ INSERT INTO identities (guid,email,pw,details)
                                                    VALUES ('%(guid)s','%(email)s','%(pw)s','%(details)s'::jsonb) """ % T
            self.T.conn.set_isolation_level(    0)
            self.T.cur.execute(                 qry)

            i_trace()