ActiveRecord::SchemaMigration Load (0.4ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (0.1ms)  begin transaction
---------------------------------------------------------------------------------------------------------------
OfacSdnIndividualLoaderTest: test_: OfacSdnIndividualLoader should create flattened_csv_file_for_mysql_import. 
---------------------------------------------------------------------------------------------------------------
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OfacSdnIndividualLoaderTest: test_: OfacSdnIndividualLoader should load table from files multiple times and always have the same record count with only individual sdn_type records. 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   (0.3ms)  SELECT COUNT(*) FROM "ofac_sdn_individuals"
  SQL (0.5ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.6ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.822530"], ["updated_at", "2016-02-23 14:18:58.822530"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.827675"], ["updated_at", "2016-02-23 14:18:58.827675"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.829267"], ["updated_at", "2016-02-23 14:18:58.829267"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.830869"], ["updated_at", "2016-02-23 14:18:58.830869"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.832874"], ["updated_at", "2016-02-23 14:18:58.832874"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.834244"], ["updated_at", "2016-02-23 14:18:58.834244"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.835577"], ["updated_at", "2016-02-23 14:18:58.835577"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.836811"], ["updated_at", "2016-02-23 14:18:58.836811"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SELECT COUNT(*) FROM "ofac_sdn_individuals"
  SQL (0.0ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.838885"], ["updated_at", "2016-02-23 14:18:58.838885"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.840405"], ["updated_at", "2016-02-23 14:18:58.840405"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.841473"], ["updated_at", "2016-02-23 14:18:58.841473"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.842633"], ["updated_at", "2016-02-23 14:18:58.842633"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.844036"], ["updated_at", "2016-02-23 14:18:58.844036"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.845046"], ["updated_at", "2016-02-23 14:18:58.845046"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.846110"], ["updated_at", "2016-02-23 14:18:58.846110"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.847221"], ["updated_at", "2016-02-23 14:18:58.847221"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.2ms)  SELECT COUNT(*) FROM "ofac_sdn_individuals"
   (0.7ms)  rollback transaction
   (0.0ms)  begin transaction
------------------------------------------------------------------------------------------------------------------------------------------------
OfacSdnIndividualLoaderTest: test_: OfacSdnIndividualLoader should only load the first 8 parts of the first and alternate identity first names. 
------------------------------------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.851462"], ["updated_at", "2016-02-23 14:18:58.851462"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.853284"], ["updated_at", "2016-02-23 14:18:58.853284"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.854537"], ["updated_at", "2016-02-23 14:18:58.854537"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.856158"], ["updated_at", "2016-02-23 14:18:58.856158"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.857686"], ["updated_at", "2016-02-23 14:18:58.857686"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.858814"], ["updated_at", "2016-02-23 14:18:58.858814"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.860039"], ["updated_at", "2016-02-23 14:18:58.860039"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.861962"], ["updated_at", "2016-02-23 14:18:58.861962"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.1ms)  SELECT  "ofac_sdn_individuals".* FROM "ofac_sdn_individuals" WHERE "ofac_sdn_individuals"."last_name" = ? LIMIT 1  [["last_name", "ABDELNUR"]]
   (0.6ms)  rollback transaction
   (0.0ms)  begin transaction
--------------------------------------------------------------------------------------------------
OfacSdnIndividualLoaderTest: test_: OfacSdnIndividualLoader should upcase and remove punctuation. 
--------------------------------------------------------------------------------------------------
  SQL (0.1ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.2ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.869068"], ["updated_at", "2016-02-23 14:18:58.869068"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.870810"], ["updated_at", "2016-02-23 14:18:58.870810"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.871916"], ["updated_at", "2016-02-23 14:18:58.871916"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.873177"], ["updated_at", "2016-02-23 14:18:58.873177"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.874631"], ["updated_at", "2016-02-23 14:18:58.874631"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.875674"], ["updated_at", "2016-02-23 14:18:58.875674"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.876752"], ["updated_at", "2016-02-23 14:18:58.876752"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.877895"], ["updated_at", "2016-02-23 14:18:58.877895"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.0ms)  SELECT  "ofac_sdn_individuals".* FROM "ofac_sdn_individuals" WHERE "ofac_sdn_individuals"."last_name" = ? LIMIT 1  [["last_name", "AGUIAR"]]
   (0.7ms)  rollback transaction
   (0.0ms)  begin transaction
----------------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #db_hit? should return false if name is not an exact match in the database. 
----------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.2ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.881873"], ["updated_at", "2016-02-23 14:18:58.881873"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.883604"], ["updated_at", "2016-02-23 14:18:58.883604"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.886274"], ["updated_at", "2016-02-23 14:18:58.886274"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.887742"], ["updated_at", "2016-02-23 14:18:58.887742"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.889847"], ["updated_at", "2016-02-23 14:18:58.889847"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.891205"], ["updated_at", "2016-02-23 14:18:58.891205"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.892701"], ["updated_at", "2016-02-23 14:18:58.892701"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.893799"], ["updated_at", "2016-02-23 14:18:58.893799"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Exists (0.3ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'DE' OR "ofac_sdn_individuals"."first_name_1" = 'DE') OR "ofac_sdn_individuals"."first_name_2" = 'DE') OR "ofac_sdn_individuals"."first_name_3" = 'DE') OR "ofac_sdn_individuals"."first_name_4" = 'DE') OR "ofac_sdn_individuals"."first_name_5" = 'DE') OR "ofac_sdn_individuals"."first_name_6" = 'DE') OR "ofac_sdn_individuals"."first_name_7" = 'DE') OR "ofac_sdn_individuals"."first_name_8" = 'DE') AND (((((((("ofac_sdn_individuals"."last_name" = 'LA' OR "ofac_sdn_individuals"."first_name_1" = 'LA') OR "ofac_sdn_individuals"."first_name_2" = 'LA') OR "ofac_sdn_individuals"."first_name_3" = 'LA') OR "ofac_sdn_individuals"."first_name_4" = 'LA') OR "ofac_sdn_individuals"."first_name_5" = 'LA') OR "ofac_sdn_individuals"."first_name_6" = 'LA') OR "ofac_sdn_individuals"."first_name_7" = 'LA') OR "ofac_sdn_individuals"."first_name_8" = 'LA') AND (((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'DE' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'DE') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LA' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LA') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
  OfacSdnIndividual Exists (0.1ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'MARIA' OR "ofac_sdn_individuals"."first_name_1" = 'MARIA') OR "ofac_sdn_individuals"."first_name_2" = 'MARIA') OR "ofac_sdn_individuals"."first_name_3" = 'MARIA') OR "ofac_sdn_individuals"."first_name_4" = 'MARIA') OR "ofac_sdn_individuals"."first_name_5" = 'MARIA') OR "ofac_sdn_individuals"."first_name_6" = 'MARIA') OR "ofac_sdn_individuals"."first_name_7" = 'MARIA') OR "ofac_sdn_individuals"."first_name_8" = 'MARIA') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'MARIA' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'MARIA') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'MARIA') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'MARIA') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'MARIA') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'MARIA') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'MARIA') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'MARIA') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'MARIA') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
  OfacSdnIndividual Exists (0.2ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'LA' OR "ofac_sdn_individuals"."first_name_1" = 'LA') OR "ofac_sdn_individuals"."first_name_2" = 'LA') OR "ofac_sdn_individuals"."first_name_3" = 'LA') OR "ofac_sdn_individuals"."first_name_4" = 'LA') OR "ofac_sdn_individuals"."first_name_5" = 'LA') OR "ofac_sdn_individuals"."first_name_6" = 'LA') OR "ofac_sdn_individuals"."first_name_7" = 'LA') OR "ofac_sdn_individuals"."first_name_8" = 'LA') AND (((((((("ofac_sdn_individuals"."last_name" = 'DE' OR "ofac_sdn_individuals"."first_name_1" = 'DE') OR "ofac_sdn_individuals"."first_name_2" = 'DE') OR "ofac_sdn_individuals"."first_name_3" = 'DE') OR "ofac_sdn_individuals"."first_name_4" = 'DE') OR "ofac_sdn_individuals"."first_name_5" = 'DE') OR "ofac_sdn_individuals"."first_name_6" = 'DE') OR "ofac_sdn_individuals"."first_name_7" = 'DE') OR "ofac_sdn_individuals"."first_name_8" = 'DE') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LA' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LA') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'DE' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'DE') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
