#!/usr/bin/env python
# coding: utf-8

# In[1]:


from caveclient import CAVEclient


# # List available annotation tables

# In[6]:


url = "https://global.brain-wire-test.org/"
datastack = "fish1_full"
client = CAVEclient(datastack_name=datastack, server_address=url)
client.info.get_datastacks()


# In[3]:


# get existing tables
all_tables = client.annotation.get_tables()
all_tables


# ## Create a table
# To create a table a description and a table schema is required. A list of available schemas can be found [here](https://global.brain-wire-test.org/schema/views/). 
# 

# In[7]:


# create a new table
table_name = "soma_ids_locations"
description = """   
This table contains soma IDs and their locations. The patient's position of the soma and the tag are the soma's fixed ID numbers. Data source: gs://fish1-public/lores_cbs_231218"""
schema_name = "bound_tag"


# In[10]:


client.annotation.create_table(table_name=table_name, 
                               schema_name=schema_name, 
                               description=description, 
                               voxel_resolution=[8, 8, 30])


# In[11]:


all_tables = client.annotation.get_tables()
all_tables


# In[ ]: