Considering the following definition of class COMPANY, write a method in Python to search and display the content in a pickled file COMPANY.DAT, where CompID is matching with the value ‘1005’.
class Company: def __init__(self,CID,NAM): self.CompID = CID #CompID Company ID self.CName = NAM #CName Company Name self.Turnover = 1000 def Display(self): print self.CompID,":",self.CName,":",self.Turnover
import pickle def ques4c(): f=Factory() file=open('COMPANY.DAT','rb') try: while True: f=pickle.load(file) if f.CompID==1005: f.Display() except EOF Error: pass file.close() #IGNORE
Observe the following table MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT. Also, find the Degree and Cardinality of the RESULT.
Degree of table RESULT=3
Cardinality of table RESULT = 2
Write a method in python to read the content from a text file diary.txt line by line and display the same on screen.
def read_file(): inFile = open('diary.txt', 'r') for line in inFile: print line
Write a method in Python to read lines from a text file DIARY.TXT, and display those lines, which are starting with an alphabet ‘P’.
def display(): file=open('DIARY.TXT','r') line=file.readline() while line: if line=='P' : print line line=file.readline() file.close() #IGNORE