Breaking News: Grepper is joining You.com. Read the official announcement!

find duplicate row in python sqlite database

Pythonist answered on April 23, 2022 Popularity 3/10 Helpfulness 1/10

answer find duplicate row in python sqlite database

related python code to find duplicate row in sqlite database

find duplicate row in python sqlite database

Comment

for name in ('AlixaProDev','Salamn'): 
    cursor.execute("SELECT rowid FROM Student WHERE Name = ?", (name,))
    db_result=cursor.fetchall()
    if len(db_result)==0:
        print('There is no Student named %s'%name)
    else:
        print('Student %s found with rowids %s'%(name,','.join(map(str, next(zip(*db_result))))))Copy Code

Popularity 3/10 Helpfulness 1/10 Language python

Source: www.alixaprodev.com

Tags: database find python row sqlite

Link to this answer
Share Copy Link

Contributed on Apr 23 2022

Pythonist

0 Answers Avg Quality 2/10

Closely Related Answers

python code to find duplicate row in sqlite database

Comment

import sqlite3
# it will create a databse with name sqlite.db
connection= sqlite3.connect('sqlite.db') 
cursor= connection.cursor()
table_query = '''CREATE TABLE  if not Exists Student
               (Name text, Course text, Age real)'''
       

cursor.execute(table_query)        
# student list 

students_data = [
 ['AlixaProDev','CS',19],
 ['Alixawebdev','BBa',21],
  ['AskALixa','Software',22],
  ['AskALixa','Software',22]
]
insert_q = []

# creating the insert query for each student
for std_data in students_data:
    name = std_data[0]
    course = std_data[1]
    age = std_data[2]
    q=f"INSERT INTO Student VALUES ('{name}','{course}','{age}')"
    # check if a row is already exist 
    cursor.execute("SELECT rowid FROM Student WHERE Name = ?", (name,))
    db_result=cursor.fetchall()
    if len(db_result)==0:
        cursor.execute(q)
        print('Studnet Data inserted Successfully')
    else:
        print('Student %s found with rowids %s'%(name,','.join(map(str, next(zip(*db_result))))))
  
        
# you need to commit changes as well
connection.commit()
# you also need to close  the connection
connection.close()Copy Code

Popularity 3/10 Helpfulness 1/10 Language python

Source: www.alixaprodev.com

Tags: database python sqlite row find

Link to this answer
Share Copy Link

Contributed on Apr 23 2022

Pythonist

0 Answers Avg Quality 2/10

find duplicate row in python sqlite database

Contents

More Related Answers

find duplicate row in python sqlite database

Closely Related Answers

python code to find duplicate row in sqlite database

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.