Okay, I needed something similar. The path to my output artifacts were quite long, but I wanted short target names and also benefit easily from bash-completion. Here is what I’m came up with: os := [arbitrary long path to an artifact] platform := [arbitrary long path to a differ artifact] packer := [common parts of … Read more
As a workaround, you can define aliases in Bash to get the result you want. Here’s something I just knocked up for a pet peeve of mine – that ‘git add’ is not verbose by default. (And there’s no config setting for it). Put this in your ~/.bash_profile or ~/.bash_rc function do_git { cmd=$1 shift … Read more
Create a database with the name you want to impersonate. Re-jigg the DDL code generator to create a view for every table in the database that has the tables I need to access via the hardcoded name. Basically, each view will have a statement that looks like this.. CREATE VIEW schemaname.tablename as SELECT * FROM … Read more
You can’t use * with an alias. Aliases can be used for individual columns. You’ll have to alias each column instead.. So unfortunately, if you have a lot of columns, you’ll need to go: SELECT u.col1 AS u_col1 , u.col2 AS u_col2 , u.col3 AS u_col3 — etc , u2.col1 AS u2_col1 , u2.col2 AS … Read more
Specify the alias name before FROM statement Meaning, you are deleting from the aliased table. delete o1 from @O as o1 where ACount = 0 and exists ( select Month from @O o2 where o1.Month = o2.Month and o2.ACount > 0) Result
Use JOIN to join the subqueries and use ON to say where the rows from each subquery must match: SELECT T1.col_a, T1.col_b, T2.col_c FROM (SELECT col_a, col_b, …etc…) AS T1 JOIN (SELECT col_a, col_c, …etc…) AS T2 ON T1.col_a = T2.col_a If there are some values of col_a that are in T1 but not in … Read more
Offhand, I believe you can use the labeled column itself as an expression: foobar = Foo.bar.label(“foobar”) session.query(foobar).filter(foobar > 10).all()
I believe that their main reason was portability of programs targeting CLR. If they were to allow a type as basic as int to be platform-dependent, making portable programs for CLR would become a lot more difficult. Proliferation of typedef-ed integral types in platform-neutral C/C++ code to cover the use of built-in int is an … Read more
Try defining a function in ~/.profile. function greplogs(){ grep “$1” */logs/*.log }
If vim is compiled with the clientserver option, you can do it. Start your vim instance with the following flag: $ gvim –servername GVIM # GVIM is the server name. It can be anything. To open more tabs in this instance, you can run the command: $ gvim –servername GVIM –remote-tab file1 file2 file3 … … Read more