dragonslayerx / codeforcesimporter Goto Github PK

I get some errors, I tried running it using pyhon2.7, python, python2 and python3. output this one is for 2.7

For example all solutions for problems of contest id 600 can be inside a subdirectories named 600 and so on where as the other files (html, css etc.) can be in the main directory.

hey @dragonslayerx
currently we use cfiignore to keep track of submissions that have been already fetched from the CF server.
I got an alternative approach which seems efficient (correct me if i'm wrong) and re-usable for generating visualizations easily!
We can store submissions in an sqlite file!
this sqlite file can act as the table from which we can query to generate the classification html and/or visualization html.
for classification data something like "select * from local_sqlite_table group by problem_type".
for visualization data (say date vs submission count) "select date as submission_date, count(*) as submission_count from local_sqlite_table group by date"

Advantages of this approach:

• Easy to sync
• efficient than writing to a file ourself (since sqlite takes care of this)
• efficient for generating info for visualization (think of the ease of sql "group by" clause vs manipulating list of submissions ourself to generate it programmatically !!!) - sqlite is built for that and we can leverage it!
• cleaner code when we need to generate lot of graphs in visualization (that goes without saying)

Approach for sync:
we can maintain something called 'last-sync-time' .
every time we sync, we can fetch all submissions whose date > last-sync-time

gym contest cannot neither be classified nor their submissions can be imported. add feature to ignore the gym submissions.

For people who rely on codeforces to practice visualizing their submission data would be a great feature to have!
Visualizations can help in

1. motivating the programmer
2. identifying the areas of improvement
3. identifying patterns of time during which he submits successful solutions
4. 1000 more points can be added..

A picture is worth a thousand words..

The API provides enough data so as to be able to save the solutions with proper extension rather than '.txt' files. The user can then run a file them directly rather that having to rename it.