the SQLite database ‘test.db’. You can also supply the special name :memory: to create a database in RAM. c.close() To release the connection of the database c.commit() To save the changes made in the table c.execute() Executes all SQL commands .Accepts two kinds of placeholders: question marks ? (“qmark style”) and named placeholders :name (“named style”).
Cartesian product Cartesian operation is helpful to merge columns from two relations cd cd command refers to change directory Class Template of creating objects. Class variable An ordinary variable declared inside a class cls To clear the screen in command window Comma(,) Comma is used to separate each data in a csv file 12th Std - CS EM Glossary - - compiler Scans the entire program and translates it as a whole into machine code. It generates the error message only after scanning the whole program. Hence debugging is comparatively hard.
Conjunction Concurrence, coincidence Constraint Restriction or limitation Constructor A special function get execution automatically when an object enter into scope. continue To skip the remaining part and start with next iteration. CRUD Create, Read, Update and Delete csv.reader() The reader function is designed to take each line of the file and make a list of all columns csv. () A dialect describes the format of the csv file that is to be read CsvQuote All If quoting is set to csvquote all, then writerow() will quote all fields.
cur = c.cursor() Creating cursor object cur.fetchall() method to get a list of the matching rows. cur.fetchmany() method that returns the next number of rows (n) of the result set cur.fetchone() method to retrieve a single matching row CWI Centrum Wiskunde & Informatica DBA DataBase Adminstrator DBMS Database Management System def This keyword is used to define function. Destructor A special function get execution automatically when an object exit from its scope. dict() It is used to print the data in dictionary format without orderdict Dictionary Collection of Key-Value pairs DictReader() Works by reading in the first line of the CSV and using each column comma separated value in this line as a