Python run_data_cmd Examples

Example #1

File: csv_parser_airodump.py Project: sburnett/bismark

def check_devid(devid,tables):
  tab = tables['userdevice']
  cmd = 'select * from %s where deviceid="%s" and end is NULL'%(tab,devid)
  res = sql.run_data_cmd(cmd)
  if len(res) == 0:
    return False
  return True

Example #2

File: events_parser.py Project: Vertikar/bismark

def get_eventsarr():
  events= {}
  cmd = 'select eventid,event from EVENTS'
  res = sql.run_data_cmd(cmd)
  for rec in res:
    events[rec[1]] = rec[0]
  return events

Example #3

File: csv_parser_airodump.py Project: projectbismark/bismark

def check_devid(devid, tables):
    tab = tables["userdevice"]
    cmd = 'select * from %s where deviceid="%s" and end is NULL' % (tab, devid)
    res = sql.run_data_cmd(cmd)
    if len(res) == 0:
        return False
    return True

Example #4

File: xml_parse.py Project: sburnett/bismark

def get_id_from_table(table, did, ts):
    cmd = 'SELECT id from ' + table + ' where '
    cmd += 'deviceid = "' + did + '" and timestamp = ' + ts
    res = sql.run_data_cmd(cmd)
    return str(res[0][0])

Example #5

File: xml_parse.py Project: c3rdparty/bismark

def get_id_from_table(table,did,ts):
  cmd = 'SELECT id from ' + table + ' where '
  cmd += 'deviceid = "' + did + '" and timestamp = ' + ts
  res = sql.run_data_cmd(cmd)
  return str(res[0][0])