From 470a3fd36798d0211de98712758659c1700a2819 Mon Sep 17 00:00:00 2001 From: Andrea Zagli Date: Sun, 27 Sep 2020 08:57:16 +0200 Subject: [PATCH] Added function SqlBuilder::where_double. --- src/sqlbuilder.c | 30 ++++++++++++++++++++++++++++++ src/sqlbuilder.h | 11 +++++++++-- 2 files changed, 39 insertions(+), 2 deletions(-) diff --git a/src/sqlbuilder.c b/src/sqlbuilder.c index 9ac5314..e478638 100644 --- a/src/sqlbuilder.c +++ b/src/sqlbuilder.c @@ -706,6 +706,36 @@ gdaex_sql_builder_where_float (GdaExSqlBuilder *sqlb, GdaSqlOperatorType op, return id; } +GdaSqlBuilderId +gdaex_sql_builder_where_double (GdaExSqlBuilder *sqlb, GdaSqlOperatorType op, + const gchar *table_name, + const gchar *field_name, + const gchar *field_alias, + GdaSqlOperatorType where_op, + gdouble op1, + gdouble op2) +{ + GValue *val1; + GValue *val2; + + GdaSqlBuilderId id; + + val1 = g_new0 (GValue, 1); + g_value_init (val1, G_TYPE_DOUBLE); + g_value_set_double (val1, op1); + + val2 = g_new0 (GValue, 1); + g_value_init (val2, G_TYPE_DOUBLE); + g_value_set_double (val2, op2); + + id = gdaex_sql_builder_where (sqlb, op, table_name, field_name, field_alias, where_op, val1, val2, NULL); + + g_value_unset (val1); + g_value_unset (val2); + + return id; +} + GdaSqlBuilderId gdaex_sql_builder_where_string (GdaExSqlBuilder *sqlb, GdaSqlOperatorType op, const gchar *table_name, diff --git a/src/sqlbuilder.h b/src/sqlbuilder.h index b6cefc1..3c20f1a 100644 --- a/src/sqlbuilder.h +++ b/src/sqlbuilder.h @@ -1,7 +1,7 @@ /* * sqlbuilder.h * - * Copyright (C) 2015-2019 Andrea Zagli + * Copyright (C) 2015-2020 Andrea Zagli * * This file is part of libgdaex. * @@ -73,7 +73,7 @@ void gdaex_sql_builder_field_string (GdaExSqlBuilder *sqlb, const gchar *table_n void gdaex_sql_builder_fields (GdaExSqlBuilder *sqlb, ...); GdaSqlBuilderId gdaex_sql_builder_where (GdaExSqlBuilder *sqlb, GdaSqlOperatorType op, - ...); + ...); GdaSqlBuilderId gdaex_sql_builder_where_boolean (GdaExSqlBuilder *sqlb, GdaSqlOperatorType op, const gchar *table_name, const gchar *field_name, @@ -95,6 +95,13 @@ GdaSqlBuilderId gdaex_sql_builder_where_float (GdaExSqlBuilder *sqlb, GdaSqlOper GdaSqlOperatorType where_op, gfloat op1, gfloat op2); +GdaSqlBuilderId gdaex_sql_builder_where_double (GdaExSqlBuilder *sqlb, GdaSqlOperatorType op, + const gchar *table_name, + const gchar *field_name, + const gchar *field_alias, + GdaSqlOperatorType where_op, + gdouble op1, + gdouble op2); GdaSqlBuilderId gdaex_sql_builder_where_string (GdaExSqlBuilder *sqlb, GdaSqlOperatorType op, const gchar *table_name, const gchar *field_name, -- 2.49.0