New $($additional$)$ requirements

You need to add a new method, named left$\_$outer$\_$join that implements a LEFT OUTER JOIN and returns a new table that is the result of such a join. This method takes a table $($the right side of a join$),$ a column name $($a string$)$ that denotes the name of the left table$$s column, and another column name $($a string$)$ that denotes the name of the right table$$s column. The rows of the focal $($self$)$ table should be joined on equality of the values of the two specified columns.

Note: this method returns a new table, neither of the original tables should be altered. You can assume that all column names are unique and that all rows are well$-$formed.

here's my code:

class Table:

def $\_\_$init$\_\_($self$)$:

self.data $=[]$

def insert$\_$into$($self$,$ row$)$:

self.data.append$($row$)$

def select$($self$,$ columns$\_$to$\_$display, columns$\_$to$\_$order$\_$by$=$None, ascending$=$True$)$:

if columns$\_$to$\_$order$\_$by:

self.data.sort$($

key$=$lambda row: tuple$($row$.$get$($col$,"")$ for col in columns$\_$to$\_$order$\_$by$),$

reverse$=$not ascending,

$)$

result $=[$

$[$row$.$get$($col$,$ None$)$ for col in columns$\_$to$\_$display$]$ for row in self.data

$]$

return result

def left$\_$outer$\_$join$($self$,$ right$\_$table, left$\_$column, right$\_$column$)$:

result$\_$table $=$ Table$()$

for left$\_$row in self.data:

match$\_$found $=$ False

for right$\_$row in right$\_$table.data:

if left$\_$row.get$($left$\_$column$)==$ right$\_$row.get$($right$\_$column$)$:

result$\_$row $=$ left$\_$row.copy$()$

result$\_$row.update$($right$\_$row$)$

result$\_$table.insert$\_$into$($result$\_$row$)$

match$\_$found $=$ True

if not match$\_$found:

result$\_$row $=$ left$\_$row.copy$()$

result$\_$table.insert$\_$into$($result$\_$row$)$

return result$\_$table

here's the test case I am failing:

import unittest

from pprint import pprint

import sys

import os

sys$.$path.append$("/$home$/$codio$/$workspace$/$student$\_$code$/")$

from table$\_$code import Table

def clean$\_$file$($filename$)$:

# remove file if exists for a clean test.

if os$.$path.exists$($filename$)$:

os$.$remove$($filename$)$

else:

print$("$Can not delete the file as it doesn't exists"$)$

class TestTableCode$($unittest$.$TestCase$)$:

def no$\_$sqlite$3\_$import$($self$)$:

#$!$NO$\_$IMPORT

sys$.$modules$[\text{'}$sqlite$3\text{'}]=$ None

import table$\_$code

def test$\_$advanced$($self$)$:

left$\_$table $=$ Table$()$

left$\_$table.insert$\_$into$(\{\text{'}$name$\text{'}$: 'Josh', 'age': $31\})$

left$\_$table.insert$\_$into$(\{\text{'}$name$\text{'}$: 'Josh', 'age': $10\})$

left$\_$table.insert$\_$into$(\{\text{'}$name$\text{'}$: 'Josh', 'age': $12\})$

left$\_$table.insert$\_$into$(\{\text{'}$name$\text{'}$: 'Emily', 'age': $29\})$

left$\_$table.insert$\_$into$(\{\text{'}$name$\text{'}$: 'Charles', 'age': $40\})$

left$\_$table.insert$\_$into$(\{\text{'}$name$\text{'}$: None, 'age': $67\})$

left$\_$table.insert$\_$into$(\{\text{'}$name$\text{'}$: None, 'age': $99\})$

right$\_$table $=$ Table$()$

right$\_$table.insert$\_$into$(\{\text{'}$first$\_$name': 'Josh', 'city': 'Pomona'$\})$

right$\_$table.insert$\_$into$(\{\text{'}$first$\_$name': 'Josh', 'city': 'Gig Harbor'$\})$

right$\_$table.insert$\_$into$(\{\text{'}$first$\_$name': 'Emily', 'city': 'San Diego'$\})$

right$\_$table.insert$\_$into$(\{\text{'}$first$\_$name': 'Cliff', 'city': 'Los Angles'$\})$

right$\_$table.insert$\_$into$(\{\text{'}$first$\_$name': 'Josh', 'city': 'Seattle'$\})$

right$\_$table.insert$\_$into$(\{\text{'}$first$\_$name': None, 'city': 'East Lansing'$\})$

join$\_$table $=$ left$\_$table.left$\_$outer$\_$join$($right$\_$table, 'name', 'first$\_$name'$)$

# check join table

result $=$ join$\_$table.select$([\text{'}$city$\text{'},$ 'first$\_$name', 'name', 'age'$],[\text{'}$age$\text{'},$ 'city'$])$

pprint$($result$)$

expected $=[[\text{'}$Gig Harbor', 'Josh', 'Josh', $10],$

$[\text{'}$Pomona$\text{'},$ 'Josh', 'Josh', $10],$

$[\text{'}$Seattle$\text{'},$ 'Josh', 'Josh', $10],$

$[\text{'}$Gig Harbor', 'Josh', 'Josh', $12],$

$[\text{'}$Pomona$\text{'},$ 'Josh', 'Josh', $12],$

$[\text{'}$Seattle$\text{'},$ 'Josh', 'Josh', $12],$

$[\text{'}$San Diego', 'Emily', 'Emily', $29],$

$[\text{'}$Gig Harbor', 'Josh', 'Josh', $31],$

$[\text{'}$Pomona$\text{'},$ 'Josh', 'Josh', $31],$

$[\text{'}$Seattle$\text{'},$ 'Josh', 'Josh', $31],$

$[$None$,$ None, 'Charles', $40],$

$[$None$,$ None, None, $67],$

$[$None$,$ None, None, $99]]$

self.assertEqual$($expected$,$ result$)$

if $\_\_$name$\_\_==\text{'}\_\_$main$\_\_\text{'}$:

unittest.main$()$