insert.c File Reference

#include <stdarg.h>
#include "windef.h"
#include "winbase.h"
#include "winerror.h"
#include "wine/debug.h"
#include "msi.h"
#include "msiquery.h"
#include "objbase.h"
#include "objidl.h"
#include "msipriv.h"
#include "winnls.h"
#include "query.h"

Include dependency graph for insert.c:

Go to the source code of this file.

Classes
struct	tagMSIINSERTVIEW

Typedefs
typedef struct tagMSIINSERTVIEW	MSIINSERTVIEW

Functions
	WINE_DEFAULT_DEBUG_CHANNEL (msidb)
static UINT	INSERT_fetch_int (struct tagMSIVIEW *view, UINT row, UINT col, UINT *val)
MSIRECORD *	msi_query_merge_record (UINT fields, const column_info *vl, MSIRECORD *rec)
static BOOL	msi_columns_in_order (MSIINSERTVIEW *iv, UINT col_count)
static UINT	msi_arrange_record (MSIINSERTVIEW *iv, MSIRECORD **values)
static BOOL	row_has_null_primary_keys (MSIINSERTVIEW *iv, MSIRECORD *row)
static UINT	INSERT_execute (struct tagMSIVIEW *view, MSIRECORD *record)
static UINT	INSERT_close (struct tagMSIVIEW *view)
static UINT	INSERT_get_dimensions (struct tagMSIVIEW *view, UINT *rows, UINT *cols)
static UINT	INSERT_get_column_info (struct tagMSIVIEW *view, UINT n, LPCWSTR *name, UINT *type, BOOL *temporary, LPCWSTR *table_name)
static UINT	INSERT_modify (struct tagMSIVIEW *view, MSIMODIFY eModifyMode, MSIRECORD *rec, UINT row)
static UINT	INSERT_delete (struct tagMSIVIEW *view)
static UINT	count_column_info (const column_info *ci)
UINT	INSERT_CreateView (MSIDATABASE *db, MSIVIEW **view, LPCWSTR table, column_info *columns, column_info *values, BOOL temp)

Variables
static const MSIVIEWOPS	insert_ops

Typedef Documentation

MSIINSERTVIEW

typedef struct tagMSIINSERTVIEW MSIINSERTVIEW

Function Documentation

count_column_info()

static UINT count_column_info ( const column_info *  ci )

static

Definition at line 343 of file insert.c.

{
    UINT n = 0;
    for ( ; ci; ci = ci->next )
        n++;
    return n;
}

Referenced by INSERT_CreateView().

INSERT_close()

static UINT INSERT_close ( struct tagMSIVIEW *  view )

static

Definition at line 252 of file insert.c.

{
    MSIINSERTVIEW *iv = (MSIINSERTVIEW*)view;
    MSIVIEW *sv;
 
    TRACE("%p\n", iv);
 
    sv = iv->sv;
    if( !sv )
        return ERROR_FUNCTION_FAILED;
 
    return sv->ops->close( sv );
}

INSERT_CreateView()

UINT INSERT_CreateView	(	MSIDATABASE *	db,
		MSIVIEW **	view,
		LPCWSTR	table,
		column_info *	columns,
		column_info *	values,
		BOOL	temp
	)

Definition at line 351 of file insert.c.

{
    MSIINSERTVIEW *iv = NULL;
    UINT r;
    MSIVIEW *tv = NULL, *sv = NULL;
 
    TRACE("%p\n", iv );
 
    /* there should be one value for each column */
    if ( count_column_info( columns ) != count_column_info(values) )
        return ERROR_BAD_QUERY_SYNTAX;
 
    r = TABLE_CreateView( db, table, &tv );
    if( r != ERROR_SUCCESS )
        return r;
 
    r = SELECT_CreateView( db, &sv, tv, columns );
    if( r != ERROR_SUCCESS )
    {
        if( tv )
            tv->ops->delete( tv );
        return r;
    }
 
    iv = msi_alloc_zero( sizeof *iv );
    if( !iv )
        return ERROR_FUNCTION_FAILED;
 
    /* fill the structure */
    iv->view.ops = &insert_ops;
    msiobj_addref( &db->hdr );
    iv->table = tv;
    iv->db = db;
    iv->vals = values;
    iv->bIsTemp = temp;
    iv->sv = sv;
    *view = (MSIVIEW*) iv;
 
    return ERROR_SUCCESS;
}

INSERT_delete()

static UINT INSERT_delete ( struct tagMSIVIEW *  view )

static

