def test_basic10(self):
phone_string = '9074635080 9077238267 9077238267'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('AK', result)
def test_basic11(self):
phone_string = '(404) 817 - 8500'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('GA', result)
def test_basic7(self):
phone_string = ' 563-302-5771'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('IA', result)
def test_basic9(self):
phone_string = '907-723-1494 907 723 1494 '
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('AK', result)
def test_basic15(self):
phone_string = '703-112-9971x27'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('VA', result)
def test_basic3(self):
city_string = '123-45'
query = f"SELECT {self.function}(CAST('{city_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual(None, result)
def test_basic17(self):
phone_int = 7031139971
query = f"SELECT {self.function}(CAST('{phone_int}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('VA', result)
def test_basic14(self):
phone_string = '225-344-0381 ext. 221'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('LA', result)
def test_basic7(self):
city_string = 'New York NY'
query = f"SELECT {self.function}(CAST('{city_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('new york', result)
def test_basic1(self):
city_string = 'Richmond'
query = f"SELECT {self.function}(CAST('{city_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('richmond', result)
def test_basic6(self):
city_string = 'Arlington VA'
query = f"SELECT {self.function}(CAST('{city_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('arlington', result)
def test_basic5(self):
city_string = '700 14th St NW, Washington DC 20005'
query = f"SELECT {self.function}(CAST('{city_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('washington', result)
def test_basic4(self):
city_string = 'Winston–Salem'
query = f"SELECT {self.function}(CAST('{city_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('winston–salem', result)
def test_basic12(self):
phone_string = '(512)4433675'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('TX', result)
def test_basic18(self):
phone_int = 17032756427
query = f"SELECT {self.function}(CAST('{phone_int}' AS int)) as result;"
result = db.execute(query).result[0]
self.assertEqual('VA', result)
def test_basic13(self):
phone_string = '(919) 313-8500 x8530'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('NC', result)
def test_basic3(self):
phone_string = '5417522520'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('OR', result)
def test_basic1(self):
phone_string = '(202) 957-8741'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('DC', result)
def test_basic6(self):
phone_string = '301.775.8616'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual('MD', result)
def test_basic16(self):
phone_string = '275-6427'
query = f"SELECT {self.function}(CAST('{phone_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual(None, result)
def test_basic2(self):
city_string = 'This is an example that is too long and can not be a city name'
query = f"SELECT {self.function}(CAST('{city_string}' AS varchar)) as result;"
result = db.execute(query).result[0]
self.assertEqual(None, result)