-------------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #db_hit? should return true if name is an 'exact' match in the database. 
-------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.4ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.906105"], ["updated_at", "2016-02-23 14:18:58.906105"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.908523"], ["updated_at", "2016-02-23 14:18:58.908523"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.910005"], ["updated_at", "2016-02-23 14:18:58.910005"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.911562"], ["updated_at", "2016-02-23 14:18:58.911562"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.913310"], ["updated_at", "2016-02-23 14:18:58.913310"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.914772"], ["updated_at", "2016-02-23 14:18:58.914772"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.915968"], ["updated_at", "2016-02-23 14:18:58.915968"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.917150"], ["updated_at", "2016-02-23 14:18:58.917150"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Exists (0.2ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
  OfacSdnIndividual Exists (0.1ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
  OfacSdnIndividual Exists (0.1ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
  OfacSdnIndividual Exists (0.1ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
   (0.9ms)  rollback transaction
   (0.1ms)  begin transaction
---------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #db_hit? should should be case insensitive for the name. 
---------------------------------------------------------------------------------------------------
  SQL (0.3ms)  DELETE FROM "ofac_sdn_individuals"
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.925379"], ["updated_at", "2016-02-23 14:18:58.925379"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.928005"], ["updated_at", "2016-02-23 14:18:58.928005"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.929525"], ["updated_at", "2016-02-23 14:18:58.929525"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.931044"], ["updated_at", "2016-02-23 14:18:58.931044"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.932801"], ["updated_at", "2016-02-23 14:18:58.932801"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.934287"], ["updated_at", "2016-02-23 14:18:58.934287"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.935812"], ["updated_at", "2016-02-23 14:18:58.935812"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.937459"], ["updated_at", "2016-02-23 14:18:58.937459"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Exists (0.2ms)  SELECT  1 AS one FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') AND (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))) LIMIT 1
   (0.7ms)  rollback transaction
   (0.1ms)  begin transaction
-----------------------------------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #possible_hits should not give partial scores if sounds like does not match the entire string. 
-----------------------------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.944690"], ["updated_at", "2016-02-23 14:18:58.944690"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.947092"], ["updated_at", "2016-02-23 14:18:58.947092"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.948805"], ["updated_at", "2016-02-23 14:18:58.948805"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.950104"], ["updated_at", "2016-02-23 14:18:58.950104"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.951633"], ["updated_at", "2016-02-23 14:18:58.951633"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.952726"], ["updated_at", "2016-02-23 14:18:58.952726"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.954291"], ["updated_at", "2016-02-23 14:18:58.954291"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.955605"], ["updated_at", "2016-02-23 14:18:58.955605"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.3ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
--------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #possible_hits should return an array of possible hits. 
--------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.963402"], ["updated_at", "2016-02-23 14:18:58.963402"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.969181"], ["updated_at", "2016-02-23 14:18:58.969181"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.970381"], ["updated_at", "2016-02-23 14:18:58.970381"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.971573"], ["updated_at", "2016-02-23 14:18:58.971573"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.973569"], ["updated_at", "2016-02-23 14:18:58.973569"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.975664"], ["updated_at", "2016-02-23 14:18:58.975664"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.977513"], ["updated_at", "2016-02-23 14:18:58.977513"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.979174"], ["updated_at", "2016-02-23 14:18:58.979174"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.6ms)  rollback transaction
   (0.0ms)  begin transaction
----------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should be backward compatible with Ofac.new. 
----------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:58.987000"], ["updated_at", "2016-02-23 14:18:58.987000"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:58.989147"], ["updated_at", "2016-02-23 14:18:58.989147"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:58.990706"], ["updated_at", "2016-02-23 14:18:58.990706"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:58.991925"], ["updated_at", "2016-02-23 14:18:58.991925"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.993571"], ["updated_at", "2016-02-23 14:18:58.993571"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.994729"], ["updated_at", "2016-02-23 14:18:58.994729"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:58.995854"], ["updated_at", "2016-02-23 14:18:58.995854"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:58.997139"], ["updated_at", "2016-02-23 14:18:58.997139"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
-----------------------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should deduct scores for non matches on address if data is in the database. 
-----------------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.001677"], ["updated_at", "2016-02-23 14:18:59.001677"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.003459"], ["updated_at", "2016-02-23 14:18:59.003459"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.004592"], ["updated_at", "2016-02-23 14:18:59.004592"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.005786"], ["updated_at", "2016-02-23 14:18:59.005786"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.007292"], ["updated_at", "2016-02-23 14:18:59.007292"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.008428"], ["updated_at", "2016-02-23 14:18:59.008428"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.009681"], ["updated_at", "2016-02-23 14:18:59.009681"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.011061"], ["updated_at", "2016-02-23 14:18:59.011061"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.6ms)  rollback transaction
   (0.0ms)  begin transaction
---------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should get a score when there are multiple first names. 
---------------------------------------------------------------------------------------------------------
  SQL (0.6ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.017045"], ["updated_at", "2016-02-23 14:18:59.017045"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.018982"], ["updated_at", "2016-02-23 14:18:59.018982"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.020175"], ["updated_at", "2016-02-23 14:18:59.020175"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.021395"], ["updated_at", "2016-02-23 14:18:59.021395"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.022932"], ["updated_at", "2016-02-23 14:18:59.022932"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.024116"], ["updated_at", "2016-02-23 14:18:59.024116"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.026711"], ["updated_at", "2016-02-23 14:18:59.026711"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.028018"], ["updated_at", "2016-02-23 14:18:59.028018"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.3ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((((((("ofac_sdn_individuals"."last_name" = 'NO' OR "ofac_sdn_individuals"."first_name_1" = 'NO') OR "ofac_sdn_individuals"."first_name_2" = 'NO') OR "ofac_sdn_individuals"."first_name_3" = 'NO') OR "ofac_sdn_individuals"."first_name_4" = 'NO') OR "ofac_sdn_individuals"."first_name_5" = 'NO') OR "ofac_sdn_individuals"."first_name_6" = 'NO') OR "ofac_sdn_individuals"."first_name_7" = 'NO') OR "ofac_sdn_individuals"."first_name_8" = 'NO') OR (((((((("ofac_sdn_individuals"."last_name" = 'MATCH' OR "ofac_sdn_individuals"."first_name_1" = 'MATCH') OR "ofac_sdn_individuals"."first_name_2" = 'MATCH') OR "ofac_sdn_individuals"."first_name_3" = 'MATCH') OR "ofac_sdn_individuals"."first_name_4" = 'MATCH') OR "ofac_sdn_individuals"."first_name_5" = 'MATCH') OR "ofac_sdn_individuals"."first_name_6" = 'MATCH') OR "ofac_sdn_individuals"."first_name_7" = 'MATCH') OR "ofac_sdn_individuals"."first_name_8" = 'MATCH')) OR (((((((("ofac_sdn_individuals"."last_name" = 'INCREDIBLY' OR "ofac_sdn_individuals"."first_name_1" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_2" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_3" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_4" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_5" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_6" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_7" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_8" = 'INCREDIBLY')) OR (((((((("ofac_sdn_individuals"."last_name" = 'LONG' OR "ofac_sdn_individuals"."first_name_1" = 'LONG') OR "ofac_sdn_individuals"."first_name_2" = 'LONG') OR "ofac_sdn_individuals"."first_name_3" = 'LONG') OR "ofac_sdn_individuals"."first_name_4" = 'LONG') OR "ofac_sdn_individuals"."first_name_5" = 'LONG') OR "ofac_sdn_individuals"."first_name_6" = 'LONG') OR "ofac_sdn_individuals"."first_name_7" = 'LONG') OR "ofac_sdn_individuals"."first_name_8" = 'LONG')) OR (((((((("ofac_sdn_individuals"."last_name" = 'NAME' OR "ofac_sdn_individuals"."first_name_1" = 'NAME') OR "ofac_sdn_individuals"."first_name_2" = 'NAME') OR "ofac_sdn_individuals"."first_name_3" = 'NAME') OR "ofac_sdn_individuals"."first_name_4" = 'NAME') OR "ofac_sdn_individuals"."first_name_5" = 'NAME') OR "ofac_sdn_individuals"."first_name_6" = 'NAME') OR "ofac_sdn_individuals"."first_name_7" = 'NAME') OR "ofac_sdn_individuals"."first_name_8" = 'NAME')) or ((((((((((((("ofac_sdn_individuals"."alternate_last_name" = 'NO' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'NO') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'MATCH' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'MATCH')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'INCREDIBLY' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'INCREDIBLY')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LONG' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LONG')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'NAME' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'NAME'))))
  OfacSdnIndividual Load (0.3ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((((((("ofac_sdn_individuals"."last_name" = 'MATCH' OR "ofac_sdn_individuals"."first_name_1" = 'MATCH') OR "ofac_sdn_individuals"."first_name_2" = 'MATCH') OR "ofac_sdn_individuals"."first_name_3" = 'MATCH') OR "ofac_sdn_individuals"."first_name_4" = 'MATCH') OR "ofac_sdn_individuals"."first_name_5" = 'MATCH') OR "ofac_sdn_individuals"."first_name_6" = 'MATCH') OR "ofac_sdn_individuals"."first_name_7" = 'MATCH') OR "ofac_sdn_individuals"."first_name_8" = 'MATCH') OR (((((((("ofac_sdn_individuals"."last_name" = 'NO' OR "ofac_sdn_individuals"."first_name_1" = 'NO') OR "ofac_sdn_individuals"."first_name_2" = 'NO') OR "ofac_sdn_individuals"."first_name_3" = 'NO') OR "ofac_sdn_individuals"."first_name_4" = 'NO') OR "ofac_sdn_individuals"."first_name_5" = 'NO') OR "ofac_sdn_individuals"."first_name_6" = 'NO') OR "ofac_sdn_individuals"."first_name_7" = 'NO') OR "ofac_sdn_individuals"."first_name_8" = 'NO')) OR (((((((("ofac_sdn_individuals"."last_name" = 'NAME' OR "ofac_sdn_individuals"."first_name_1" = 'NAME') OR "ofac_sdn_individuals"."first_name_2" = 'NAME') OR "ofac_sdn_individuals"."first_name_3" = 'NAME') OR "ofac_sdn_individuals"."first_name_4" = 'NAME') OR "ofac_sdn_individuals"."first_name_5" = 'NAME') OR "ofac_sdn_individuals"."first_name_6" = 'NAME') OR "ofac_sdn_individuals"."first_name_7" = 'NAME') OR "ofac_sdn_individuals"."first_name_8" = 'NAME')) OR (((((((("ofac_sdn_individuals"."last_name" = 'LONG' OR "ofac_sdn_individuals"."first_name_1" = 'LONG') OR "ofac_sdn_individuals"."first_name_2" = 'LONG') OR "ofac_sdn_individuals"."first_name_3" = 'LONG') OR "ofac_sdn_individuals"."first_name_4" = 'LONG') OR "ofac_sdn_individuals"."first_name_5" = 'LONG') OR "ofac_sdn_individuals"."first_name_6" = 'LONG') OR "ofac_sdn_individuals"."first_name_7" = 'LONG') OR "ofac_sdn_individuals"."first_name_8" = 'LONG')) OR (((((((("ofac_sdn_individuals"."last_name" = 'INCREDIBLY' OR "ofac_sdn_individuals"."first_name_1" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_2" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_3" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_4" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_5" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_6" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_7" = 'INCREDIBLY') OR "ofac_sdn_individuals"."first_name_8" = 'INCREDIBLY')) or ((((((((((((("ofac_sdn_individuals"."alternate_last_name" = 'MATCH' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'MATCH') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'MATCH') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'NO' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'NO') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'NO')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'NAME' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'NAME')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LONG' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LONG') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LONG')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'INCREDIBLY' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'INCREDIBLY') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'INCREDIBLY'))))
   (0.7ms)  rollback transaction
   (0.1ms)  begin transaction
---------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a partial score if there is a partial name match. 
---------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.036764"], ["updated_at", "2016-02-23 14:18:59.036764"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.2ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.039204"], ["updated_at", "2016-02-23 14:18:59.039204"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.042418"], ["updated_at", "2016-02-23 14:18:59.042418"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.044071"], ["updated_at", "2016-02-23 14:18:59.044071"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.045840"], ["updated_at", "2016-02-23 14:18:59.045840"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.047173"], ["updated_at", "2016-02-23 14:18:59.047173"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.048474"], ["updated_at", "2016-02-23 14:18:59.048474"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.049658"], ["updated_at", "2016-02-23 14:18:59.049658"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'MIDDLENAME' OR "ofac_sdn_individuals"."first_name_1" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_2" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_3" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_4" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_5" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_6" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_7" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_8" = 'MIDDLENAME')) OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or ((((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'MIDDLENAME' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'MIDDLENAME')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'WRONGLASTNAME' OR "ofac_sdn_individuals"."first_name_1" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."first_name_2" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."first_name_3" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."first_name_4" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."first_name_5" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."first_name_6" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."first_name_7" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."first_name_8" = 'WRONGLASTNAME') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'WRONGLASTNAME' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'WRONGLASTNAME') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'WRONGLASTNAME') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'MIDDLENAME' OR "ofac_sdn_individuals"."first_name_1" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_2" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_3" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_4" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_5" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_6" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_7" = 'MIDDLENAME') OR "ofac_sdn_individuals"."first_name_8" = 'MIDDLENAME')) OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or ((((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'MIDDLENAME' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'MIDDLENAME') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'MIDDLENAME')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.8ms)  rollback transaction
   (0.0ms)  begin transaction
-----------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a score of 0 if no name is given. 
-----------------------------------------------------------------------------------------------
  SQL (0.1ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.056780"], ["updated_at", "2016-02-23 14:18:59.056780"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.059167"], ["updated_at", "2016-02-23 14:18:59.059167"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.060906"], ["updated_at", "2016-02-23 14:18:59.060906"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.062537"], ["updated_at", "2016-02-23 14:18:59.062537"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.064498"], ["updated_at", "2016-02-23 14:18:59.064498"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.066052"], ["updated_at", "2016-02-23 14:18:59.066052"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.067348"], ["updated_at", "2016-02-23 14:18:59.067348"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.068614"], ["updated_at", "2016-02-23 14:18:59.068614"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (1.7ms)  rollback transaction
   (0.0ms)  begin transaction
-----------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a score of 0 if there is no name match. 
-----------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.073065"], ["updated_at", "2016-02-23 14:18:59.073065"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.075033"], ["updated_at", "2016-02-23 14:18:59.075033"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.076242"], ["updated_at", "2016-02-23 14:18:59.076242"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.077500"], ["updated_at", "2016-02-23 14:18:59.077500"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.079318"], ["updated_at", "2016-02-23 14:18:59.079318"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.080471"], ["updated_at", "2016-02-23 14:18:59.080471"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.082135"], ["updated_at", "2016-02-23 14:18:59.082135"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.084520"], ["updated_at", "2016-02-23 14:18:59.084520"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'KEVIN' OR "ofac_sdn_individuals"."first_name_1" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_2" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_3" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_4" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_5" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_6" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_7" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_8" = 'KEVIN') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'KEVIN' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'KEVIN')))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'OBRIAN' OR "ofac_sdn_individuals"."first_name_1" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_2" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_3" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_4" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_5" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_6" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_7" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_8" = 'OBRIAN') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OBRIAN' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OBRIAN')))
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'OBRIAN' OR "ofac_sdn_individuals"."first_name_1" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_2" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_3" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_4" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_5" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_6" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_7" = 'OBRIAN') OR "ofac_sdn_individuals"."first_name_8" = 'OBRIAN') OR (((((((("ofac_sdn_individuals"."last_name" = 'MATTHEW' OR "ofac_sdn_individuals"."first_name_1" = 'MATTHEW') OR "ofac_sdn_individuals"."first_name_2" = 'MATTHEW') OR "ofac_sdn_individuals"."first_name_3" = 'MATTHEW') OR "ofac_sdn_individuals"."first_name_4" = 'MATTHEW') OR "ofac_sdn_individuals"."first_name_5" = 'MATTHEW') OR "ofac_sdn_individuals"."first_name_6" = 'MATTHEW') OR "ofac_sdn_individuals"."first_name_7" = 'MATTHEW') OR "ofac_sdn_individuals"."first_name_8" = 'MATTHEW')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OBRIAN' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OBRIAN') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OBRIAN') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'MATTHEW' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'MATTHEW') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'MATTHEW') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'MATTHEW') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'MATTHEW') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'MATTHEW') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'MATTHEW') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'MATTHEW') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'MATTHEW'))))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'KEVIN' OR "ofac_sdn_individuals"."first_name_1" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_2" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_3" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_4" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_5" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_6" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_7" = 'KEVIN') OR "ofac_sdn_individuals"."first_name_8" = 'KEVIN') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'KEVIN' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'KEVIN') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'KEVIN')))
   (0.7ms)  rollback transaction
   (0.0ms)  begin transaction
---------------------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a score of 100 if there is a name and city and address match. 
---------------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.091167"], ["updated_at", "2016-02-23 14:18:59.091167"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.093358"], ["updated_at", "2016-02-23 14:18:59.093358"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.094735"], ["updated_at", "2016-02-23 14:18:59.094735"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.095956"], ["updated_at", "2016-02-23 14:18:59.095956"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.097525"], ["updated_at", "2016-02-23 14:18:59.097525"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.098667"], ["updated_at", "2016-02-23 14:18:59.098667"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.099910"], ["updated_at", "2016-02-23 14:18:59.099910"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.101029"], ["updated_at", "2016-02-23 14:18:59.101029"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.7ms)  rollback transaction
   (0.0ms)  begin transaction
-------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a score of 30 if there is only a partial match. 
-------------------------------------------------------------------------------------------------------------
  SQL (0.1ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.104947"], ["updated_at", "2016-02-23 14:18:59.104947"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.108326"], ["updated_at", "2016-02-23 14:18:59.108326"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.110045"], ["updated_at", "2016-02-23 14:18:59.110045"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.111460"], ["updated_at", "2016-02-23 14:18:59.111460"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.113242"], ["updated_at", "2016-02-23 14:18:59.113242"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.114689"], ["updated_at", "2016-02-23 14:18:59.114689"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.116152"], ["updated_at", "2016-02-23 14:18:59.116152"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.117239"], ["updated_at", "2016-02-23 14:18:59.117239"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.3ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'LA' OR "ofac_sdn_individuals"."first_name_1" = 'LA') OR "ofac_sdn_individuals"."first_name_2" = 'LA') OR "ofac_sdn_individuals"."first_name_3" = 'LA') OR "ofac_sdn_individuals"."first_name_4" = 'LA') OR "ofac_sdn_individuals"."first_name_5" = 'LA') OR "ofac_sdn_individuals"."first_name_6" = 'LA') OR "ofac_sdn_individuals"."first_name_7" = 'LA') OR "ofac_sdn_individuals"."first_name_8" = 'LA')) OR (((((((("ofac_sdn_individuals"."last_name" = 'DE' OR "ofac_sdn_individuals"."first_name_1" = 'DE') OR "ofac_sdn_individuals"."first_name_2" = 'DE') OR "ofac_sdn_individuals"."first_name_3" = 'DE') OR "ofac_sdn_individuals"."first_name_4" = 'DE') OR "ofac_sdn_individuals"."first_name_5" = 'DE') OR "ofac_sdn_individuals"."first_name_6" = 'DE') OR "ofac_sdn_individuals"."first_name_7" = 'DE') OR "ofac_sdn_individuals"."first_name_8" = 'DE')) OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LA' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LA')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'DE' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'DE')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
  OfacSdnIndividual Load (0.3ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((((("ofac_sdn_individuals"."last_name" = 'DE' OR "ofac_sdn_individuals"."first_name_1" = 'DE') OR "ofac_sdn_individuals"."first_name_2" = 'DE') OR "ofac_sdn_individuals"."first_name_3" = 'DE') OR "ofac_sdn_individuals"."first_name_4" = 'DE') OR "ofac_sdn_individuals"."first_name_5" = 'DE') OR "ofac_sdn_individuals"."first_name_6" = 'DE') OR "ofac_sdn_individuals"."first_name_7" = 'DE') OR "ofac_sdn_individuals"."first_name_8" = 'DE') OR (((((((("ofac_sdn_individuals"."last_name" = 'LA' OR "ofac_sdn_individuals"."first_name_1" = 'LA') OR "ofac_sdn_individuals"."first_name_2" = 'LA') OR "ofac_sdn_individuals"."first_name_3" = 'LA') OR "ofac_sdn_individuals"."first_name_4" = 'LA') OR "ofac_sdn_individuals"."first_name_5" = 'LA') OR "ofac_sdn_individuals"."first_name_6" = 'LA') OR "ofac_sdn_individuals"."first_name_7" = 'LA') OR "ofac_sdn_individuals"."first_name_8" = 'LA')) OR (((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ')) OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((((("ofac_sdn_individuals"."alternate_last_name" = 'DE' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'DE') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'DE') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LA' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LA') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LA')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.8ms)  rollback transaction
   (0.0ms)  begin transaction
--------------------------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a score of 60 if there is a name match on alternate identity name. 
--------------------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.125320"], ["updated_at", "2016-02-23 14:18:59.125320"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.127539"], ["updated_at", "2016-02-23 14:18:59.127539"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.128793"], ["updated_at", "2016-02-23 14:18:59.128793"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.130035"], ["updated_at", "2016-02-23 14:18:59.130035"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.131608"], ["updated_at", "2016-02-23 14:18:59.131608"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.132896"], ["updated_at", "2016-02-23 14:18:59.132896"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.134407"], ["updated_at", "2016-02-23 14:18:59.134407"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.135673"], ["updated_at", "2016-02-23 14:18:59.135673"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.3ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'NAME' OR "ofac_sdn_individuals"."first_name_1" = 'NAME') OR "ofac_sdn_individuals"."first_name_2" = 'NAME') OR "ofac_sdn_individuals"."first_name_3" = 'NAME') OR "ofac_sdn_individuals"."first_name_4" = 'NAME') OR "ofac_sdn_individuals"."first_name_5" = 'NAME') OR "ofac_sdn_individuals"."first_name_6" = 'NAME') OR "ofac_sdn_individuals"."first_name_7" = 'NAME') OR "ofac_sdn_individuals"."first_name_8" = 'NAME') OR (((((((("ofac_sdn_individuals"."last_name" = 'ALTERNATE' OR "ofac_sdn_individuals"."first_name_1" = 'ALTERNATE') OR "ofac_sdn_individuals"."first_name_2" = 'ALTERNATE') OR "ofac_sdn_individuals"."first_name_3" = 'ALTERNATE') OR "ofac_sdn_individuals"."first_name_4" = 'ALTERNATE') OR "ofac_sdn_individuals"."first_name_5" = 'ALTERNATE') OR "ofac_sdn_individuals"."first_name_6" = 'ALTERNATE') OR "ofac_sdn_individuals"."first_name_7" = 'ALTERNATE') OR "ofac_sdn_individuals"."first_name_8" = 'ALTERNATE')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'NAME' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'NAME') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'NAME') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'ALTERNATE' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'ALTERNATE') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'ALTERNATE') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'ALTERNATE') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'ALTERNATE') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'ALTERNATE') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'ALTERNATE') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'ALTERNATE') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'ALTERNATE'))))
   (0.7ms)  rollback transaction
   (0.0ms)  begin transaction
-----------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a score of 60 if there is a name match. 
-----------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.141663"], ["updated_at", "2016-02-23 14:18:59.141663"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.143430"], ["updated_at", "2016-02-23 14:18:59.143430"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.144604"], ["updated_at", "2016-02-23 14:18:59.144604"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.145813"], ["updated_at", "2016-02-23 14:18:59.145813"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.150166"], ["updated_at", "2016-02-23 14:18:59.150166"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.151243"], ["updated_at", "2016-02-23 14:18:59.151243"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.152268"], ["updated_at", "2016-02-23 14:18:59.152268"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.153370"], ["updated_at", "2016-02-23 14:18:59.153370"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.6ms)  rollback transaction
   (0.0ms)  begin transaction
--------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give a score of 90 if there is a name and city match. 
--------------------------------------------------------------------------------------------------------------
  SQL (0.1ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (1.5ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.157971"], ["updated_at", "2016-02-23 14:18:59.157971"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.161279"], ["updated_at", "2016-02-23 14:18:59.161279"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.162842"], ["updated_at", "2016-02-23 14:18:59.162842"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.164290"], ["updated_at", "2016-02-23 14:18:59.164290"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.166079"], ["updated_at", "2016-02-23 14:18:59.166079"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.5ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.167922"], ["updated_at", "2016-02-23 14:18:59.167922"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.169298"], ["updated_at", "2016-02-23 14:18:59.169298"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.170435"], ["updated_at", "2016-02-23 14:18:59.170435"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
   (0.6ms)  rollback transaction
   (0.1ms)  begin transaction
-----------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should give partial scores for sounds like matches. 
-----------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.175457"], ["updated_at", "2016-02-23 14:18:59.175457"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.177340"], ["updated_at", "2016-02-23 14:18:59.177340"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.178572"], ["updated_at", "2016-02-23 14:18:59.178572"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.179797"], ["updated_at", "2016-02-23 14:18:59.179797"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.181282"], ["updated_at", "2016-02-23 14:18:59.181282"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.182410"], ["updated_at", "2016-02-23 14:18:59.182410"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.183652"], ["updated_at", "2016-02-23 14:18:59.183652"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.184746"], ["updated_at", "2016-02-23 14:18:59.184746"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'HERNANDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'HERNANDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'HERNANDEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR'))))
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((((("ofac_sdn_individuals"."last_name" = 'LOPEZ' OR "ofac_sdn_individuals"."first_name_1" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_2" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_3" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_4" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_5" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_6" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_7" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_8" = 'LOPEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'MENDEZ' OR "ofac_sdn_individuals"."first_name_1" = 'MENDEZ') OR "ofac_sdn_individuals"."first_name_2" = 'MENDEZ') OR "ofac_sdn_individuals"."first_name_3" = 'MENDEZ') OR "ofac_sdn_individuals"."first_name_4" = 'MENDEZ') OR "ofac_sdn_individuals"."first_name_5" = 'MENDEZ') OR "ofac_sdn_individuals"."first_name_6" = 'MENDEZ') OR "ofac_sdn_individuals"."first_name_7" = 'MENDEZ') OR "ofac_sdn_individuals"."first_name_8" = 'MENDEZ')) OR (((((((("ofac_sdn_individuals"."last_name" = 'LOUIS' OR "ofac_sdn_individuals"."first_name_1" = 'LOUIS') OR "ofac_sdn_individuals"."first_name_2" = 'LOUIS') OR "ofac_sdn_individuals"."first_name_3" = 'LOUIS') OR "ofac_sdn_individuals"."first_name_4" = 'LOUIS') OR "ofac_sdn_individuals"."first_name_5" = 'LOUIS') OR "ofac_sdn_individuals"."first_name_6" = 'LOUIS') OR "ofac_sdn_individuals"."first_name_7" = 'LOUIS') OR "ofac_sdn_individuals"."first_name_8" = 'LOUIS')) OR (((((((("ofac_sdn_individuals"."last_name" = 'EDUARDO' OR "ofac_sdn_individuals"."first_name_1" = 'EDUARDO') OR "ofac_sdn_individuals"."first_name_2" = 'EDUARDO') OR "ofac_sdn_individuals"."first_name_3" = 'EDUARDO') OR "ofac_sdn_individuals"."first_name_4" = 'EDUARDO') OR "ofac_sdn_individuals"."first_name_5" = 'EDUARDO') OR "ofac_sdn_individuals"."first_name_6" = 'EDUARDO') OR "ofac_sdn_individuals"."first_name_7" = 'EDUARDO') OR "ofac_sdn_individuals"."first_name_8" = 'EDUARDO')) or (((((((((((("ofac_sdn_individuals"."alternate_last_name" = 'LOPEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LOPEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'MENDEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'MENDEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'MENDEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'MENDEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'MENDEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'MENDEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'MENDEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'MENDEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'MENDEZ')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LOUIS' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LOUIS') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LOUIS') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LOUIS') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LOUIS') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LOUIS') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LOUIS') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LOUIS') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LOUIS')) OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'EDUARDO' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'EDUARDO') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'EDUARDO') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'EDUARDO') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'EDUARDO') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'EDUARDO') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'EDUARDO') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'EDUARDO') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'EDUARDO'))))
   (0.6ms)  rollback transaction
   (0.1ms)  begin transaction
---------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should handle first or last name not given. 
---------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.4ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.190887"], ["updated_at", "2016-02-23 14:18:59.190887"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.193254"], ["updated_at", "2016-02-23 14:18:59.193254"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.194918"], ["updated_at", "2016-02-23 14:18:59.194918"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.196490"], ["updated_at", "2016-02-23 14:18:59.196490"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.198217"], ["updated_at", "2016-02-23 14:18:59.198217"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.199924"], ["updated_at", "2016-02-23 14:18:59.199924"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.201175"], ["updated_at", "2016-02-23 14:18:59.201175"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.202441"], ["updated_at", "2016-02-23 14:18:59.202441"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR')))
  OfacSdnIndividual Load (0.3ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR')))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR')))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR')))
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR')))
  OfacSdnIndividual Load (0.1ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE ((((((((("ofac_sdn_individuals"."last_name" = 'OSCAR' OR "ofac_sdn_individuals"."first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."first_name_8" = 'OSCAR') or ((((((((("ofac_sdn_individuals"."alternate_last_name" = 'OSCAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'OSCAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'OSCAR')))
   (0.6ms)  rollback transaction
   (0.1ms)  begin transaction
---------------------------------------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should not deduct from score if no data for city or address is in the database. 
---------------------------------------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.213256"], ["updated_at", "2016-02-23 14:18:59.213256"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.215387"], ["updated_at", "2016-02-23 14:18:59.215387"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.216777"], ["updated_at", "2016-02-23 14:18:59.216777"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.218528"], ["updated_at", "2016-02-23 14:18:59.218528"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.220212"], ["updated_at", "2016-02-23 14:18:59.220212"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.221374"], ["updated_at", "2016-02-23 14:18:59.221374"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.222888"], ["updated_at", "2016-02-23 14:18:59.222888"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.224456"], ["updated_at", "2016-02-23 14:18:59.224456"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'LOPEZ' OR "ofac_sdn_individuals"."first_name_1" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_2" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_3" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_4" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_5" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_6" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_7" = 'LOPEZ') OR "ofac_sdn_individuals"."first_name_8" = 'LOPEZ') OR (((((((("ofac_sdn_individuals"."last_name" = 'LUIS' OR "ofac_sdn_individuals"."first_name_1" = 'LUIS') OR "ofac_sdn_individuals"."first_name_2" = 'LUIS') OR "ofac_sdn_individuals"."first_name_3" = 'LUIS') OR "ofac_sdn_individuals"."first_name_4" = 'LUIS') OR "ofac_sdn_individuals"."first_name_5" = 'LUIS') OR "ofac_sdn_individuals"."first_name_6" = 'LUIS') OR "ofac_sdn_individuals"."first_name_7" = 'LUIS') OR "ofac_sdn_individuals"."first_name_8" = 'LUIS')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'LOPEZ' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LOPEZ') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LOPEZ') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'LUIS' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'LUIS') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'LUIS') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'LUIS') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'LUIS') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'LUIS') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'LUIS') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'LUIS') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'LUIS'))))
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
-----------------------------------------------------------------------------------------------------
OfacIndividualTest: test_: OfacIndividual #score should stip punctuation from names and still match. 
-----------------------------------------------------------------------------------------------------
  SQL (0.2ms)  DELETE FROM "ofac_sdn_individuals"
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "first_name_3", "first_name_4", "first_name_5", "first_name_6", "first_name_7", "first_name_8", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "alternate_first_name_3", "alternate_first_name_4", "alternate_first_name_5", "alternate_first_name_6", "alternate_first_name_7", "alternate_first_name_8", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "ABDELNUR"], ["first_name_1", "A"], ["first_name_2", "REALLY"], ["first_name_3", "VERY"], ["first_name_4", "EXTRAORDINARY"], ["first_name_5", "INCREDIBLY"], ["first_name_6", "LONG"], ["first_name_7", "FIRST"], ["first_name_8", "NAME"], ["address", ""], ["city", ""], ["alternate_last_name", "VIAJES"], ["alternate_first_name_1", "A"], ["alternate_first_name_2", "REALLY"], ["alternate_first_name_3", "VERY"], ["alternate_first_name_4", "EXTRAORDINARY"], ["alternate_first_name_5", "INCREDIBLY"], ["alternate_first_name_6", "LONG"], ["alternate_first_name_7", "FIRST"], ["alternate_first_name_8", "NAME"], ["created_at", "2016-02-23 14:18:59.228373"], ["updated_at", "2016-02-23 14:18:59.228373"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "alternate_first_name_2", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "HERNANDEZ"], ["alternate_first_name_1", "OSCAR"], ["alternate_first_name_2", "GROUCH"], ["created_at", "2016-02-23 14:18:59.230309"], ["updated_at", "2016-02-23 14:18:59.230309"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "alternate_first_name_1", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?, ?)  [["last_name", "HERNANDEZ"], ["first_name_1", "OSCAR"], ["address", "123 SOMEWHERE LN"], ["city", "CLEARWATER"], ["alternate_last_name", "NAME"], ["alternate_first_name_1", "ALTERNATE"], ["created_at", "2016-02-23 14:18:59.231420"], ["updated_at", "2016-02-23 14:18:59.231420"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "first_name_2", "address", "city", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "LOPEZ MENDEZ"], ["first_name_1", "LUIS"], ["first_name_2", "EDUARDO"], ["address", ""], ["city", ""], ["created_at", "2016-02-23 14:18:59.232553"], ["updated_at", "2016-02-23 14:18:59.232553"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.233964"], ["updated_at", "2016-02-23 14:18:59.233964"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.0ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", ""], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.235041"], ["updated_at", "2016-02-23 14:18:59.235041"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "BNC"], ["created_at", "2016-02-23 14:18:59.236148"], ["updated_at", "2016-02-23 14:18:59.236148"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.1ms)  INSERT INTO "ofac_sdn_individuals" ("last_name", "first_name_1", "address", "city", "alternate_last_name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?)  [["last_name", "AGUIAR"], ["first_name_1", "ALRAHMAN"], ["address", "1840 WEST 49TH STREET"], ["city", ""], ["alternate_last_name", "NATIONAL BANK OF CUBA"], ["created_at", "2016-02-23 14:18:59.237516"], ["updated_at", "2016-02-23 14:18:59.237516"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  OfacSdnIndividual Load (0.2ms)  SELECT last_name, first_name_1, first_name_2, first_name_3, first_name_4, first_name_5, first_name_6, first_name_7, first_name_8, alternate_last_name, alternate_first_name_1, alternate_first_name_2, alternate_first_name_3, alternate_first_name_4, alternate_first_name_5, alternate_first_name_6, alternate_first_name_7, alternate_first_name_8, address, city FROM "ofac_sdn_individuals" WHERE (((((((((("ofac_sdn_individuals"."last_name" = 'AGUIAR' OR "ofac_sdn_individuals"."first_name_1" = 'AGUIAR') OR "ofac_sdn_individuals"."first_name_2" = 'AGUIAR') OR "ofac_sdn_individuals"."first_name_3" = 'AGUIAR') OR "ofac_sdn_individuals"."first_name_4" = 'AGUIAR') OR "ofac_sdn_individuals"."first_name_5" = 'AGUIAR') OR "ofac_sdn_individuals"."first_name_6" = 'AGUIAR') OR "ofac_sdn_individuals"."first_name_7" = 'AGUIAR') OR "ofac_sdn_individuals"."first_name_8" = 'AGUIAR') OR (((((((("ofac_sdn_individuals"."last_name" = 'ALRAHMAN' OR "ofac_sdn_individuals"."first_name_1" = 'ALRAHMAN') OR "ofac_sdn_individuals"."first_name_2" = 'ALRAHMAN') OR "ofac_sdn_individuals"."first_name_3" = 'ALRAHMAN') OR "ofac_sdn_individuals"."first_name_4" = 'ALRAHMAN') OR "ofac_sdn_individuals"."first_name_5" = 'ALRAHMAN') OR "ofac_sdn_individuals"."first_name_6" = 'ALRAHMAN') OR "ofac_sdn_individuals"."first_name_7" = 'ALRAHMAN') OR "ofac_sdn_individuals"."first_name_8" = 'ALRAHMAN')) or (((((((((("ofac_sdn_individuals"."alternate_last_name" = 'AGUIAR' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'AGUIAR') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'AGUIAR') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'AGUIAR') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'AGUIAR') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'AGUIAR') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'AGUIAR') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'AGUIAR') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'AGUIAR') OR (((((((("ofac_sdn_individuals"."alternate_last_name" = 'ALRAHMAN' OR "ofac_sdn_individuals"."alternate_first_name_1" = 'ALRAHMAN') OR "ofac_sdn_individuals"."alternate_first_name_2" = 'ALRAHMAN') OR "ofac_sdn_individuals"."alternate_first_name_3" = 'ALRAHMAN') OR "ofac_sdn_individuals"."alternate_first_name_4" = 'ALRAHMAN') OR "ofac_sdn_individuals"."alternate_first_name_5" = 'ALRAHMAN') OR "ofac_sdn_individuals"."alternate_first_name_6" = 'ALRAHMAN') OR "ofac_sdn_individuals"."alternate_first_name_7" = 'ALRAHMAN') OR "ofac_sdn_individuals"."alternate_first_name_8" = 'ALRAHMAN'))))
   (0.8ms)  rollback transaction