W3cubDocs

/Nim

Module mysql

Types

my_bool = bool
Pmy_bool = ptr my_bool
PVIO = pointer
Pgptr = ptr gptr
gptr = cstring
Pmy_socket = ptr my_socket
my_socket = cint
PPByte = pointer
cuint = cint
Enum_server_command = enum
  COM_SLEEP, COM_QUIT, COM_INIT_DB, COM_QUERY, COM_FIELD_LIST, COM_CREATE_DB,
  COM_DROP_DB, COM_REFRESH, COM_SHUTDOWN, COM_STATISTICS, COM_PROCESS_INFO,
  COM_CONNECT, COM_PROCESS_KILL, COM_DEBUG, COM_PING, COM_TIME, COM_DELAYED_INSERT,
  COM_CHANGE_USER, COM_BINLOG_DUMP, COM_TABLE_DUMP, COM_CONNECT_OUT,
  COM_REGISTER_SLAVE, COM_STMT_PREPARE, COM_STMT_EXECUTE, COM_STMT_SEND_LONG_DATA,
  COM_STMT_CLOSE, COM_STMT_RESET, COM_SET_OPTION, COM_STMT_FETCH, COM_END
Pst_net = ptr St_net
St_net {...}{.final.} = object
  vio*: PVIO
  buff*: cstring
  buff_end*: cstring
  write_pos*: cstring
  read_pos*: cstring
  fd*: my_socket
  max_packet*: int
  max_packet_size*: int
  pkt_nr*: cuint
  compress_pkt_nr*: cuint
  write_timeout*: cuint
  read_timeout*: cuint
  retry_count*: cuint
  fcntl*: cint
  compress*: my_bool
  remain_in_buf*: int
  len*: int
  buf_length*: int
  where_b*: int
  return_status*: ptr cint
  reading_or_writing*: char
  save_char*: cchar
  no_send_ok*: my_bool
  no_send_eof*: my_bool
  no_send_error*: my_bool
  last_error*: array[0 .. 200 - 1, char]
  sqlstate*: array[0 .. 6 - 1, char]
  last_errno*: cuint
  error*: char
  query_cache_query*: gptr
  report_error*: my_bool
  return_errno*: my_bool
NET = St_net
PNET = ptr NET
Enum_field_types = enum
  TYPE_DECIMAL, TYPE_TINY, TYPE_SHORT, TYPE_LONG, TYPE_FLOAT, TYPE_DOUBLE, TYPE_NULL,
  TYPE_TIMESTAMP, TYPE_LONGLONG, TYPE_INT24, TYPE_DATE, TYPE_TIME, TYPE_DATETIME,
  TYPE_YEAR, TYPE_NEWDATE, TYPE_VARCHAR, TYPE_BIT, TYPE_NEWDECIMAL = 246,
  TYPE_ENUM = 247, TYPE_SET = 248, TYPE_TINY_BLOB = 249, TYPE_MEDIUM_BLOB = 250,
  TYPE_LONG_BLOB = 251, TYPE_BLOB = 252, TYPE_VAR_STRING = 253, TYPE_STRING = 254,
  TYPE_GEOMETRY = 255
Enum_shutdown_level = enum
  SHUTDOWN_DEFAULT = 0, SHUTDOWN_WAIT_CONNECTIONS = 1, SHUTDOWN_WAIT_TRANSACTIONS = 2,
  SHUTDOWN_WAIT_UPDATES = 8, SHUTDOWN_WAIT_ALL_BUFFERS = 16,
  SHUTDOWN_WAIT_CRITICAL_BUFFERS = 17, KILL_QUERY = 254, KILL_CONNECTION = 255
Enum_cursor_type = enum
  CURSOR_TYPE_NO_CURSOR = 0, CURSOR_TYPE_READ_ONLY = 1, CURSOR_TYPE_FOR_UPDATE = 2,
  CURSOR_TYPE_SCROLLABLE = 4
Enum_mysql_set_option = enum
  OPTION_MULTI_STATEMENTS_ON, OPTION_MULTI_STATEMENTS_OFF
Psockaddr = ptr Sockaddr
Sockaddr {...}{.final.} = object
Prand_struct = ptr Rand_struct
Rand_struct {...}{.final.} = object
  seed1*: int
  seed2*: int
  max_value*: int
  max_value_dbl*: cdouble
Item_result = enum
  STRING_RESULT, REAL_RESULT, INT_RESULT, ROW_RESULT, DECIMAL_RESULT
PItem_result = ptr Item_result
Pst_udf_args = ptr St_udf_args
St_udf_args {...}{.final.} = object
  arg_count*: cuint
  arg_type*: PItem_result
  args*: cstringArray
  lengths*: ptr int
  maybe_null*: cstring
  attributes*: cstringArray
  attribute_lengths*: ptr int
UDF_ARGS = St_udf_args
PUDF_ARGS = ptr UDF_ARGS
Pst_udf_init = ptr St_udf_init
St_udf_init {...}{.final.} = object
  maybe_null*: my_bool
  decimals*: cuint
  max_length*: int
  theptr*: cstring
  const_item*: my_bool
UDF_INIT = St_udf_init
PUDF_INIT = ptr UDF_INIT
Pst_mysql_field = ptr St_mysql_field
St_mysql_field {...}{.final.} = object
  name*: cstring
  org_name*: cstring
  table*: cstring
  org_table*: cstring
  db*: cstring
  catalog*: cstring
  def*: cstring
  len*: int
  max_length*: int
  name_length*: cuint
  org_name_length*: cuint
  table_length*: cuint
  org_table_length*: cuint
  db_length*: cuint
  catalog_length*: cuint
  def_length*: cuint
  flags*: cuint
  decimals*: cuint
  charsetnr*: cuint
  ftype*: Enum_field_types
  extension*: pointer
FIELD = St_mysql_field
PFIELD = ptr FIELD
PROW = ptr ROW
ROW = cstringArray
PFIELD_OFFSET = ptr FIELD_OFFSET
FIELD_OFFSET = cuint
my_ulonglong = int64
Pmy_ulonglong = ptr my_ulonglong
Pst_mysql_rows = ptr St_mysql_rows
St_mysql_rows {...}{.final.} = object
  next*: Pst_mysql_rows
  data*: ROW
  len*: int
