[camel-performance-tests] 03/04: SQL Kafka: Added 50000 rows script to pre-populate the database

[ac...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

acosentino pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/camel-performance-tests.git

commit b1519c9bdf7fbf65e9250d38ef9db02c6074597f
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Tue Oct 12 06:49:46 2021 +0200

    SQL Kafka: Added 50000 rows script to pre-populate the database
---
 profiling/sql-kafka/script/populate-50000.sql | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/profiling/sql-kafka/script/populate-50000.sql b/profiling/sql-kafka/script/populate-50000.sql
new file mode 100644
index 0000000..e548c52
--- /dev/null
+++ b/profiling/sql-kafka/script/populate-50000.sql
@@ -0,0 +1,7 @@
+do $$
+BEGIN
+for r in 1..50000 loop
+INSERT into accounts (username,city) VALUES ('John', 'New York');
+END loop;
+END;
+$$;