Assignment 12-03

 

 

1.viewing the customer based on customer id :

''' Write a Program for Customer Management:
Create a Customerdetails ⇒ id,name,city,tickets
Options :
       1.viewing the customer based on customer id
       2. Total count of tickets sold
       3. City wise ticket sold
       4. Information ⇒ based on descending order
       5. Update ⇒ customer id ⇒ which detail
      6. Delete ⇒ customer id ⇒ delete the record '''

import sqlite3

con = sqlite3.connect('cus.db')

cursor = con.cursor()
sq = '''CREATE TABLE customer_details(
               id INTEGER PRIMARY KEY,
               name TEXT , 
               city TEXT,
               tickets INTEGER)'''

cursor.execute(sq)

print('table is created successfully')

con.commit()
con.close()


 

 

 

import sqlite3

def data(dl2):

    con = sqlite3.connect('cus.db')
    cursor = con.cursor()


    ins = '''INSERT INTO customer_details
            VALUES (?,?,?,?) '''

    cursor.executemany(ins, dl2)

    con.commit()
    print("no of records inserted: ",cursor.rowcount)
    con.commit()
    con.close()

dl2 = [(1,'raj','banglore',4),(2,'raju','chennai',3),(3,'rajesh','mumbai',5),(4,'martha','delhi',2),(5,'ulrich','delhi',4),(6,'jonas','delhi',5),(7,'anna','pune',6),(8,'hanna','kolkata',10),(9,'charlotte','pune',2),(10,'thomas','kolkata',3)]

data(dl2)


 

import sqlite3

def show(n):
    c = sqlite3.connect('cus.db')

    cur = c.cursor()

    cur.execute("SELECT * FROM customer_details WHERE id = (?)",(n,))

    rec = cur.fetchall()

    for i in rec:
        print(i)

    c.commit()
    c.close()


import bhshjb

#k = int(input("enter the id : "))

bhshjb.show()

2. Total count of tickets sold :

import sqlite3

def show():
    c = sqlite3.connect('cus.db')

    cur = c.cursor()

    cur.execute("SELECT SUM(tickets) FROM customer_details ")

    rec = cur.fetchall()

    for i in rec:
        print(i)

    c.commit()
    c.close()


 

3. City wise ticket sold :

 

import sqlite3


def show(n):

    c = sqlite3.connect('cus.db')

    cur = c.cursor()

    cur.execute("SELECT * FROM customer_details WHERE city = (?)", (n,))

    rec = cur.fetchall()
    print(rec)
    j=0
    for i in rec:
        j=i[-1]+j

    print(j)
    c.commit()
    c.close()



 

import bhshjb

#k = int(input("enter the id : "))

bhshjb.show('delhi')

 

4. Information ⇒ based on descending order :

def show(n):

    c = sqlite3.connect('cus.db')

    cur = c.cursor()

    cur.execute("SELECT * FROM customer_details ORDER BY id DESC")

    rec = cur.fetchall()
    print(rec)

    for i in rec:
        print(i)
    c.commit()
    c.close()


 

5. Update ⇒ customer id ⇒ which detail :

 


def show():

    c = sqlite3.connect('cus.db')

    cur = c.cursor()

    cur.execute("UPDATE customer_details SET name = 'suman' WHERE id = 1")

    rec = cur.fetchall()
    print(rec)

    for i in rec:
        print(i)
    c.commit()
    c.close()


 

6. Delete ⇒ customer id ⇒ delete the record :

 

import sqlite3


def show():

    c = sqlite3.connect('cus.db')

    cur = c.cursor()

    cur.execute("DELETE  FROM customer_details WHERE id = 10")

    rec = cur.fetchall()
    print(rec)

    for i in rec:
        print(i)
    c.commit()
    c.close()


 

 

 

 

 

 

Comments

Post a Comment

Popular posts from this blog

Queue in Java

Image
  Queue Interface In Java :   The Queue interface present in the java.util package and extends the Collection interface is used to hold the elements about to be processed in FIFO(First In First Out) order.  It is an ordered list of objects with its use limited to insert elements at the end of the list and deleting elements from the start of the list, (i.e.), it follows the FIFO or the First-In-First-Out principle.       queue needs a concrete class for the declaration and the most common classes are the PriorityQueue and LinkedList in Java.   Queue is an interface, objects cannot be created of the type queue. We always need a class which extends this list in order to create an object   Example : import java.util.LinkedList ; import java.util.Queue ; public class q { public static void main (String[] args) { Queue<Integer> qu = new LinkedList<>() ; for ( int i = 0 ; i < 5 ; i++) ...
Read more

Using lists , tuples, sets, dictionaries

  DAY 2 :   lists , tuples, sets, dictionaries lists: Lists are one of 4 built-in data types in Python used to store collections of data, the other 3 are tuple,set and dictionary, all with different qualities and usage. Lists are used to store multiple items in a single variable. Lists are created using square brackets     example: my_list = ["apple","banana","orange"]                         list2 = [5,7,9,6,3]   methods in list : append() Adds an element at the end of the list clear() Removes all the elements from the list copy() Returns a copy of the list count() Returns the number of elements with the specified value extend() Add the elements of a list (or any iterable), to the end of the current list index() Returns the index of the first element with the specified value insert() Adds an element at the specified position pop() Removes the element at the ...
Read more

Blog on Pytest

  Testing Python Applications with Pytest     Pytest is a testing framework and test runner for Python. In this guide, we will look at the most useful configuration and usage, including several pytest plugins and external libraries.   Pytest basics  Pytest will automatically scan our codebase for test modules, files following the file name convention test_*.py or *_test.py , and scan them for functions named test_*() . If we want to run tests defined as methods inside classes, we need to prefix the class names with Test . Pytest will also automatically pick up any tests written using unittest module.   Standard test functions and test runs from python_pytest . basics import add def test_add_can_add_numbers ( ) : # given num = 3 num2 = 45 # when result = add ( num , num2 ) # then assert result == 48 By default, fixtures are function-scoped, meaning that a fixture's lifetime is t...
Read more