About

This plugin holds a eq database

Commands

DB

dbbackup


usage: #bp.eqdb.dbbackup [-h] [name]

backup the database

positional arguments:
  name        the name to backup to

optional arguments:
  -h, --help  show help (default: False)

dbclose


usage: #bp.eqdb.dbclose [-h]

close the database

optional arguments:
  -h, --help  show help (default: False)

dbmodify


usage: #bp.eqdb.dbmodify [-h] [stmt]

run a sql update/insert against the database

positional arguments:
  stmt        the sql statement

optional arguments:
  -h, --help  show help (default: False)

dbremove


usage: #bp.eqdb.dbremove [-h] [table] [rownumber]

remove a row from a table

positional arguments:
  table       the table to remove the row from
  rownumber   the row number to remove (default: -1)

optional arguments:
  -h, --help  show help (default: False)

dbselect


usage: #bp.eqdb.dbselect [-h] [stmt]

run a sql statement against the database

positional arguments:
  stmt        the sql statement

optional arguments:
  -h, --help  show help (default: False)

dbvac


usage: #bp.eqdb.dbvac [-h]

vacuum the database

optional arguments:
  -h, --help  show help (default: False)

eqdb

getitem


usage: #bp.eqdb.getitem [-h] [id]

get item

positional arguments:
  id          the identifier/serial/wearloc

optional arguments:
  -h, --help  show help (default: False)

test


usage: #bp.eqdb.test [-h]

test

optional arguments:
  -h, --help  show help (default: False)

Base

api


usage: #bp.eqdb.api [-h] [api]

list functions in the api

positional arguments:
  api         api to get details of

optional arguments:
  -h, --help  show help (default: False)

help


usage: #bp.eqdb.help [-a] [-c] [-h]

show help info for this plugin

optional arguments:
  -a, --api       show functions this plugin has in the api (default: False)
  -c, --commands  show commands in this plugin (default: False)
  -h, --help      show help (default: False)

inspect


usage: #bp.eqdb.inspect [-m METHOD] [-o OBJECT] [-s] [-h]

inspect a plugin

optional arguments:
  -m METHOD, --method METHOD
                        get code for a method
  -o OBJECT, --object OBJECT
                        show an object of the plugin, can be method or
                        variable
  -s, --simple          show a simple output (default: False)
  -h, --help            show help (default: False)

reset


usage: #bp.eqdb.reset [-h]

reset the plugin

optional arguments:
  -h, --help  show help (default: False)

save


usage: #bp.eqdb.save [-h]

save the plugin state

optional arguments:
  -h, --help  show help (default: False)

set


usage: #bp.eqdb.set [-h] [name] [value]

change a setting in the plugin

if there are no arguments or 'list' is the first argument then
it will list the settings for the plugin

positional arguments:
  name        the setting name (default: list)
  value       the new value of the setting

optional arguments:
  -h, --help  show help (default: False)

stats


usage: #bp.eqdb.stats [-h]

show plugin stats

optional arguments:
  -h, --help  show help (default: False)

Settings

backupstart


the time for a db backup, like 1200 or 2000

backupinterval


the interval to backup the db, default every 4 hours

API

modifymany


eqdb.modifymany(stmt, data)

    update many rows in a database


original defined in plugins/core/sqldb.py

modify


eqdb.modify(stmt, data=None)

    modify the database


original defined in plugins/core/sqldb.py

getrow


eqdb.getrow(rowid, ttable)

    get a row from a table


original defined in plugins/core/sqldb.py

saveitem


eqdb.saveitem(serial)

    save an item to the database


original defined in plugins/aardwolf/eqdb.py

getitem


eqdb.getitem(serial)

    get an item from the database


original defined in plugins/aardwolf/eqdb.py

select


eqdb.select(stmt)

    run a select stmt against the db


original defined in plugins/core/sqldb.py