from app import db, models, views
from datetime import datetime
import shutil

# Delete old database and create a new one
# try:
# 	shutil.rmtree('db_repository')
# 	shutil.rmtree('app.db')
# 	import db_create
# except:
# 	pass

# Add tags
tag_beep = models.Tag(name="beep")
tag_honk = models.Tag(name="honk")
tag_urgent1= models.Tag(name="urgent-1")
tag_urgent2 = models.Tag(name="urgent-2")
tag_urgent3 = models.Tag(name="urgent-3")
tag_urgent4 = models.Tag(name="urgent-4")
tag_looming = models.Tag(name="looming")
tag_spatial= models.Tag(name="spatial")
tag_spoken = models.Tag(name="spoken")
tag_female = models.Tag(name="female")
tag_male = models.Tag(name="male")
tag_short = models.Tag(name="short")
tag_long = models.Tag(name="long")
tag_sharp = models.Tag(name="sharp")
tag_tor = models.Tag(name="take-over request")
tag_fast = models.Tag(name="fast")
tag_precise = models.Tag(name="precise")
tag_unprecise = models.Tag(name="unprecise")
tag_reverb = models.Tag(name="reverb")
tag_volumnious = models.Tag(name="voluminous")
tag_trash = models.Tag(name="trash")
tag_slurred = models.Tag(name="slurred")
tag_nice = models.Tag(name="nice")
tag_positive = models.Tag(name="positive")
tag_negative = models.Tag(name="negative")
tag_wave = models.Tag(name="wave")
tag_acknowledge = models.Tag(name="acknowledge")
tag_playful = models.Tag(name="playful")
tag_fussy = models.Tag(name="fussy")
tag_starting = models.Tag(name="starting")
tag_informative = models.Tag(name="informative")
tag_clear = models.Tag(name="clear")
tag_unclear = models.Tag(name="unclear")
tag_warning = models.Tag(name="warning")
tag_high = models.Tag(name="high")
tag_low = models.Tag(name="low")
tag_metallic = models.Tag(name="metallic")
tag_wooden = models.Tag(name="wooden")
tag_worthy = models.Tag(name="worthy")
tag_popup = models.Tag(name="popup")
tag_shorter = models.Tag(name="shorter")
tag_hard_to_hear = models.Tag(name="hard to hear")
tag_misleading = models.Tag(name="misleading")
tag_neutral = models.Tag(name="neutral")
tag_wrong = models.Tag(name="wrong")
tag_peaceful = models.Tag(name="peaceful")
tag_nervous = models.Tag(name="nervous")
tag_sport = models.Tag(name="sport")
tag_active = models.Tag(name="active")
tag_movement = models.Tag(name="movement")
tag_computer = models.Tag(name="computer")
tag_opening = models.Tag(name="opening")
tag_notification = models.Tag(name="notification")
tag_sudden = models.Tag(name="sudden")
tag_speed = models.Tag(name="speed")
tag_transition = models.Tag(name="transition")
tag_sad = models.Tag(name="sad")
tag_unusual = models.Tag(name="unusual")
tag_on = models.Tag(name="on")
tag_angry = models.Tag(name="angry")
tag_speech = models.Tag(name="speech")
tag_command = models.Tag(name="command")
tag_sound = models.Tag(name="sound")
tag_beat = models.Tag(name="beat")
tag_jarring = models.Tag(name="jarring")
tag_click = models.Tag(name="click")
tag_windows = models.Tag(name="windows")
tag_higher_at_the_end = models.Tag(name="higher at the end")
tag_close = models.Tag(name="close")
tag_attention = models.Tag(name="attention")
tag_calm = models.Tag(name="calm")
tag_sleep = models.Tag(name="sleep")
tag_aggressive = models.Tag(name="aggressive")
tag_knock = models.Tag(name="knock")
tag_information = models.Tag(name="information")
tag_signal = models.Tag(name="signal")
tag_accelerated = models.Tag(name="accelerated")
tag_pushing = models.Tag(name="pushing")
tag_stone = models.Tag(name="stone")
tag_clapping = models.Tag(name="clapping")
tag_high_pitch = models.Tag(name="high pitch")
tag_strike = models.Tag(name="strike")
tag_happy = models.Tag(name="happy")
tag_violin = models.Tag(name="violin")
tag_blinking = models.Tag(name="blinking")
tag_assistent = models.Tag(name="assistent")
tag_old_telephone = models.Tag(name="old telephone")
tag_big_hall = models.Tag(name="big hall")
tag_login = models.Tag(name="login")
tag_logout = models.Tag(name="logout")
tag_welcome = models.Tag(name="welcome")
tag_start_of_OS = models.Tag(name="start of OS")
tag_bright = models.Tag(name="bright")
tag_mystical = models.Tag(name="mystical")
tag_audiobook = models.Tag(name="audiobook")
tag_hello = models.Tag(name="hello")
tag_stop = models.Tag(name="stop")
tag_steps = models.Tag(name="steps")
tag_faster = models.Tag(name="faster")
tag_something_happens = models.Tag(name="something happens")
tag_strange = models.Tag(name="strange")
tag_instrument = models.Tag(name="instrument")
tag_woodpecker = models.Tag(name="woodpecker")
tag_hurry = models.Tag(name="hurry")
tag_crash = models.Tag(name="crash")
tag_need_to_intervene = models.Tag(name="need to intervene")
tag_shutdown = models.Tag(name="shutdown")
tag_traffic_lights = models.Tag(name="traffic lights")
tag_move = models.Tag(name="move")
tag_selection_in_menu = models.Tag(name="selection in menu")
tag_telephone = models.Tag(name="telephone")
tag_shutdown_of_OS = models.Tag(name="shutdown of OS")
tag_danger = models.Tag(name="danger")
tag_threat = models.Tag(name="threat")
tag_approach = models.Tag(name="approach")
tag_be_aware = models.Tag(name="be aware")
tag_patience = models.Tag(name="patience")
tag_dull = models.Tag(name="dull")
tag_dance = models.Tag(name="dance")
tag_jingle = models.Tag(name="jingle")
tag_sunrise = models.Tag(name="sunrise")
tag_insect = models.Tag(name="insect")
tag_light = models.Tag(name="light")
tag_clear = models.Tag(name="clear")
tag_uncertain = models.Tag(name="uncertain")
tag_unsecure = models.Tag(name="unsecure")
tag_secret = models.Tag(name="secret")
tag_complex = models.Tag(name="complex")
tag_affirmative = models.Tag(name="affirmative")
tag_bird = models.Tag(name="bird")
tag_jazz = models.Tag(name="jazz")
tag_pains = models.Tag(name="pains")
tag_winter = models.Tag(name="winter")
tag_nature = models.Tag(name="nature")
tag_water = models.Tag(name="water")
tag_persecution = models.Tag(name="persecution")
tag_underground = models.Tag(name="underground")
tag_future = models.Tag(name="future")
tag_automated = models.Tag(name="automated")
tag_electronic = models.Tag(name="electronic")
tag_synthetic = models.Tag(name="synthetic")
tag_not_human = models.Tag(name="not human")
tag_rhythm = models.Tag(name="rhythm")
tag_classic = models.Tag(name="classic")
tag_accord = models.Tag(name="accord")
tag_dull = models.Tag(name="dull")
tag_drawing = models.Tag(name="drawing")
tag_demanding = models.Tag(name="demanding")
tag_speed = models.Tag(name="speed")
tag_weather = models.Tag(name="weather")
tag_flash = models.Tag(name="flash")
tag_wakeup = models.Tag(name="wakeup")
tag_cold = models.Tag(name="cold")
tag_drum = models.Tag(name="drum")
tag_voice = models.Tag(name="voice")
tag_blaster = models.Tag(name="blaster")
tag_explosion = models.Tag(name="explosion")
tag_low = models.Tag(name="low")
tag_bell = models.Tag(name="bell")
tag_alarm = models.Tag(name="alarm")
tag_horn = models.Tag(name="horn")
tag_piano = models.Tag(name="piano")
tag_bass = models.Tag(name="bass")
tag_pulse = models.Tag(name="pulse")
tag_modern = models.Tag(name="modern")
tag_movie = models.Tag(name="movie")
tag_note = models.Tag(name="note")
tag_blast = models.Tag(name="blast")
tag_critical = models.Tag(name="critical")
tag_directional = models.Tag(name="directional")
tag_lane_switch = models.Tag(name="lane switch")
tag_safe = models.Tag(name="safe")

