2 Replies - 1414 Views - Last Post: 05 September 2014 - 07:47 PM Rate Topic: -----

#1 mark103  Icon User is offline

  • D.I.C Head

Reputation: -10
  • View blog
  • Posts: 107
  • Joined: 13-April 08

TypeError: attribute of type 'NoneType' is not callable

Posted 04 September 2014 - 08:55 AM

Hi all,

I'm working on my python script as I'm pulling the data from the sqlite3 database. I'm trying to convert the string object to datetime object, but I have got a problem with the code as I get the error when I'm trying convert from the string object to datetime object.

The error I'm getting is: TypeError: attribute of type 'NoneType' is not callable

The error are jumping on this line:

program_startdate = datetime.datetime.strptime(str(row[2]), "%Y%m%d%H%M%S")





Here is example the results from the sqlite3 database:

20140520170000
20140520170000 
20140520170000
20140520170000
20140520170000
20140520170000
20140520170000



Here is the code:

#get the channels list
cur.execute('SELECT channel FROM programs WHERE channel GROUP BY channel')

for row in cur:
    channels = row[0].encode('ascii')
    channelList.append(channels)


    # set the channels text
    for index in range(0, CHANNELS_PER_PAGE):
        channel = channelList[index]

        if channel is not None:
           self.getControl(4110 + index).setLabel(channel)


           #get the programs list
           cur.execute('SELECT channel, title, start_date, stop_date FROM programs WHERE channel="channel"')
           programList = list()
           programs = cur.fetchall()

           for row in programs:
               program = row[1].encode('ascii'), str(row[2]), str(row[3])
               #print program
               #print datetime.datetime.strptime(str(row[2]), "%Y%m%d%H%M%S")

               program_startdate = datetime.datetime.strptime(str(row[2]), "%Y%m%d%H%M%S")
               #program_endDate = datetime.datetime.strptime(str(row[3]), "%Y%m%d%H%M%S")
               programList.append(program)


               # find nearest half hour
               viewStartDate = datetime.datetime.now()
               viewStartDate -= datetime.timedelta(minutes = viewStartDate.minute % 30, seconds = viewStartDate.second)

               #convert the datetime object between start and end date
               startDelta = program_startdate - viewStartDate
               #stopDelta = program_endDate - viewStartDate
               #print startDelta, stopDelta   # check if you're getting the result you want
               #cellStart = self._secondsToXposition(startDelta.seconds)
           cur.close()



I'm using python version 2.6.

Can you please help me how to fix the code to get rid of the error?

Thanks in advance

Is This A Good Question/Topic? 0
  • +

Replies To: TypeError: attribute of type 'NoneType' is not callable

#2 mark103  Icon User is offline

  • D.I.C Head

Reputation: -10
  • View blog
  • Posts: 107
  • Joined: 13-April 08

Re: TypeError: attribute of type 'NoneType' is not callable

Posted 05 September 2014 - 08:50 AM

does anyone know how to fix this????????
Was This Post Helpful? 0
  • +
  • -

#3 mark103  Icon User is offline

  • D.I.C Head

Reputation: -10
  • View blog
  • Posts: 107
  • Joined: 13-April 08

Re: TypeError: attribute of type 'NoneType' is not callable

Posted 05 September 2014 - 07:47 PM

bump
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1