ROWS = St_mysql_rows
PROWS = ptr ROWS
PROW_OFFSET = ptr ROW_OFFSET
ROW_OFFSET = ROWS
Pst_used_mem = ptr St_used_mem
St_used_mem {...}{.final.} = object
  next*: Pst_used_mem
  left*: cuint
  size*: cuint
USED_MEM = St_used_mem
PUSED_MEM = ptr USED_MEM
Pst_mem_root = ptr St_mem_root
St_mem_root {...}{.final.} = object
  free*: PUSED_MEM
  used*: PUSED_MEM
  pre_alloc*: PUSED_MEM
  min_malloc*: cuint
  block_size*: cuint
  block_num*: cuint
  first_block_usage*: cuint
  error_handler*: proc () {...}{.cdecl.}
MEM_ROOT = St_mem_root
PMEM_ROOT = ptr MEM_ROOT
Pst_mysql_data = ptr St_mysql_data
St_mysql_data {...}{.final.} = object
  rows*: my_ulonglong
  fields*: cuint
  data*: PROWS
  alloc*: MEM_ROOT
  prev_ptr*: ptr PROWS
DATA = St_mysql_data
PDATA = ptr DATA
Option = enum
  OPT_CONNECT_TIMEOUT, OPT_COMPRESS, OPT_NAMED_PIPE, INIT_COMMAND,
  READ_DEFAULT_FILE, READ_DEFAULT_GROUP, SET_CHARSET_DIR, SET_CHARSET_NAME,
  OPT_LOCAL_INFILE, OPT_PROTOCOL, SHARED_MEMORY_BASE_NAME, OPT_READ_TIMEOUT,
  OPT_WRITE_TIMEOUT, OPT_USE_RESULT, OPT_USE_REMOTE_CONNECTION,
  OPT_USE_EMBEDDED_CONNECTION, OPT_GUESS_CONNECTION, SET_CLIENT_IP, SECURE_AUTH,
  REPORT_DATA_TRUNCATION, OPT_RECONNECT
St_dynamic_array {...}{.final.} = object
  buffer*: cstring
  elements*: cuint
  max_element*: cuint
  alloc_increment*: cuint
  size_of_element*: cuint
DYNAMIC_ARRAY = St_dynamic_array
Pst_dynamic_array = ptr St_dynamic_array
Pst_mysql_options = ptr St_mysql_options
St_mysql_options {...}{.final.} = object
  connect_timeout*: cuint
  read_timeout*: cuint
  write_timeout*: cuint
  port*: cuint
  protocol*: cuint
  client_flag*: int
  host*: cstring
  user*: cstring
  password*: cstring
  unix_socket*: cstring
  db*: cstring
  init_commands*: Pst_dynamic_array
  my_cnf_file*: cstring
  my_cnf_group*: cstring
  charset_dir*: cstring
  charset_name*: cstring
  ssl_key*: cstring
  ssl_cert*: cstring
  ssl_ca*: cstring
  ssl_capath*: cstring
  ssl_cipher*: cstring
  shared_memory_base_name*: cstring
  max_allowed_packet*: int
  use_ssl*: my_bool
  compress*: my_bool
  named_pipe*: my_bool
  rpl_probe*: my_bool
  rpl_parse*: my_bool
  no_master_reads*: my_bool
  separate_thread*: my_bool
  methods_to_use*: Option
  client_ip*: cstring
  secure_auth*: my_bool
  report_data_truncation*: my_bool
  local_infile_init*: proc (para1: var pointer; para2: cstring; para3: pointer): cint {...}{.
      cdecl.}
  local_infile_read*: proc (para1: pointer; para2: cstring; para3: cuint): cint
  local_infile_end*: proc (para1: pointer)
  local_infile_error*: proc (para1: pointer; para2: cstring; para3: cuint): cint
  local_infile_userdata*: pointer
Status = enum
  STATUS_READY, STATUS_GET_RESULT, STATUS_USE_RESULT
Protocol_type = enum
  PROTOCOL_DEFAULT, PROTOCOL_TCP, PROTOCOL_SOCKET, PROTOCOL_PIPE, PROTOCOL_MEMORY
Rpl_type = enum
  RPL_MASTER, RPL_SLAVE, RPL_ADMIN
Charset_info_st {...}{.final.} = object
  number*: cuint
  primary_number*: cuint
  binary_number*: cuint
  state*: cuint
  csname*: cstring
  name*: cstring
  comment*: cstring
  tailoring*: cstring
  ftype*: cstring
  to_lower*: cstring
  to_upper*: cstring
  sort_order*: cstring
  contractions*: ptr int16
  sort_order_big*: ptr ptr int16
  tab_to_uni*: ptr int16
  tab_from_uni*: pointer
  state_map*: cstring
  ident_map*: cstring
  strxfrm_multiply*: cuint
  mbminlen*: cuint
  mbmaxlen*: cuint
  min_sort_char*: int16
  max_sort_char*: int16
  escape_with_backslash_is_dangerous*: my_bool
  cset*: pointer
  coll*: pointer
CHARSET_INFO = Charset_info_st
Pcharset_info_st = ptr Charset_info_st
Pcharacter_set = ptr Character_set
Character_set {...}{.final.} = object
  number*: cuint
  state*: cuint
  csname*: cstring
  name*: cstring
  comment*: cstring
  dir*: cstring
  mbminlen*: cuint
  mbmaxlen*: cuint
MY_CHARSET_INFO = Character_set
PMY_CHARSET_INFO = ptr MY_CHARSET_INFO
Pst_mysql_methods = ptr St_mysql_methods
Pst_mysql = ptr St_mysql
St_mysql {...}{.final.} = object
  net*: NET
  connector_fd*: gptr
  host*: cstring
  user*: cstring
  passwd*: cstring
  unix_socket*: cstring
  server_version*: cstring
  host_info*: cstring
  info*: cstring
  db*: cstring
  charset*: Pcharset_info_st
  fields*: PFIELD
  field_alloc*: MEM_ROOT
  affected_rows*: my_ulonglong
  insert_id*: my_ulonglong
  extra_info*: my_ulonglong
  thread_id*: int
  packet_length*: int
  port*: cuint
  client_flag*: int
  server_capabilities*: int
  protocol_version*: cuint
  field_count*: cuint
  server_status*: cuint
  server_language*: cuint
  warning_count*: cuint
  options*: St_mysql_options
  status*: Status
  free_me*: my_bool
  reconnect*: my_bool
  scramble*: array[0 .. 21 - 1, char]
  rpl_pivot*: my_bool
  master*: Pst_mysql
  next_slave*: Pst_mysql
  last_used_slave*: Pst_mysql
  last_used_con*: Pst_mysql
  stmts*: pointer
  methods*: Pst_mysql_methods
  thd*: pointer
  unbuffered_fetch_owner*: Pmy_bool
MySQL = St_mysql
PMySQL = ptr MySQL
Pst_mysql_res = ptr St_mysql_res
St_mysql_res {...}{.final.} = object
  row_count*: my_ulonglong
  fields*: PFIELD
  data*: PDATA
  data_cursor*: PROWS
  lengths*: ptr int
  handle*: PMySQL
  field_alloc*: MEM_ROOT
  field_count*: cuint
  current_field*: cuint
  row*: ROW
  current_row*: ROW
  eof*: my_bool
  unbuffered_fetch_cancelled*: my_bool
  methods*: Pst_mysql_methods
RES = St_mysql_res
PRES = ptr RES
Pst_mysql_stmt = ptr St_mysql_stmt
PSTMT = ptr STMT
St_mysql_methods {...}{.final.} = object
  read_query_result*: proc (MySQL: PMySQL): my_bool {...}{.cdecl.}
  advanced_command*: proc (MySQL: PMySQL; command: Enum_server_command;
                         header: cstring; header_length: int; arg: cstring;
                         arg_length: int; skip_check: my_bool): my_bool
  read_rows*: proc (MySQL: PMySQL; fields: PFIELD; fields_count: cuint): PDATA
  use_result*: proc (MySQL: PMySQL): PRES
  fetch_lengths*: proc (fto: ptr int; column: ROW; field_count: cuint)
  flush_use_result*: proc (MySQL: PMySQL)
  list_fields*: proc (MySQL: PMySQL): PFIELD
  read_prepare_result*: proc (MySQL: PMySQL; stmt: PSTMT): my_bool
  stmt_execute*: proc (stmt: PSTMT): cint
  read_binary_rows*: proc (stmt: PSTMT): cint
  unbuffered_fetch*: proc (MySQL: PMySQL; row: cstringArray): cint
  free_embedded_thd*: proc (MySQL: PMySQL)
  read_statistics*: proc (MySQL: PMySQL): cstring
  next_result*: proc (MySQL: PMySQL): my_bool
  read_change_user_result*: proc (MySQL: PMySQL; buff: cstring; passwd: cstring): cint
  read_rowsfrom_cursor*: proc (stmt: PSTMT): cint
METHODS = St_mysql_methods
PMETHODS = ptr METHODS
Pst_mysql_manager = ptr St_mysql_manager
St_mysql_manager {...}{.final.} = object
  net*: NET
  host*: cstring
  user*: cstring
  passwd*: cstring
  port*: cuint
  free_me*: my_bool
  eof*: my_bool
  cmd_status*: cint
  last_errno*: cint
  net_buf*: cstring
  net_buf_pos*: cstring
  net_data_end*: cstring
  net_buf_size*: cint
  last_error*: array[0 .. 256 - 1, char]
MANAGER = St_mysql_manager
PMANAGER = ptr MANAGER
Pst_mysql_parameters = ptr St_mysql_parameters
St_mysql_parameters {...}{.final.} = object
  p_max_allowed_packet*: ptr int
  p_net_buffer_length*: ptr int
PARAMETERS = St_mysql_parameters
PPARAMETERS = ptr PARAMETERS
Enum_mysql_stmt_state = enum
  STMT_INIT_DONE = 1, STMT_PREPARE_DONE, STMT_EXECUTE_DONE, STMT_FETCH_DONE
Pst_mysql_bind = ptr St_mysql_bind
St_mysql_bind {...}{.final.} = object
  len*: int
  is_null*: Pmy_bool
  buffer*: pointer
  error*: Pmy_bool
  buffer_type*: Enum_field_types
  buffer_length*: int
  row_ptr*: ptr byte
  offset*: int
  length_value*: int
  param_number*: cuint
  pack_length*: cuint
  error_value*: my_bool
  is_unsigned*: my_bool
  long_data_used*: my_bool
  is_null_value*: my_bool
  store_param_func*: proc (net: PNET; param: Pst_mysql_bind) {...}{.cdecl.}
  fetch_result*: proc (para1: Pst_mysql_bind; para2: PFIELD; row: PPByte)
  skip_result*: proc (para1: Pst_mysql_bind; para2: PFIELD; row: PPByte)
BIND = St_mysql_bind
PBIND = ptr BIND
St_mysql_stmt {...}{.final.} = object
  mem_root*: MEM_ROOT
  mysql*: PMySQL
  params*: PBIND
  `bind`*: PBIND
  fields*: PFIELD
  result*: DATA
  data_cursor*: PROWS
  affected_rows*: my_ulonglong
  insert_id*: my_ulonglong
  read_row_func*: proc (stmt: Pst_mysql_stmt; row: PPByte): cint {...}{.cdecl.}
  stmt_id*: int
  flags*: int
  prefetch_rows*: int
  server_status*: cuint
  last_errno*: cuint
  param_count*: cuint
  field_count*: cuint
  state*: Enum_mysql_stmt_state
  last_error*: array[0 .. 200 - 1, char]
  sqlstate*: array[0 .. 6 - 1, char]
  send_types_to_server*: my_bool
  bind_param_done*: my_bool
  bind_result_done*: char
  unbuffered_fetch_cancelled*: my_bool
  update_max_length*: my_bool
STMT = St_mysql_stmt
Enum_stmt_attr_type = enum
  STMT_ATTR_UPDATE_MAX_LENGTH, STMT_ATTR_CURSOR_TYPE, STMT_ATTR_PREFETCH_ROWS

Consts

NAME_LEN = 64
HOSTNAME_LENGTH = 60
USERNAME_LENGTH = 16
SERVER_VERSION_LENGTH = 60
SQLSTATE_LENGTH = 5
LOCAL_HOST = "localhost"
LOCAL_HOST_NAMEDPIPE = '.'
NAMEDPIPE = "MySQL"
SERVICENAME = "MySQL"
SCRAMBLE_LENGTH = 20
SCRAMBLE_LENGTH_323 = 8
SCRAMBLED_PASSWORD_CHAR_LENGTH = 41
SCRAMBLED_PASSWORD_CHAR_LENGTH_323 = 16
NOT_NULL_FLAG = 1
PRI_KEY_FLAG = 2
UNIQUE_KEY_FLAG = 4
MULTIPLE_KEY_FLAG = 8
BLOB_FLAG = 16
UNSIGNED_FLAG = 32
ZEROFILL_FLAG = 64
BINARY_FLAG = 128
ENUM_FLAG = 256
AUTO_INCREMENT_FLAG = 512
TIMESTAMP_FLAG = 1024
SET_FLAG = 2048
NO_DEFAULT_VALUE_FLAG = 4096
NUM_FLAG = 32768
PART_KEY_FLAG = 16384
GROUP_FLAG = 32768
UNIQUE_FLAG = 65536
BINCMP_FLAG = 131072
REFRESH_GRANT = 1
REFRESH_LOG = 2
REFRESH_TABLES = 4
REFRESH_HOSTS = 8
REFRESH_STATUS = 16
REFRESH_THREADS = 32
REFRESH_SLAVE = 64
REFRESH_MASTER = 128
REFRESH_READ_LOCK = 16384
REFRESH_FAST = 32768
REFRESH_QUERY_CACHE = 65536
REFRESH_QUERY_CACHE_FREE = 0x00020000
REFRESH_DES_KEY_FILE = 0x00040000
REFRESH_USER_RESOURCES = 0x00080000
CLIENT_LONG_PASSWORD = 1
CLIENT_FOUND_ROWS = 2
CLIENT_LONG_FLAG = 4
CLIENT_CONNECT_WITH_DB = 8
CLIENT_NO_SCHEMA = 16
CLIENT_COMPRESS = 32
CLIENT_ODBC = 64
CLIENT_LOCAL_FILES = 128
CLIENT_IGNORE_SPACE = 256
CLIENT_PROTOCOL_41 = 512
CLIENT_INTERACTIVE = 1024
CLIENT_SSL = 2048
CLIENT_IGNORE_SIGPIPE = 4096
CLIENT_TRANSACTIONS = 8192
CLIENT_RESERVED = 16384
CLIENT_SECURE_CONNECTION = 32768
CLIENT_MULTI_STATEMENTS = 65536
CLIENT_MULTI_RESULTS = 131072
CLIENT_REMEMBER_OPTIONS: int = 2147483648
SERVER_STATUS_IN_TRANS = 1
SERVER_STATUS_AUTOCOMMIT = 2
SERVER_STATUS_MORE_RESULTS = 4
SERVER_MORE_RESULTS_EXISTS = 8
SERVER_QUERY_NO_GOOD_INDEX_USED = 16
SERVER_QUERY_NO_INDEX_USED = 32
SERVER_STATUS_CURSOR_EXISTS = 64
SERVER_STATUS_LAST_ROW_SENT = 128
SERVER_STATUS_DB_DROPPED = 256
SERVER_STATUS_NO_BACKSLASH_ESCAPES = 512
ERRMSG_SIZE = 200
NET_READ_TIMEOUT = 30
NET_WRITE_TIMEOUT = 60
NET_WAIT_TIMEOUT = 28800
ONLY_KILL_QUERY = 1
MAX_TINYINT_WIDTH = 3
MAX_SMALLINT_WIDTH = 5
MAX_MEDIUMINT_WIDTH = 8
MAX_INT_WIDTH = 10
MAX_BIGINT_WIDTH = 20
MAX_CHAR_WIDTH = 255
MAX_BLOB_WIDTH = 8192
packet_error = -1
CLIENT_MULTI_QUERIES = 65536
FIELD_TYPE_DECIMAL = TYPE_DECIMAL
FIELD_TYPE_NEWDECIMAL = TYPE_NEWDECIMAL
FIELD_TYPE_TINY = TYPE_TINY
FIELD_TYPE_SHORT = TYPE_SHORT
FIELD_TYPE_LONG = TYPE_LONG
FIELD_TYPE_FLOAT = TYPE_FLOAT
FIELD_TYPE_DOUBLE = TYPE_DOUBLE
FIELD_TYPE_NULL = TYPE_NULL
FIELD_TYPE_TIMESTAMP = TYPE_TIMESTAMP
FIELD_TYPE_LONGLONG = TYPE_LONGLONG
FIELD_TYPE_INT24 = TYPE_INT24
FIELD_TYPE_DATE = TYPE_DATE
FIELD_TYPE_TIME = TYPE_TIME
FIELD_TYPE_DATETIME = TYPE_DATETIME
FIELD_TYPE_YEAR = TYPE_YEAR
FIELD_TYPE_NEWDATE = TYPE_NEWDATE
FIELD_TYPE_ENUM = TYPE_ENUM
FIELD_TYPE_SET = TYPE_SET
FIELD_TYPE_TINY_BLOB = TYPE_TINY_BLOB
FIELD_TYPE_MEDIUM_BLOB = TYPE_MEDIUM_BLOB
FIELD_TYPE_LONG_BLOB = TYPE_LONG_BLOB
FIELD_TYPE_BLOB = TYPE_BLOB
FIELD_TYPE_VAR_STRING = TYPE_VAR_STRING
FIELD_TYPE_STRING = TYPE_STRING
FIELD_TYPE_CHAR = TYPE_TINY
FIELD_TYPE_INTERVAL = TYPE_ENUM
FIELD_TYPE_GEOMETRY = TYPE_GEOMETRY
FIELD_TYPE_BIT = TYPE_BIT
SHUTDOWN_KILLABLE_CONNECT = '\x01'
SHUTDOWN_KILLABLE_TRANS = '\x02'
SHUTDOWN_KILLABLE_LOCK_TABLE = '\x04'
SHUTDOWN_KILLABLE_UPDATE = '\b'
NET_HEADER_SIZE = 4
COMP_HEADER_SIZE = 3
NULL_LENGTH: int = -1
STMT_HEADER = 4
LONG_DATA_HEADER = 6
CLIENT_NET_READ_TIMEOUT = 31536000
CLIENT_NET_WRITE_TIMEOUT = 31536000
COUNT_ERROR = -1
ALLOC_MAX_BLOCK_TO_DROP = 4096
ALLOC_MAX_BLOCK_USAGE_BEFORE_DROP = 10
MAX_MYSQL_MANAGER_ERR = 256
MAX_MYSQL_MANAGER_MSG = 256
MANAGER_OK = 200
MANAGER_INFO = 250
MANAGER_ACCESS = 401
MANAGER_CLIENT_ERR = 450
MANAGER_INTERNAL_ERR = 500
LOCAL_INFILE_ERROR_LEN = 512
NO_DATA = 100
DATA_TRUNCATED = 101

Procs

proc my_net_init(net: PNET; vio: PVIO): my_bool {...}{.cdecl, dynlib: lib,
    importc: "my_net_init".}
proc my_net_local_init(net: PNET) {...}{.cdecl, dynlib: lib, importc: "my_net_local_init".}
proc net_end(net: PNET) {...}{.cdecl, dynlib: lib, importc: "net_end".}
proc net_clear(net: PNET) {...}{.cdecl, dynlib: lib, importc: "net_clear".}
proc net_realloc(net: PNET; len: int): my_bool {...}{.cdecl, dynlib: lib,
    importc: "net_realloc".}
proc net_flush(net: PNET): my_bool {...}{.cdecl, dynlib: lib, importc: "net_flush".}
proc my_net_write(net: PNET; packet: cstring; length: int): my_bool {...}{.cdecl, dynlib: lib,
    importc: "my_net_write".}
proc net_write_command(net: PNET; command: char; header: cstring; head_len: int;
                      packet: cstring; length: int): my_bool {...}{.cdecl, dynlib: lib,
    importc: "net_write_command".}
proc net_real_write(net: PNET; packet: cstring; length: int): cint {...}{.cdecl, dynlib: lib,
    importc: "net_real_write".}
proc my_net_read(net: PNET): int {...}{.cdecl, dynlib: lib, importc: "my_net_read".}
proc my_connect(s: my_socket; name: Psockaddr; namelen: cuint; timeout: cuint): cint {...}{.
    cdecl, dynlib: lib, importc: "my_connect".}
proc randominit(para1: Prand_struct; seed1: int; seed2: int) {...}{.cdecl, dynlib: lib,
    importc: "randominit".}
proc my_rnd(para1: Prand_struct): cdouble {...}{.cdecl, dynlib: lib, importc: "my_rnd".}
proc create_random_string(fto: cstring; len: cuint; rand_st: Prand_struct) {...}{.cdecl,
    dynlib: lib, importc: "create_random_string".}
proc hash_password(fto: int; password: cstring; password_len: cuint) {...}{.cdecl,
    dynlib: lib, importc: "hash_password".}
proc make_scrambled_password_323(fto: cstring; password: cstring) {...}{.cdecl,
    dynlib: lib, importc: "make_scrambled_password_323".}
proc scramble_323(fto: cstring; message: cstring; password: cstring) {...}{.cdecl,
    dynlib: lib, importc: "scramble_323".}
proc check_scramble_323(para1: cstring; message: cstring; salt: int): my_bool {...}{.cdecl,
    dynlib: lib, importc: "check_scramble_323".}
proc get_salt_from_password_323(res: ptr int; password: cstring) {...}{.cdecl, dynlib: lib,
    importc: "get_salt_from_password_323".}
proc make_password_from_salt_323(fto: cstring; salt: ptr int) {...}{.cdecl, dynlib: lib,
    importc: "make_password_from_salt_323".}
proc octet2hex(fto: cstring; str: cstring; length: cuint): cstring {...}{.cdecl, dynlib: lib,
    importc: "octet2hex".}
proc make_scrambled_password(fto: cstring; password: cstring) {...}{.cdecl, dynlib: lib,
    importc: "make_scrambled_password".}
proc scramble(fto: cstring; message: cstring; password: cstring) {...}{.cdecl, dynlib: lib,
    importc: "scramble".}
proc check_scramble(reply: cstring; message: cstring; hash_stage2: pointer): my_bool {...}{.
    cdecl, dynlib: lib, importc: "check_scramble".}
proc get_salt_from_password(res: pointer; password: cstring) {...}{.cdecl, dynlib: lib,
    importc: "get_salt_from_password".}
proc make_password_from_salt(fto: cstring; hash_stage2: pointer) {...}{.cdecl, dynlib: lib,
    importc: "make_password_from_salt".}
proc get_tty_password(opt_message: cstring): cstring {...}{.cdecl, dynlib: lib,
    importc: "get_tty_password".}
proc errno_to_sqlstate(errno: cuint): cstring {...}{.cdecl, dynlib: lib,
    importc: "mysql_errno_to_sqlstate".}
proc modify_defaults_file(file_location: cstring; option: cstring;
                         option_value: cstring; section_name: cstring;
                         remove_option: cint): cint {...}{.cdecl, dynlib: lib,
    importc: "load_defaults".}
proc load_defaults(conf_file: cstring; groups: cstringArray; argc: ptr cint;
                  argv: ptr cstringArray): cint {...}{.cdecl, dynlib: lib,
    importc: "load_defaults".}
proc my_init(): my_bool {...}{.cdecl, dynlib: lib, importc: "my_init".}
proc my_thread_init(): my_bool {...}{.cdecl, dynlib: lib, importc: "my_thread_init".}
proc my_thread_end() {...}{.cdecl, dynlib: lib, importc: "my_thread_end".}
proc server_init(argc: cint; argv: cstringArray; groups: cstringArray): cint {...}{.cdecl,
    dynlib: lib, importc: "mysql_server_init".}
proc server_end() {...}{.cdecl, dynlib: lib, importc: "mysql_server_end".}
proc library_init(argc: cint; argv: cstringArray; groups: cstringArray): cint {...}{.cdecl,
    dynlib: lib, importc: "mysql_server_init".}
