Python fetchall return true and false

I have a python script that makes a fetchall():

connection = pymssql.connect(host='host', user='user', password='pw', database='database', as_dict=True)

cursor = connection.cursor()

cursor.execute("EXEC SPname")
data=cursor.fetchall()


My problem is that the cursor.fetchall() is returning True or Falses (and others columns with others values example above) but in the database the value is a bit 1 or 0 and when exported to CSV it puts the True or False and I want 1 or 0.

Sample data returned in SQL:

ID Price Price2 Price3 Active Opened Sent Enable
1 12234.09 1111.09 3444.36 1 1 1 0


2 Answers
2

You can use int()

int()

Ex:

print(int(True))
print(int(False))


Output:

1
0


a= csv.writer(fp, delimiter=';') for line in data: a.writerows(line)

a= csv.writer(fp, delimiter=';') for line in data: line["mycolumn1"] = int(line["mycolumn1"]) line["mycolumn2"] = int(line["mycolumn2"]) line["mycolumn3"] = int(line["mycolumn3"]) a.writerows(line)

data

fetchall returns a list of tuples or dictionaries. The easiest way to convert them to integers is by mapping the int method to that list:

fetchall

int

data_in_integer_form = map(int, data)


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.