[19:41:46] tgr: figured out you can use pg_dump to test for the existence of tables / databases [19:43:23] tgr: [19:43:25] root@bind:~# pg_dump -s -d this_database_doesnt_exist >/dev/null ; echo $? [19:43:25] pg_dump: [archiver (db)] connection to database "this_database_doesnt_exist" failed: FATAL: database "this_database_doesnt_exist" does not exist [19:43:25] 1 [19:43:27] root@bind:~# pg_dump -s -d this_one_exists >/dev/null ; echo $? [19:43:29] 0 [19:43:31] root@bind:~# pg_dump -s -d this_one_exists -t missing_table >/dev/null ; echo $? [19:43:33] pg_dump: No matching tables were found [19:43:35] 1 [20:03:17] dapatrick: could I possibly ask you to prioritize the security review for oyejorge/less.php? it should help fix a serious perf issue [20:03:43] is there any place on wikimedia servers which hosts libraries likie jquery/bootstrap? so that every little project does not have to keep a copy [20:04:01] ori: Sure thing. Chris and I spoke about it last friday and I have it on my list for this week. [20:04:40] SMalyshev: https://tools.wmflabs.org/cdnjs/ [20:04:45] dapatrick: cool, much appreciated [20:05:06] ori: cool. Is it ok to have non-tools projects (like query.wikidata.org) use it? [20:05:07] ori: cool. Is it ok to have non-tools projects (like query.wikidata.org) use it? [20:05:24] dunno -- ask YuviPanda? [20:06:07] SMalyshev: no, production things shouldn't use wmflabs.org [20:06:32] legoktm: so, I guess I can't use cdnjs on labs then. Any alternative? [20:06:56] you can use https://www.mediawiki.org/w/load.php?debug=false&modules=jquery&only=scripts&raw=1 for jquery [20:07:12] well, no one will know to notify you when changing jquery version [20:07:13] s [20:07:23] so just maintain your own copies [20:07:24] legoktm: ok, what about bootstrap? [20:07:47] ori: I can but that kind of sucks that every project would have it's own jquery... [20:07:48] we don't have anything for bootstrap afaik [20:08:11] ori: except for all the emails about the jquery upgrade because it will break things ;-) [20:08:23] https://integration.wikimedia.org/zuul/ uses the MediaWiki jquery and its own boostrap [20:09:08] *its own [20:09:28] ok, I'll try that and see how it works, thanks [20:29:48] ori: what do you think about https://gerrit.wikimedia.org/r/#/c/199598/32/modules/postgresql/files/postgres_db_exists ? looks like I messed up a push and reverted it [20:30:43] it would be nice to have the same logic in all postgresql resources, and I don't want to change spatialdb and the rest because I have no idea how to test them [21:05:17] tgr: the pd_dump command seems sufficiently concise [21:05:49] tgr: doesn't require constructing a sql string, passing it as an command-line arg, and parsing the result with grep [21:05:59] just one command and you get the exit status you need [23:28:59] git fetch ssh://tgr@gerrit.wikimedia.org:29418/operations/puppet refs/changes/98/199598/33 && git cherry-pick FETCH_HEAD [23:29:13] duh, too many windows