embedded_device_map.py

#!/usr/bin/env python3

# Copyright (c) 2022, Brian A. McKenzie <mckenzba@gmail.com>
#
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions are met:
#
# 1. Redistributions of source code must retain the above copyright notice, this
#    list of conditions and the following disclaimer.
#
# 2. Redistributions in binary form must reproduce the above copyright notice,
#    this list of conditions and the following disclaimer in the documentation
#    and/or other materials provided with the distribution.
#
# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
# AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
# DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
# FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
# DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
# SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
# CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
# OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
# OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

import os
import sys
import sqlite3
import argparse

db_help = 'device map database'
query_help = 'SQL query to run on the database'

def main():
    parser = argparse.ArgumentParser()

    required = parser.add_argument_group('required arguments')
    required.add_argument('-db', type=str, required=True, help=db_help)
    required.add_argument('-query', type=str, required=True, nargs='+', help=query_help)

    args = parser.parse_args()

    db = args.db.replace('\\', '')
    query = ' '.join(args.query).replace('\\', '')

    if not os.path.exists(db):
        print('Invalid database path: %s' % db)
        sys.exit(1)

    conn = sqlite3.connect(db)

    try:
        cursor = conn.execute(query)
    except sqlite3.Error as error:
        print('SQLite3 error: %s' % (' '.join(error.args)))
    else:
        for row in cursor.fetchall():
            print('|'.join(map(str, row)))
    finally:
        conn.close()

if __name__ == "__main__":
    main()