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)