db.session.add(tag_beep)
db.session.add(tag_honk)
db.session.add(tag_urgent1)
db.session.add(tag_urgent2)
db.session.add(tag_urgent3)
db.session.add(tag_urgent4)
db.session.add(tag_looming)
db.session.add(tag_spatial)
db.session.add(tag_spoken)
db.session.add(tag_female)
db.session.add(tag_male)
db.session.add(tag_short)
db.session.add(tag_long)
db.session.add(tag_tor)
db.session.add(tag_fast)
db.session.add(tag_precise)
db.session.add(tag_unprecise)
db.session.add(tag_reverb)
db.session.add(tag_volumnious)
db.session.add(tag_trash)
db.session.add(tag_slurred)
db.session.add(tag_nice)
db.session.add(tag_positive)
db.session.add(tag_negative)
db.session.add(tag_wave)
db.session.add(tag_acknowledge)
db.session.add(tag_playful)
db.session.add(tag_fussy)
db.session.add(tag_starting)
db.session.add(tag_informative)
db.session.add(tag_clear)
db.session.add(tag_unclear)
db.session.add(tag_warning)
db.session.add(tag_high)
db.session.add(tag_low)
db.session.add(tag_metallic)
db.session.add(tag_popup)
db.session.add(tag_shorter)
db.session.add(tag_hard_to_hear)
db.session.add(tag_misleading)
db.session.add(tag_neutral)
db.session.add(tag_wrong)
db.session.add(tag_worthy)
db.session.add(tag_wooden)
db.session.add(tag_peaceful)
db.session.add(tag_nervous)
db.session.add(tag_sport)
db.session.add(tag_active)
db.session.add(tag_movement)
db.session.add(tag_computer)
db.session.add(tag_opening)
db.session.add(tag_notification)
db.session.add(tag_sudden)
db.session.add(tag_speed)
db.session.add(tag_transition)
db.session.add(tag_sad)
db.session.add(tag_unusual)
db.session.add(tag_on)
db.session.add(tag_angry)
db.session.add(tag_speech)
db.session.add(tag_command)
db.session.add(tag_sound)
db.session.add(tag_beat)
db.session.add(tag_jarring)
db.session.add(tag_click)
db.session.add(tag_windows)
db.session.add(tag_higher_at_the_end)
db.session.add(tag_close)
db.session.add(tag_attention)
db.session.add(tag_calm)
db.session.add(tag_sleep)
db.session.add(tag_aggressive)
db.session.add(tag_knock)
db.session.add(tag_information)
db.session.add(tag_signal)
db.session.add(tag_accelerated)
db.session.add(tag_pushing)
db.session.add(tag_stone)
db.session.add(tag_clapping)
db.session.add(tag_high_pitch)
db.session.add(tag_strike)
db.session.add(tag_happy)
db.session.add(tag_violin)
db.session.add(tag_blinking)
db.session.add(tag_assistent)
db.session.add(tag_old_telephone)
db.session.add(tag_big_hall)
db.session.add(tag_login)
db.session.add(tag_logout)
db.session.add(tag_welcome)
db.session.add(tag_start_of_OS)
db.session.add(tag_bright)
db.session.add(tag_mystical)
db.session.add(tag_audiobook)
db.session.add(tag_hello)
db.session.add(tag_stop)
db.session.add(tag_steps)
db.session.add(tag_faster)
db.session.add(tag_something_happens)
db.session.add(tag_strange)
db.session.add(tag_woodpecker)
db.session.add(tag_instrument)
db.session.add(tag_hurry)
db.session.add(tag_crash)
db.session.add(tag_need_to_intervene)
db.session.add(tag_shutdown)
db.session.add(tag_traffic_lights)
db.session.add(tag_move)
db.session.add(tag_selection_in_menu)
db.session.add(tag_telephone)
db.session.add(tag_shutdown_of_OS)
db.session.add(tag_danger)
db.session.add(tag_threat)
db.session.add(tag_approach)
db.session.add(tag_be_aware)
db.session.add(tag_patience)
db.session.add(tag_dull)
db.session.add(tag_dance)
db.session.add(tag_jingle)
db.session.add(tag_sunrise)
db.session.add(tag_light)
db.session.add(tag_clear)
db.session.add(tag_uncertain)
db.session.add(tag_unsecure)
db.session.add(tag_secret)
db.session.add(tag_complex)
db.session.add(tag_affirmative)
db.session.add(tag_bird)
db.session.add(tag_jazz)
db.session.add(tag_pains)
db.session.add(tag_winter)
db.session.add(tag_nature)
db.session.add(tag_water)
db.session.add(tag_persecution)
db.session.add(tag_underground)
db.session.add(tag_future)
db.session.add(tag_automated)
db.session.add(tag_electronic)
db.session.add(tag_synthetic)
db.session.add(tag_not_human)
db.session.add(tag_rhythm)
db.session.add(tag_classic)
db.session.add(tag_accord)
db.session.add(tag_dull)
db.session.add(tag_drawing)
db.session.add(tag_demanding)
db.session.add(tag_speed)
db.session.add(tag_weather)
db.session.add(tag_flash)
db.session.add(tag_wakeup)
db.session.add(tag_cold)
db.session.add(tag_drum)
db.session.add(tag_voice)
db.session.add(tag_blaster)
db.session.add(tag_explosion)
db.session.add(tag_low)
db.session.add(tag_bell)
db.session.add(tag_alarm)
db.session.add(tag_horn)
db.session.add(tag_piano)
db.session.add(tag_bass)
db.session.add(tag_pulse)
db.session.add(tag_modern)
db.session.add(tag_movie)
db.session.add(tag_note)
db.session.add(tag_blast)
db.session.add(tag_critical)
db.session.add(tag_directional)
db.session.add(tag_lane_switch)
db.session.add(tag_safe)

db.session.commit()

