datajoint-python icon indicating copy to clipboard operation
datajoint-python copied to clipboard

datajoint python CLI

Open A-Baji opened this issue 1 year ago • 0 comments

Examples:

vscode ➜ /workspaces/datajoint-python (dj-cli) $ dj
dj repl

>>> dj.config
{   'connection.charset': '',
    'connection.init_function': None,
    'database.host': 'fakeservices.datajoint.io',
    'database.password': 'simple',
    'database.port': 3306,
    'database.reconnect': True,
    'database.use_tls': None,
    'database.user': 'root',
    'display.limit': 12,
    'display.show_tuple_count': True,
    'display.width': 14,
    'enable_python_native_blobs': True,
    'fetch_format': 'array',
    'filepath_checksum_size_limit': None,
    'loglevel': 'INFO',
    'safemode': True}
>>> 
vscode ➜ /workspaces/datajoint-python (dj-cli) $ datajoint -u test_user -p test_password -h test_host
dj repl

>>> print(dj.config['database.user'],dj.config['database.password'],dj.config['database.host'])
test_user test_password test_host
>>> 
vscode ➜ /workspaces/datajoint-python (dj-cli) $ dj -s djtest_test1:test1 djtest_relational:relational
[2023-06-22 17:35:08,925][INFO]: Connecting [email protected]:3306
[2023-06-22 17:35:08,930][INFO]: Connected [email protected]:3306
dj repl

schema modules:

  - test1
  - relational

>>> test1.TTest()
*key    value    
+-----+ +-------+
0       0        
1       2        
2       4        
3       6        
4       8        
5       10       
6       12       
7       14       
8       16       
9       18       
 (Total: 10)

>>> 

A-Baji avatar Jun 22 '23 17:06 A-Baji