Thread: Query generator
Hi everyone,
Does anyone know a random query generator for Postgres? Something that gets my schema and, based on that, generates hundreds of different queries with join, group by, etc.
Thank you.
On 29/09/2016 21:27, Vinicius Segalin wrote: > Hi everyone, > Hello, > Does anyone know a random query generator for Postgres? Something that > gets my schema and, based on that, generates hundreds of different > queries with join, group by, etc. > You should try sqlsmith (https://github.com/anse1/sqlsmith), which works very well. -- Julien Rouhaud http://dalibo.com - http://dalibo.org
2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouhaud@dalibo.com>:
On 29/09/2016 21:27, Vinicius Segalin wrote:
> Hi everyone,
>
Hello,
> Does anyone know a random query generator for Postgres? Something that
> gets my schema and, based on that, generates hundreds of different
> queries with join, group by, etc.
>
You should try sqlsmith (https://github.com/anse1/sqlsmith), which works
very well.
I had found this one before, but all I could get was queries using "standard" tables, like the ones from pg_catalog and information_schema. It didn't generate queries from the tables I've created. Was I doing something wrong?
On 29/09/2016 23:23, Vinicius Segalin wrote: > 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouhaud@dalibo.com > <mailto:julien.rouhaud@dalibo.com>>: > You should try sqlsmith (https://github.com/anse1/sqlsmith > <https://github.com/anse1/sqlsmith>), which works > very well. > > > I had found this one before, but all I could get was queries using > "standard" tables, like the ones from pg_catalog and information_schema. > It didn't generate queries from the tables I've created. Was I doing > something wrong? > I don't think so, unless you specified an empty database with the --target option. I never had this issue myself, so I can only advice you to open an issue on the project repository if you still have this problem. -- Julien Rouhaud http://dalibo.com - http://dalibo.org
Vinicius Segalin <vinisegalin@gmail.com> writes: > 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouhaud@dalibo.com>: > > > You should try sqlsmith (https://github.com/anse1/sqlsmith), which works > > very well. > > I had found this one before, but all I could get was queries using > "standard" tables, like the ones from pg_catalog and > information_schema. It didn't generate queries from the tables I've > created. Was I doing something wrong? It should pick your relations with the same likelihood it picks the catalog tables. You could verify this for with, e.g., sqlsmith --dry-run | grep your_table_name Thanks to Julien, sqlsmith's master branch now has an option --exclude-catalog that inhibits use of catalog relations. If you are building from github, you might want to give it another chance with this option. I'll probably do a proper release in next two weeks. Feedback welcome :-) regards, Andreas
2016-10-16 8:54 GMT-02:00 Andreas Seltenreich <seltenreich@gmx.de>:
Vinicius Segalin <vinisegalin@gmail.com> writes:
> 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouhaud@dalibo.com>:
>
> > You should try sqlsmith (https://github.com/anse1/sqlsmith), which works
> > very well.
>
> I had found this one before, but all I could get was queries using
> "standard" tables, like the ones from pg_catalog and
> information_schema. It didn't generate queries from the tables I've
> created. Was I doing something wrong?
It should pick your relations with the same likelihood it picks the
catalog tables. You could verify this for with, e.g.,
sqlsmith --dry-run | grep your_table_name
Thanks to Julien, sqlsmith's master branch now has an option
--exclude-catalog that inhibits use of catalog relations. If you are
building from github, you might want to give it another chance with this
option. I'll probably do a proper release in next two weeks.
Feedback welcome :-)
regards,
Andreas
Yes, I was talking in private with him and he came up with this solution. Thank you again, Julien.
I need to try it again, did a quick test on friday, but it looks like it works perfectly! :)