// Searches all tables unit it finds a match or no tables are left
func (t *Taggers) search_all_tables(token *string, conn *db.Mysql) int {
escaped_token := sutils.EscapeAllQuotes(*token)
names_q := "select * from names WHERE name = \"" + escaped_token + "\""
dict_q := "select * from dict WHERE word = \"" + escaped_token + "\""
geo_q := "select * from geo WHERE name = \"" + escaped_token + "\""
if conn.Query(names_q) != nil {
log.Tracef("%s found in names table", *token)
return 1
} else if conn.Query(dict_q) != nil {
log.Tracef("%s found in dict table", *token)
return 2
} else if conn.Query(geo_q) != nil {
log.Tracef("%s found in geo table", *token)
return 3
}
log.Tracef("%s not found", *token)
return -1
}
