Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

doc example with doctors on postgres generates 0 values #422

Open
nealchau opened this issue Mar 3, 2023 · 1 comment
Open

doc example with doctors on postgres generates 0 values #422

nealchau opened this issue Mar 3, 2023 · 1 comment
Labels
bug Something isn't working

Comments

@nealchau
Copy link

nealchau commented Mar 3, 2023

The docs give table doctors, and show how synth can import the table information and generate the values. i added a trivial hospitals table with only an id column to complete the schema. Then I ran the import command, I found the doctors.json to have only minor differences with the one in the docs:

21,23c21
<           "subtype": "naive_date",
<           "begin": null,
<           "end": null
---
>           "subtype": "naive_date"
38c36
<       "subtype": "u64"
---
>       "subtype": "i32"
45c43
< }
---
> }

however the generate command gives an error and doesn't populate anything:

synth generate --to postgres://postgres:postgres@localhost/guru99 --schema public guru99
Collection doctors generated 0 values. Skipping insertion...

I would expect values to be generated and inserted.

ubuntu 22.04
synth 0.6.9
psql (PostgreSQL) 14.5 (Ubuntu 14.5-0ubuntu0.22.04.1)

@nealchau nealchau added the bug Something isn't working label Mar 3, 2023
@ratskates
Copy link

I have the same set up as above. Can confirm the same issue in addition this seems to be happening for any postgres table

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants