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.
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Apply New License

License Detail

Please complete this required field.

  • Ultipa Graph V4

Standalone

Please complete this required field.

Please complete this required field.

The MAC address of the server you want to deploy.

Please complete this required field.

Please complete this required field.

Cancel
Apply
ID
Product
Status
Cores
Applied Validity Period(days)
Effective Date
Excpired Date
Mac Address
Apply Comment
Review Comment
Close
Profile
  • Full Name:
  • Phone:
  • Company:
  • Company Email:
  • Country:
  • Language:
Change Password
Apply

You have no license application record.

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

Not having one? Apply now! >>>

Product Created On ID Amount (USD) Invoice
Product Created On ID Amount (USD) Invoice

No Invoice

v5.0
Search
    English
    v5.0

      Delete

      Overview

      The delete() statement allows for the deletion of nodes or edges that meet the given conditions.

      // Deletes isolated nodes
      delete().nodes(<filter?>).nodetach()
                     
      // Deletes nodes along with any edges connected to them 
      delete().nodes(<filter?>).detach()
                  
      // Deletes edges
      delete().edges(<filter?>)
      
      Method
      Param
      Description
      Optional
      nodes() or edges() <filter?> The filtering condition enclosed in {}, or an alias to specify the nodes or edges to delete. Leaving it blank will target all nodes or edges. No
      nodetach() / Prevents the deletion of nodes that still have edges connected to them; it is implicitly applied. Yes
      detach() / Enforces the deletion of nodes along with edges connected to them. Yes

      An edge cannot exist when any of its endpoints is removed from the graph. By default, UQL does not allow to delete a node while it still has edges connected to it.

      However, you can use the method detach() or nodetach().force() to enable the deletion of nodes along with their connected edges. For example, when node B is deleted, edges 1, 2 and 4 will also be deleted.

      Example Graph

      To create the graph, execute each of the following UQL queries sequentially in an empty graphset:

      create().node_schema("user").edge_schema("follow")
      create().node_property(@user, "name").node_property(@user, "age", int32).edge_property(@follow, "time", datetime)
      insert().into(@user).nodes([{_id:"U001", name:"Jason", age:30}, {_id:"U002", name:"Tim"}, {_id:"U003", name:"Grace", age:25}, {_id:"U004", name:"Ted", age:26}, {_id:"U005", name:"Kyle", age:21}])
      insert().into(@follow).edges([{_from:"U004", _to:"U001", time:"2021-9-10"}, {_from:"U003", _to:"U001", time:"2020-3-12"}, {_from:"U004", _to:"U002", time:"2023-7-30"}])
      

      Deleting Isolated Nodes

      To delete the isolated node whose name is Kyle:

      delete().nodes({name == "Kyle"})
      

      The delete().nodes() query can only delete isolated nodes, if any node specified has connected edges, an error will be thrown, and no nodes will be deleted.

      Deleting Any Nodes

      To delete the node whose name is Grace along with its connected edges:

      delete().nodes({name == "Grace"}).detach()
      

      To delete all nodes along with all edges:

      delete().nodes().detach()
      

      Deleting Edges

      To delete @follow edges:

      delete().edges({@follow})
      

      Limiting the Amount to Delete

      To limit the number of nodes or edges to delete, first retrieve the data from the database using statements like find(), then apply the LIMIT statement to keep only the first N records before passing the alias to the delete() statement.

      To delete any two edges:

      find().edges() as e limit 2
      delete().edges(e)
      return e{*}
      

      Result: e

      _uuid
      _from
      _to
      _from_uuid
      _to_uuid
      schema
      values
      Sys-gen U004 U001 UUID of U004 UUID of U001 follow {time: "2021-09-11 00:00:00"}
      Sys-gen U004 U002 UUID of U004 UUID of U002 follow {time: "2023-07-31 00:00:00"}
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写