import database # add a record to the database, # database.add_one("Laura", "Smith", "*****@*****.**") # Delete records use # database.delete_one('7') # Lookup Email Address Record database.email_lookup('*****@*****.**') # Add many records # stuff = [ # ('Brenda', 'Smitherton', '*****@*****.**'), # ('Joshua', 'Raintree', '*****@*****.**') # ] # # database.add_many(stuff) # show all database.show_all()
import database # Add a record to the database, first name, last name, email #database.add_one("Laura","Smith",'*****@*****.**') #Delete record user the row id number 6 #database.delete_one('6') # Add many data in list #stuff = [ # ('Brenda','Smitherton','*****@*****.**'), # ('Joshua','Raintree','*****@*****.**') # ] #database.add_many(stuff) # Lookup email Address Record database.email_lookup("*****@*****.**") #Show all customer data database.show_all()
import database # # Add record to DB # database.add_one("Gary", "Tester", "*****@*****.**") # # Add many records to DB # database.add_many_random(10) # # Delete record at rowid # database.delete_one("1") # # Add Many records # stuff = [ # ('Way', 'Out', '*****@*****.**'), # ('Mona', 'Shisha', '*****@*****.**') # ] # database.add_many(stuff) # DB email lookup database.email_lookup("*****@*****.**") # # Show all in DB # database.show_all()
import database #database.add_record("Bartek","Podgorski","*****@*****.**") #database.delete_record('7') #stuff = [ # ('Wes','Brown', '*****@*****.**'), # ('Steph','Kuewa', '*****@*****.**'), # ('Dan', 'Pas', '*****@*****.**') # ] #database.add_many_records(stuff) database.email_lookup("*****@*****.**") #database.show_all()
import database #stuff = [ # ('sof','ort','*****@*****.**'), # ('albert','o','*****@*****.**') # ] #database.add_many(stuff) # database.delete_one('6') # database.add_one("Josi","Josefa","*****@*****.**") #database.show_all() database.email_lookup('*****@*****.**')
import database # Lookup email record database.email_lookup("*****@*****.**") # Delete One record database.delete_one('4') # Add record database.add_one("Rafael", "Magalhaes", "*****@*****.**") # Adds Many records lista = [("Remy", "Lacroix", "*****@*****.**"), ("Lexi", "Belle", "*****@*****.**")] database.add_many(lista) # Show All records database.show_all()
import database # database.add_one("Laura", "Smith", "*****@*****.**") # database.add_one("Cherry", "Blue", "*****@*****.**") # database.delete_one(str(8)) # customers = [ # ('Brenda', 'Smitherton', '*****@*****.**'), # ('Joshua', 'Raintree', '*****@*****.**'), # ('ChungHyang', 'Sung', '*****@*****.**') # ] # database.add_many(customers) database.show_all() print("------- email lookup ------") database.email_lookup("*****@*****.**")
def main() -> None: database.email_lookup('*****@*****.**')
import database # add a record to the database #database.add_one("Kobe","Bryant","*****@*****.**") # delete row 6 using 6 as a string #database.delete_one('6') # look up email database.email_lookup("*****@*****.**") # will give us the specfic email we are looking for #add many records #stuff = [ #('Andrew', 'luck', '*****@*****.**'), #('Tom', 'Brady', 'tombrady.com') #] #database.add_many(stuff) # will add these 2 records to the database #database.show_all() # if we run it, it all print our database
import database database.show_all() database.add_customer("Demo","Istan","*****@*****.**") database.delete_customer(2) rows = [ ('Pablo','Escobar','*****@*****.**'), ('Diablo','Senu','*****@*****.**'), ('Boss','Baby','*****@*****.**') ] database.add_many_cust(rows) database.show_all() database.email_lookup("*****@*****.**")