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