Does locust support DB connection?

[carlosmmelo]

I'm new to locust, I've been using jmeter for API and DB (using JDBC) load tests. However it seems locust just support API load test (by using HttpLocust module).

Is there any way for me to connect directly into a DB (say postgresql for example) and run my tests against that db? without using an API (ODBC)

[mthurlin]

Yes, you can write a custom client class that uses whatever protocol you want:
http://docs.locust.io/en/latest/testing-other-systems.html

[MochiXu]

I have modified my code based on this introduction, But the aggregate report keeps showing 0, and there are no charts from result

[cyberw]

Where is your client implementation? You need to override methods in your client (or use getattr as shown in the example) so that they call self.env.events.request.fire(...) after each request.

[cyberw]

You can check out some more examples here: https://github.com/SvenskaSpel/locust-plugins/tree/c405417065e2f129d4f181519513785763ca50bb/locust_plugins/users

[pinchukov98]

@MochiXu hi, tell me, did you manage to connect to the database?

[cyberw]

There's now an example User class for Postgres: https://github.com/locustio/locust/blob/master/locust/contrib/postgres.py

Here's a locustfile that shows how to use it: https://github.com/locustio/locust/blob/master/examples/postgres/locustfile.py

[pinchukov98]

@cyberw Can you find out what the error is here, the connection to the Mssql database is not being made? I just hid the user data for now

[pinchukov98]

@cyberw and how to import locust.contrib.postgres ?