static void __add_join (Psh *holder) { MidgardCRCoreQueryExecutor *executor = MIDGARD_CR_CORE_QUERY_EXECUTOR (holder->executor); GdaSqlStatement *sql_stm = executor->priv->stmt; GdaSqlStatementSelect *select = (GdaSqlStatementSelect *) sql_stm->contents; GdaSqlSelectFrom *from = select->from; GdaSqlSelectJoin *join = gda_sql_select_join_new (GDA_SQL_ANY_PART (from)); join->type = GDA_SQL_SELECT_JOIN_LEFT; GdaSqlExpr *expr = gda_sql_expr_new (GDA_SQL_ANY_PART (join)); expr->value = gda_value_new (G_TYPE_STRING); g_value_take_string (expr->value, g_strdup_printf ("%s.%s = %s.%s", holder->table_alias, holder->colname, holder->target_table_alias, holder->target_colname)); join->expr = expr; join->position = ++executor->priv->joinid; gda_sql_select_from_take_new_join (from , join); GdaSqlSelectTarget *s_target = gda_sql_select_target_new (GDA_SQL_ANY_PART (from)); s_target->table_name = g_strdup (holder->target_table); s_target->as = g_strdup (holder->target_table_alias); gda_sql_select_from_take_new_target (from, s_target); /* Set target expression */ GdaSqlExpr *texpr = gda_sql_expr_new (GDA_SQL_ANY_PART (s_target)); GValue *tval = g_new0 (GValue, 1); g_value_init (tval, G_TYPE_STRING); g_value_set_string (tval, s_target->table_name); texpr->value = tval; s_target->expr = texpr; }
gboolean __query_select_add_joins (MidgardQuerySelect *self, GdaSqlOperation *operation, GError **error) { __add_implicit_workspace_join (self, operation); if (!MIDGARD_QUERY_EXECUTOR (self)->priv->joins) return TRUE; GSList *l = NULL; MidgardQueryExecutor *executor = MIDGARD_QUERY_EXECUTOR (self); GdaSqlStatement *sql_stm = executor->priv->stmt; GdaSqlStatementSelect *select = (GdaSqlStatementSelect *) sql_stm->contents; GdaSqlSelectFrom *from = select->from; GdaSqlSelectJoin *join; for (l = MIDGARD_QUERY_EXECUTOR (self)->priv->joins; l != NULL; l = l->next) { qsj *_sj = (qsj*) l->data; join = gda_sql_select_join_new (GDA_SQL_ANY_PART (from)); join->type = _sj->join_type; MidgardQueryStorage *left_storage = _sj->left_property->priv->storage; MidgardQueryStorage *right_storage = _sj->right_property->priv->storage; GError *err = NULL; GValue lval = {0, }; midgard_query_holder_get_value (MIDGARD_QUERY_HOLDER (_sj->left_property), &lval); gchar *left_table_field = midgard_core_query_compute_constraint_property (executor, left_storage, g_value_get_string (&lval), &err); if (err) { g_propagate_error (error, err); g_free (left_table_field); } GValue rval = {0, }; midgard_query_holder_get_value (MIDGARD_QUERY_HOLDER (_sj->right_property), &rval); gchar *right_table_field = midgard_core_query_compute_constraint_property (executor, right_storage, g_value_get_string (&rval), &err); if (err) { g_propagate_error (error, err); g_free (right_table_field); } GdaSqlExpr *expr = gda_sql_expr_new (GDA_SQL_ANY_PART (join)); expr->value = gda_value_new (G_TYPE_STRING); g_value_take_string (expr->value, g_strdup_printf ("%s = %s", left_table_field, right_table_field)); join->expr = expr; join->position = ++executor->priv->joinid; /* Add right storage to targets */ MQE_SET_TABLE_ALIAS (executor, right_storage); gda_sql_select_from_take_new_join (from , join); GdaSqlSelectTarget *s_target = gda_sql_select_target_new (GDA_SQL_ANY_PART (from)); s_target->table_name = g_strdup (right_storage->priv->table); s_target->as = g_strdup (right_storage->priv->table_alias); gda_sql_select_from_take_new_target (from, s_target); // Set target expression GdaSqlExpr *texpr = gda_sql_expr_new (GDA_SQL_ANY_PART (s_target)); GValue *tval = g_new0 (GValue, 1); g_value_init (tval, G_TYPE_STRING); g_value_set_string (tval, right_storage->priv->table); texpr->value = tval; s_target->expr = texpr; } return TRUE; }
static void _midgard_query_select_execute (MidgardExecutable *iface, gboolean async, GError **error) { g_return_if_fail (iface != NULL); MidgardQuerySelect *self = MIDGARD_QUERY_SELECT (iface); MidgardQueryExecutor *executor = MIDGARD_QUERY_EXECUTOR (self); GError *err = NULL; midgard_validable_validate (MIDGARD_VALIDABLE (self), &err); if (err) { g_propagate_error (error, err); return; } MidgardDBObjectClass *klass = executor->priv->storage->priv->klass; MidgardConnection *mgd = executor->priv->mgd; GdaConnection *cnc = mgd->priv->connection; GdaSqlStatement *sql_stm; GdaSqlStatementSelect *sss; sql_stm = gda_sql_statement_new (GDA_SQL_STATEMENT_SELECT); sss = (GdaSqlStatementSelect*) sql_stm->contents; g_assert (GDA_SQL_ANY_PART (sss)->type == GDA_SQL_ANY_STMT_SELECT); MIDGARD_QUERY_EXECUTOR (self)->priv->stmt = sql_stm; sss->from = gda_sql_select_from_new (GDA_SQL_ANY_PART (sss)); /* Initialize top base expresion and operation with default AND operator type */ GdaSqlExpr *base_where = gda_sql_expr_new (GDA_SQL_ANY_PART (sss)); GdaSqlOperation *base_operation = gda_sql_operation_new (GDA_SQL_ANY_PART (base_where)); base_operation->operator_type = GDA_SQL_OPERATOR_TYPE_AND; base_where->cond = base_operation; gda_sql_statement_select_take_where_cond (sql_stm, base_where); /* Create targets (FROM) */ GdaSqlSelectTarget *s_target = gda_sql_select_target_new (GDA_SQL_ANY_PART (sss->from)); s_target->table_name = g_strdup (midgard_core_class_get_table (klass)); s_target->as = g_strdup_printf ("t%d", ++MIDGARD_QUERY_EXECUTOR (self)->priv->tableid); MIDGARD_QUERY_EXECUTOR (self)->priv->table_alias = g_strdup (s_target->as); gda_sql_select_from_take_new_target (sss->from, s_target); /* Set target expression */ GdaSqlExpr *texpr = gda_sql_expr_new (GDA_SQL_ANY_PART (s_target)); GValue *tval = g_new0 (GValue, 1); g_value_init (tval, G_TYPE_STRING); g_value_set_string (tval, s_target->table_name); texpr->value = tval; s_target->expr = texpr; /* Add fields for all properties registered per class (SELECT a,b,c...) */ klass->dbpriv->add_fields_to_select_statement (klass, mgd, sss, s_target->as); GdaSqlExpr *where = sss->where_cond; GdaSqlOperation *operation = where->cond; /* Add joins, LEFT JOIN tbl2 ON... */ __query_select_add_joins (MIDGARD_QUERY_SELECT (self), operation, &err); if (err) { g_propagate_error (error, err); goto return_false; } /* Add constraints' conditions (WHERE a=1, b=2...) */ if (MIDGARD_QUERY_EXECUTOR (self)->priv->constraint) { MIDGARD_QUERY_CONSTRAINT_SIMPLE_GET_INTERFACE (MIDGARD_QUERY_EXECUTOR (self)->priv->constraint)->priv->add_conditions_to_statement (MIDGARD_QUERY_EXECUTOR (self), MIDGARD_QUERY_EXECUTOR (self)->priv->constraint, sql_stm, base_where, &err); if (err) { g_propagate_error (error, err); goto return_false; } if (MIDGARD_QUERY_EXECUTOR (self)->priv->n_constraints == 1) __add_second_dummy_constraint (sss, operation); /* Add dummy constraint if operation has only one operand */ if (operation->operands && (g_slist_length (operation->operands) == 1)) __add_dummy_constraint (sss, operation); } else { /* no constraints, add dummy '1=1 AND 0<1' to satisfy top constraint group */ __add_dummy_constraint (sss, operation); __add_second_dummy_constraint (sss, operation); } /* Add orders , ORDER BY t1.field... */ if (!__query_select_add_orders (executor, &err)) { if (err) g_propagate_error (error, err); goto return_false; } /* Exclude deleted */ if (MGD_DBCLASS_METADATA_CLASS (klass) && !executor->priv->include_deleted) __add_exclude_deleted_constraints (executor, sss, operation, klass); /* Add limit, LIMIT x */ if (executor->priv->limit > 0) { GdaSqlExpr *limit_expr = gda_sql_expr_new (GDA_SQL_ANY_PART (sss)); GValue *limit_val = g_new0 (GValue, 1); g_value_init (limit_val, G_TYPE_STRING); g_value_take_string (limit_val, g_strdup_printf ("%d", executor->priv->limit)); limit_expr->value = limit_val; sss->limit_count = limit_expr; } /* Add offset, OFFSET x */ if (executor->priv->offset >= 0) { GdaSqlExpr *offset_expr = gda_sql_expr_new (GDA_SQL_ANY_PART (sss)); GValue *offset_val = g_new0 (GValue, 1); g_value_init (offset_val, G_TYPE_STRING); g_value_take_string (offset_val, g_strdup_printf ("%d", executor->priv->offset)); offset_expr->value = offset_val; sss->limit_offset = offset_expr; } /* Check structure */ if (!gda_sql_statement_check_structure (sql_stm, &err)) { g_set_error (error, MIDGARD_EXECUTION_ERROR, MIDGARD_EXECUTION_ERROR_INTERNAL, "Can't build SELECT statement: %s)", err && err->message ? err->message : _("Unknown reason")); if (err) g_clear_error (&err); goto return_false; } /* Create statement */ GdaStatement *stmt = gda_statement_new (); g_object_set (G_OBJECT (stmt), "structure", sql_stm, NULL); gda_sql_statement_free (sql_stm); sql_stm = NULL; if (MGD_CNC_DEBUG (mgd)) { gchar *debug_sql = gda_connection_statement_to_sql (cnc, stmt, NULL, GDA_STATEMENT_SQL_PRETTY, NULL, NULL); g_debug ("QuerySelect: %s", debug_sql); g_free (debug_sql); } /* execute statement */ GdaDataModel *model = NULL; midgard_executable_execution_start (MIDGARD_EXECUTABLE(self)); model = gda_connection_statement_execute_select (cnc, stmt, NULL, &err); g_object_unref (stmt); if (!model && !err) { g_set_error (error, MIDGARD_EXECUTION_ERROR, MIDGARD_EXECUTION_ERROR_INTERNAL, "Execute error - Unknown reason, underlying error is NULL"); goto return_false; } if (err) { g_set_error (error, MIDGARD_EXECUTION_ERROR, MIDGARD_EXECUTION_ERROR_INTERNAL, "Execute error - %s", err->message); g_error_free (err); goto return_false; } executor->priv->results_count = gda_data_model_get_n_rows (model); if (executor->priv->resultset && G_IS_OBJECT (executor->priv->resultset)) g_object_unref (G_OBJECT (executor->priv->resultset)); executor->priv->resultset = (gpointer) model; return; return_false: if (sql_stm) gda_sql_statement_free (sql_stm); return; }
static void __add_implicit_workspace_join (MidgardQuerySelect *self, GdaSqlOperation *operation) { g_return_if_fail (self != NULL); MidgardDBObjectClass *klass = MIDGARD_QUERY_EXECUTOR (self)->priv->storage->priv->klass; if (!g_type_is_a (G_OBJECT_CLASS_TYPE (klass), MIDGARD_TYPE_OBJECT)) return; MidgardConnection *mgd = MIDGARD_QUERY_EXECUTOR (self)->priv->mgd; /* Do not take worskpace into account if if it's disabled * or enabled and none set */ if (!MGD_CNC_USES_WORKSPACE (mgd)) return; if (!MGD_CNC_HAS_WORKSPACE (mgd)) return; gboolean bool_is_int = MIDGARD_QUERY_EXECUTOR (self)->priv->bool_is_int; guint ws_id = MGD_CNC_WORKSPACE_ID (mgd); MidgardQueryExecutor *executor = MIDGARD_QUERY_EXECUTOR (self); GdaSqlStatement *sql_stm = executor->priv->stmt; GdaSqlStatementSelect *select = (GdaSqlStatementSelect *) sql_stm->contents; GdaSqlSelectFrom *from = select->from; GdaSqlSelectJoin *join; const gchar *klass_table = MGD_DBCLASS_TABLENAME (klass); gchar *left_table = executor->priv->table_alias; //gchar *right_table = g_strdup_printf ("t%d", ++executor->priv->tableid); gchar *right_table = g_strdup ("midgard_ws_tmp_table"); join = gda_sql_select_join_new (GDA_SQL_ANY_PART (from)); join->type = GDA_SQL_SELECT_JOIN_INNER; GdaSqlExpr *expr = gda_sql_expr_new (GDA_SQL_ANY_PART (join)); expr->value = gda_value_new (G_TYPE_STRING); g_value_take_string (expr->value, g_strdup_printf ("%s.%s = %s.%s", left_table, MGD_WORKSPACE_ID_FIELD, right_table, MGD_WORKSPACE_ID_FIELD)); join->expr = expr; join->position = ++executor->priv->joinid; MidgardConfig *config = mgd->priv->config; const gchar *sql_part_bool_func_start = ""; const gchar *sql_part_bool_func_end = ""; const gchar *deleted_field = midgard_core_object_get_deleted_field (klass); GString *table = g_string_new ("(SELECT DISTINCT MAX"); if (config->priv->dbtype == MIDGARD_DB_TYPE_POSTGRES && deleted_field) { sql_part_bool_func_start = " bool_or("; sql_part_bool_func_end = ") AS metadata_deleted"; } g_string_append_printf (table, "(%s) AS %s, %s %s%s%s%s FROM %s WHERE %s IN (0,", MGD_WORKSPACE_ID_FIELD, MGD_WORKSPACE_ID_FIELD, MGD_WORKSPACE_OID_FIELD, deleted_field ? "," : "", sql_part_bool_func_start, deleted_field ? deleted_field : "", sql_part_bool_func_end, klass_table, MGD_WORKSPACE_ID_FIELD); const MidgardWorkspaceStorage *ws = midgard_connection_get_workspace (mgd); GSList *list = MIDGARD_WORKSPACE_STORAGE_GET_INTERFACE (ws)->priv->list_ids (mgd, MIDGARD_WORKSPACE_STORAGE (ws)); GSList *l = NULL; guint i = 0; guint id; for (l = list; l != NULL; l = l->next, i++) { GValue *id_val = (GValue *) l->data; if (G_VALUE_HOLDS_UINT (id_val)) id = g_value_get_uint (id_val); else id = (guint) g_value_get_int (id_val); g_string_append_printf (table, "%s%d", i > 0 ? "," : "", id); } if (!list) g_string_append (table, "0"); g_string_append (table, ") "); if (deleted_field) g_string_append_printf (table, "AND %s = %s ", deleted_field, __BOOL_VALUE (bool_is_int)); g_string_append_printf (table, "GROUP BY %s)", MGD_WORKSPACE_OID_FIELD); g_slist_free (list); gda_sql_select_from_take_new_join (from , join); GdaSqlSelectTarget *s_target = gda_sql_select_target_new (GDA_SQL_ANY_PART (from)); s_target->table_name = g_string_free (table, FALSE); s_target->as = right_table; gda_sql_select_from_take_new_target (from, s_target); /* MIDGARD_QUERY_EXECUTOR (self)->priv->include_deleted_targets = g_slist_append (MIDGARD_QUERY_EXECUTOR (self)->priv->include_deleted_targets, s_target); */ GdaSqlExpr *texpr = gda_sql_expr_new (GDA_SQL_ANY_PART (s_target)); GValue *tval = g_new0 (GValue, 1); g_value_init (tval, G_TYPE_STRING); g_value_set_string (tval, g_strdup (s_target->table_name)); texpr->value = tval; s_target->expr = texpr; /* Add workspace object id constraint */ GdaSqlExpr *ws_expr = gda_sql_expr_new (GDA_SQL_ANY_PART (operation)); ws_expr->value = gda_value_new (G_TYPE_STRING); g_value_take_string (ws_expr->value, g_strdup_printf ("%s.%s = %s.%s", left_table, MGD_WORKSPACE_OID_FIELD, right_table, MGD_WORKSPACE_OID_FIELD)); operation->operands = g_slist_append (operation->operands, ws_expr); }