Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of uppercase, lowercase, numbers, and special characters (such as @*&#).
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Certifications

Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Invoice

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File
v4.3
Search
    中文EN
    v4.3

      Insert

      Insert operation means to insert one or multiple nodes/edges into the current GraphSet; commands insert(), insert().overwrite() and upsert() all can trigger insert operation. This article introduces the insert operation triggered by command insert().

      insert() may trigger:

      • an insert operation if:
        • ID is not provided
        • the provided ID does not exist in the graph
      • a failure if:
        • the provided ID already exists in the graph
        • FROM or TO is not provided when inserting edges
        • provided FROM or TO does not exist in the graph

      When insert operation is triggered:

      • the missing ID will be generated by system
      • the missing custom properties will be null
      • the custom properties provided in the wrong data type will be using default value
        • "" (string, text)
        • 0 (int32, int64, uint32, uint64, float, double, decimal)
        • "1970-01-01 08:00:00 +08:00" (timestamp)
        • "0000-00-00 00:00:00" (datetime)
        • [] (list)
        • POINT(0.00 0.00) (point)

      It is not suggested to execute insertion operation after streaming return of an algorithm, see details on stream() in document Ultipa Graph Analytics & Algorithms - Using Algorithms - Execution Method.

      Syntax:

      • Statement alias: supported (NODE or EDGE)

      // To insert nodes of a certain schema in the current graphset
      insert().into(@<schema>)
        .nodes([				// Square brackets can be omitted if inserts only one node
          {<property1>:<value1>, <property2>:<value2>, ...},
          {<property1>:<value1>, <property2>:<value2>, ...},
          ...
        ])
        
      // To insert edges of a certain schema in the current graphset, must carry _from and _to, or must carry _from_uuid and _to_uuid
      insert().into(@<schema>)
        .edges([				// Square brackets can be omitted if inserts only one edge
          {<property1>:<value1>, <property2>:<value2>, ...},
          {<property1>:<value1>, <property2>:<value2>, ...},
          ...
        ])
      

      Example: Insert a node of @default, provide properties 'point' and 'blob'

      insert().into(@default).nodes({
        point: point({latitude: 132.1, longitude: -1.5}),
        blob: castToRaw("32")
      })
      

      Analysis: When inserting type piont and blob, refer to related documents for the usage of functions point() and castToRaw().

      Sample graph: (to be used for the following examples)

      Run below UQLs one by one in an empty graphset to create graph data:

      create().node_schema("account").edge_schema("follow")
      create().node_property(@account, "name").edge_property(@follow, "time", datetime)
      insert().into(@account).nodes([{_id:"U001", _uuid:1, name:"Jason"}, {_id:"U002", _uuid:2, name:"Tim"}, {_id:"U003", _uuid:3, name:"Grace"}, {_id:"U004", _uuid:4, name:"Ted"}])
      insert().into(@follow).edges([{_uuid:1, _from_uuid:4, _to_uuid:1, time:"2021-09-10"}, {_uuid:2, _from_uuid:3, _to_uuid:2, time:"2020-03-12"}, {_uuid:3, _from_uuid:4, _to_uuid:2, time:"2023-07-30"}])
      

      Example: Insert two nodes into @account, one does not carry any information, namely, the _id and _uuid will be generated and all custom properties are null; the other carries a nonexistent _id and all properties in correct data type, in which case only the _uuid is generated

      insert().into(@account).nodes([{}, {_id: "U005", name: "Alice"}]) as nodes
      return nodes{*}
      

      |           _id          | _uuid |  name  |
      |------------------------|-------|--------|
      | ULTIPA8000000000000001 |   5   |  null  |
      | U005                   |   6   | Alice  |
      

      Example: Prompt error when inserting node due to that ID already exist

      insert().into(@account).nodes({_id: "U001"}) as nodes
      return nodes{*}
      

      Duplicated ids!
      

      Example: Prompt error when inserting edge due to that TO does not exist

      insert().into(@follow).edges({_from: "U001", _to: "U010"}) as edges
      return edges{*}
      

      The _to: U010 does not exist!
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写