[camel-performance-tests] branch main updated: SQL to Kafka: Script for having 30000 entries

[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


The following commit(s) were added to refs/heads/main by this push:
     new d165a07  SQL to Kafka: Script for having 30000 entries
d165a07 is described below

commit d165a07b2f612a37ba4ae3519a79eb853588a09b
Author: Andrea Cosentino <anco...@gmail.com>
AuthorDate: Thu Oct 7 07:55:10 2021 +0200

    SQL to Kafka: Script for having 30000 entries
---
 profiling/sql-kafka/script/{populate.sql => populate-30000.sql} | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/profiling/sql-kafka/script/populate.sql 
b/profiling/sql-kafka/script/populate-30000.sql
similarity index 55%
rename from profiling/sql-kafka/script/populate.sql
rename to profiling/sql-kafka/script/populate-30000.sql
index 3e5bc3d..0a752d3 100644
--- a/profiling/sql-kafka/script/populate.sql
+++ b/profiling/sql-kafka/script/populate-30000.sql
@@ -1 +1,7 @@
+do $$
+BEGIN
+for r in 1..30000 loop
 INSERT into accounts (username,city) VALUES ('John', 'New York');
+END loop;
+END;
+$$;