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()
Ejemplo n.º 2
0
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()
Ejemplo n.º 3
0
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()
Ejemplo n.º 4
0
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()
Ejemplo n.º 5
0
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('*****@*****.**')
Ejemplo n.º 6
0
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()
Ejemplo n.º 7
0
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
Ejemplo n.º 10
0
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("*****@*****.**")