proc library_end() {...}{.cdecl, dynlib: lib, importc: "mysql_server_end".}
proc get_parameters(): PPARAMETERS {...}{.stdcall, dynlib: lib,
                                  importc: "mysql_get_parameters".}
proc thread_init(): my_bool {...}{.stdcall, dynlib: lib, importc: "mysql_thread_init".}
proc thread_end() {...}{.stdcall, dynlib: lib, importc: "mysql_thread_end".}
proc num_rows(res: PRES): my_ulonglong {...}{.stdcall, dynlib: lib,
                                     importc: "mysql_num_rows".}
proc num_fields(res: PRES): cuint {...}{.stdcall, dynlib: lib, importc: "mysql_num_fields".}
proc eof(res: PRES): my_bool {...}{.stdcall, dynlib: lib, importc: "mysql_eof".}
proc fetch_field_direct(res: PRES; fieldnr: cuint): PFIELD {...}{.stdcall, dynlib: lib,
    importc: "mysql_fetch_field_direct".}
proc fetch_fields(res: PRES): PFIELD {...}{.stdcall, dynlib: lib,
                                   importc: "mysql_fetch_fields".}
proc row_tell(res: PRES): ROW_OFFSET {...}{.stdcall, dynlib: lib, importc: "mysql_row_tell".}
proc field_tell(res: PRES): FIELD_OFFSET {...}{.stdcall, dynlib: lib,
                                       importc: "mysql_field_tell".}
proc field_count(MySQL: PMySQL): cuint {...}{.stdcall, dynlib: lib,
                                     importc: "mysql_field_count".}
proc affected_rows(MySQL: PMySQL): my_ulonglong {...}{.stdcall, dynlib: lib,
    importc: "mysql_affected_rows".}
proc insert_id(MySQL: PMySQL): my_ulonglong {...}{.stdcall, dynlib: lib,
    importc: "mysql_insert_id".}
proc errno(MySQL: PMySQL): cuint {...}{.stdcall, dynlib: lib, importc: "mysql_errno".}
proc error(MySQL: PMySQL): cstring {...}{.stdcall, dynlib: lib, importc: "mysql_error".}
proc sqlstate(MySQL: PMySQL): cstring {...}{.stdcall, dynlib: lib, importc: "mysql_sqlstate".}
proc warning_count(MySQL: PMySQL): cuint {...}{.stdcall, dynlib: lib,
                                       importc: "mysql_warning_count".}
proc info(MySQL: PMySQL): cstring {...}{.stdcall, dynlib: lib, importc: "mysql_info".}
proc thread_id(MySQL: PMySQL): int {...}{.stdcall, dynlib: lib, importc: "mysql_thread_id".}
proc character_set_name(MySQL: PMySQL): cstring {...}{.stdcall, dynlib: lib,
    importc: "mysql_character_set_name".}
proc set_character_set(MySQL: PMySQL; csname: cstring): int32 {...}{.stdcall, dynlib: lib,
    importc: "mysql_set_character_set".}
proc init(MySQL: PMySQL): PMySQL {...}{.stdcall, dynlib: lib, importc: "mysql_init".}
proc ssl_set(MySQL: PMySQL; key: cstring; cert: cstring; ca: cstring; capath: cstring;
            cipher: cstring): my_bool {...}{.stdcall, dynlib: lib, importc: "mysql_ssl_set".}
proc change_user(MySQL: PMySQL; user: cstring; passwd: cstring; db: cstring): my_bool {...}{.
    stdcall, dynlib: lib, importc: "mysql_change_user".}
proc real_connect(MySQL: PMySQL; host: cstring; user: cstring; passwd: cstring;
                 db: cstring; port: cuint; unix_socket: cstring; clientflag: int): PMySQL {...}{.
    stdcall, dynlib: lib, importc: "mysql_real_connect".}
proc select_db(MySQL: PMySQL; db: cstring): cint {...}{.stdcall, dynlib: lib,
    importc: "mysql_select_db".}
proc query(MySQL: PMySQL; q: cstring): cint {...}{.stdcall, dynlib: lib,
                                        importc: "mysql_query".}
proc send_query(MySQL: PMySQL; q: cstring; len: int): cint {...}{.stdcall, dynlib: lib,
    importc: "mysql_send_query".}
proc real_query(MySQL: PMySQL; q: cstring; len: int): cint {...}{.stdcall, dynlib: lib,
    importc: "mysql_real_query".}
proc store_result(MySQL: PMySQL): PRES {...}{.stdcall, dynlib: lib,
                                     importc: "mysql_store_result".}
proc use_result(MySQL: PMySQL): PRES {...}{.stdcall, dynlib: lib,
                                   importc: "mysql_use_result".}
proc master_query(MySQL: PMySQL; q: cstring; len: int): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_master_query".}
proc master_send_query(MySQL: PMySQL; q: cstring; len: int): my_bool {...}{.stdcall,
    dynlib: lib, importc: "mysql_master_send_query".}
proc slave_query(MySQL: PMySQL; q: cstring; len: int): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_slave_query".}
proc slave_send_query(MySQL: PMySQL; q: cstring; len: int): my_bool {...}{.stdcall,
    dynlib: lib, importc: "mysql_slave_send_query".}
proc get_character_set_info(MySQL: PMySQL; charset: PMY_CHARSET_INFO) {...}{.stdcall,
    dynlib: lib, importc: "mysql_get_character_set_info".}
proc set_local_infile_default(MySQL: PMySQL) {...}{.cdecl, dynlib: lib,
    importc: "mysql_set_local_infile_default".}
proc enable_rpl_parse(MySQL: PMySQL) {...}{.stdcall, dynlib: lib,
                                    importc: "mysql_enable_rpl_parse".}
proc disable_rpl_parse(MySQL: PMySQL) {...}{.stdcall, dynlib: lib,
                                     importc: "mysql_disable_rpl_parse".}
proc rpl_parse_enabled(MySQL: PMySQL): cint {...}{.stdcall, dynlib: lib,
    importc: "mysql_rpl_parse_enabled".}
proc enable_reads_from_master(MySQL: PMySQL) {...}{.stdcall, dynlib: lib,
    importc: "mysql_enable_reads_from_master".}
