sqlite_test_bind

mksqlite Version 2.5 build: 133, ein MATLAB Interface zu SQLite
(c) 2008-2017 by Martin Kortmann <mail@kortmann.de>
                 Andreas Martin  <andimartin@users.sourceforge.net>
basierend auf SQLite Version 3.16.2 - http://www.sqlite.org
mksqlite verwendet:
 - DEELX perl kompatible regex engine Version 1.3 (Sswater@gmail.com)
 - BLOSC/LZ4 1.3.0-rc3.dev zur Datenkompression (Francesc Alted / Yann Collett) 
 - MD5 Message-Digest Algorithm (RFC 1321) Implementierung von Alexander Peslyak
   
Platform: PCWIN64, little endian

Create a database with some records

    fprintf( 'Creating in-memory database...\n' );
    mksqlite( 'open', ':memory:' ); % "in-memory"-database

    %          |First name |Last name    |City         |Random data
    mydata = { ...
               'Gunther',  'Meyer',      'Munich',     []; ...
               'Holger',   'Michelmann', 'Garbsen',    rand( 1, 10 ); ...
               'Knuth',    'Almeroth',   'Wehnsen',    'coworker' ...
             };

    % create table
    mksqlite( 'CREATE TABLE demo (Col_1, Col_2, Col_3, Data)' );

    % create records
    % uses "cell expansion" for command shortening!
    for i = 1:size( mydata, 1 )
        mksqlite( 'INSERT INTO demo VALUES (?,?,?,?)', mydata{i,:} );
    end

Creating in-memory database...

Take a screenshot (figure) as RGB-matrix...

    h = figure;
    set( h, 'units', 'normalized', 'position', [0.5,0.5,0.2,0.2] );
    x = linspace( 0, 2*pi, 20 );
    plot( x, sin(x), 'r-', 'linewidth', 2 );
    legend on
    F = getframe(h);
    delete(h);
    data = F.cdata;

    % ... write back screenshot information as BLOB with additional
    % array size parameters
    mksqlite( 'INSERT INTO demo VALUES (?,?,?,?)', ...
              size( data, 1 ), size( data, 2 ), size( data, 3 ), data );




    % ------------------------------------------------------------------

Read back all records

    fprintf( 'Restore BLOB records...\n\n' )

    query = mksqlite( 'SELECT * FROM demo' );

    fprintf( '---> Empty array: ' ), ...
             query(1).Data

    fprintf( '---> 10 random numbers between 0 and 1: ' ), ...
             typecast( query(2).Data, 'double' )

    fprintf( '---> Text: ' ), ...
             cast( query(3).Data, 'char' )

    fprintf( '---> Image: (see figure) \n\n' )

    % Reshape vector from 4th row as multidimensional array (RGB matrix) back:
    img = reshape( query(4).Data, query(4).Col_1, query(4).Col_2, query(4).Col_3 );

    % display image got from database
    h = image( img );
    axis off
    set( gcf, 'units', 'normalized', 'position', [0.5,0.5,0.2,0.2] );
    drawnow

    % bring figure on top
    try
        warning( 'off', 'MATLAB:HandleGraphics:ObsoletedProperty:JavaFrame' );
        jh = get( h, 'JavaFrame' );
        jh.fFigureClient.getWindow.setAlwaysOnTop( true );
        jh.fFigureClient.getWindow.setVisible( true );
    catch
        % ignore errors
    end

    mksqlite( 'close' );

Restore BLOB records...

---> Empty array: 
ans =

     []

---> 10 random numbers between 0 and 1: 
ans =

   0.913375856139019
   0.632359246225410
   0.097540404999410
   0.278498218867048
   0.546881519204984
   0.957506835434298
   0.964888535199277
   0.157613081677548
   0.970592781760616
   0.957166948242946

---> Text: 
ans =

coworker

---> Image: (see figure)

Contents

Create a database with some records

Take a screenshot (figure) as RGB-matrix...

Read back all records