import pytest from src.database import ActorsSql from src import openJson # Comnnection Database config = openJson("config/config.json") # Database values : dbValues = openJson("config/dbValues.json") numberOfActors = dbValues["numberOfActors"] @pytest.mark.actors def test_actors(): db = ActorsSql(**config) actors = [("toto", "junior"), ("ta", "pator"), ("gfsfgdf", "pator"), ("", "final robert Carlos")] lenAllActors = len(db.selectActors()) db.insertActor(actors[0]) db.insertActors(actors[1:-1]) db.insertActorFullName(actors[-1][1]) lenAllActorsInsert = len(db.selectActors()) assert lenAllActorsInsert == lenAllActors + len(actors) selectByName = db.selectActorByName(actors[0][0], actors[0][1])
import pytest from src.database import GenresSql from src import openJson # Comnnection Database config = openJson("config/config.json") @pytest.mark.genres def test_genreByName(): db = GenresSql(**config) lenAllGenre = len(db.selectGenres()) toto1 = "toto1" # test function insert one genre db.insertGenre(toto1) allGenre = db.selectGenres() assert len(allGenre) == lenAllGenre + 1 # test function select by name res = db.selectGenreByName(toto1) # test function delete by name db.deleteGenreByName("toto1") # test select, FORMAT : [(1, 'Action'), (3, 'Adventure'), (4, 'Drama'), (5, 'Sci-Fi'), (6, 'News'), (7, 'Romance'), ...] allGenre = db.selectGenres()
#! /usr/bin/env python3 # coding: utf-8 from src import openJson from src.addData.moviesController import moviesController import argparse parser = argparse.ArgumentParser() parser.add_argument("-v", "--verbose", help="increase output verbosity", action="store_true") parser.add_argument("-f", "--filePath", help="Json file to add") args = parser.parse_args() if "__main__" == __name__: # load data movies = openJson(args.filePath) # Data ingetion moviesAdder = moviesController() moviesAdder.run(movies)