AttributeError: 'float' object has no attribute 'encode'

Question

下記のプログラムを実行したところこのようなエラーが表示されます。

last_sf_modified = 2018/06/14 22:51:30
last_lo_modified = 2000/01/01 00:00:00
Traceback (most recent call last):
File "s2h_updater.py", line 17, in <module>
updated = s2h.sf_get_updated_companies(last_lo_modified)
File "/home/dbcon/s2h.py", line 46, in sf_get_updated_companies
r[e] = r[e].encode('utf-8')
AttributeError: 'float' object has no attribute 'encode'

「Total_VC_Investment__c」がfloat型のためencodeができない状況です。
様々な方法を試しましたがうまくいかないためお力を貸していただければ幸いです。
float型をstring型に変換する方針です。
試した方法はコメントにしてあります。
宜しくお願いします。

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import s2hdb
from datetime import datetime as dt
from operator import add
#
# Salesforce handle Functions
#

def sf_get_last_modified_date():
    sf = s2hdb.sf_get_descriptor()
    q = "SELECT LastModifiedDate FROM Account " + \
                    "ORDER BY LastModifiedDate DESC LIMIT 1"
    r = sf.query_all(q)
    last_modified = dt.strptime(r["records"][0]["LastModifiedDate"],
                                    '%Y-%m-%dT%H:%M:%S.000+0000')
    return last_modified

def sf_get_updated_companies(last_modified):
    sf = s2hdb.sf_get_descriptor()
    q = "SELECT Name, Website, Description, Description_JP__c, " + \
        "Core_Technology__c, Core_Technology_JP__c, Development_Status__c, " + \
        "Development_Status_JP__c, Application__c, Application_JP__c, Tags__c, " + \
        "crunchbase_City__c, crunchbase_Region__c, crunchbase_Country__c, " + \
        "crunchbase_Founded_Date__c, crunchbase__Latest_Round_Funding_Type_Series__c, " + \
        "crunchbase_Profile_Image_URL__c, CreatedDate, Total_VC_Investment__c " + \
        "FROM Account WHERE LastModifiedDate > " + \
        last_modified.strftime('%Y-%m-%dT%H:%M:%S.000+0000')
    results = sf.query_all(q)
    #print (results)
    coms = []
    for r in results["records"]:
        com = []
        elements = ['Name', 'Website', 'Description', 'Description_JP__c',
                    'Core_Technology__c', 'Core_Technology_JP__c', 'Development_Status__c',
                    'Development_Status_JP__c', 'Application__c', 'Application_JP__c', 'Tags__c',
                    'crunchbase_City__c', 'crunchbase_Region__c', 'crunchbase_Country__c',
                    'crunchbase_Founded_Date__c', 'crunchbase__Latest_Round_Funding_Type_Series__c',
                    'crunchbase_Profile_Image_URL__c', 'CreatedDate', 'Total_VC_Investment__c']
        elements = [str(e) for e in elements]
        for e in elements:
            # Convert NoneType Object as ""
            if (r[e] is None):
                r[e] = str("")
            r[e] = r[e].encode('utf-8')
            r[e] = r[e].replace('\'', '\'\'')

            #if (e == 'crunchbase__Total_Funding_USD__c'):
                #if (r[e] is None):
                    #r[e] = str("")
                #r[e] = str('crunchbase__Total_Funding_USD__c')
                #com.append('\'{0}\''.format(r[e]))
            #else:
           com.append('\'{0}\''.format(r[e]))
        # Duplication check.
        # It seems salesforce returns duplicated records.
        duplicated = False
        for c in coms:
            if coms[0] == '\'{0}\''.format(r["Name"]):
                   duplicated = True
        if (duplicated is True):
            continue

        coms.append(com)
    #print (coms)
    return coms

#
# Local DB handle functions
#

def lo_get_last_modified_date():
    con = s2hdb.lo_get_descriptor()
    cur = con.cursor()

    q = "SELECT last_modified from company ORDER BY last_modified DESC LIMIT 1"
    cur.execute(q)
    if (cur.rowcount == 0):
        # We want to move all from salesforce, so just set very early date
        last_modified = dt.strptime("2000/1/1 00:00:00", '%Y/%m/%d %H:%M:%S')
    else:
        last_modified = cur.fetchone()[0]
    cur.close()

    return last_modified

def lo_update_companies(data):
    if (len(data) == 0):
        return
    con = s2hdb.lo_get_descriptor()
    cur = con.cursor()

    coms = []
    for t in data:
        coms.append(t[0:19])
    #print (coms)
    q = "INSERT INTO company (legal_name, website, `desc`, desc_jp, core_tech, core_tech_jp, development_status, development_status_jp, " + \
        "application, application_jp, cat_name, City, Region, Country, founded_date, funding_series, picture, CreatedDate, total_funding) VALUES " + \
        ", ".join(map(lambda x : "(" + ",".join(x) + ")", coms)) + " " + \
        "ON DUPLICATE KEY UPDATE legal_name = VALUES(legal_name)"
    #print (q)
    cur.execute(q)

    q = "INSERT INTO company (headquarter) " + \
    "SELECT GROUP_CONCAT(City, Region, Country SEPARATOR ', ') FROM company GROUP BY legal_name "
    cur.execute(q)
    con.commit()
    cur.close()

Comments

[coco_bauer]

「Total_VC_Investment__c」(DBから抽出した""Total_VC_Investment__c"フィルドの値）をどうしたいのですか？　浮動小数点数を文字列にするとか、変換する方針があると思うのですが。（何がしたいかが決まらないと、コードは作れません）

[beginner_py]

文字列に変換する方針です。質問にも追記致します。

Answer 1

  r[e] = str(r[e]).encode('utf-8')

のように、文字列であることを保証してあげると良いと思います。

Comments

[beginner_py]

解決できました。有難うございました。