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

[acosentino]

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 c1edf19670a782435ebf1f0e8651aaff02501d49
Author: Andrea Cosentino <anco...@gmail.com>
AuthorDate: Tue Oct 12 06:45:40 2021 +0200

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

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