def db_setup(HOST: str, USER: str, dbname: str, PASSW: str, PORT: str,
keep: bool):
"""sets up database
:param HOST: OGM Graph ref
:param USER: OGM Graph ref
:param dbname: OGM Graph ref
:param PASSW: OGM Graph ref
:param PORT: OGM Graph ref
:param keep: boolean value to keep or destroy database
"""
print('(connecting to db)')
clear_database = ''
if (not keep):
clear_database = input(
'Are you sure you want to delete the database? (Y/N)')
if clear_database in ['Y', 'y', 'Yes', 'yes', 'YES']:
print('(dropping database)')
g = Graph(Config.from_url(dbname, USER, PASSW, initial_drop=True))
g.create_all(Node.registry)
g.create_all(Relationships.registry)
else:
print('(keeping database)')
g = Graph(Config.from_url(dbname, USER, PASSW, initial_drop=False))
SchemaNode = declarative_node()
SchemaRelationship = declarative_relationship()
classes_from_schema = g.build_mapping(SchemaNode,
SchemaRelationship,
auto_plural=True)
g.include(classes_from_schema)
g.client.command(
"ALTER DATABASE DATETIMEFORMAT \"yyyy-MM-dd'T'HH:mm:ss.SSS'Z'\"")
print('our db g', g)
return g
tmp.append(list(region))
a['regions'] = tmp
return a
# init db
# initial_drop = True
# test
# cx_db = 'localhost:8889/cx'
graph = Graph(Config.from_url(cx_db, 'root', 'root',
initial_drop=initial_drop))
# models.create_efficiently(graph, models.Node.registry)
# models.create_efficiently(graph, models.Relationship.registry)
if initial_drop:
graph.create_all(models.Node.registry)
graph.create_all(models.Relationship.registry)
else:
graph.include(models.Node.registry)
graph.include(models.Relationship.registry)
logging.basicConfig(level=logging.DEBUG,
stream=sys.stdout,
format='%(asctime)s %(name)s %(levelname)s %(message)s')
logger = logging.getLogger('cx')
logger.info('Start to Load Biological Data')
CX_Neuropils = ['PB', 'EB', 'NO', 'no', 'BU', 'bu', 'LAL', 'lal']
neuropil_name_to_node = {}
"data": "version number"
}
],
"created": "2017-03-13T14:02:10.000Z",
"modified": "2017-03-13T14:02:10.000Z",
"labels": ["infrastructure"]
}
# with monkeytype.trace():
config = Config(host="127.0.0.1", user="******", db_name="test_embedded", storage="plocal", cred="OrientPW",
port=2424, initial_drop=True)
# graph = Graph(Config.from_url('localhost/g-test', 'root', 'root', initial_drop=True))
# graph = Graph(Config.from_url('localhost/g-test', 'root', 'root'))
graph = Graph(config)
graph.create_all(Node.registry)
print("create_all done for nodes")
# print(result)
graph.create_all(Relationships.registry)
print("create_all done for Relationships")
# print(result)
# try:
# result = graph.assets.create(**asset)
# print("created an asset")
# print(result)
# print("Querying...")
# result = graph.assets.query(name=asset["name"]).one()
# print(dir(result))
# except Exception as e:
# print('Exception:')
# print(e)
lpu0_pat_ports_data)
connect_lpu_pat(lpu1_ports_sels, lpu1_lpu_ports_data,
lpu1_pat_ports_data)
if __name__ == '__main__':
logging.basicConfig(
level=logging.DEBUG,
stream=sys.stdout,
format='%(asctime)s %(name)s %(levelname)s %(message)s')
#g_orient = Graph(Config.from_url('/vision_demo','admin', 'admin', initial_drop=True)) # set to True to erase the database
g_orient = Graph(
Config.from_url('/ampa/bionet/databases/development/na_server',
'admin',
'admin',
initial_drop=False,
serialization_type=OrientSerialization.Binary)
) # set to True to erase the database
g_orient.create_all(Node.registry)
g_orient.create_all(Relationship.registry)
#g_orient.include(Node.registry)
#g_orient.include(Relationship.registry)
vl = NetworkXLoader(g_orient)
# Load LPU data:
vl.logger.info('Loading sample Lamina circuit...')
vl.load_lpu('lamina.gexf.gz', 'LAM')
"""
util for create classes
"""
import os
import django
from django.conf import settings
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "mysite_orientdb.settings")
django.setup()
from pyorient.ogm import Graph, Config
from ngpyorient.ng_node import NgNode
from ngpyorient.ng_relationship import NgRelationship
config = Config.from_url(
settings.DATABASES_NG["default"]["URL"],
settings.DATABASES_NG["default"]["USER"],
settings.DATABASES_NG["default"]["PASSWORD"],
)
graph = Graph(config)
# NgNode.registry.pop("ngnode")
# NgRelationship.registry.pop("ngrelationship")
graph.create_all(NgNode.registry)
graph.create_all(NgRelationship.registry)
graph.client.close()
