Changeset 16396

Timestamp:

05/17/08 12:00:13 (2 months ago)

Author:

piotras

Message:

Refactored multilang fallback query generation

Files:

• branches/branch-1-8/src/core/midgard/src/midgard_core_query_builder.c (modified) (6 diffs)

branches/branch-1-8/src/core/midgard/src/midgard_core_query_builder.c

@@ -151 +151 @@
-        if(multilang_fallback) {
-                
-
-
-
+//
+//
+//
-        }
-
@@ -163 +163 @@
-            tables = builder->tables;
-        
-        /* MULTILANG FALLBACK */
-        if(multilang_fallback) 
-                g_string_append_printf(sql, 
-                                ", CASE WHEN lang=%d THEN 1 ELSE 0 END AS midgard_fallback_language ",
-                                mgd_lang(builder->mgd));
-
-        g_string_append(sql, " FROM ");
-        g_string_append(sql, tables);
@@ -181 +175 @@
-                MIDGARD_QUERY_CONSTRAINT(builder->stack->data), sql);
-
+        /* MULTILANG FALLBACK */
+        if(multilang_fallback) {
+
+                g_string_append_printf(sql, " AND %s_i.id IN (", builder->schema->table);
+                g_string_append_printf(sql, " SELECT ABS(MIN(i_id)) as i_id FROM (SELECT sid, "
+                                "CASE WHEN lang=%d THEN %s_i.id*-1 ELSE %s_i.id END AS i_id FROM "
+                                "%s  WHERE %s_i.sid = %s.id AND lang IN (%d,%d) ",
+                                mgd_get_default_lang(builder->mgd),
+                                builder->schema->table, builder->schema->table,
+                                tables, builder->schema->table, builder->schema->table,
+                                mgd_get_default_lang(builder->mgd), mgd_lang(builder->mgd));
+
+                if(g_slist_length(builder->stack) > 0) {
+                
+                        g_string_append(sql, " AND ");
+                        midgard_query_constraint_add_sql(
+                                                MIDGARD_QUERY_CONSTRAINT(builder->stack->data), sql);
+                }
+
+                g_string_append(sql, " ) AS midgard_multilang_fallback_table GROUP BY sid )");
+        }
+
-        if (builder->schema->use_lang == 1) {
-                g_string_append(sql, " AND ");
@@ -188 +204 @@
-                g_string_append(sql, "_i.sid");  
-               
-
+
+
-
-                        g_string_append(sql, " AND ");
-                        g_string_append(sql, builder->schema->table);
-                        /* Default behaviour , we get multilang records 
-                         * with lang 0 and other lang set, thus we have 
-                         * "full" list of objects , even some of them are 
-                         * not translated yet.*/ 
-                        if(builder->lang < 0) {
-                                g_string_append_printf(sql,
-                                                "_i.lang IN (%d, %d)",
-                                                mgd_get_default_lang(builder->mgd), 
-                                                mgd_lang(builder->mgd));
-                        } else {
-                                /* builder->lang is set with set_lang method, so 
-                                 * we get only those records with lang being set
-                                 * and we ignore all others , even woth lang 0 
-                                 */
-                                g_string_append_printf(sql,
-                                                "_i.lang = %d ",
-
-
+
-                }       
-        }           
@@ -230 +232 @@
-                                " %s.metadata_deleted = FALSE",
-                                builder->schema->table);
-        }
-
-        /* MULTILANG FALLBACK */
-        if(multilang_fallback) {
-
-                /* Unfortunatelly we can not use QB's API and order method :( */        
-                g_string_append(sql, " ORDER BY midgard_fallback_language DESC ");
-        }
-                        
@@ -249 +244 @@
-                        g_string_append(sql, ", ");
-                } else {
-
-
-
-
-
+
+
-                MidgardQueryOrder *order = g_array_index(
-                        builder->orders, MidgardQueryOrder*, i);        
-                g_string_append(sql, midgard_query_order_get_sql(order));
-        }
-
-        /* MULTILANG FALLBACK */
-        if(multilang_fallback)
-                g_string_append(sql, " ) AS midgard_multilang_table GROUP BY sid");
-
-        if (mode < MQB_SELECT_COUNT && builder->limit != G_MAXUINT)