[SOLVED] Trying to print the amount from database but it shows error like this : TypeError: 'str' object is not callable

yuvi1325 · 09-21-2018, 01:06 AM

row=0
rows=0
sql='select * from train_details'
cur.execute(sql)
rows = cur.fetchall()
print tabulate(rows)

id1=int(input("Enter the ID mentioned above which you want to travel"))
cur.execute("select count(*) from train_details")
row=cur.fetchone()
for i in range(0,row[0]):
for j in range (0,1):
cur.execute('select id from train_details')
row=cur.fetchall()
if(row[i][j]==id1):
#cur.execute("select * from train_details where id==?",(id1,))
#rows = cur.fetchall()
print(" 1.First Class ")
print(" 2.Second Class ")
print(" 3.Third Class ")

choice=int(input("Enter the class which you want to travel"))
if(choice==1):
cur.execute("select firstclass_amount from train_details where id==?"
(id1))
row=cur.fetchall()
for row in rows:
print(row)
elif(choice==2):
cur.execute("select secondclass_amount from train_details where id==?"
(id1))
row=cur.fetchall()
for row in rows:
print(row)
elif(choice==3):
row=0
rows=0
cur.execute("select thirdclass_amount from train_details where id==?"
(id1))
row=cur.fetchall()
for row in rows:
print(row)
else:
print("Enter the above classes mentioned ")

print("Enter the id mentioned above")

berndbausch · 09-21-2018, 02:58 AM

Since you didn't format your code, it's not clear if it is indented correctly.

In any case, this looks incorrect:

Code:

cur.execute("select firstclass_amount from train_details where id==?"
(id1,))

Shouldn't there be a comma after the string?

Same for a few lines further down.

By the way, your question has nothing to do with Linux.

yuvi1325 · 09-21-2018, 03:45 AM

Code:

               
                row=0
	   	rows=0
		sql='select * from train_details'
		cur.execute(sql)		
		rows = cur.fetchall()
        		print tabulate(rows)

		id1=int(input("Enter the ID mentioned above which you want to travel"))
		cur.execute("select count(*) from train_details")
    		row=cur.fetchone()
		for i in range(0,row[0]):
      			for j in range (0,1):
				cur.execute('select id from train_details')
				row=cur.fetchall()
				if(row[i][j]==id1):
					#cur.execute("select * from train_details where id==?",(id1,))
					#rows = cur.fetchall()
					print("         1.First Class        ")
					print("         2.Second Class        ")
					print("         3.Third Class        ")
					
					choice=int(input("Enter the class which you want to travel"))
					if(choice==1):
						cur.execute("select firstclass_amount from train_details where id==?"
(id1))				
						row=cur.fetchall()
						for row in rows:
        						print(row)
        				elif(choice==2):
        					cur.execute("select secondclass_amount from train_details where id==?"
(id1))				
						row=cur.fetchall()
						for row in rows:
        						print(row)
        				elif(choice==3):
        					row=0
        					rows=0
        					cur.execute("select thirdclass_amount from train_details where id==?"
(id1))				
						row=cur.fetchall()
						for row in rows:
        						print(row)
        				else:
        					print("Enter the above classes mentioned ")
						
		print("Enter the id mentioned above")

pan64 · 09-21-2018, 09:03 AM

you made a change in a commented line. That will have no real effect.

Code:

cur.execute("select firstclass_amount from train_details where id==%s" %
(id1))

probably, but there can be other ways too... (ambiguous)

berndbausch · 09-21-2018, 05:46 PM

Quote:

Originally Posted by yuvi1325

Code:

               
                choice=int(input("Enter the class which you want to travel"))
					if(choice==1):
						cur.execute("select firstclass_amount from train_details where id==?"
(id1))				
						row=cur.fetchall()
						for row in rows:
        						print(row)
        				elif(choice==2):
        					cur.execute("select secondclass_amount from train_details where id==?"
(id1))

Still looks incorrect (commas missing), although I would think this generates a syntax error rather than a runtime one.

At which line does the error occur? Which choice do you enter?