DatabaseForControl.py

import datajoint as dj
import socket

# connect to local database server for communication wioth 2pmaster
#s = socket.socket(socket.AF_INET, socket.SOCK_DGRAM)
#s.connect(("8.8.8.8", 80))
#ip = s.getsockname()[0]
hostname = socket.gethostname()
ip = socket.gethostbyname(hostname) # make sure hostname in /etc/hosts file is set to actual address not 127.0.1.1

conn2 = dj.Connection(ip, 'atlab', dj.config['database.password'])
if conn2.is_connected:
    print('Connection to 2pMaster Made...')
schema2 = dj.schema('pipeline_behavior', connection=conn2)

@schema2
class SetupControl(dj.Lookup):
    definition = """
    #
    twop_setup               : varchar(256)   # two photon setup name, e.g. 2P1
    setup                  : varchar(256)   # Setup name of behavior/stim computer, e.g. at-stim01
    ---
    ip                     : varchar(16)    # setup IP address, e.g. at-stim01.ad.bcm.edu
    state="ready"          : enum('systemReady','sessionRunning','stimRunning','stimPaused')  #
    state_control="ready"  : enum('startSession','startStim','stopStim','stopSession','pauseStim','resumeStim','Initialize','')  #
    animal_id=null         : int # animal id
    session=null           : int # session number
    scan_idx=null          : int             # 
    stimulus=""            : varchar   #
    next_trial=null        : int  #
    last_ping=null         : timestamp
    task_idx=7             : int             # task identification number
    task="train"           : enum('train','calibrate')
    trial_done=1           : int # 0=trial running 1=trial finished
    exp_done=1             : int # 0=exp running 1=all trials done
    sync_level1=0          : int
    sync_level2=-1         : int
    sync_level3=255        : int
    """