Skip to content

Instantly share code, notes, and snippets.

@Kidinnu

Kidinnu/sqlite_connect.py Secret

Last active April 1, 2020 04:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Kidinnu/3503edd9ce279929b6ffa207e563cd7c to your computer and use it in GitHub Desktop.
Save Kidinnu/3503edd9ce279929b6ffa207e563cd7c to your computer and use it in GitHub Desktop.
Download ZIP
Google Colab + Google Drive + SQLite
Raw
sqlite_connect.py
# Этот код необходимо выполнить для разрешения доступа Google Colab к диску Google Drive,
# на котором будет храниться файл базы данных
# Разрешение нужно выдавать повторно спустя каждые 12 часов (это особенность работы Google Colab)
from google.colab import drive
drive.mount('/content/drive')
import sqlite3
path = "./drive/My Drive/mydatabase.db"
conn = sqlite3.connect(path)
cursor = conn.cursor()
# Работа с БД
# ...
# ...
cursor.close()
conn.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment