Example: Classic Sales - The DataJoint Book

This is the classic sales database provided as part of the MySQL tutorial. http://www.mysqltutorial.org/mysql-sample-database.aspx

This example is adapated here without change under fair use for the purposes of instruction.

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

%sql --file classicsales.sql

 * mysql://root:***@localhost
1 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
0 rows affected.
7 rows affected.
110 rows affected.
7 rows affected.
23 rows affected.
23 rows affected.
122 rows affected.
326 rows affected.
273 rows affected.
2996 rows affected.

[]

import datajoint as dj
schema = dj.Schema('classic_sales')
schema.spawn_missing_classes()

[2025-01-15 01:40:49,567][INFO]: Connecting root@localhost:3306
[2025-01-15 01:40:49,584][INFO]: Connected root@localhost:3306

dj.Diagram(schema)

Payment()