# Add custom sounds
sound_beep_freezman = models.Sound(name="Beep freezman",
			filename="153213__freezeman__beep1.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_beep_freezman.tag_add(tag_beep)
sound_beep_freezman.tag_add(tag_urgent2)
sound_beep_freezman.tag_add(tag_long)
sound_beep_freezman.tag_add(tag_worthy)
db.session.add(sound_beep_freezman)

sound_beep_greencouch = models.Sound(name="Water beep",
			filename="124905__greencouch__beeps-5.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_beep_greencouch.tag_add(tag_water)
sound_beep_greencouch.tag_add(tag_urgent1)
db.session.add(sound_beep_greencouch)

sound_beep_alaskarobotics = models.Sound(name="2000 Hz beeps",
			filename="221086__alaskarobotics__2000-hz-beeps.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_beep_alaskarobotics.tag_add(tag_urgent3)
sound_beep_alaskarobotics.tag_add(tag_beep)
db.session.add(sound_beep_alaskarobotics)

sound_beep_five_beeps = models.Sound(name="Five beeps",
			filename="246332__kwahmah-02__five-beeps.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_beep_five_beeps.tag_add(tag_beep)
sound_beep_five_beeps.tag_add(tag_urgent3)
sound_beep_five_beeps.tag_add(tag_short)
db.session.add(sound_beep_five_beeps)

sound_beep_train_door = models.Sound(name="Train door beep",
			filename="346572__inspectorj__train-door-beep-b.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_beep_train_door.tag_add(tag_beep)
sound_beep_train_door.tag_add(tag_urgent2)
sound_beep_train_door.tag_add(tag_long)
db.session.add(sound_beep_train_door)

sound_drum_tom = models.Sound(name="Drum",
			filename="261449__veiler__dw-tom-1.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_drum_tom.tag_add(tag_drum)
sound_drum_tom.tag_add(tag_short)
db.session.add(sound_drum_tom)

sound_rising_voice = models.Sound(name="Rising voice",
			filename="262688__iut-paris8__paget-ludovic-2014-2015-skype-connection-sound.wav",
			rights="CC Attribution License")
sound_rising_voice.tag_add(tag_looming)
sound_rising_voice.tag_add(tag_voice)
db.session.add(sound_rising_voice)

sound_explosion_1 = models.Sound(name="Blaster explosion",
			filename="320366__n-audioman__explosion3.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_explosion_1.tag_add(tag_blaster)
sound_explosion_1.tag_add(tag_explosion)
db.session.add(sound_explosion_1)

sound_rising_tone = models.Sound(name="Rising tone",
			filename="221552__greenrover__rising-tone.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_rising_tone.tag_add(tag_looming)
sound_rising_tone.tag_add(tag_urgent3)
sound_rising_tone.tag_add(tag_short)
db.session.add(sound_rising_tone)

sound_russian_clement = models.Sound(name="Russian clement",
			filename="166663__univ-lyon3__raussin-clement-2012-13-son3.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_russian_clement.tag_add(tag_looming)
sound_russian_clement.tag_add(tag_short)
db.session.add(sound_russian_clement)

sound_blast = models.Sound(name="Blast",
			filename="110564__2887679652__emp-blast.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_blast.tag_add(tag_low)
sound_blast.tag_add(tag_blast)
db.session.add(sound_blast)

sound_drop = models.Sound(name="Drop",
			filename="106717__nikolino__knall9-1zu8.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_drop.tag_add(tag_explosion)
sound_drop.tag_add(tag_short)
db.session.add(sound_drop)

sound_alarm_peep = models.Sound(name="Alarm peep",
			filename="126519__ycdmdj__alarm-peep.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_alarm_peep.tag_add(tag_bell)
sound_alarm_peep.tag_add(tag_alarm)
db.session.add(sound_alarm_peep)

sound_multiple_pulses = models.Sound(name="Multiple pulses",
			filename="18504__saternolia__h-01.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_multiple_pulses.tag_add(tag_long)
sound_multiple_pulses.tag_add(tag_instrument)
sound_multiple_pulses.tag_add(tag_urgent3)
sound_multiple_pulses.tag_add(tag_danger)
db.session.add(sound_multiple_pulses)

sound_hunting_horn = models.Sound(name="Hunting horn",
			filename="72753__benboncan__hunting-horn.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_hunting_horn.tag_add(tag_horn)
sound_hunting_horn.tag_add(tag_danger)
db.session.add(sound_hunting_horn)

sound_fog_horn = models.Sound(name="Fog horn",
			filename="324275__reznik-krkovicka__horn-02.mp3",
			rights="CC Attribution License",
			sound_type="1")
sound_fog_horn.tag_add(tag_horn)
sound_fog_horn.tag_add(tag_danger)
sound_fog_horn.tag_add(tag_urgent4)
db.session.add(sound_fog_horn)

sound_urgent_impact = models.Sound(name="Urgent impact",
			filename="223017__speedenza__urgent-impacts-5.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_urgent_impact.tag_add(tag_urgent2)
sound_urgent_impact.tag_add(tag_short)
db.session.add(sound_urgent_impact)

sound_speed_alarm = models.Sound(name="Speed alarm",
			filename="24236__soundhead__speed-alarm.wav",
			rights="CC Attribution License")
sound_speed_alarm.tag_add(tag_alarm)
sound_speed_alarm.tag_add(tag_fast)
sound_speed_alarm.tag_add(tag_urgent4)
db.session.add(sound_speed_alarm)

sound_power_down = models.Sound(name="Power down",
			filename="34203__themfish__power-down.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_power_down.tag_add(tag_looming)
sound_power_down.tag_add(tag_urgent1)
db.session.add(sound_power_down)

sound_scary_piano = models.Sound(name="Scary piano",
			filename="170593__timpan__scary-piano.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_scary_piano.tag_add(tag_instrument)
sound_scary_piano.tag_add(tag_piano)
sound_scary_piano.tag_add(tag_mystical)
db.session.add(sound_scary_piano)

sound_saarde = models.Sound(name="Saarde",
			filename="330637__troym1__saarde.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_saarde.tag_add(tag_complex)
sound_saarde.tag_add(tag_instrument)
db.session.add(sound_saarde)

sound_wobble_bass = models.Sound(name="Wobble bass",
			filename="51254__rutgermuller__wobble-bass-test.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_wobble_bass.tag_add(tag_bass)
sound_wobble_bass.tag_add(tag_pulse)
db.session.add(sound_wobble_bass)

sound_dnb_kick = models.Sound(name="DNB kick",
			filename="41155__sandyrb__dnb-kick-008.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_dnb_kick.tag_add(tag_short)
sound_dnb_kick.tag_add(tag_urgent1)
sound_dnb_kick.tag_add(tag_modern)
db.session.add(sound_dnb_kick)

sound_cold3 = models.Sound(name="Cold 3",
			filename="48456__flick3r__cold-3.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_cold3.tag_add(tag_complex)
sound_cold3.tag_add(tag_electronic)
sound_cold3.tag_add(tag_modern)
db.session.add(sound_cold3)

sound_dun_dun_dun = models.Sound(name="Dun dun dun",
			filename="45654__simon-lacelle__dun-dun-dun.wav",
			rights="CC Attribution License",
			sound_type="1")
sound_dun_dun_dun.tag_add(tag_movie)
sound_dun_dun_dun.tag_add(tag_urgent2)
db.session.add(sound_dun_dun_dun)

sound_Ash3 = models.Sound(name="A#3",
			filename="203502__tesabob2001__a-3.mp3",
			rights="CC Attribution License",
			sound_type="1")
sound_Ash3.tag_add(tag_note)
db.session.add(sound_Ash3)

sound_G3 = models.Sound(name="G3",
			filename="203493__tesabob2001__g3.mp3",
			rights="CC Attribution License",
			sound_type="1")
sound_G3.tag_add(tag_note)
db.session.add(sound_G3)

sound_G5 = models.Sound(name="G5",
			filename="203490__tesabob2001__g-5.mp3",
			rights="CC Attribution License")
sound_G5.tag_add(tag_note)
db.session.add(sound_G5)

sound_G4 = models.Sound(name="G4",
			filename="203492__tesabob2001__g4.mp3",
			rights="CC Attribution License",
			sound_type="1")
sound_G4.tag_add(tag_note)
db.session.add(sound_G4)

sound_G5 = models.Sound(name="G5",
			filename="203495__tesabob2001__g5.mp3",
			rights="CC Attribution License",
			sound_type="1")
sound_G5.tag_add(tag_note)
db.session.add(sound_G5)

sound_F3 = models.Sound(name="F3",
			filename="203501__tesabob2001__f-3.mp3",
			rights="CC Attribution License",
			sound_type="1")
sound_F3.tag_add(tag_note)
db.session.add(sound_F3)

# Add sounds from projects
sound_a1 = models.Sound(name="A_1",
			filename="A_1.wav",
			sound_type="2")
sound_a1.tag_add(tag_speech)
sound_a1.tag_add(tag_female)
sound_a1.tag_add(tag_urgent1)
sound_a1.tag_add(tag_command)
sound_a11 = models.Sound(name="A_11",
			filename="A_11.wav",
			sound_type="1")
sound_a11.tag_add(tag_short)
sound_a11.tag_add(tag_beep)
sound_a11.tag_add(tag_sound)
sound_a11.tag_add(tag_violin)
sound_a11.tag_add(tag_danger)
sound_a11.tag_add(tag_threat)
sound_a18 = models.Sound(name="A_18",
			filename="A_18.wav",
			sound_type="1")
sound_a18.tag_add(tag_beat)
sound_a18.tag_add(tag_metallic)
sound_a18.tag_add(tag_long)
sound_a18.tag_add(tag_blinking)
sound_a18.tag_add(tag_traffic_lights)
sound_a18.tag_add(tag_assistent)
sound_a18.tag_add(tag_approach)
sound_a23 = models.Sound(name="A_23",
			filename="A_23.wav",
			sound_type="1")
sound_a23.tag_add(tag_beep)
sound_a23.tag_add(tag_jarring)
sound_a23.tag_add(tag_short)
sound_a23.tag_add(tag_old_telephone)
sound_a23.tag_add(tag_metallic)
sound_a23.tag_add(tag_cold)
sound_a23.tag_add(tag_big_hall)
sound_a23.tag_add(tag_telephone)
sound_a23.tag_add(tag_be_aware)
sound_a7 = models.Sound(name="A_7",
			filename="A_7.wav",
			sound_type="1")
sound_a7.tag_add(tag_short)
sound_a7.tag_add(tag_beep)
sound_a7.tag_add(tag_click)
sound_a7.tag_add(tag_windows)
sound_a7.tag_add(tag_login)
sound_a7.tag_add(tag_logout)
sound_a7.tag_add(tag_patience)
sound_a7.tag_add(tag_dull)
sound_a7.tag_add(tag_dance)
sound_a8 = models.Sound(name="A_8",
			filename="A_8.wav",
			sound_type="1")
sound_a8.tag_add(tag_higher_at_the_end)
sound_a8.tag_add(tag_hello)
sound_a8.tag_add(tag_welcome)
sound_a8.tag_add(tag_start_of_OS)
sound_a8.tag_add(tag_jingle)
sound_a8.tag_add(tag_sunrise)
sound_ad_deactivation = models.Sound(name="AD Deactivation",
			filename="AD_Deactivation.wav",
			sound_type="1",
			sound_family="2")
sound_ad_deactivation.tag_add(tag_short)
sound_ad_deactivation.tag_add(tag_close)
sound_ad_deactivation.tag_add(tag_login)
sound_ad_deactivation.tag_add(tag_logout)
sound_ad_deactivation.tag_add(tag_insect)
sound_ad_deactivation.tag_add(tag_light)
sound_ad_notification = models.Sound(name="AD Notification advice",
			filename="AD_Notification_advice.wav",
			sound_type="1",
			sound_family="2")
sound_ad_notification.tag_add(tag_short)
sound_ad_notification.tag_add(tag_attention)
sound_ad_notification.tag_add(tag_login)
sound_ad_notification.tag_add(tag_logout)
sound_ad_notification.tag_add(tag_bright)
sound_ad_notification.tag_add(tag_clear)
sound_ad_notification.tag_add(tag_precise)
sound_b23 = models.Sound(name="B_23",
			filename="B_23.wav",
			sound_type="1")
sound_b23.tag_add(tag_long)
sound_b23.tag_add(tag_calm)
sound_b23.tag_add(tag_sleep)
sound_b23.tag_add(tag_mystical)
sound_b23.tag_add(tag_audiobook)
sound_b23.tag_add(tag_uncertain)
sound_b23.tag_add(tag_unsecure)
sound_b23.tag_add(tag_secret)
sound_b25 = models.Sound(name="B_25",
			filename="B_25.wav",
			sound_type="1")
sound_b25.tag_add(tag_beep)
sound_b25.tag_add(tag_short)
sound_b25.tag_add(tag_login)
sound_b25.tag_add(tag_logout)
sound_b25.tag_add(tag_bright)
sound_b25.tag_add(tag_fast)
sound_b3 = models.Sound(name="B_3",
			filename="B_3.wav",
			sound_type="1")
sound_b3.tag_add(tag_aggressive)
sound_b3.tag_add(tag_hello)
sound_b3.tag_add(tag_welcome)
sound_b3.tag_add(tag_complex)
sound_b3.tag_add(tag_affirmative)
sound_b7 = models.Sound(name="B_7",
			filename="B_7.wav",
			sound_type="1")
sound_b7.tag_add(tag_knock)
sound_b7.tag_add(tag_short)
sound_b7.tag_add(tag_click)
sound_b7.tag_add(tag_woodpecker)
sound_b7.tag_add(tag_bird)
sound_cc_activated = models.Sound(name="Cruising Chauffeur is activated",
			filename="Cruising Chauffeur is activated.wav",
			sound_type="2")
sound_cc_activated.tag_add(tag_information)
sound_cc_activated.tag_add(tag_female)
sound_dev_basic_brake = models.Sound(name="Basic brake",
			filename="DEV_Basic_Brake.wav",
			sound_type="1")
sound_dev_basic_brake.tag_add(tag_signal)
sound_dev_basic_brake.tag_add(tag_fast)
sound_dev_basic_brake.tag_add(tag_urgent1)
sound_dev_basic_brake.tag_add(tag_stop)
sound_dev_basic_brake.tag_add(tag_steps)
sound_dev_basic_brake.tag_add(tag_dance)
sound_dev_basic_brake.tag_add(tag_jazz)
sound_dev_blink = models.Sound(name="Blink 3",
			filename="DEV_Blink3.wav",
			sound_type="1")
sound_dev_blink.tag_add(tag_accelerated)
sound_dev_blink.tag_add(tag_pushing)
sound_dev_blink.tag_add(tag_faster)
sound_dev_blink.tag_add(tag_something_happens)
sound_dev_blink.tag_add(tag_approach)
sound_dev_blink.tag_add(tag_pains)
sound_dev_vari2 = models.Sound(name="Vari2 EFX",
			filename="DEV_Vari2_EFX.wav",
			sound_type="1")
sound_dev_vari2.tag_add(tag_stone)
sound_dev_vari2.tag_add(tag_clapping)
sound_dev_vari2.tag_add(tag_click)
sound_dev_vari2.tag_add(tag_wooden)
sound_dev_vari2.tag_add(tag_strange)
sound_dev_vari2.tag_add(tag_instrument)
sound_dev_vari2.tag_add(tag_woodpecker)
sound_dev_vari2.tag_add(tag_winter)
sound_dev_vari2.tag_add(tag_nature)
sound_dev_vari2.tag_add(tag_water)
sound_dev_w7 = models.Sound(name="W7",
			filename="DEV_W7.wav",
			sound_type="1")
sound_dev_w7.tag_add(tag_higher_at_the_end)
sound_dev_w7.tag_add(tag_big_hall)
sound_dev_w7.tag_add(tag_steps)
sound_dev_w7.tag_add(tag_hurry)
sound_dev_w7.tag_add(tag_danger)
sound_dev_w7.tag_add(tag_persecution)
sound_dev_w7.tag_add(tag_underground)
sound_full_6sec= models.Sound(name="Full 6 dec",
			filename="FINAL_Full_6Sec+Level3.wav",
			sound_type="1")
sound_full_6sec.tag_add(tag_urgent1)
sound_full_6sec.tag_add(tag_high_pitch)
sound_full_6sec.tag_add(tag_crash)
sound_full_6sec.tag_add(tag_need_to_intervene)
sound_full_6sec.tag_add(tag_future)
sound_full_6sec.tag_add(tag_complex)
sound_full_6sec.tag_add(tag_automated)
sound_future_750ms = models.Sound(name="Future 750ms",
			filename="FINAL_Future 750ms.wav",
			sound_type="1")
sound_future_750ms.tag_add(tag_beep)
sound_future_750ms.tag_add(tag_metallic)
sound_future_750ms.tag_add(tag_short)
sound_future_750ms.tag_add(tag_shutdown)
sound_future_750ms.tag_add(tag_electronic)
sound_future_750ms.tag_add(tag_synthetic)
sound_future_750ms.tag_add(tag_not_human)
sound_high_full = models.Sound(name="High full",
			filename="FINAL_High_Full.wav",
			sound_type="1")
sound_high_full.tag_add(tag_knock)
sound_high_full.tag_add(tag_accelerated)
sound_high_full.tag_add(tag_traffic_lights)
sound_high_full.tag_add(tag_move)
sound_high_full.tag_add(tag_rhythm)
sound_nova_switch_off = models.Sound(name="Switch off (Nova)",
			filename="Project_Nova_02_SwitchOff.wav",
			sound_type="1")
sound_nova_switch_off.tag_add(tag_close)
sound_nova_switch_off.tag_add(tag_short)
sound_nova_switch_off.tag_add(tag_selection_in_menu)
sound_nova_switch_off.tag_add(tag_classic)
sound_nova_switch_off.tag_add(tag_accord)
sound_nova_switch_off.tag_add(tag_dull)
sound_nova_53 = models.Sound(name="Sound 5 (Nova)",
			filename="Project_Nova_5_3_B.wav",
			sound_type="1")
sound_nova_53.tag_add(tag_attention)
sound_nova_53.tag_add(tag_short)
sound_nova_53.tag_add(tag_metallic)
sound_nova_53.tag_add(tag_drawing)
sound_nova_53.tag_add(tag_demanding)
sound_nova_65 = models.Sound(name="Sound 6 (Nova)",
			filename="Project_Nova_6_5_A.wav",
			sound_type="1")
sound_nova_65.tag_add(tag_short)
sound_nova_65.tag_add(tag_strike)
sound_nova_65.tag_add(tag_move)
sound_nova_65.tag_add(tag_speed)
sound_nova_65.tag_add(tag_weather)
sound_nova_65.tag_add(tag_flash)
sound_uc1_activation_exc3 = models.Sound(name="Activation system error",
			filename="UC1_Activation_Exc3_system_error.wav",
			sound_type="2")
sound_uc1_activation_exc3.tag_add(tag_female)
sound_uc1_activation_exc3.tag_add(tag_information)
sound_uc1_activation_exc3.tag_add(tag_telephone)
sound_uc2_tor_notification = models.Sound(name="TOR notification",
			filename="UC2_TOR_Notification.wav",
			sound_type="1",
			sound_family="2")
sound_uc2_tor_notification.tag_add(tag_notification)
sound_uc2_tor_notification.tag_add(tag_information)
sound_uc2_tor_notification.tag_add(tag_short)
sound_uc2_tor_notification.tag_add(tag_shutdown_of_OS)
sound_uc2_tor_notification.tag_add(tag_jingle)
sound_uc2_tor_notification.tag_add(tag_wakeup)

sound_a13 = models.Sound(name="A_13",
			filename="A_13.wav",
			sound_type="2")
sound_a13.tag_add(tag_female)
sound_a13.tag_add(tag_sharp)
sound_a13.tag_add(tag_fast)
sound_a13.tag_add(tag_precise)
sound_a13.tag_add(tag_peaceful)
sound_a15 = models.Sound(name="A_15",
			filename="A_15.wav",
			sound_type="1")
sound_a15.tag_add(tag_reverb)
sound_a15.tag_add(tag_volumnious)
sound_a15.tag_add(tag_urgent1)
sound_a15.tag_add(tag_nervous)
sound_a16= models.Sound(name="A_16",
			filename="A_16.wav",
			sound_type="1")
sound_a16.tag_add(tag_short)
sound_a16.tag_add(tag_trash)
sound_a16.tag_add(tag_sport)
sound_a16.tag_add(tag_active)
sound_a16.tag_add(tag_movement)
sound_b12 = models.Sound(name="B_12",
			filename="B_12.wav",
			sound_type="2")
sound_b12.tag_add(tag_long)
sound_b12.tag_add(tag_slurred)
sound_b12.tag_add(tag_female)
sound_b12.tag_add(tag_peaceful)
sound_b13 = models.Sound(name="B_13",
			filename="B_13.wav",
			sound_type="1")
sound_b13.tag_add(tag_nice)
sound_b13.tag_add(tag_positive)
sound_b13.tag_add(tag_acknowledge)
sound_b13.tag_add(tag_computer)
sound_b13.tag_add(tag_opening)
sound_b17 = models.Sound(name="B_17",
			filename="B_17.wav",
			sound_type="1")
sound_b17.tag_add(tag_short)
sound_b17.tag_add(tag_positive)
sound_b19 = models.Sound(name="B_19",
			filename="B_19.wav",
			sound_type="1",
			sound_family="2")
sound_b19.tag_add(tag_wave)
sound_b19.tag_add(tag_negative)
sound_b19.tag_add(tag_notification)
sound_b19.tag_add(tag_sudden)
sound_dev_brake = models.Sound(name="Brake dev",
			filename="DEV_BRAKE.wav",
			sound_type="1")
sound_dev_brake.tag_add(tag_playful)
sound_dev_brake.tag_add(tag_fussy)
sound_dev_brake.tag_add(tag_starting)
sound_dev_brake.tag_add(tag_transition)
sound_discontinue_steering = models.Sound(name="Discontinue steering and pedal use",
			filename="Discontinue Steering and Pedal Use.wav",
			sound_type="2")
sound_discontinue_steering.tag_add(tag_informative)
sound_discontinue_steering.tag_add(tag_long)
sound_discontinue_steering.tag_add(tag_precise)
sound_discontinue_steering.tag_add(tag_female)
sound_discontinue_steering.tag_add(tag_sad)
sound_detected_error = models.Sound(name="Due to detected error",
			filename="due to detected error.wav",
			sound_type="2")
sound_detected_error.tag_add(tag_unprecise)
sound_detected_error.tag_add(tag_female)
sound_detected_error.tag_add(tag_sad)
sound_excessive_speed = models.Sound(name="Due to excessive speed",
			filename="Due to excessive speed.wav",
			sound_type="2")
sound_excessive_speed.tag_add(tag_precise)
sound_excessive_speed.tag_add(tag_informative)
sound_excessive_speed.tag_add(tag_clear)
sound_excessive_speed.tag_add(tag_female)
sound_excessive_speed.tag_add(tag_sad)
sound_default_overlay = models.Sound(name="Default overlay full",
			filename="FINAL_Default_Overlay_Full_750.wav",
			sound_type="1")
sound_default_overlay.tag_add(tag_warning)
sound_default_overlay.tag_add(tag_metallic)
sound_default_overlay.tag_add(tag_unusual)
sound_subtle_750 = models.Sound(name="Subtle overlay full",
			filename="FINAL_Subtle_750_OverlayFull.wav",
			sound_type="1")
sound_subtle_750.tag_add(tag_high)
sound_subtle_750.tag_add(tag_fast)
sound_subtle_750.tag_add(tag_warning)
sound_subtle_750.tag_add(tag_metallic)
sound_nova_switch_on = models.Sound(name="Switch on (Nova)",
			filename="Project_Nova_01_SwitchOn.wav",
			sound_type="1")
sound_nova_switch_on.tag_add(tag_reverb)
sound_nova_switch_on.tag_add(tag_short)
sound_nova_switch_on.tag_add(tag_on)
sound_nove_manoevre = models.Sound(name="Manoevre (Nova)",
			filename="Project_Nova_03_Manoevre.wav",
			sound_type="1")
sound_nove_manoevre.tag_add(tag_metallic)
sound_nove_manoevre.tag_add(tag_short)
sound_nove_manoevre.tag_add(tag_fast)
sound_nove_manoevre.tag_add(tag_on)
sound_nova_safety_assist = models.Sound(name="Safety assist (Nova)",
			filename="Project_Nova_06_SafetyAssist_Lv1.wav",
			sound_type="1")
sound_nova_safety_assist.tag_add(tag_short)
sound_nova_safety_assist.tag_add(tag_fast)
sound_nova_safety_assist.tag_add(tag_on)
sound_nova_indicator = models.Sound(name="Indicator (Nova)",
			filename="Project_Nova_09_Indicator.wav",
			sound_type="1")
sound_nova_indicator.tag_add(tag_reverb)
sound_nova_indicator.tag_add(tag_popup)
sound_nova_indicator.tag_add(tag_short)
sound_nova_indicator.tag_add(tag_fast)
sound_nova_indicator.tag_add(tag_on)
sound_nova_10 = models.Sound(name="Sound 10 (Nova)",
			filename="Project_Nova_10_2_v2.wav",
			sound_type="1",
			sound_family="2")
sound_nova_10.tag_add(tag_sharp)
sound_nova_10.tag_add(tag_short)
sound_nova_10.tag_add(tag_fast)
sound_nova_10.tag_add(tag_notification)
sound_nova_10.tag_add(tag_transition)
sound_nova_9 = models.Sound(name="Sound 9 (Nova)",
			filename="Project_Nova_9_4_On.wav",
			sound_type="1")
sound_nova_9.tag_add(tag_shorter)
sound_nova_9.tag_add(tag_hard_to_hear)
sound_uc1_activation = models.Sound(name="CC activated",
			filename="UC1_Activation_CC_Activated.wav",
			sound_type="1")
sound_uc1_activation.tag_add(tag_reverb)
sound_uc1_activation.tag_add(tag_positive)
sound_uc1_activation.tag_add(tag_informative)
sound_uc1_activation.tag_add(tag_nice)
sound_uc1_activation.tag_add(tag_female)
sound_uc1_activation.tag_add(tag_happy)
sound_uc2_tor = models.Sound(name="TOR speeding",
			filename="UC2_TOR_speeding.wav",
			sound_type="2")
sound_uc2_tor.tag_add(tag_long)
sound_uc2_tor.tag_add(tag_informative)
sound_uc2_tor.tag_add(tag_positive)
sound_uc2_tor.tag_add(tag_female)
sound_uc2_tor.tag_add(tag_sad)
sound_uc2_system_error = models.Sound(name="TOR system error",
			filename="UC2_TOR_system_error.wav",
			sound_type="2")
sound_uc2_system_error.tag_add(tag_short)
sound_uc2_system_error.tag_add(tag_warning)
sound_uc2_system_error.tag_add(tag_positive)
sound_uc2_system_error.tag_add(tag_misleading)
sound_uc2_system_error.tag_add(tag_female)
sound_uc2_system_error.tag_add(tag_angry)
sound_urgent_takeover = models.Sound(name="Urgent TOR",
			filename="URGENT_TAKEOVER.wav",
			sound_type="1")
sound_urgent_takeover.tag_add(tag_warning)
sound_urgent_takeover.tag_add(tag_negative)
sound_urgent_takeover.tag_add(tag_sharp)
sound_urgent_takeover.tag_add(tag_precise)
sound_urgent_takeover.tag_add(tag_urgent1)
sound_urgent_takeover.tag_add(tag_tor)
sound_urgent_takeover.tag_add(tag_fast)
sound_user_error = models.Sound(name="User error",
			filename="User_Error.wav",
			sound_type="1")
sound_user_error.tag_add(tag_wrong)
sound_user_error.tag_add(tag_reverb)
sound_user_error.tag_add(tag_neutral)
sound_user_error.tag_add(tag_warning)
sound_user_error_important = models.Sound(name="User error important",
			filename="User_Error_Important.wav",
			sound_type="1")
sound_user_error_important.tag_add(tag_wrong)
sound_user_error_important.tag_add(tag_reverb)
sound_user_error_important.tag_add(tag_negative)
sound_user_error_important.tag_add(tag_warning)
sound_nova_63 = models.Sound(name="Nova 6-3",
			filename="Project_Nova_6_3_A.wav",
			sound_type="1")
sound_nova_63.tag_add(tag_directional)
sound_nova_63.tag_add(tag_urgent3)
sound_nova_63.tag_add(tag_positive)
sound_nova_63.tag_add(tag_warning)
sound_nova_63.tag_add(tag_critical)
sound_uc2_tor_obstacle = models.Sound(name="UC2 TOR obstacle",
			filename="UC2_TOR_Obstacle_detected.wav",
			sound_type="1")
sound_uc2_tor_obstacle.tag_add(tag_speech)
sound_uc2_tor_obstacle.tag_add(tag_urgent3)
sound_uc2_tor_obstacle.tag_add(tag_tor)
sound_uc2_tor_obstacle.tag_add(tag_warning)
sound_uc2_tor_obstacle.tag_add(tag_critical)
sound_uc2_tor_obstacle.tag_add(tag_worthy)
sound_uc2_tor_obstacle.tag_add(tag_automated)
sound_uc4_overtaking = models.Sound(name="UC4 overtaking",
			filename="UC4_Overtaking.wav",
			sound_type="2",
			sound_family="2")
sound_uc4_overtaking.tag_add(tag_speech)
sound_uc4_overtaking.tag_add(tag_urgent2)
sound_uc4_overtaking.tag_add(tag_notification)
sound_uc4_overtaking.tag_add(tag_lane_switch)
sound_uc4_overtaking.tag_add(tag_automated)
sound_nova_12 = models.Sound(name="Nova 1-2",
			filename="Project_Nova_1_2.wav",
			sound_type="1",
			sound_family="2")
sound_nova_12.tag_add(tag_urgent2)
sound_nova_12.tag_add(tag_notification)
sound_nova_12.tag_add(tag_calm)

db.session.add(sound_a1)
db.session.add(sound_nova_63)
db.session.add(sound_uc2_tor_obstacle)
db.session.add(sound_uc4_overtaking)
db.session.add(sound_nova_12)
db.session.add(sound_a11)
db.session.add(sound_a18)
db.session.add(sound_a23)
db.session.add(sound_a7)
db.session.add(sound_a8)
db.session.add(sound_ad_deactivation)
db.session.add(sound_ad_notification)
db.session.add(sound_b23)
db.session.add(sound_b25)
db.session.add(sound_b3)
db.session.add(sound_b7)
db.session.add(sound_cc_activated)
db.session.add(sound_dev_basic_brake)
db.session.add(sound_dev_blink)
db.session.add(sound_dev_vari2)
db.session.add(sound_dev_w7)
db.session.add(sound_full_6sec)
db.session.add(sound_future_750ms)
db.session.add(sound_high_full)
db.session.add(sound_nova_switch_off)
db.session.add(sound_nova_53)
db.session.add(sound_nova_65)
db.session.add(sound_uc1_activation_exc3)
db.session.add(sound_uc2_tor_notification)

db.session.add(sound_a13)
db.session.add(sound_a15)
db.session.add(sound_a16)
db.session.add(sound_b12)
db.session.add(sound_b13)
db.session.add(sound_b17)
db.session.add(sound_b19)
db.session.add(sound_dev_brake)
db.session.add(sound_discontinue_steering)
db.session.add(sound_detected_error)
db.session.add(sound_excessive_speed)
db.session.add(sound_default_overlay)
db.session.add(sound_subtle_750)
db.session.add(sound_nova_switch_on)
db.session.add(sound_nove_manoevre)
db.session.add(sound_nova_safety_assist)
db.session.add(sound_nova_indicator)
db.session.add(sound_nova_10)
db.session.add(sound_nova_9)
db.session.add(sound_uc1_activation)
db.session.add(sound_uc2_tor)
db.session.add(sound_uc2_system_error)
db.session.add(sound_urgent_takeover)
db.session.add(sound_user_error)
db.session.add(sound_user_error_important)

views.update_tags_json()
views.update_sounds_json()
db.session.commit()

# Add users
stephan_cieler = models.ClientUser(nickname="stephan_cieler",
				first_name="Stephan",
				last_name="Cieler",
                email="stephan.cieler@continental-corporation.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="ayrton_70.jpg")
benjamin_mathe = models.ClientUser(nickname="benjamin_mathe",
				first_name="Benjamin",
				last_name="Mathe",
                email="benjamin.mathe@continental-corporation.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="jim_70.jpg")
joerg_witthaus = models.ClientUser(nickname="joerg_witthaus",
				first_name="Joerg",
				last_name="Witthaus",
                email="joerg.witthaus@continental-corporation.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="michael_70.jpg")
pavlo_bazilinskyy = models.ClientUser(nickname="pavlo_bazilinskyy",
				first_name="Pavlo",
				last_name="Bazilinskyy",
                email="pavlo.bazilinskyy@gmail.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True)
sascha_becker  = models.SupplierUser(nickname="sascha_becker",
				first_name="Sascha",
				last_name="Becker",
                email="Sascha02.Becker@continental-corporation.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="niki_70.jpg")
johannes_kerkmann  = models.SupplierUser(nickname="johannes_kerkmann",
				first_name="Johannes",
				last_name="Kerkmann",
                email="johannes.kerkmann@conti-engineering.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="bender_128.png")
christian_bouchard = models.SupplierUser(nickname="christian_bouchard",
				first_name="Christian",
				last_name="Bouchard",
                email="Christian.Bouchard@continental-corporation.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="jake_128.png")
joost_de_winter = models.ClientUser(nickname="joost_de_winter",
				first_name="Joost",
				last_name="De Winter",
                email="jcfdewinter@gmail.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="kyle_128.png")
supplier4 = models.SupplierUser(nickname="jeremy_ondrey",
				first_name="Supplier",
				last_name="Four",
                email="Jeremy.Ondrey@continental-corporation.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="planet_128.png")
supplier5 = models.SupplierUser(nickname="supplier5",
				first_name="Supplier",
				last_name="Five",
                email="wordsforsound.ayrton@gmail.com",
                password="12345678",
                last_seen=datetime.now(),
                receive_emails=True,
                avatar_filename="finn_128.png")
db.session.add(stephan_cieler)
db.session.add(joerg_witthaus)
db.session.add(benjamin_mathe)
db.session.add(pavlo_bazilinskyy)
db.session.add(joost_de_winter)
db.session.add(johannes_kerkmann)
db.session.add(sascha_becker)
db.session.add(christian_bouchard)
db.session.add(supplier4)
db.session.add(supplier5)
db.session.commit()

######## Validation participant 1 ########
project_auditory_test_1 = models.Project(name="Validation 1",
				description="In this project we will create two assets to validate the newly developed sound design process.",
				filename="validation_description.pdf",
				finished=False,
				user=benjamin_mathe,
				timestamp=datetime.now())
db.session.add(project_auditory_test_1)
db.session.commit()

# Add assets
asset1_1 = models.Asset(name="Asset 1A",
				description="Beep-like sound for an urgent take-over request in a critical situation with TTC less than or equal 5 sec (e.g. sudden serious traffic accident in the lane of the automated car). It should sound worthy, with a touch of \"wooden\" sound. The sound should be directional: it should point to the the safest maneuver (right/left). It may include speech.",
        		status=models.AssetStatus.iteration.value,
        		project=project_auditory_test_1,
        		finished=False,
        		iteration_number=0,
        		timestamp=datetime.now(),
        		notify_by_email=True)
asset1_2 = models.Asset(name="Asset 2A",
				description="Not loud and not very intrusive notification for the situation when a highly automated car decides to switch lanes in automated mode. Without speech (similar to UC4_Overtaking.wav, but without speech).",
                status=models.AssetStatus.iteration.value,
                project=project_auditory_test_1,
                finished=False,
                iteration_number=0,
                timestamp=datetime.now(),
                notify_by_email=True)
db.session.add(asset1_1)
db.session.add(asset1_2)
description1_1 = models.Description(duration="200",
				description="Beep-like sound for an urgent take-over request in a critical situation with TTC less than or equal 5 sec (e.g. sudden serious traffic accident in the lane of the automated car). It should sound worthy, with a touch of \"wooden\" sound. The sound should be directional: it should point to the the safest maneuver (right/left). It may include speech.",
        		sound_type=3,
                sound_family=1,
        		user=benjamin_mathe,
        		timestamp=datetime.now())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_beep.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_urgent4.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_tor.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_critical.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_automated.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_worthy.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_wooden.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_directional.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_safe.name).first())
description1_1.tag_add(models.Tag.query.filter_by(name=tag_warning.name).first())
description1_1.sound_add(models.Sound.query.filter_by(name=sound_nova_63.name).first())
description1_1.sound_add(models.Sound.query.filter_by(name=sound_uc2_tor_obstacle.name).first())
description1_1.sound_add(models.Sound.query.filter_by(name=sound_beep_freezman.name).first())
description1_2 = models.Description(duration="65",
				description="Not loud and not very intrusive notification for the situation when a highly automated car decides to switch lanes in automated mode. Without speech (similar to UC4_Overtaking.wav, but without speech).",
                sound_type=1,
                sound_family=2,
                user=benjamin_mathe,
                timestamp=datetime.now())
description1_2.tag_add(models.Tag.query.filter_by(name=tag_calm.name).first())
description1_2.tag_add(models.Tag.query.filter_by(name=tag_notification.name).first())
description1_2.tag_add(models.Tag.query.filter_by(name=tag_lane_switch.name).first())
description1_2.tag_add(models.Tag.query.filter_by(name=tag_automated.name).first())
description1_2.sound_add(models.Sound.query.filter_by(name=sound_nova_12.name).first())
description1_2.sound_add(models.Sound.query.filter_by(name=sound_uc4_overtaking.name).first())
description1_2.sound_add(models.Sound.query.filter_by(name=sound_drum_tom.name).first())
db.session.add(description1_1)
db.session.add(description1_2)

asset1_1.description_add(description1_1)
asset1_2.description_add(description1_2)

asset1_1.client_add(benjamin_mathe)
asset1_1.supplier_add(sascha_becker)

asset1_2.client_add(benjamin_mathe)
asset1_2.supplier_add(sascha_becker)

asset1_1.init_in_hands()
asset1_2.init_in_hands()

project_auditory_test_1.asset_add(asset1_1)
project_auditory_test_1.asset_add(asset1_2)
db.session.commit()

######## Validation participant 2 ########
project_auditory_test_2 = models.Project(name="Validation 2",
				description="In this project we will create two assets to validate the newly developed sound design process.",
				filename="validation_description.pdf",
				finished=False,
				user=benjamin_mathe,
				timestamp=datetime.now())
db.session.add(project_auditory_test_2)
db.session.commit()

# Add assets
asset2_1 = models.Asset(name="Asset 1B",
				description="Beep-like sound for an urgent take-over request in a critical situation with TTC less than or equal 5 sec (e.g. sudden serious traffic accident in the lane of the automated car). It should sound worthy, with a touch of \"wooden\" sound. The sound should be directional: it should point to the the safest maneuver (right/left). It may include speech.",
        		status=models.AssetStatus.iteration.value,
        		project=project_auditory_test_1,
        		finished=False,
        		iteration_number=0,
        		timestamp=datetime.now(),
        		notify_by_email=True)
asset2_2 = models.Asset(name="Asset 2B",
				description="Not loud and not very intrusive notification for the situation when a highly automated car decides to switch lanes in automated mode. Without speech (similar to UC4_Overtaking.wav, but without speech).",
                status=models.AssetStatus.iteration.value,
                project=project_auditory_test_1,
                finished=False,
                iteration_number=0,
                timestamp=datetime.now(),
                notify_by_email=True)
db.session.add(asset2_1)
db.session.add(asset2_2)
description2_1 = models.Description(duration="200",
				description="Beep-like sound for an urgent take-over request in a critical situation with TTC less than or equal 5 sec (e.g. sudden serious traffic accident in the lane of the automated car). It should sound worthy, with a touch of \"wooden\" sound. The sound should be directional: it should point to the the safest maneuver (right/left). It may include speech.",
        		sound_type=3,
                sound_family=1,
        		user=benjamin_mathe,
        		timestamp=datetime.now())
db.session.add(description2_1)
description2_1.tag_add(models.Tag.query.filter_by(name=tag_beep.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_urgent4.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_tor.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_critical.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_automated.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_worthy.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_wooden.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_directional.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_safe.name).first())
description2_1.tag_add(models.Tag.query.filter_by(name=tag_warning.name).first())
description2_1.sound_add(models.Sound.query.filter_by(name=sound_nova_63.name).first())
description2_1.sound_add(models.Sound.query.filter_by(name=sound_uc2_tor_obstacle.name).first())
description2_1.sound_add(models.Sound.query.filter_by(name=sound_beep_freezman.name).first())
description2_2 = models.Description(duration="65",
				description="Not loud and not very intrusive notification for the situation when a highly automated car decides to switch lanes in automated mode. Without speech (similar to UC4_Overtaking.wav, but without speech).",
                sound_type=1,
                sound_family=2,
                user=benjamin_mathe,
                timestamp=datetime.now())
db.session.add(description2_2)
description2_2.tag_add(models.Tag.query.filter_by(name=tag_calm.name).first())
description2_2.tag_add(models.Tag.query.filter_by(name=tag_notification.name).first())
description2_2.tag_add(models.Tag.query.filter_by(name=tag_lane_switch.name).first())
description2_2.tag_add(models.Tag.query.filter_by(name=tag_automated.name).first())
description2_2.sound_add(models.Sound.query.filter_by(name=sound_nova_12.name).first())
description2_2.sound_add(models.Sound.query.filter_by(name=sound_uc4_overtaking.name).first())
description2_2.sound_add(models.Sound.query.filter_by(name=sound_drum_tom.name).first())

asset2_1.description_add(description2_1)
asset2_2.description_add(description2_2)

asset2_1.client_add(benjamin_mathe)
asset2_1.supplier_add(christian_bouchard)

asset2_2.client_add(benjamin_mathe)
asset2_2.supplier_add(christian_bouchard)

asset2_1.init_in_hands()
asset2_2.init_in_hands()

project_auditory_test_2.asset_add(asset2_1)
project_auditory_test_2.asset_add(asset2_2)
db.session.commit()

######## Validation participant 3 ########
project_auditory_test_3 = models.Project(name="Validation 3",
				description="In this project we will create two assets to validate the newly developed sound design process.",
				filename="validation_description.pdf",
				finished=False,
				user=benjamin_mathe,
				timestamp=datetime.now())
db.session.add(project_auditory_test_3)
db.session.commit()

# Add assets
asset3_1 = models.Asset(name="Asset 1C",
				description="Beep-like sound for an urgent take-over request in a critical situation with TTC less than or equal 5 sec (e.g. sudden serious traffic accident in the lane of the automated car). It should sound worthy, with a touch of \"wooden\" sound. The sound should be directional: it should point to the the safest maneuver (right/left). It may include speech.",
        		status=models.AssetStatus.iteration.value,
        		project=project_auditory_test_1,
        		finished=False,
        		iteration_number=0,
        		timestamp=datetime.now(),
        		notify_by_email=True)
asset3_2 = models.Asset(name="Asset 2C",
				description="Not loud and not very intrusive notification for the situation when a highly automated car decides to switch lanes in automated mode. Without speech (similar to UC4_Overtaking.wav, but without speech).",
                status=models.AssetStatus.iteration.value,
                project=project_auditory_test_1,
                finished=False,
                iteration_number=0,
                timestamp=datetime.now(),
                notify_by_email=True)
db.session.add(asset3_1)
db.session.add(asset3_2)
description3_1 = models.Description(duration="200",
				description="Beep-like sound for an urgent take-over request in a critical situation with TTC less than or equal 5 sec (e.g. sudden serious traffic accident in the lane of the automated car). It should sound worthy, with a touch of \"wooden\" sound. The sound should be directional: it should point to the the safest maneuver (right/left). It may include speech.",
        		sound_type=3,
                sound_family=1,
        		user=benjamin_mathe,
        		timestamp=datetime.now())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_beep.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_urgent4.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_tor.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_critical.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_automated.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_worthy.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_wooden.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_directional.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_safe.name).first())
description3_1.tag_add(models.Tag.query.filter_by(name=tag_warning.name).first())
description3_1.sound_add(models.Sound.query.filter_by(name=sound_nova_63.name).first())
description3_1.sound_add(models.Sound.query.filter_by(name=sound_uc2_tor_obstacle.name).first())
description3_1.sound_add(models.Sound.query.filter_by(name=sound_beep_freezman.name).first())
db.session.add(description3_1)
description3_2 = models.Description(duration="65",
				description="Not loud and not very intrusive notification for the situation when a highly automated car decides to switch lanes in automated mode. Without speech (similar to UC4_Overtaking.wav, but without speech).",
                sound_type=1,
                sound_family=2,
                user=benjamin_mathe,
                timestamp=datetime.now())
db.session.add(description3_2)
description3_2.tag_add(models.Tag.query.filter_by(name=tag_calm.name).first())
description3_2.tag_add(models.Tag.query.filter_by(name=tag_notification.name).first())
description3_2.tag_add(models.Tag.query.filter_by(name=tag_lane_switch.name).first())
description3_2.tag_add(models.Tag.query.filter_by(name=tag_automated.name).first())
description3_2.sound_add(models.Sound.query.filter_by(name=sound_nova_12.name).first())
description3_2.sound_add(models.Sound.query.filter_by(name=sound_uc4_overtaking.name).first())
description3_2.sound_add(models.Sound.query.filter_by(name=sound_drum_tom.name).first())

asset3_1.description_add(description3_1)
asset3_2.description_add(description3_2)

asset3_1.client_add(benjamin_mathe)
asset3_1.supplier_add(johannes_kerkmann)

asset3_2.client_add(benjamin_mathe)
asset3_2.supplier_add(johannes_kerkmann)

asset3_1.init_in_hands()
asset3_2.init_in_hands()

project_auditory_test_3.asset_add(asset3_1)
project_auditory_test_3.asset_add(asset3_2)
db.session.commit()
