自动生成CYPHER-TASK脚本优化自增ID的获取
Here’s the table of contents:
变量冲突调整
版本V-1.0.2
原始查询样例
生成custom.task.build.graph.batch.*过程
变量冲突调整
文本中下列变量在使用时去掉双下划线`--`【因为与GitHubIO.blog编译冲突】
{--{merge_field}
{--{matchFrom_field}
{--{matchTo_field}
## 版本V-1.0.1
支持自定义设置batch size大小!
在该版本中优化自增ID的获取方式,避免无效查询浪费性能。【2021-01-15-自动生成CYPHER-TASK脚本】在这个版本中,自增ID的获取默认是区间自增,但...
Shell字符串转义
Here’s the table of contents:
单引号转义
单引号括号转义
HTTP请求执行Cypher
单引号转义
脚本
echo 'RETURN '\'\hello\'' AS str'
输出
RETURN 'hello' AS str
单引号括号转义
脚本
echo 'RETURN '\'\(\hello\)\'' AS str'
输出
RETURN '(hello)' AS str
HTTP请求执行Cypher
curl -u ongdb:testlab%pro -d '{"statements": [{"statemen...
CentOS系统安装Python3环境
Here’s the table of contents:
安装Python3
安装pip工具
安装cypher包
执行Python文件
CentOS后台运行Python
安装Python3
yum install python36
安装pip工具
sudo yum install python-pip
sudo pip3 install --upgrade pip
安装cypher包
pip3 install ipython-cypher
pip3 install pandas
执行Python文件
python3 test.py
CentOS后台运行Python
nohup python3 -u test.py > test.log 2>...
图数据构建脚本后台远程执行
Here’s the table of contents:
execute-graph-data-build
execute-graph-data-build
从202机器后台执行CQL脚本,在173集群中构建图数据
#!/bin/bash
su - ongdb <<EOF
testlab%pro
echo "Build Graph Data..."
cat /home/ongdb/graph-sync-check-point/temp/public_fund_replenish.cql | /home/ongdb/ongdb-enterprise-3.5.22/bin/cypher-shell -a bolt+routing://10.20.12.17...
ONgDB集群数据增量备份方案
Here’s the table of contents:
修改集群配置
远程全量热备命令
远程增量热备命令
数据恢复脚本
参考文档
修改集群配置
# Enable online backups to be taken from this database.
dbms.backup.enabled=true
# By default the backup service will only listen on localhost.
# To enable remote backups you will have to bind to an external
# network interface (e.g. 0.0.0.0 for all interfaces...
后台执行CQL脚本
Here’s the table of contents:
执行单条CQL
test.sh批量执行脚本
执行单条CQL
cat /ongdb_data/ongdb-enterprise-3.5.22/test.cql | nohup /ongdb_data/ongdb-enterprise-3.5.22/bin/cypher-shell -a bolt://10.20.7.181:7687 -u ongdb -p testlab%pro >>console.log 2>&1 &
test.sh批量执行脚本
#!/bin/bash
# 定义CQL文件名称
array=(test1 test2 test3 test4 test5 test6...
ONgDB批量导入CSV文件
Here’s the table of contents:
版本
cypher-shell执行批量提交的脚本
browser中执行批量提交的CYPHER
版本
ongdb-enterprise-3.5.22
cypher-shell执行批量提交的脚本
USING PERIODIC COMMIT 10000
LOAD CSV FROM 'file:/xbe' AS line
WITH TOINT(line[1]) AS ybId,TOINT(line[2]) AS kwId,apoc.convert.toFloat(line[3]) AS weight
MATCH (yb:研报)-[r:包含]->(kw:关键词) WHERE ID(yb)=ybId AND I...
126 post articles, 16 pages.