# Procédures d'import

## Import des niveaux des étudiants
fichier CSV : utclogin;level

```
DELETE FROM student;
\copy student FROM '/tmp/students.csv' DELIMITER ';'
```

## Sync de la base de prod avec la base locale (pour tests)
su postgres
psql

```
\c postgres
DROP DATABASE apisub;
CREATE DATABASE apisub WITH OWNER apisub;
\c apisub
BEGIN;
\i /home/stc/Bureau/apisub20181213.sql
SELECT pg_catalog.set_config('search_path', 'public', false);
COMMIT;
```

## Manual INSERT of Api

INSERT INTO api (id,dbegin,code,name,description,duration,size,ects,resplogin) VALUES (
gen_random_uuid(),
TO_DATE('01/01/2020','DD/MM/YYYY'),
code,
'title',
'longtitle',
duration,
size,
ects,
'login'
);