Question

In this question you will be writing the code to carry out a query on a database table in Python. The CREATE command shown below is given just for your reference, so that you know the structure of the table and its columns. The database is an SQLite database in the file named taxa.sqlite. create table species ( id int primary key, genus varchar ( 5 0 ), species varchar(50), common_name char(100) ) Write python code that would be part of a script. Assume that the file taxa.sqlite is in the same directory as the script. Before the part of the script you are asked to write, the script assigns a value to the variable gen_id. Use that variable in your code. All this is background, your job is to write the python code that will make a connection to the database and fetch all the columns of all the rows in which the genus is equal to gen_id. You may assume any necessary imports have already been provided. Do not simply concatenate values to create the appropriate command, but use a safer approach.

please write in python. thank you

Answer 1

#!/usr/bin/python
import sqlite3

conn = sqlite3.connect('taxa.sqlite')

cursor = conn.execute("SELECT id, genus, species, common_name from species WHERE genus=?",(gen_id,))
for row in cursor:
    print(row[0], row[1], row[2], row[3])

conn.close()

**************************************************

Thanks for your question. We try our best to help you with detailed answers, But in any case, if you need any modification or have a query/issue with respect to above answer, Please ask that in the comment section. We will surely try to address your query ASAP and resolve the issue.

Please consider providing a thumbs up to this question if it helps you. by Doing that, You will help other students, who are facing similar issue.