README.md

mex mariadb client

• https://git.osuv.de/m/mex-mariadb

• Pull Mirror: https://gitlab.com/markuman/mex-mariadb

• Push Mirror: https://github.com/markuman/mex-mariadb

• test compiling

  • MariaDB 5.5 @ Centos 7
  • MariaDB 10.2 @ Alpine Linux
  • MariaDB 10.3.29 @ macOS Big Sur 11.7.1

• run tests against

  • MariaDB 10.1
  • MariaDB 10.2
  • MariaDB 10.3
  • MySQL 5.7

Build

$ make
mkoctfile --mex  -L/usr/lib  -lmysqlclient -lpthread -lz -lm -ldl -lssl -lcrypto -I/usr/include/mysql mariadb.c

On macOS use make macos_mariadb or make macos_mysql depending on which binaries are installed (MariaDB or MySQL). Use Homebrew to install the binary libraries with brew install mariadb or brew install mysql.

example

you can take a look at gitlabci.m file too. the classdef file mariadb.m and the mex file mariadb_.mex are both used for testing.

class def example

octave:1> sql = mariadb('hostname', '127.0.0.1', 'password', 'password');
octave:2> sql.query('create database octave')
ans = [](0x0)

to change a database, you can recreate your class
or change the property sql.database = 'octave'.

octave:3> sql = mariadb('hostname', '127.0.0.1', 'password', 'password', 'database', 'octave');
octave:4> sql.query('create table a (idx int)');
octave:5> sql.query('insert into a (idx) values (1),(2),(3),(4)');
octave:6> sql.query('select * from a')
ans =
{
  [1,1] = idx
  [2,1] = 1
  [3,1] = 2
  [4,1] = 3
  [5,1] = 4
}

you can change the output format to matrix

octave:7> sql.output = 'mat'
sql =

<object mariadb>

octave:8> sql.query('select * from a')
ans =

   NaN
     1
     2
     3
     4

octave:9>

return structure

the return structure is always a cell.

octave:1> a = mariadb_('127.0.0.1', 3306, 'root', 'password', 'testdb', 'select * from a')
a =
{
  [1,1] = idx
  [2,1] = 1
  [3,1] = 2
  [4,1] = 8
  [5,1] = 1
  [6,1] = 2
  [7,1] = 8
  [1,2] = b
  [2,2] = NULL
  [3,2] = NULL
  [4,2] = NULL
  [5,2] = 1
  [6,2] = 2
  [7,2] = 3
}

select * from a;

idx |b |
----|--|
1   |  |
2   |  |
8   |  |
1   |1 |
2   |2 |
8   |3 |

mariadb()

properties

• hostname
  • char, default localhost
• port
  • number, default 3306
• username
  • char, default root
• password
  • char, default password
• database
  • char, default empty string. Connects to no database
• command
  • char, sql command
• is_octave
  • boolean, determines if class was init on matlab or octave
• output
  • char, defines the output format. currently supports only mat and cell

methods

• query(command)
  • executes sql command
• to_mat()
  • only used internally to convert the cell output to matrix format.