---
source: crates/core/tests/extractors_snapshots.rs
expression: body
input_file: crates/core/tests/fixtures/extractors/sql/users.sql
---
{
"defs": [
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:0",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
0,
252
],
"signature": "",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:288",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
288,
526
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "table",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
527,
707
],
"signature": "",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:710",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
710,
785
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "table",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:\"UserAccounts\"",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
786,
845
],
"signature": "",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:848",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
848,
918
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "table",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
919,
1079
],
"signature": "",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:1082",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1082,
1155
],
"signature": "",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:1212",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1212,
1327
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "function",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1328,
1460
],
"signature": "p_email:text",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:1463",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1463,
1644
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "function",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
1645,
2208
],
"signature": "p_email:text,p_name:text",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:2211",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
2211,
2339
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "function",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
2340,
2575
],
"signature": "p_tag:text",
"visibility": ""
},
{
"binding": "none",
"kind": "comment",
"moniker": "code+moniker://app/lang:sql/module:users/comment:2578",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
2578,
2692
],
"signature": "",
"visibility": ""
},
{
"binding": "local",
"kind": "view",
"moniker": "code+moniker://app/lang:sql/module:users/schema:app/view:recent_users",
"origin": "extracted",
"parent": "code+moniker://app/lang:sql/module:users",
"position": [
2693,
2819
],
"signature": "",
"visibility": ""
}
],
"refs": [
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"kind": "uses_type",
"position": [
568,
572
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"kind": "uses_type",
"position": [
602,
606
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"kind": "uses_type",
"position": [
640,
644
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:users",
"kind": "uses_type",
"position": [
671,
682
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:timestamptz"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:\"UserAccounts\"",
"kind": "uses_type",
"position": [
827,
831
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"kind": "uses_type",
"position": [
961,
965
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/table:user_tags",
"kind": "uses_type",
"position": [
1032,
1036
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"kind": "uses_type",
"position": [
1364,
1368
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)",
"kind": "uses_type",
"position": [
1378,
1382
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "uses_type",
"position": [
1685,
1689
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "uses_type",
"position": [
1698,
1702
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "uses_type",
"position": [
1712,
1721
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/type:app.users"
},
{
"alias": "",
"binding": "local",
"confidence": "resolved",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:create_user(p_email:text,p_name:text)",
"kind": "calls",
"position": [
7,
7
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/schema:app/function:make_id(p_email:text)"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"kind": "uses_type",
"position": [
2381,
2385
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:text"
},
{
"alias": "",
"binding": "local",
"confidence": "name_match",
"from": "code+moniker://app/lang:sql/module:users/schema:app/function:users_with_tag(p_tag:text)",
"kind": "uses_type",
"position": [
2395,
2410
],
"receiver_hint": "",
"to": "code+moniker://app/lang:sql/module:users/type:`SETOF app.users`"
},
{
"alias": "",
"binding": "local",
"confidence": "external",
"from": "code+moniker://app/lang:sql/module:users/schema:app/view:recent_users",
"kind": "calls",
"position": [
2794,
2794
],
"receiver_hint": "",
"to": "code+moniker://app/external_pkg:pg_catalog/path:now"
}
],
"root": "code+moniker://app/lang:sql/module:users"
}