from dbms.table import Table
Table.create('Student', ('id', 'name', 'email', 'address'))
Table.create('Employee', ('id', 'name', 'designation', 'Address'))
Table.index('Student', 'name')
Table.index('Employee', 'name')
students = Table('Student')
students.insert((1, 'Samuel L. Jackson', '*****@*****.**', 'Somewhere in USA'))
print(students.search((None, 'Samuel L. Jackson', None, None)))
employees = Table('Employee')
employees.insert((1, 'Garrett', '123456789', 'New York'))
employees.insert((2, 'John Doe', 'N', 'London'))
employees.insert((3, 'Joe', 'P', 'Kazan'))
# employees.delete((2, None, None, None))
employees.insert((4, 3, 2, 1))
employees.update((4, None, None, None), (4, 3, 'hello', 'world'))
employees.update((4, None, None, None), (4, 'Joe', 'erwin', 'schrodinger'))
print(employees.search((None, 'Garrett', None, None)))
print(employees.search((None, 'Joe', None, None)))
print(employees.search((None, None, None, None)))
students.insert(('id', 'name'), (42, 'Joshua'))
print(students.search((None, None, None, None)))
query = employees.select('id', 'name').where('id').equals(1).Or('name').equals('Joe')
result = employees.execute(query)
print(result)
from dbms.table import Table
Table.create('Student', ('id', 'name', 'email', 'address'))
Table.create('Employee', ('id', 'name', 'designation', 'Address'))
students = Table('Student')
students.insert((1, 'Samuel L. Jackson', '*****@*****.**', 'Somewhere in USA'))
print(students.search((None, 'Samuel L. Jackson', None, None)))
employees = Table('Employee')
employees.insert((1, 'Garrett', '123456789', 'New York'))
employees.insert((2, 'John Doe', 'N', 'London'))
employees.insert((3, 'Joe', 'P', 'Kazan'))
employees.delete((2, None, None, None))
employees.insert((4, 3, 2, 1))
employees.update((4, None, None, None), (4, 3, 'hello', 'world'))
employees.update((4, None, None, None), (4, 'Joe', 'erwin', 'schrodinger'))
print(employees.search((None, 'Garrett', None, None)))
print(employees.search((None, 'Joe', None, None)))
