Socket
Socket
Sign inDemoInstall

sqlite-utils-move-tables

Package Overview
Dependencies
2
Maintainers
1
Alerts
File Explorer

Install Socket

Detect and block malicious and high-risk dependencies

Install

    sqlite-utils-move-tables

Command for sqlite-utils to move tables from one database to another


Maintainers
1

Readme

sqlite-utils-move-tables

PyPI Changelog Tests License

Command for sqlite-utils to move tables from one database to another

Installation

Install this plugin in the same environment as sqlite-utils.

sqlite-utils install sqlite-utils-move-tables

Usage

This plugin adds a single command, sqlite-utils move-tables. The command can be used to move one or more tables from one database file to another.

sqlite-utils move-tables origin.db destination.db tablename

You can pass multiple tables to the command to move multiple tables in one go:

sqlite-utils move-tables origin.db destination.db table1 table2

A moved table will have its columns and primary keys recreated and all data copied across to the new database. The original table will then be dropped.

Foreign key constraints, indexes and triggers will not be copied across.

To keep the original table, use --keep:

sqlite-utils move-tables origin.db destination.db tablename --keep

The command checks for the existence of all of the tables in the first database, and ensures they do not yet exist in the second database. It will show an error if either of these conditions are not meant.

To ignore that error and fail silently if a table is missing or already created, use --ignore.

To over-write and replace a table in the destination database with a name that matches one of the tables to be moved, use --replace.

It is advisable to create a copy of your origin database before running this command!

Development

To set up this plugin locally, first checkout the code. Then create a new virtual environment:

cd sqlite-utils-move-tables
python3 -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

pytest

FAQs


Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc