The DataJoint Book

import pymysql
import os
pymysql.install_as_MySQLdb()

connection_string = "mysql://{user}:{password}@{host}".format(
    user=os.environ['DJ_USER'],
    host=os.environ['DJ_HOST'],
    password=os.environ['DJ_PASS']
)

%load_ext sql
%sql $connection_string

# This patches a recent bug in MySQL:
# https://community.deeplearning.ai/t/error-while-querying-db-from-jupyter-notebook/716351
%config SqlMagic.style = '_DEPRECATED_DEFAULT'

%sql --file 20210-dump.sql

import datajoint as dj

%%sql
SHOW SCHEMAS

schema = dj.Schema('primitive_mvt_export')

[2025-01-15 16:59:39,082][INFO]: Connecting root@localhost:3306
[2025-01-15 16:59:39,119][INFO]: Connected root@localhost:3306

schema.spawn_missing_classes()
dj.Diagram(schema)

Trial)()

  Cell In[7], line 1
    Trial)()
         ^
SyntaxError: unmatched ')'

print(Monet2().size_on_disk)
print(MovieClip().size_on_disk)
print(Trippy().size_on_disk)
print(Clip().size_on_disk)
print(Movie().size_on_disk)
print(Condition().size_on_disk)
print(Scan().size_on_disk)
print(Trial().size_on_disk)
print(Sync().size_on_disk)

dj.U('animal_id', 'session', 'scan_idx') & (Trial - Sync)

dj.Diagram(schema)

MovieClip()

dj.config['display.limit'] = 20

Sync()

Movie()

Sync()

%%sql
SHOW databases

Trial - Sync

Sync

Sync()

Examples

Blob Detection Workflow

Exercises

Assignment 01