Posts

Showing posts from January 21, 2019

National Academy of Sciences

Image
For other uses, see National Academy of Sciences (disambiguation). National Academy of Sciences The National Academy of Sciences building in Washington, D.C.. Formation March 3, 1863 ; 155 years ago  ( 1863-03-03 ) Founders Alexander Dallas Bache Abraham Lincoln Founded at 2101 Constitution Ave NW, Washington, D.C., U.S. 20418 Type NGO Website nasonline.org The National Academy of Sciences ( NAS ) is a United States nonprofit, non-governmental organization. NAS is part of the National Academies of Sciences, Engineering, and Medicine, along with the National Academy of Engineering (NAE) and the National Academy of Medicine (NAM). As a national academy, new members of the organization are elected annually by current members, based on their distinguished and continuing achievements in original research. Election to the National Academy is one of the highest honors in the scientific field. Members serve pro bono as "advisers to the nation" on s...

How to scope a MySQL JOOQ rename table query to the same database?

Image
4 I have a scala application that manages multiple MySQL database schemas, which includes modifying (adding, renaming, etc.) tables. The commands are issued over a connection pool that connects to a generic management database in the database server. Because the application is designed to be cross-database, I use JOOQ to render SQL queries (execution is done via a separate JDBC module). I experience issues with JOOQs alterTable(...).renameTo(...) DSL - consider the following example: We have a table "TestTable" in database "TestDatabase". Let's say I want to rename that table simply to "Foo", keeping it in "TestDatabase". This code: ... val context = DSL.using(SQLDialect.MYSQL_5_7) val query = context .alterTable(table(name("TestDatabase...