Syntactic sugar for ATTACH DATABASE #113

Activity

1. simonw

   added

   enhancementNew feature or requestNew feature or request

   on May 19, 2020
2. simonw commented on May 19, 2020

   

   simonw

   on May 19, 2020

   OwnerAuthor

   More actions

   Here's how twitter-to-sqlite does it: https://github.com/dogsheep/twitter-to-sqlite/blob/6be0ffcee24504fa2964b0e526842b8cfce7567b/twitter_to_sqlite/utils.py#L506-L511

                   attach_sql = """
                       ATTACH DATABASE '{}' AS [{}];
                   """.format(
                       str(pathlib.Path(filepath).resolve()), alias
                   )
                   db.conn.execute(attach_sql)
3. simonw

   closed this as completedin 999f099on Feb 19, 2021
4. simonw commented on Feb 19, 2021

   

   simonw

   on Feb 19, 2021

   OwnerAuthor

   More actions

   Documentation: https://sqlite-utils.datasette.io/en/latest/python-api.html#attaching-additional-databases
5. simonw

   added a commit that references this issue on Feb 19, 2021

   Release 3.6

   ...

   806c210
6. polyrand

   added a commit that references this issue on Mar 12, 2024

   db.attach(alias, filepath) method, closes simonw#113

   ...

   This issue will close once commit 999f099 is merged into the 'main' branch.

   999f099