Definition at line 304 of file insert.c.

{
    MSIINSERTVIEW *iv = (MSIINSERTVIEW*)view;
    MSIVIEW *sv;
 
    TRACE("%p\n", iv );
 
    sv = iv->sv;
    if( sv )
        sv->ops->delete( sv );
    msiobj_release( &iv->db->hdr );
    msi_free( iv );
 
    return ERROR_SUCCESS;
}

INSERT_execute()

static UINT INSERT_execute ( struct tagMSIVIEW *  view, MSIRECORD *  record  )

static

Definition at line 204 of file insert.c.

{
    MSIINSERTVIEW *iv = (MSIINSERTVIEW*)view;
    UINT r, row = -1, col_count = 0;
    MSIVIEW *sv;
    MSIRECORD *values = NULL;
 
    TRACE("%p %p\n", iv, record );
 
    sv = iv->sv;
    if( !sv )
        return ERROR_FUNCTION_FAILED;
 
    r = sv->ops->execute( sv, 0 );
    TRACE("sv execute returned %x\n", r);
    if( r )
        return r;
 
    r = sv->ops->get_dimensions( sv, NULL, &col_count );
    if( r )
        goto err;
 
    /*
     * Merge the wildcard values into the list of values provided
     * in the query, and create a record containing both.
     */
    values = msi_query_merge_record( col_count, iv->vals, record );
    if( !values )
        goto err;
 
    r = msi_arrange_record( iv, &values );
    if( r != ERROR_SUCCESS )
        goto err;
 
    /* rows with NULL primary keys are inserted at the beginning of the table */
    if( row_has_null_primary_keys( iv, values ) )
        row = 0;
 
    r = iv->table->ops->insert_row( iv->table, values, row, iv->bIsTemp );
 
err:
    if( values )
        msiobj_release( &values->hdr );
 
    return r;
}

INSERT_fetch_int()

static UINT INSERT_fetch_int ( struct tagMSIVIEW *  view, UINT  row, UINT  col, UINT *  val  )

static

Definition at line 51 of file insert.c.

{
    MSIINSERTVIEW *iv = (MSIINSERTVIEW*)view;
 
    TRACE("%p %d %d %p\n", iv, row, col, val );
 
    return ERROR_FUNCTION_FAILED;
}

INSERT_get_column_info()

static UINT INSERT_get_column_info ( struct tagMSIVIEW *  view, UINT  n, LPCWSTR *  name, UINT *  type, BOOL *  temporary, LPCWSTR *  table_name  )

static

Definition at line 280 of file insert.c.

{
    MSIINSERTVIEW *iv = (MSIINSERTVIEW*)view;
    MSIVIEW *sv;
 
    TRACE("%p %d %p %p %p %p\n", iv, n, name, type, temporary, table_name );
 
    sv = iv->sv;
    if( !sv )
        return ERROR_FUNCTION_FAILED;
 
    return sv->ops->get_column_info( sv, n, name, type, temporary, table_name );
}

INSERT_get_dimensions()

static UINT INSERT_get_dimensions ( struct tagMSIVIEW *  view, UINT *  rows, UINT *  cols  )

static

Definition at line 266 of file insert.c.

{
    MSIINSERTVIEW *iv = (MSIINSERTVIEW*)view;
    MSIVIEW *sv;
 
    TRACE("%p %p %p\n", iv, rows, cols );
 
    sv = iv->sv;
    if( !sv )
        return ERROR_FUNCTION_FAILED;
 
    return sv->ops->get_dimensions( sv, rows, cols );
}

INSERT_modify()

static UINT INSERT_modify ( struct tagMSIVIEW *  view, MSIMODIFY  eModifyMode, MSIRECORD *  rec, UINT  row  )

static

Definition at line 295 of file insert.c.

{
    MSIINSERTVIEW *iv = (MSIINSERTVIEW*)view;
 
    TRACE("%p %d %p\n", iv, eModifyMode, rec );
 
    return ERROR_FUNCTION_FAILED;
}

msi_arrange_record()

static UINT msi_arrange_record ( MSIINSERTVIEW *  iv, MSIRECORD **  values  )

static

Definition at line 127 of file insert.c.

