<commit_before>CREATE TABLE IF NOT EXISTS personne (
  id INTEGER PRIMARY KEY ASC,
  nom TEXT,
  prenom TEXT,
  date_naissance TEXT
);

<commit_msg>correction premiere partie<commit_after>CREATE TABLE IF NOT EXISTS personne (
  id INTEGER PRIMARY KEY ASC,
  nom TEXT,
  prenom TEXT,
  date_naissance TEXT
);

CREATE TABLE IF NOT EXISTS adresse (
  id INTEGER PRIMARY KEY ASC,
  personne_id INTEGER,
  label TEXT,
  ville TEXT,
  code_postal INT
);


INSERT INTO personne (id, nom, prenom, date_naissance) VALUES (NULL , 'Guichon', 'Paul', NULL );
INSERT INTO adresse (id, personne_id, label, ville, code_postal) VALUES
  (NULL, 1, '2 rue de la liberté', 'st denie', '93500');

INSERT INTO adresse (id, personne_id, label, ville, code_postal) VALUES
  (NULL, 1, '5 rue de la contrainte', 'Paris', '75016');

SELECT * FROM adresse;
{'fraction_non_alphanumeric': 0.09650180940892641, 'fraction_numerical': 0.016887816646562123, 'mean_word_length': 4.4605263157894735, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7668319', 'n_tokens_mistral': 310, 'n_tokens_neox': 280, 'n_words': 107}