proc disable_reads_from_master(MySQL: PMySQL) {...}{.stdcall, dynlib: lib,
    importc: "mysql_disable_reads_from_master".}
proc reads_from_master_enabled(MySQL: PMySQL): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_reads_from_master_enabled".}
proc rpl_query_type(q: cstring; length: cint): Rpl_type {...}{.stdcall, dynlib: lib,
    importc: "mysql_rpl_query_type".}
proc rpl_probe(MySQL: PMySQL): my_bool {...}{.stdcall, dynlib: lib,
                                     importc: "mysql_rpl_probe".}
proc set_master(MySQL: PMySQL; host: cstring; port: cuint; user: cstring; passwd: cstring): cint {...}{.
    stdcall, dynlib: lib, importc: "mysql_set_master".}
proc add_slave(MySQL: PMySQL; host: cstring; port: cuint; user: cstring; passwd: cstring): cint {...}{.
    stdcall, dynlib: lib, importc: "mysql_add_slave".}
proc shutdown(MySQL: PMySQL; shutdown_level: Enum_shutdown_level): cint {...}{.stdcall,
    dynlib: lib, importc: "mysql_shutdown".}
proc dump_debug_info(MySQL: PMySQL): cint {...}{.stdcall, dynlib: lib,
                                        importc: "mysql_dump_debug_info".}
proc refresh(sql: PMySQL; refresh_options: cuint): cint {...}{.stdcall, dynlib: lib,
    importc: "mysql_refresh".}
proc kill(MySQL: PMySQL; pid: int): cint {...}{.stdcall, dynlib: lib, importc: "mysql_kill".}
proc set_server_option(MySQL: PMySQL; option: Enum_mysql_set_option): cint {...}{.stdcall,
    dynlib: lib, importc: "mysql_set_server_option".}
proc ping(MySQL: PMySQL): cint {...}{.stdcall, dynlib: lib, importc: "mysql_ping".}
proc stat(MySQL: PMySQL): cstring {...}{.stdcall, dynlib: lib, importc: "mysql_stat".}
proc get_server_info(MySQL: PMySQL): cstring {...}{.stdcall, dynlib: lib,
    importc: "mysql_get_server_info".}
proc get_client_info(): cstring {...}{.stdcall, dynlib: lib,
                               importc: "mysql_get_client_info".}
proc get_client_version(): int {...}{.stdcall, dynlib: lib,
                              importc: "mysql_get_client_version".}
proc get_host_info(MySQL: PMySQL): cstring {...}{.stdcall, dynlib: lib,
    importc: "mysql_get_host_info".}
proc get_server_version(MySQL: PMySQL): int {...}{.stdcall, dynlib: lib,
    importc: "mysql_get_server_version".}
proc get_proto_info(MySQL: PMySQL): cuint {...}{.stdcall, dynlib: lib,
                                        importc: "mysql_get_proto_info".}
proc list_dbs(MySQL: PMySQL; wild: cstring): PRES {...}{.stdcall, dynlib: lib,
    importc: "mysql_list_dbs".}
proc list_tables(MySQL: PMySQL; wild: cstring): PRES {...}{.stdcall, dynlib: lib,
    importc: "mysql_list_tables".}
proc list_processes(MySQL: PMySQL): PRES {...}{.stdcall, dynlib: lib,
                                       importc: "mysql_list_processes".}
proc options(MySQL: PMySQL; option: Option; arg: cstring): cint {...}{.stdcall, dynlib: lib,
    importc: "mysql_options".}
proc free_result(result: PRES) {...}{.stdcall, dynlib: lib, importc: "mysql_free_result".}
proc data_seek(result: PRES; offset: my_ulonglong) {...}{.stdcall, dynlib: lib,
    importc: "mysql_data_seek".}
proc row_seek(result: PRES; offset: ROW_OFFSET): ROW_OFFSET {...}{.stdcall, dynlib: lib,
    importc: "mysql_row_seek".}
proc field_seek(result: PRES; offset: FIELD_OFFSET): FIELD_OFFSET {...}{.stdcall,
    dynlib: lib, importc: "mysql_field_seek".}
proc fetch_row(result: PRES): ROW {...}{.stdcall, dynlib: lib, importc: "mysql_fetch_row".}
proc fetch_lengths(result: PRES): ptr int {...}{.stdcall, dynlib: lib,
                                       importc: "mysql_fetch_lengths".}
proc fetch_field(result: PRES): PFIELD {...}{.stdcall, dynlib: lib,
                                     importc: "mysql_fetch_field".}
proc list_fields(MySQL: PMySQL; table: cstring; wild: cstring): PRES {...}{.stdcall,
    dynlib: lib, importc: "mysql_list_fields".}
proc escape_string(fto: cstring; `from`: cstring; from_length: int): int {...}{.stdcall,
    dynlib: lib, importc: "mysql_escape_string".}
proc hex_string(fto: cstring; `from`: cstring; from_length: int): int {...}{.stdcall,
    dynlib: lib, importc: "mysql_hex_string".}
proc real_escape_string(MySQL: PMySQL; fto: cstring; `from`: cstring; len: int): int {...}{.
    stdcall, dynlib: lib, importc: "mysql_real_escape_string".}
proc debug(debug: cstring) {...}{.stdcall, dynlib: lib, importc: "mysql_debug".}
proc myodbc_remove_escape(MySQL: PMySQL; name: cstring) {...}{.stdcall, dynlib: lib,
    importc: "myodbc_remove_escape".}
proc thread_safe(): cuint {...}{.stdcall, dynlib: lib, importc: "mysql_thread_safe".}
proc embedded(): my_bool {...}{.stdcall, dynlib: lib, importc: "mysql_embedded".}
proc manager_init(con: PMANAGER): PMANAGER {...}{.stdcall, dynlib: lib,
    importc: "mysql_manager_init".}
proc manager_connect(con: PMANAGER; host: cstring; user: cstring; passwd: cstring;
                    port: cuint): PMANAGER {...}{.stdcall, dynlib: lib,
    importc: "mysql_manager_connect".}
proc manager_close(con: PMANAGER) {...}{.stdcall, dynlib: lib,
                                 importc: "mysql_manager_close".}
