Google-drive-to-sqlite

Latest version: v0.4

Safety actively analyzes 623608 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

0.4

- Redesigned [the schema](https://github.com/simonw/google-drive-to-sqlite/blob/0.4/README.md#database-schema) to reflect that Google Drive files can only have one, not multiple owners. [34](https://github.com/simonw/google-drive-to-sqlite/issues/34)
- Removed `drive_folders_owners` and `drive_files_owners` tables.
- `drive_files` and `drive_folders` now have a `_owner` column that is a foreign key to `drive_users`.
- New [google-drive-to-sqlite export format file_id](https://github.com/simonw/google-drive-to-sqlite/blob/0.4/README.md#google-drive-to-sqlite-export-format-file_id) command for exporting Google Docs files as different formats such as `pdf`. [21](https://github.com/simonw/google-drive-to-sqlite/issues/21)
- New options to `files`: `--apps` for all Google Docs files of all types, or `--docs`, `--sheets`, `--presentations` and `--drawings` for Google Docs files of specific types.
- `google-drive-to-sqlite files` and `get` commands now have a `--verbose` option showing what the tool is doing in detail.
- Automatically retries up to twice on HTTP transport errors, with a 2 second delay. [18](https://github.com/simonw/google-drive-to-sqlite/issues/18)
- The `auth.json` file now defaults to `0600` permissions, meaning only the user can read that file on a shared system. [37](https://github.com/simonw/google-drive-to-sqlite/issues/37)

0.3

- New design for the database schema: [9](https://github.com/simonw/google-drive-to-sqlite/issues/9)
- `drive_files` contains files, with a `_parent` foreign key to the parent folder
- `drive_folders` contains folders, with a self-referential `_parent` foreign key
- `drive_users` contains users who may own or have modified files
- `drive_folders_owners` relates folders to their owners
- `drive_files_owners` relates files to their owners
- The full schema is now included [in the documentation](https://github.com/simonw/google-drive-to-sqlite/blob/0.3/README.md#database-schema).
- New `--import-json` and `--import-nl` options to the `files` command for creating a database using JSON data retrieved previously using the `--nl` and `--json` options. [20](https://github.com/simonw/google-drive-to-sqlite/issues/20)
- `--starred`, `--trashed` and `--shared-with-me` options for `files` as shortcuts for constructing more advanced search queries. [25](https://github.com/simonw/google-drive-to-sqlite/issues/25)
- Documentation now has a [quickstart section](https://github.com/simonw/google-drive-to-sqlite/blob/0.3/README.md#quickstart). [24](https://github.com/simonw/google-drive-to-sqlite/issues/24)

0.2a0

- New `google-drive-to-sqlite revoke` command, for revoking stored credentials. [16](https://github.com/simonw/google-drive-to-sqlite/issues/16)
- If an hour long `access_token` expires while a command is running, the failed request is retried with a new token automatically generated using the `refresh_token`. [11](https://github.com/simonw/google-drive-to-sqlite/issues/11)

0.1a2

- Improved README.

0.1a1

- New `google-drive-to-sqlite download` command, [documented here](https://github.com/simonw/google-drive-to-sqlite/blob/0.1a1/README.md#google-drive-to-sqlite-download-file_id). [4](https://github.com/simonw/google-drive-to-sqlite/issues/4)
- Fixed bug where `google-drive-to-sqlite get` threw an error if retrieving non-JSON output. [13](https://github.com/simonw/google-drive-to-sqlite/issues/13)
- Increased timeout to 30s. [8](https://github.com/simonw/google-drive-to-sqlite/issues/8)

0.1a0

This initial alpha release may not work for anyone other than me, as Google still need to verify my OAuth application.

- `google-drive-to-sqlite auth` command for authenticating with Google and storing the resulting credentials. [2](https://github.com/simonw/google-drive-to-sqlite/issues/2)
- `google-drive-to-sqlite files` command for fetching file metadata from Google Drive and storing it in a SQLite database file, or outputting it as JSON. [7](https://github.com/simonw/google-drive-to-sqlite/issues/7)
- `google-drive-to-sqlite get` command for executing other authenticated API calls against Google APIs. [3](https://github.com/simonw/google-drive-to-sqlite/issues/3)

Links

Releases

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.