Import TickTick data into a SQLite database
Project description
ticktick-to-sqlite
Import TickTick data into a SQLite database
Installation
Install this tool using pip
:
pip install ticktick-to-sqlite
Usage
Pre-requisite:
-
Register your application.
-
Assuming you have a TickTick account, register your app and create a
client_id
andclient_secret
.@lazeroffmichael (author of
ticktick-py
) wrote a easy to follow "Get Started" instructions to set up your app.
-
-
(Recommended) Set enviornment variables for your login credentials:
TICKTICK_USERNANE
- Your TickTick usernameTICKTICK_PASSWORD
- Your TickTick password
For help, run:
ticktick-to-sqlite --help
You can also use:
python -m ticktick_to_sqlite --help
Authenticate
Store app settings for OAuth.
(venv) $ ticktick-to-sqlite auth
Register your application and obtain: "Client ID", "Client Secret", and pick a "Redirect URL". Paste it here:
Client ID: your_client_id
Client Secret: your_client_secret
Redirect URL: https://127.0.0.1
Tasks
Save your uncompleted tasks.
ticktick-to-sqlite tasks ticktick.db
Save your completed tasks for a specified time range (ex. between Dec 31st, 2023 and Jan 31st, 2024).
ticktick-to-sqlite completed-tasks ticktick.db 2023-12-31 --end-date 2024-01-31
Tags
Save your tags.
ticktick-to-sqlite tags ticktick.db
Projects
Save your projects (aka "Lists").
ticktick-to-sqlite projects
Save your project folders (aka "List Folders").
ticktick-to-sqlite project-folders
Development
To contribute to this tool, first checkout the code. Then create a new virtual environment:
cd ticktick-to-sqlite
python -m venv venv
source venv/bin/activate
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests:
pytest
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for ticktick_to_sqlite-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f0f734e25984d306900a095656de1542359b757b2626678ba20c28edc23f38cb |
|
MD5 | 8ef0ef03faa5697ff9992d1b3fb133ca |
|
BLAKE2b-256 | 0d4152924c23aded36b2684800073a892b9a26fc898bb3ede2dd7b5f1d161da7 |