{"id":67,"date":"2004-09-23T20:54:27","date_gmt":"2004-09-23T19:54:27","guid":{"rendered":"\/?p=67"},"modified":"2025-02-01T03:04:17","modified_gmt":"2025-02-01T03:04:17","slug":"sql-import-from-database-for-sqleditor","status":"publish","type":"post","link":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/2004\/09\/23\/sql-import-from-database-for-sqleditor\/","title":{"rendered":"SQL Import from database for SQLEditor"},"content":{"rendered":"<p>I now have the first version of database import working for SQLEditor. This means that you can point it at a database and it will grab the structure of the database directly.<\/p>\n<p>Currently it&#8217;s missing foreign key support, but it seems to support most other functionality.<\/p>\n<p>On a related note, I have finally fixed the bug that sometimes meant that you could end up with bad sql code. The new version now uses &#8220;alter table&#8221; rather than &#8220;references&#8221;, it creates all of the tables first and <em>then<\/em> adds the foreign keys. This means that even circular dependencies will now be exportable.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I now have the first version of database import working for SQLEditor. This means that you can point it at a database and it will grab the structure of the database directly. Currently it&#8217;s missing foreign key support, but it seems to support most other functionality. On a related note, I have finally fixed the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":1,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":1611,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/posts\/67\/revisions\/1611"}],"wp:attachment":[{"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.malcolmhardie.com\/weblogs\/angus\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}