[libgda/LIBGDA_4.2] gda_compute_dml_statements(): handle column's default value and autoincrement
- From: Vivien Malerba <vivien src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [libgda/LIBGDA_4.2] gda_compute_dml_statements(): handle column's default value and autoincrement
- Date: Mon, 25 Jul 2011 19:59:47 +0000 (UTC)
commit f6a541a7066bce369a13d6315c0ccc453699592f
Author: Vivien Malerba <malerba gnome-db org>
Date: Sun Jul 24 13:10:29 2011 +0200
gda_compute_dml_statements(): handle column's default value and autoincrement
libgda/gda-util.c | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
---
diff --git a/libgda/gda-util.c b/libgda/gda-util.c
index e756888..dd32252 100644
--- a/libgda/gda-util.c
+++ b/libgda/gda-util.c
@@ -1180,6 +1180,12 @@ gda_compute_dml_statements (GdaConnection *cnc, GdaStatement *select_stmt, gbool
pspec->g_type = tcol->gtype != G_TYPE_INVALID ? tcol->gtype: G_TYPE_STRING;
pspec->nullok = tcol->nullok;
expr = gda_sql_expr_new (GDA_SQL_ANY_PART (ist));
+ if (tcol->default_value)
+ g_value_set_string ((expr->value = gda_value_new (G_TYPE_STRING)),
+ tcol->default_value);
+ else if (gda_meta_table_column_get_attribute (tcol, GDA_ATTRIBUTE_AUTO_INCREMENT))
+ g_value_set_string ((expr->value = gda_value_new (G_TYPE_STRING)), "''");
+
expr->param_spec = pspec;
insert_values_list = g_slist_append (insert_values_list, expr);
}
@@ -1189,6 +1195,11 @@ gda_compute_dml_statements (GdaConnection *cnc, GdaStatement *select_stmt, gbool
pspec->g_type = tcol->gtype != G_TYPE_INVALID ? tcol->gtype: G_TYPE_STRING;
pspec->nullok = tcol->nullok;
expr = gda_sql_expr_new (GDA_SQL_ANY_PART (ust));
+ if (tcol->default_value)
+ g_value_set_string ((expr->value = gda_value_new (G_TYPE_STRING)),
+ tcol->default_value);
+ else if (gda_meta_table_column_get_attribute (tcol, GDA_ATTRIBUTE_AUTO_INCREMENT))
+ g_value_set_string ((expr->value = gda_value_new (G_TYPE_STRING)), "''");
expr->param_spec = pspec;
ust->expr_list = g_slist_append (ust->expr_list, expr);
}
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]