Want to make a better, stats for the app?

[H3T-Shah]

I currently made a script for playback time.
Made it using the backup database sql
Though I'm not sure if I'm able to help in the development, cause limitness due to my hadware and academics.
Still if you need ideas, Sure!

[25huizengek1]

Thank you for the script. While it doesn't work like intended because of the weird issues that could arise with writing files using print, I get the point of it. I guess I could add a total playtime stat somewhere?

[H3T-Shah]

I clearly get it, using print statement is not the best idea but I wanted something as fast as possible, so just slapped in the easiest way to make the script.
If you add total playtime stat, that's appreciated!
You can just ignore this script, cause I'm thinking to re-write the whole script in Java or Kotlin, and making a whole new project.

I thing I need to ask for is, add information of what time the database was exported, like what you did for 'likedat' table, it was an UTC.
That's useful for what I'm thinking for the new project.
THANKS!

[25huizengek1]

@H3T-Shah I guess you could simplify:

def main():
    db = sqlite3.connect(sys.argv[1])
    cursor = db.cursor()

    cursor.execute("SELECT SUM(totalPlayTimeMs) FROM Song")
    millis = cursor.fetchone()[0]
    minutes = millis // 60000
    print(f"{minutes // 60} hours and {minutes % 60} minutes played")

    cursor.close()
    db.close()

[H3T-Shah]

OMG. I highly appreciate this! Thank You!
Still a long way to go 😅

Well, I can argue that I don't know SQL 😜