If you are like me and have certain restrictions in a production environment, you may wish to use a table variable instead of temp table, and an ad-hoc query rather than a create procedure. Of course depending on your sql server instance, it must support table variables. I also added a USE statement to narrow … Read more
You’re looking for Enumerable#select (also called find_all): @fathers.select {|father| father[“age”] > 35 } # => [ { “age” => 40, “father” => “Bob” }, # { “age” => 50, “father” => “Batman” } ] Per the documentation, it “returns an array containing all elements of [the enumerable, in this case @fathers] for which block is … Read more
You can do this on a Git repository: git grep “string/regexp” $(git rev-list –all) GitHub advanced search has code search capability: The code search will look through all of the code publicly hosted on GitHub. You can also filter by: the language: language: the repository name (including the username): repo: the file path: path:
Streams If you are using Java 8, perhaps you could try something like this: public boolean containsName(final List<MyObject> list, final String name){ return list.stream().filter(o -> o.getName().equals(name)).findFirst().isPresent(); } Or alternatively, you could try something like this: public boolean containsName(final List<MyObject> list, final String name){ return list.stream().map(MyObject::getName).filter(name::equals).findFirst().isPresent(); } This method will return true if the List<MyObject> contains … Read more
The quick and dirty way: Right click on a folder, go to properties, and mark a folder as derived. Derived entities are excluded from searching by default. The problem with this approach is that Eclipse “forgets” that the folder is derived if you delete it (either from within Eclipse or externally, followed by refreshing the … Read more
Just for anyone else landing on this page from Google or elsewhere, this answer is probably the best answer out of all of them. To summarize, simply hit: CTRL + , And then start typing the file name.
Yeah, use .match, rather than .search. The result from the .match call will return the actual string that was matched itself, but it can still be used as a boolean value. var string = “Stackoverflow is the BEST”; var result = string.match(/best/i); // result == ‘BEST’; if (result){ alert(‘Matched’); } Using a regular expression like … Read more
Change table_name and field to match your table name and field in question: UPDATE table_name SET field = REPLACE(field, ‘foo’, ‘bar’) WHERE INSTR(field, ‘foo’) > 0; REPLACE (string functions) INSTR (string functions)
This problem can be solved with a recursive combinations of all possible sums filtering out those that reach the target. Here is the algorithm in Python: def subset_sum(numbers, target, partial=[]): s = sum(partial) # check if the partial sum is equals to target if s == target: print “sum(%s)=%s” % (partial, target) if s >= … Read more
You can also type command -I while less is running. It toggles case sensitivity for searches.