Record links

[dodalovicgran]

Hi, I've got the following model:

An address table, that has city as string and zip as string.

id	city	zip
ber	Berlin	14222
lon	London	ABC333

and a user table that has:

id	name	billing_address	shipping_address
joe	Joe	address:ber	address:lon
jack	Jack	address:lon	address:ber

I want to:

• insert 2 addresses, address:lon and address.ber
• insert two users, one having shipping_address = address:ber and billing_address = address and the other one other way round.
• query the DB to retrieve all users with already resolved billing and shipping addresses.
  I wasn't able to figure out things by reading the docs.

Thank you

[sethsandaru]

You need to add FETCH in order to eager-load the record links (1:1 mapping)

SELECT *
FROM user
FETCH billing_address, shipping_address

FYA I have some snippets noted down here https://github.com/sethsandaru/surreal-snippets which might help you

[AlexFrid]

The alternative without using FETCH would be

SELECT *, billing_address.*, shipping_address.*
FROM user