Fred Z
80ace05a4a
Adds the first PyMySQL to DB interaction
2018-07-26 19:42:11 +02:00
Fred Z
1e290aa3c4
Adds PyMSQL dependences, to query DB #4
2018-07-26 19:01:29 +02:00
Fred Z
f3421e3a08
Adds MySQL script to create local DB. #2:done
...
Renames legacy script with DB name
2018-07-26 19:00:10 +02:00
Fred Z
1c3ca10bbc
Adds 'get_category()' function with doctests #4
2018-07-26 15:42:57 +02:00
Fred Z
9757078975
Adds 'code' field & renames product variables #4
2018-07-26 00:20:33 +02:00
Fred Z
82bc0f2c32
Updates get_product() to pass tests #4
2018-07-25 23:24:35 +02:00
Fred Z
2af8ad4a97
Adds get_product() tests #4
...
- 'id' field may not be filled for all products
- adds test for code product unavaiable
- adds test for code product as a string
2018-07-25 21:09:12 +02:00
Fred Z
ea26876509
Writes code for function get_product() #4
2018-07-24 22:39:36 +02:00
Fred Z
a4faa0631d
Writes tests for 1st API access: get_product() #4
2018-07-24 22:39:36 +02:00
Fred Z
cd90df1db1
Adds requirements.txt (requests) #4
2018-07-24 22:39:36 +02:00
Fred Z
92a3f2b8d7
Adds Physical Data Model #2 & creates doc folder
...
Updates README (URL's links), move docs files in new doc folder
2018-07-24 22:37:36 +02:00
Fred Z
650fc334ca
Acts the roadmap fork #09
2018-07-24 00:55:53 +02:00
Fred Z
774ff877e2
Archives legacy SQL files #10
...
Using the CSV file is now out of scope, keep the SQL scripts for memories.
That was nice to play with a 1.7go CSV file & MariaDB.
2018-07-24 00:44:21 +02:00
Fred Z
5a2a97a873
Adjuts field type to not loosing data #2
2018-07-23 17:47:15 +02:00
Fred Z
6b6e03fce3
Syncs fields between documentation and script #2
2018-07-23 17:46:36 +02:00
Fred Z
e17fbb8530
Improves documentation
2018-07-23 01:59:38 +02:00
Fred Z
f1c2bd9627
Deletes useless file
2018-07-23 01:23:38 +02:00
Fred Z
4b53e09bc6
Changes the 'Étapes' checklist to an ordonate list
2018-07-23 01:22:28 +02:00
Fred Z
12e25e31b0
Deletes requirements.txt due to wrong configuration
2018-07-23 01:17:26 +02:00
Fred Z
b698d3cc75
Imports & reduces data to a mono-table MySQL DB #2
...
`sample.csv` is a small test-file based on the HUDGE OpenFF CSV file :
head --lines=100 fr.openfoodfacts.org.products.csv > sample.csv
tail --lines=100 fr.openfoodfacts.org.products.csv >> sample.csv
Script keep :
- `'countries_fr':'France'` tagged rows
- selected fields (see documentation)
2018-07-22 23:59:36 +02:00
Fred Z
ab4a9f0cd7
Changes kept field list
2018-07-22 23:58:59 +02:00
Fred Z
abc1a23d9b
Ignores HUDGE OpenFF CSV file
2018-07-22 23:58:08 +02:00
Fred Z
b409a15b1b
Adds dependences
2018-07-22 16:03:21 +02:00
Fred Z
8c0ab3c30f
Choose the needed fields #1
2018-07-22 15:41:23 +02:00
Fred Z
f441643a11
Edits documentation to drives the develloppement
2018-07-21 21:10:13 +02:00
Fred Z
2c3ce870a1
Presents the basis of the projects
2018-07-21 21:08:23 +02:00
Fred Z
5d03603fe8
Adds files skeleton
2018-07-17 19:03:28 +02:00
Fred Z
6d6ac77723
Edits README.md for the 1st time
2018-07-17 19:02:42 +02:00
Fred Z
cec26cfafe
Initial commit
2018-07-17 17:00:12 +02:00