|
|
c52bd9ce8c
|
Add labels and title for plot
|
2022-07-08 11:18:46 +02:00 |
|
|
|
9a0c8038f5
|
Add plot function
|
2022-07-08 11:16:45 +02:00 |
|
|
|
b4c922e878
|
Use AVG for graph function, and group by the date
|
2022-07-08 10:54:02 +02:00 |
|
efrei
|
f29a92fcf6
|
Ajout de la fonction avebrage by city graph
|
2022-07-08 10:40:41 +02:00 |
|
|
|
5343bc2389
|
Add manual context manager
|
2022-07-08 10:12:40 +02:00 |
|
|
|
0d68e29cdb
|
Reformat
|
2022-07-07 21:58:06 +02:00 |
|
|
|
c0f3c7cf87
|
Remove last function added from todo
|
2022-07-07 20:58:25 +02:00 |
|
|
|
09ee438cb4
|
Add function for nature mutation count
|
2022-07-07 20:57:37 +02:00 |
|
|
|
474974de8e
|
Add zipcode functions
|
2022-07-07 20:33:33 +02:00 |
|
|
|
c2d1dbfdf3
|
Add functions
|
2022-07-07 20:29:27 +02:00 |
|
|
|
48f75f8661
|
Add query to connector
|
2022-07-07 20:11:18 +02:00 |
|
|
|
0c6ecb2084
|
Remove rule fk_tables
|
2022-07-07 18:28:13 +02:00 |
|
|
|
6660c05375
|
Add mcd png files
|
2022-07-07 18:26:55 +02:00 |
|
|
|
8f9fff8990
|
Remove MACRO_DRAFT table
|
2022-07-07 18:22:14 +02:00 |
|
|
|
b7141411b4
|
Add fk tables
|
2022-07-07 17:56:53 +02:00 |
|
|
|
8a30ef281b
|
Add fk of Voie
|
2022-07-07 17:50:16 +02:00 |
|
|
|
f054f45482
|
Add fk of Mutation
|
2022-07-07 17:45:54 +02:00 |
|
|
|
6e45f19eb8
|
Add fk of Code_postal
|
2022-07-07 17:41:13 +02:00 |
|
|
|
bd7c472078
|
Add fk of Commune
|
2022-07-07 17:30:49 +02:00 |
|
|
|
6df581360d
|
Remove add_foreign_keys script entirely
|
2022-07-07 17:27:56 +02:00 |
|
|
|
bd519d15c8
|
Add fk of Bien when importing, otherwise it won't work
|
2022-07-07 17:27:53 +02:00 |
|
|
|
86db6c7f29
|
Add fk of Adresse when importing, otherwise it won't work
|
2022-07-07 17:27:50 +02:00 |
|
|
|
1e9e573331
|
Add fk of Bien, add id for MACRO_DRAFT, use it when importing data
|
2022-07-07 15:44:23 +02:00 |
|
|
|
1988dd85be
|
Add fk of Adresse
|
2022-07-07 09:01:57 +02:00 |
|
|
|
dad7bf7cda
|
Add pk of Bien
|
2022-07-06 23:50:16 +02:00 |
|
|
|
cbf83d4962
|
Add pk of Mutation
|
2022-07-06 23:42:35 +02:00 |
|
|
|
4ba7d6f87c
|
Add pk of Code_postal
|
2022-07-06 23:35:34 +02:00 |
|
|
|
5bed49ee7f
|
Apply CONCAT to all tables with two values, like Nature
|
2022-07-06 23:20:14 +02:00 |
|
|
|
dd1177bc02
|
Add pk of Nature
|
2022-07-06 22:25:06 +02:00 |
|
|
|
539b301ca0
|
Add pk of Type_local
|
2022-07-06 21:41:20 +02:00 |
|
|
|
bd1e06c571
|
Add pk of Nature_mutation
|
2022-07-06 21:30:08 +02:00 |
|
|
|
9c7a1cb22e
|
Revert "Revert Add INDEX on Departement"
This reverts commit ba92cac024.
|
2022-07-06 21:28:01 +02:00 |
|
|
|
77c26ccf60
|
Move all Table_id columns to the ALTER TABLE sections near their fk
|
2022-07-06 21:16:38 +02:00 |
|
|
|
13695dadbb
|
Add pk of Adresse
|
2022-07-06 21:09:06 +02:00 |
|
|
|
ba92cac024
|
Revert Add INDEX on Departement
This reverts commit bdf961291f
|
2022-07-06 20:54:59 +02:00 |
|
|
|
c0aa7e8093
|
Rename sql scripts to be more descriptive
|
2022-07-06 20:49:10 +02:00 |
|
|
|
bdf961291f
|
Add INDEX on Departement
|
2022-07-06 20:44:20 +02:00 |
|
|
|
c544523f6d
|
Add pk of Voie
|
2022-07-06 20:37:44 +02:00 |
|
|
|
d92041bbe3
|
Add pk of Type_de_voie
|
2022-07-06 20:17:23 +02:00 |
|
|
|
6acfc12562
|
Format ALTER command on one line
|
2022-07-06 20:13:39 +02:00 |
|
|
|
eb6ab1f289
|
Add comments to sql script
|
2022-07-06 20:01:26 +02:00 |
|
|
|
65327e257e
|
Add pk of Commune
|
2022-07-06 15:35:12 +02:00 |
|
|
|
e36727fc53
|
Use sample for tests
|
2022-07-06 12:16:03 +02:00 |
|
|
|
d850787b52
|
Add pk of Departement
|
2022-07-06 00:04:16 +02:00 |
|
|
|
8d9e80965b
|
Split sql script into multiple scripts
|
2022-07-05 21:29:57 +02:00 |
|
|
|
8e6b31b82d
|
Add todo with sql statements
|
2022-07-05 16:55:10 +02:00 |
|
|
|
d40ebab126
|
Add Foreign keys and move data imports to bottom
|
2022-07-05 16:51:29 +02:00 |
|
|
|
c0b39f9ccc
|
Create basic table structure
|
2022-07-05 15:44:36 +02:00 |
|
|
|
f0e39ca29f
|
Use fetchall to return a value when making a query
|
2022-07-05 08:33:53 +02:00 |
|
|
|
eed48d87c5
|
Make verbose option a command line global
|
2022-07-04 22:07:35 +02:00 |
|
