Skip to content

Instantly share code, notes, and snippets.

@wszgrcy
Last active September 25, 2022 13:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wszgrcy/64ed33176e46f738066f0a1ce0d9e036 to your computer and use it in GitHub Desktop.
Save wszgrcy/64ed33176e46f738066f0a1ce0d9e036 to your computer and use it in GitHub Desktop.
database1
[
{
"stmt": "SELECT * FROM file_system_node_entity;",
"header": [
"id",
"icon",
"defaultIcon",
"name",
"type",
"fileSystemNodeContentId",
"prevId",
"nextId",
"list",
"parentId",
"fileSystemId"
],
"rows": [
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"",
"1",
"虚拟根",
"folder",
"NULL",
"NULL",
"NULL",
"ca6f9dd0-678a-40b6-9fad-7f132bd25bd3,2440721e-ccd1-4145-b810-64dec88fc928,1ae1592c-64e7-4a93-bd85-a86787b7f132,72e7a4ea-956b-49a2-bb0f-dc0df53a276e,31607611-e06c-4404-bcf0-4aadb0607d7a,1373e7d3-0ff2-4576-9057-a81b68615652,17e4601e-b9ed-415b-80fc-6bb24efefefd,1e38dab1-2fd6-4f98-a57f-34153b245a19,ed7c6472-b746-45cf-ab97-fa575f61b1fe,84771eb9-1e75-41a2-8e1c-0c9becbc574d,3e4f617f-6ae1-420f-abe5-b02b6c8e1867,37cc919f-ef44-4d19-8a8d-b195808032b5,0c1ed87a-c855-4bd8-a368-ec41f0fa192c,68906e22-9642-4052-9dec-8812ccbe7df9,ce409f49-594c-4a74-b7ea-5872b3dfa0ad,1d0664df-e941-4333-8bff-8fcc8dd35de9,fb13cf6b-5605-4b4d-813f-376e2f5ae03d,a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed",
"NULL",
"NULL"
],
[
"ca6f9dd0-678a-40b6-9fad-7f132bd25bd3",
"text_snippet",
"1",
"12",
"file",
"NULL",
"NULL",
"2440721e-ccd1-4145-b810-64dec88fc928",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"2440721e-ccd1-4145-b810-64dec88fc928",
"text_snippet",
"1",
"345",
"file",
"NULL",
"ca6f9dd0-678a-40b6-9fad-7f132bd25bd3",
"1ae1592c-64e7-4a93-bd85-a86787b7f132",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"1ae1592c-64e7-4a93-bd85-a86787b7f132",
"text_snippet",
"1",
"657",
"file",
"NULL",
"2440721e-ccd1-4145-b810-64dec88fc928",
"72e7a4ea-956b-49a2-bb0f-dc0df53a276e",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"72e7a4ea-956b-49a2-bb0f-dc0df53a276e",
"text_snippet",
"1",
"789",
"file",
"NULL",
"1ae1592c-64e7-4a93-bd85-a86787b7f132",
"31607611-e06c-4404-bcf0-4aadb0607d7a",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"31607611-e06c-4404-bcf0-4aadb0607d7a",
"text_snippet",
"1",
"890",
"file",
"NULL",
"72e7a4ea-956b-49a2-bb0f-dc0df53a276e",
"1373e7d3-0ff2-4576-9057-a81b68615652",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"1373e7d3-0ff2-4576-9057-a81b68615652",
"text_snippet",
"1",
"-0=",
"file",
"NULL",
"31607611-e06c-4404-bcf0-4aadb0607d7a",
"17e4601e-b9ed-415b-80fc-6bb24efefefd",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"68906e22-9642-4052-9dec-8812ccbe7df9",
"text_snippet",
"1",
"=sad",
"file",
"NULL",
"0c1ed87a-c855-4bd8-a368-ec41f0fa192c",
"ce409f49-594c-4a74-b7ea-5872b3dfa0ad",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"ce409f49-594c-4a74-b7ea-5872b3dfa0ad",
"text_snippet",
"1",
"fdg",
"file",
"NULL",
"68906e22-9642-4052-9dec-8812ccbe7df9",
"1d0664df-e941-4333-8bff-8fcc8dd35de9",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"37cc919f-ef44-4d19-8a8d-b195808032b5",
"text_snippet",
"1",
"gh",
"file",
"NULL",
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867",
"0c1ed87a-c855-4bd8-a368-ec41f0fa192c",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"0c1ed87a-c855-4bd8-a368-ec41f0fa192c",
"text_snippet",
"1",
"jhk",
"file",
"NULL",
"37cc919f-ef44-4d19-8a8d-b195808032b5",
"68906e22-9642-4052-9dec-8812ccbe7df9",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"ed7c6472-b746-45cf-ab97-fa575f61b1fe",
"text_snippet",
"1",
"kl;",
"file",
"NULL",
"1e38dab1-2fd6-4f98-a57f-34153b245a19",
"84771eb9-1e75-41a2-8e1c-0c9becbc574d",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"17e4601e-b9ed-415b-80fc-6bb24efefefd",
"text_snippet",
"1",
"bnmb",
"file",
"NULL",
"1373e7d3-0ff2-4576-9057-a81b68615652",
"1e38dab1-2fd6-4f98-a57f-34153b245a19",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"84771eb9-1e75-41a2-8e1c-0c9becbc574d",
"text_snippet",
"1",
"uyi",
"file",
"NULL",
"ed7c6472-b746-45cf-ab97-fa575f61b1fe",
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"1e38dab1-2fd6-4f98-a57f-34153b245a19",
"text_snippet",
"1",
"vbcb",
"file",
"NULL",
"17e4601e-b9ed-415b-80fc-6bb24efefefd",
"ed7c6472-b746-45cf-ab97-fa575f61b1fe",
"NULL",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"1d0664df-e941-4333-8bff-8fcc8dd35de9",
"folder",
"1",
"1235435",
"folder",
"NULL",
"ce409f49-594c-4a74-b7ea-5872b3dfa0ad",
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d",
"",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d",
"folder",
"1",
"4444444",
"folder",
"NULL",
"1d0664df-e941-4333-8bff-8fcc8dd35de9",
"a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed",
"23e2a29e-f9cf-4a03-a990-c53103aa5186",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed",
"folder",
"1",
"55555555",
"folder",
"NULL",
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d",
"NULL",
"afad7f50-e92c-44f1-b7e5-e00c9b75ed66",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"afad7f50-e92c-44f1-b7e5-e00c9b75ed66",
"text_snippet",
"1",
"12313",
"file",
"NULL",
"NULL",
"NULL",
"NULL",
"a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"23e2a29e-f9cf-4a03-a990-c53103aa5186",
"text_snippet",
"1",
"234234",
"file",
"NULL",
"NULL",
"NULL",
"NULL",
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"401718cc-7978-48f0-8d0e-7ef048d86e74",
"text_snippet",
"1",
"123123",
"file",
"NULL",
"NULL",
"257d5457-9000-4dec-93cd-ae389b0a630b",
"NULL",
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867",
"folder",
"1",
"sdfsdf",
"folder",
"NULL",
"84771eb9-1e75-41a2-8e1c-0c9becbc574d",
"37cc919f-ef44-4d19-8a8d-b195808032b5",
"401718cc-7978-48f0-8d0e-7ef048d86e74,257d5457-9000-4dec-93cd-ae389b0a630b",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
],
[
"257d5457-9000-4dec-93cd-ae389b0a630b",
"folder",
"1",
"sdfsdf",
"folder",
"NULL",
"401718cc-7978-48f0-8d0e-7ef048d86e74",
"NULL",
"NULL",
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867",
"70c0bbf7-f042-4f3c-87d1-eb85287bbad2"
]
]
}
]
[
{
"stmt": "SELECT * FROM file_system_node_entity_closure;",
"header": [
"id_ancestor",
"id_descendant"
],
"rows": [
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b"
],
[
"ca6f9dd0-678a-40b6-9fad-7f132bd25bd3",
"ca6f9dd0-678a-40b6-9fad-7f132bd25bd3"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"ca6f9dd0-678a-40b6-9fad-7f132bd25bd3"
],
[
"2440721e-ccd1-4145-b810-64dec88fc928",
"2440721e-ccd1-4145-b810-64dec88fc928"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"2440721e-ccd1-4145-b810-64dec88fc928"
],
[
"1ae1592c-64e7-4a93-bd85-a86787b7f132",
"1ae1592c-64e7-4a93-bd85-a86787b7f132"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"1ae1592c-64e7-4a93-bd85-a86787b7f132"
],
[
"72e7a4ea-956b-49a2-bb0f-dc0df53a276e",
"72e7a4ea-956b-49a2-bb0f-dc0df53a276e"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"72e7a4ea-956b-49a2-bb0f-dc0df53a276e"
],
[
"31607611-e06c-4404-bcf0-4aadb0607d7a",
"31607611-e06c-4404-bcf0-4aadb0607d7a"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"31607611-e06c-4404-bcf0-4aadb0607d7a"
],
[
"1373e7d3-0ff2-4576-9057-a81b68615652",
"1373e7d3-0ff2-4576-9057-a81b68615652"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"1373e7d3-0ff2-4576-9057-a81b68615652"
],
[
"68906e22-9642-4052-9dec-8812ccbe7df9",
"68906e22-9642-4052-9dec-8812ccbe7df9"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"68906e22-9642-4052-9dec-8812ccbe7df9"
],
[
"ce409f49-594c-4a74-b7ea-5872b3dfa0ad",
"ce409f49-594c-4a74-b7ea-5872b3dfa0ad"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"ce409f49-594c-4a74-b7ea-5872b3dfa0ad"
],
[
"37cc919f-ef44-4d19-8a8d-b195808032b5",
"37cc919f-ef44-4d19-8a8d-b195808032b5"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"37cc919f-ef44-4d19-8a8d-b195808032b5"
],
[
"0c1ed87a-c855-4bd8-a368-ec41f0fa192c",
"0c1ed87a-c855-4bd8-a368-ec41f0fa192c"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"0c1ed87a-c855-4bd8-a368-ec41f0fa192c"
],
[
"ed7c6472-b746-45cf-ab97-fa575f61b1fe",
"ed7c6472-b746-45cf-ab97-fa575f61b1fe"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"ed7c6472-b746-45cf-ab97-fa575f61b1fe"
],
[
"17e4601e-b9ed-415b-80fc-6bb24efefefd",
"17e4601e-b9ed-415b-80fc-6bb24efefefd"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"17e4601e-b9ed-415b-80fc-6bb24efefefd"
],
[
"84771eb9-1e75-41a2-8e1c-0c9becbc574d",
"84771eb9-1e75-41a2-8e1c-0c9becbc574d"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"84771eb9-1e75-41a2-8e1c-0c9becbc574d"
],
[
"1e38dab1-2fd6-4f98-a57f-34153b245a19",
"1e38dab1-2fd6-4f98-a57f-34153b245a19"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"1e38dab1-2fd6-4f98-a57f-34153b245a19"
],
[
"1d0664df-e941-4333-8bff-8fcc8dd35de9",
"1d0664df-e941-4333-8bff-8fcc8dd35de9"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"1d0664df-e941-4333-8bff-8fcc8dd35de9"
],
[
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d",
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d"
],
[
"a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed",
"a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed"
],
[
"afad7f50-e92c-44f1-b7e5-e00c9b75ed66",
"afad7f50-e92c-44f1-b7e5-e00c9b75ed66"
],
[
"a12fc82d-53c0-44f6-a2b2-c2ee9e2df4ed",
"afad7f50-e92c-44f1-b7e5-e00c9b75ed66"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"afad7f50-e92c-44f1-b7e5-e00c9b75ed66"
],
[
"23e2a29e-f9cf-4a03-a990-c53103aa5186",
"23e2a29e-f9cf-4a03-a990-c53103aa5186"
],
[
"fb13cf6b-5605-4b4d-813f-376e2f5ae03d",
"23e2a29e-f9cf-4a03-a990-c53103aa5186"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"23e2a29e-f9cf-4a03-a990-c53103aa5186"
],
[
"401718cc-7978-48f0-8d0e-7ef048d86e74",
"401718cc-7978-48f0-8d0e-7ef048d86e74"
],
[
"1d0664df-e941-4333-8bff-8fcc8dd35de9",
"401718cc-7978-48f0-8d0e-7ef048d86e74"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"401718cc-7978-48f0-8d0e-7ef048d86e74"
],
[
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867",
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867"
],
[
"1d0664df-e941-4333-8bff-8fcc8dd35de9",
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867"
],
[
"257d5457-9000-4dec-93cd-ae389b0a630b",
"257d5457-9000-4dec-93cd-ae389b0a630b"
],
[
"3e4f617f-6ae1-420f-abe5-b02b6c8e1867",
"257d5457-9000-4dec-93cd-ae389b0a630b"
],
[
"1d0664df-e941-4333-8bff-8fcc8dd35de9",
"257d5457-9000-4dec-93cd-ae389b0a630b"
],
[
"f8c3f996-4b65-4aa2-9dfc-960c9e55788b",
"257d5457-9000-4dec-93cd-ae389b0a630b"
]
]
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment