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

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

Method Over riding in Java

Method Overriding in Java : If subclass (child class) has the same method as declared in the parent class, it is known as method overriding in Java . In other words, If a subclass provides the specific implementation of the method that has been declared by one of its parent class, it is known as method overriding.   Usage of Java Method Overriding Method overriding is used to provide the specific implementation of a method which is already provided by its superclass. Method overriding is used for runtime polymorphism   Rules for Java Method Overriding The method must have the same name as in the parent class The method must have the same parameter as in the parent class. There must be an IS-A relationship (inheritance).   // normal parent and child class usage class  Vehicle{      void  run(){System.out.println( "Vehicle is running" );}   }     //child class    class  Bike  exte...
Read more

introduction to SQL

 SQL :    SQL is a standard language for storing, manipulating and retrieving data in databases.   What is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987     What Can SQL do? SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records in a database SQL can update records in a database SQL can delete records from a database SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures, and views     Using SQL in Your Web Site To build a web site that shows data from a database, you will need: An RDBMS database program (i.e. MS Access, SQL Server, MySQL) To use a ser...
Read more