reset-database.py

#!/usr/bin/python
from libs.db_sqlite import SqliteDatabase

if __name__ == '__main__':
  db = SqliteDatabase()

  #
  # songs table

  db.query("DROP TABLE IF EXISTS songs;")
  print('removed db.songs');

  db.query("""
    CREATE TABLE songs (
      id  INTEGER PRIMARY KEY AUTOINCREMENT,
      name  TEXT,
      filehash  TEXT
    );
  """)
  print('created db.songs');

  #
  # fingerprints table

  db.query("DROP TABLE IF EXISTS fingerprints;")
  print('removed db.fingerprints');

  db.query("""
    CREATE TABLE `fingerprints` (
      `id`  INTEGER PRIMARY KEY AUTOINCREMENT,
      `song_fk` INTEGER,
      `hash`  TEXT,
      `offset`  INTEGER
    );
  """)
  print('created db.fingerprints');

  print('done');