def test_history_export():
# db_path = "/Users/nsetzer/Music/Library/yue.db"
db_path = "D:\\Dropbox\\ConsolePlayer\\yue.db"
sqlstore = SQLStore(db_path)
History.init(sqlstore)
ts = int((datetime.datetime.now() - datetime.timedelta(28)).timestamp())
rule = AndSearchRule([
ExactSearchRule("column", "playtime"),
GreaterThanEqualSearchRule("date", ts, type_=int)
])
# get all records in the local database
records = History.instance().export(rule)
print(records)
def _connect():
# db_path = "/Users/nsetzer/Music/Library/yue.db"
db_path = "D:\\Dropbox\\ConsolePlayer\\yue.db"
sqlstore = SQLStore(db_path)
History.init(sqlstore)
Library.init(sqlstore)
username = "******"
apikey = "f45596be-5355-4cef-bd00-fb63f872b140"
songs = Library.instance().search("beast")
song = songs[0]
api = ApiClient("http://localhost:4200")
user = api.login("admin", "admin")
print(user)
api.setApiUser(username)
api.setApiKey(user['apikey'])
apiw = ApiClientWrapper(api)
songs = apiw.connect()
return songs, api, apiw