29 lines
539 B
Markdown
29 lines
539 B
Markdown
|
# Fast Fantoir
|
||
|
|
||
|
```
|
||
|
time ./scripts/gen-fantoir.sh FANTOIR0721
|
||
|
Generating fantoir CSV
|
||
|
Finished release [optimized] target(s) in 0.00s
|
||
|
Running `target/release/fast-fantoir FANTOIR0721`
|
||
|
Generating fantoir SQLite DB
|
||
|
DB generated at /home/ninjatrappeur/code-root/git.alternativebit.fr/fast-fantoir/fantoir.sqlite
|
||
|
|
||
|
real 0m13,319s
|
||
|
user 0m9,804s
|
||
|
sys 0m3,458s
|
||
|
```
|
||
|
|
||
|
DB Schema:
|
||
|
|
||
|
```
|
||
|
sqlite> .tables
|
||
|
fantoir
|
||
|
|
||
|
sqlite> .schema fantoir
|
||
|
CREATE TABLE IF NOT EXISTS "fantoir"(
|
||
|
"full_insee" TEXT,
|
||
|
"rivoli_with_key" TEXT,
|
||
|
"libelle" TEXT
|
||
|
);
|
||
|
```
|