Up to [Platon] / tucniak / db

Initial import

// Copyright (c) 2003,2004,2005 Juraj Kolesár <koli@koli.sk>               
#include "tdb.h"
/* fill {{{ *******************************************************************/
int tdb_table_fill(T_DB *tdb, T_MATRIX *matrix, char * SQL_select) {
  T_ROW *t_row = NULL;
    MYSQL_ROW db_row;
    int Fields = 0;
    int Rows = 0;
  register int col, row;

    matrix->table = NULL;
  //TODO: this should be not here, check by next compilation
  
    if (mysql_real_query(tdb->connection, SQL_select, strlen(SQL_select))) {
        return __LT_ERR;
    }
    
    log("%s", SQL_select);
    //TODO: remove, or format better this log
    
    if (matrix->memory = mysql_store_result(tdb->connection)) {
        Fields = mysql_num_fields(matrix->memory);
        Rows = mysql_num_rows(matrix->memory);
    } else return __LT_ERR;

    for (row=0; row < Rows; row++) {
        db_row = mysql_fetch_row(matrix->memory);    
        for (col=0; col < Fields; col++) {
            t_row = g_slist_append(t_row, db_row[col]);
        }
        matrix->table = g_list_append(matrix->table, t_row);
        t_row = NULL;
    }
  return(Rows);
}
/* }}} */
/* free {{{ *******************************************************************/
int tdb_table_free (T_MATRIX *matrix) {
    mysql_free_result(matrix->memory);
    g_list_free(matrix->table);
    matrix->table = NULL;
    return(0);
}
/* }}} */