proc manager_command(con: PMANAGER; cmd: cstring; cmd_len: cint): cint {...}{.stdcall,
    dynlib: lib, importc: "mysql_manager_command".}
proc manager_fetch_line(con: PMANAGER; res_buf: cstring; res_buf_size: cint): cint {...}{.
    stdcall, dynlib: lib, importc: "mysql_manager_fetch_line".}
proc read_query_result(MySQL: PMySQL): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_read_query_result".}
proc stmt_init(MySQL: PMySQL): PSTMT {...}{.stdcall, dynlib: lib, importc: "mysql_stmt_init".}
proc stmt_prepare(stmt: PSTMT; query: cstring; len: int): cint {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_prepare".}
proc stmt_execute(stmt: PSTMT): cint {...}{.stdcall, dynlib: lib,
                                   importc: "mysql_stmt_execute".}
proc stmt_fetch(stmt: PSTMT): cint {...}{.stdcall, dynlib: lib, importc: "mysql_stmt_fetch".}
proc stmt_fetch_column(stmt: PSTMT; `bind`: PBIND; column: cuint; offset: int): cint {...}{.
    stdcall, dynlib: lib, importc: "mysql_stmt_fetch_column".}
proc stmt_store_result(stmt: PSTMT): cint {...}{.stdcall, dynlib: lib,
                                        importc: "mysql_stmt_store_result".}
proc stmt_param_count(stmt: PSTMT): int {...}{.stdcall, dynlib: lib,
                                      importc: "mysql_stmt_param_count".}
proc stmt_attr_set(stmt: PSTMT; attr_type: Enum_stmt_attr_type; attr: pointer): my_bool {...}{.
    stdcall, dynlib: lib, importc: "mysql_stmt_attr_set".}
proc stmt_attr_get(stmt: PSTMT; attr_type: Enum_stmt_attr_type; attr: pointer): my_bool {...}{.
    stdcall, dynlib: lib, importc: "mysql_stmt_attr_get".}
proc stmt_bind_param(stmt: PSTMT; bnd: PBIND): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_bind_param".}
proc stmt_bind_result(stmt: PSTMT; bnd: PBIND): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_bind_result".}
proc stmt_close(stmt: PSTMT): my_bool {...}{.stdcall, dynlib: lib,
                                    importc: "mysql_stmt_close".}
proc stmt_reset(stmt: PSTMT): my_bool {...}{.stdcall, dynlib: lib,
                                    importc: "mysql_stmt_reset".}
proc stmt_free_result(stmt: PSTMT): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_free_result".}
proc stmt_send_long_data(stmt: PSTMT; param_number: cuint; data: cstring; len: int): my_bool {...}{.
    stdcall, dynlib: lib, importc: "mysql_stmt_send_long_data".}
proc stmt_result_metadata(stmt: PSTMT): PRES {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_result_metadata".}
proc stmt_param_metadata(stmt: PSTMT): PRES {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_param_metadata".}
proc stmt_errno(stmt: PSTMT): cuint {...}{.stdcall, dynlib: lib, importc: "mysql_stmt_errno".}
proc stmt_error(stmt: PSTMT): cstring {...}{.stdcall, dynlib: lib,
                                    importc: "mysql_stmt_error".}
proc stmt_sqlstate(stmt: PSTMT): cstring {...}{.stdcall, dynlib: lib,
                                       importc: "mysql_stmt_sqlstate".}
proc stmt_row_seek(stmt: PSTMT; offset: ROW_OFFSET): ROW_OFFSET {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_row_seek".}
proc stmt_row_tell(stmt: PSTMT): ROW_OFFSET {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_row_tell".}
proc stmt_data_seek(stmt: PSTMT; offset: my_ulonglong) {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_data_seek".}
proc stmt_num_rows(stmt: PSTMT): my_ulonglong {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_num_rows".}
proc stmt_affected_rows(stmt: PSTMT): my_ulonglong {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_affected_rows".}
proc stmt_insert_id(stmt: PSTMT): my_ulonglong {...}{.stdcall, dynlib: lib,
    importc: "mysql_stmt_insert_id".}
proc stmt_field_count(stmt: PSTMT): cuint {...}{.stdcall, dynlib: lib,
                                        importc: "mysql_stmt_field_count".}
proc commit(MySQL: PMySQL): my_bool {...}{.stdcall, dynlib: lib, importc: "mysql_commit".}
proc rollback(MySQL: PMySQL): my_bool {...}{.stdcall, dynlib: lib, importc: "mysql_rollback".}
proc autocommit(MySQL: PMySQL; auto_mode: my_bool): my_bool {...}{.stdcall, dynlib: lib,
    importc: "mysql_autocommit".}
proc more_results(MySQL: PMySQL): my_bool {...}{.stdcall, dynlib: lib,
                                        importc: "mysql_more_results".}
proc next_result(MySQL: PMySQL): cint {...}{.stdcall, dynlib: lib,
                                    importc: "mysql_next_result".}
proc close(sock: PMySQL) {...}{.stdcall, dynlib: lib, importc: "mysql_close".}
proc net_safe_read(MySQL: PMySQL): cuint {...}{.cdecl, dynlib: lib, importc: "net_safe_read".}
proc IS_PRI_KEY(n: int32): bool {...}{.raises: [], tags: [].}
unequals operator. This is a shorthand for not (x == y).
proc IS_NOT_NULL(n: int32): bool {...}{.raises: [], tags: [].}
unequals operator. This is a shorthand for not (x == y).
proc IS_BLOB(n: int32): bool {...}{.raises: [], tags: [].}
unequals operator. This is a shorthand for not (x == y).
proc IS_NUM_FIELD(f: Pst_mysql_field): bool {...}{.raises: [], tags: [].}
unequals operator. This is a shorthand for not (x == y).
proc IS_NUM(t: Enum_field_types): bool {...}{.raises: [], tags: [].}
proc INTERNAL_NUM_FIELD(f: Pst_mysql_field): bool {...}{.raises: [], tags: [].}
unequals operator. This is a shorthand for not (x == y).
proc reload(x: PMySQL): cint {...}{.raises: [], tags: [].}

© 2006–2018 Andreas Rumpf
Licensed under the MIT License.
https://nim-lang.org/docs/mysql.html