Skip to content

MariaDB Client for GNU Octave (maybe this is compatible for MySQL and Matlab too)

License

Notifications You must be signed in to change notification settings

markuman/mex-mariadb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

64 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

mex mariadb client

pipeline status

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.

About

MariaDB Client for GNU Octave (maybe this is compatible for MySQL and Matlab too)

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published