Function dump_record_activity

instapy/util.py:1460–1527

Dump the record activity data to a local human-readable JSON

(profile_name, logger, logfolder)

def dump_record_activity(profile_name, logger, logfolder):
    """Dump the record activity data to a local human-readable JSON"""

    conn = None

    try:
        # get a DB and start a connection
        db, id = get_database()
        conn = sqlite3.connect(db)

        with conn:
            conn.row_factory = sqlite3.Row
            cur = conn.cursor()

            cur.execute(
                "SELECT * FROM recordActivity WHERE profile_id=:var", {"var": id}
            )
            user_data = cur.fetchall()

        if user_data:
            ordered_user_data = {}
            current_data = {}

            # get the existing data
            filename = "{}recordActivity.json".format(logfolder)
            if os.path.isfile(filename):
                with open(filename) as recordActFile:
                    current_data = json.load(recordActFile)

            # re-order live user data in the required structure
            for hourly_data in user_data:
                hourly_data = tuple(hourly_data)
                day = hourly_data[-1][:10]
                hour = hourly_data[-1][-8:-6]

                if day not in ordered_user_data.keys():
                    ordered_user_data.update({day: {}})

                ordered_user_data[day].update(
                    {
                        hour: {
                            "likes": hourly_data[1],
                            "comments": hourly_data[2],
                            "follows": hourly_data[3],
                            "unfollows": hourly_data[4],
                            "server_calls": hourly_data[5],
                        }
                    }
                )

            # update user data with live data whilst preserving all other
            # data (keys)
            current_data.update({profile_name: ordered_user_data})

            # dump the fresh record data to a local human readable JSON
            with open(filename, "w") as recordActFile:
                json.dump(current_data, recordActFile)