{
    MSIRECORD *padded;
    UINT col_count, val_count;
    UINT r, i, colidx;
    LPCWSTR a, b;
 
    r = iv->table->ops->get_dimensions(iv->table, NULL, &col_count);
    if (r != ERROR_SUCCESS)
        return r;
 
    val_count = MSI_RecordGetFieldCount(*values);
 
    /* check to see if the columns are arranged already
     * to avoid unnecessary copying
     */
    if (col_count == val_count && msi_columns_in_order(iv, col_count))
        return ERROR_SUCCESS;
 
    padded = MSI_CreateRecord(col_count);
    if (!padded)
        return ERROR_OUTOFMEMORY;
 
    for (colidx = 1; colidx <= val_count; colidx++)
    {
        r = iv->sv->ops->get_column_info(iv->sv, colidx, &a, NULL, NULL, NULL);
        if (r != ERROR_SUCCESS)
            goto err;
 
        for (i = 1; i <= col_count; i++)
        {
            r = iv->table->ops->get_column_info(iv->table, i, &b, NULL,
                                                NULL, NULL);
            if (r != ERROR_SUCCESS)
                goto err;
 
            if (!wcscmp( a, b ))
            {
                MSI_RecordCopyField(*values, colidx, padded, i);
                break;
            }
        }
    }
    msiobj_release(&(*values)->hdr);
    *values = padded;
    return ERROR_SUCCESS;
 
err:
    msiobj_release(&padded->hdr);
    return r;
}

Referenced by INSERT_execute().

msi_columns_in_order()

static BOOL msi_columns_in_order ( MSIINSERTVIEW *  iv, UINT  col_count  )

static

Definition at line 109 of file insert.c.

{
    LPCWSTR a, b;
    UINT i;
 
    for (i = 1; i <= col_count; i++)
    {
        iv->sv->ops->get_column_info(iv->sv, i, &a, NULL, NULL, NULL);
        iv->table->ops->get_column_info(iv->table, i, &b, NULL, NULL, NULL);
 
        if (wcscmp( a, b )) return FALSE;
    }
    return TRUE;
}

Referenced by msi_arrange_record().

msi_query_merge_record()

MSIRECORD * msi_query_merge_record	(	UINT	fields,
		const column_info *	vl,
		MSIRECORD *	rec
	)

Definition at line 66 of file insert.c.

{
    MSIRECORD *merged;
    DWORD wildcard_count = 1, i;
 
    merged = MSI_CreateRecord( fields );
    for( i=1; i <= fields; i++ )
    {
        if( !vl )
        {
            TRACE("Not enough elements in the list to insert\n");
            goto err;
        }
        switch( vl->val->type )
        {
        case EXPR_SVAL:
            TRACE( "field %lu -> %s\n", i, debugstr_w(vl->val->u.sval) );
            MSI_RecordSetStringW( merged, i, vl->val->u.sval );
            break;
        case EXPR_IVAL:
            MSI_RecordSetInteger( merged, i, vl->val->u.ival );
            break;
        case EXPR_WILDCARD:
            if( !rec )
                goto err;
            MSI_RecordCopyField( rec, wildcard_count, merged, i );
            wildcard_count++;
            break;
        default:
            ERR("Unknown expression type %d\n", vl->val->type);
        }
        vl = vl->next;
    }
 
    return merged;
err:
    msiobj_release( &merged->hdr );
    return NULL;
}

Referenced by INSERT_execute(), and UPDATE_execute().

row_has_null_primary_keys()

static BOOL row_has_null_primary_keys ( MSIINSERTVIEW *  iv, MSIRECORD *  row  )

static

Definition at line 179 of file insert.c.

{
    UINT r, i, col_count, type;
 
    r = iv->table->ops->get_dimensions( iv->table, NULL, &col_count );
    if (r != ERROR_SUCCESS)
        return FALSE;
 
    for (i = 1; i <= col_count; i++)
    {
        r = iv->table->ops->get_column_info(iv->table, i, NULL, &type,
                                            NULL, NULL);
        if (r != ERROR_SUCCESS)
            return FALSE;
 
        if (!(type & MSITYPE_KEY))
            continue;
 
        if (MSI_RecordIsNull(row, i))
            return TRUE;
    }
 
    return FALSE;
}

Referenced by INSERT_execute().

WINE_DEFAULT_DEBUG_CHANNEL()

WINE_DEFAULT_DEBUG_CHANNEL

(

msidb

)

Variable Documentation

insert_ops

const MSIVIEWOPS insert_ops

static

Initial value:

=
{
    INSERT_fetch_int,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    INSERT_execute,
    INSERT_close,
    INSERT_get_dimensions,
    INSERT_get_column_info,
    INSERT_modify,
    INSERT_delete,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
}

Definition at line 320 of file insert.c.

Referenced by INSERT_CreateView().