I was presented with this problem about a year ago when it came to looking up user entered information about a oil rig in a database of miscellaneous information. The goal was to do some sort of fuzzy string search that could identify the database entry with the most common elements. Part of the research … Read more
Use packaging.version.parse. >>> from packaging import version >>> version.parse(“2.3.1”) < version.parse(“10.1.2”) True >>> version.parse(“1.3.a4”) < version.parse(“10.1.2”) True >>> isinstance(version.parse(“1.3.a4”), version.Version) True >>> isinstance(version.parse(“1.3.xy123”), version.LegacyVersion) True >>> version.Version(“1.3.xy123”) Traceback (most recent call last): … packaging.version.InvalidVersion: Invalid version: ‘1.3.xy123’ packaging.version.parse is a third-party utility but is used by setuptools (so you probably already have it installed) and … Read more
If, OTOH, your list of strings is indeed hideously long, use a set: accepted_strings = {‘auth’, ‘authpriv’, ‘daemon’} if facility in accepted_strings: do_stuff() Testing for containment in a set is O(1) on average.
What about isEmpty() ? if(str != null && !str.isEmpty()) Be sure to use the parts of && in this order, because java will not proceed to evaluate the second part if the first part of && fails, thus ensuring you will not get a null pointer exception from str.isEmpty() if str is null. Beware, it’s … Read more
The good news is that if you need to make a case-sensitive query, it is very easy to do: SELECT * FROM `table` WHERE BINARY `column` = ‘value’