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

python code to find duplicate row in sqlite database

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

answer python code to find duplicate row in sqlite database

related find duplicate row in python sqlite database

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 2/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

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: python sqlite database row find

Link to this answer
Share Copy Link

Contributed on Apr 23 2022

Pythonist

0 Answers Avg Quality 2/10

python code to find duplicate row in sqlite database

Contents

More Related Answers

python code to find duplicate row in sqlite database

Closely Related Answers

find duplicate row in python sqlite database

Grepper

Documentation

Social

Legal

Contact

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