src/query_order.c

/* 
 * Copyright (C) 2005 Jukka Zitting <jz@yukatan.fi>
 *
 * This program is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as published
 * by the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */

#include <config.h>
#include "query_order.h"
#include <mysql.h>
#include <string.h>
#include "midgard/midgard_legacy.h"
#include "midgard/midgard_object.h"
#include "midgard/midgard_metadata.h"

static const gchar *dirs[] = { "ASC", "DESC", NULL };

MidgardQueryOrder *midgard_query_order_new(
        midgard *mgd, GObjectClass *klass, const gchar *name, const gchar *dir)
{
        MidgardQueryOrder *order = g_new(MidgardQueryOrder, 1);

        order->mgd = mgd;
        order->spec = g_object_class_find_property(klass, name);
        if (order->spec == NULL) {
                g_warning("Invalid order constraint property: %s", name);
                g_free(order);
                return NULL;
        }
        /* FIXME , I need to duplicate name here.
         * One should use pointer wihout allocating new memory for name,
         * but property seems to "overwritten" in QB. Or some memory corruption
         * happens. I can not find it with valgrind */
        order->property = g_strdup(name);
        order->klass = (MidgardObjectClass *)klass;
        /* I do not understand why g_object_ref is used for GParamSpec */
        /* g_object_ref(G_OBJECT(order->spec)); */

        order->dir = NULL;
        guint i = 0;
        while (dirs[i] && strcmp(dir, dirs[i]) != 0) {
                i++;
        }
        if (dirs[i]) {
                order->dir = dirs[i];
        } else {
                g_warning("Invalid order direction: %s", dir);
                g_free(order);
                return NULL;
        }

        order->sql = NULL;

        return order;
}

const gchar *midgard_query_order_get_sql(MidgardQueryOrder *order)
{
        g_assert(order);

        if (!order->sql) {
                
                if(g_str_equal(order->property, "guid")){
                        order->sql = g_strdup_printf(
                                        "%s.guid %s", 
                                        midgard_object_class_get_table(order->klass),
                                        order->dir);
                } else if (g_str_equal(order->property, "sitegroup")){
                        order->sql = g_strdup_printf(
                                        "%s.sitegroup %s",
                                        midgard_object_class_get_table(order->klass),
                                        order->dir);
                } else if (order->ext_type == MIDGARD_TYPE_METADATA) {
                        MidgardObjectClass *pklass =  
                                (MidgardObjectClass*) g_type_class_peek(order->parent_type);
                        if(pklass){
                                order->sql = g_strdup_printf(
                                                "%s.%s %s",
                                                midgard_object_class_get_table(pklass),
                                                g_param_spec_get_nick(
                                                        (GParamSpec *)order->spec),
                                                order->dir);
                        }                       
                } else {
                        
                        order->sql = g_strdup_printf(
                                        "%s %s", 
                                        g_param_spec_get_nick(
                                                (GParamSpec *)order->spec), 
                                        order->dir);
                }
        }

        return order->sql;
}

void midgard_query_order_free(MidgardQueryOrder *order) {
        g_assert(order);
        g_free(order->sql);
        g_free((gchar*)order->property);
        /* FIXME, order->spec is GParamSpec */
        /* g_object_unref(G_OBJECT(order->spec)); */
        g_free(order);
}

---