class TrailerSeen(db.Model): __tablename__ = 'trailer_seen' id = db.Column(db.Integer, primary_key=True) time_stamp = db.Column(db.String(50)) seen_by = db.Column(db.String(50)) imdb_id = db.Column(db.String(20)) rate = db.Column(db.String(10)) is_skipped = db.Column(db.String(10)) reported = db.Column(db.String(10)) time_watched = db.Column(db.String(20)) predicted_rate = db.Column(db.String(20)) type_of_rec = db.Column(db.String(10)) def __init__(self, timestamp, seen_by, imdb_id, rate, is_skipped, reported, time_watched, predicted_rate, type_of_rec): self.time_stamp = timestamp self.seen_by = seen_by self.imdb_id = imdb_id self.rate = rate self.is_skipped = is_skipped self.reported = reported self.time_watched = time_watched self.predicted_rate = predicted_rate self.type_of_rec = type_of_rec def __repr__(self): return 'seen_by: {0} , imdb_id: {1}, rate: {2},' \ ' is_skipped: {3}, type_of_rec: {4}'.format(self.seen_by, self.imdb_id, self.rate, self.is_skipped, self.type_of_rec)
class UserFavoriteGenre(db.Model): __tablename__ = 'user_favorite_genre' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(50)) genre_1 = db.Column(db.String(20)) genre_2 = db.Column(db.String(20)) genre_3 = db.Column(db.String(20)) genre_4 = db.Column(db.String(20)) def __init__(self, rated_by, genre1, genre2, genre3, genre4): self.user_id = rated_by self.genre_1 = genre1 self.genre_2 = genre2 self.genre_3 = genre3 self.genre_4 = genre4 def __repr__(self): return 'user_id: {0} , genre1: {1}, genre2: {2} genre3: {3}, genre4: {4}' \ .format(self.user_id, self.genre_1, self.genre_2, self.genre_3,self.genre_4)
class DemQuestionnaire(db.Model): __tablename__ = 'dem_questionnaire' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(50)) dateOfBirth = db.Column(db.String(15)) gender = db.Column(db.String(10)) nationality = db.Column(db.String(60)) question1_1 = db.Column(db.String(10)) question1_2 = db.Column(db.String(10)) question1_3 = db.Column(db.String(10)) question1_4 = db.Column(db.String(10)) question1_5 = db.Column(db.String(10)) question1_6 = db.Column(db.String(50)) question1_7 = db.Column(db.String(10)) question1_8 = db.Column(db.String(10)) question1_9 = db.Column(db.String(10)) question1_10 = db.Column(db.String(10)) question1_11 = db.Column(db.String(50)) question_2 = db.Column(db.String(10)) twitter = db.Column(db.String(20)) fb = db.Column(db.String(20)) instagram = db.Column(db.String(20)) lastfm = db.Column(db.String(20)) spotify = db.Column(db.String(20)) def __init__( self, user_id, dateOfBirth, gender, nationality, question1_1, question1_2, question1_3, question1_4, question1_5, question1_6, question1_7, question1_8, question1_9, question1_10, question1_11, question_2, twitter, fb, instagram, lastfm, spotify, ): self.user_id = user_id self.dateOfBirth = dateOfBirth self.gender = gender self.nationality = nationality self.question1_1 = question1_1 self.question1_2 = question1_2 self.question1_3 = question1_3 self.question1_4 = question1_4 self.question1_5 = question1_5 self.question1_6 = question1_6 self.question1_7 = question1_7 self.question1_8 = question1_8 self.question1_9 = question1_9 self.question1_10 = question1_10 self.question1_11 = question1_11 self.question_2 = question_2 self.twitter = twitter self.fb = fb self.instagram = instagram self.lastfm = lastfm self.spotify = spotify
class Questionnaire(db.Model): __tablename__ = 'questionnaire' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(50)) list1 = db.Column(db.String(10)) list2 = db.Column(db.String(10)) list3 = db.Column(db.String(10)) timestamp1 = db.Column(db.String(20)) timestamp2 = db.Column(db.String(20)) timestamp3 = db.Column(db.String(20)) timestamp4 = db.Column(db.String(20)) timestamp5 = db.Column(db.String(20)) timestamp6 = db.Column(db.String(20)) timestamp7 = db.Column(db.String(20)) question_1 = db.Column(db.String(10)) question_2 = db.Column(db.String(10)) question_3 = db.Column(db.String(10)) question_4 = db.Column(db.String(10)) question_5 = db.Column(db.String(10)) question_6 = db.Column(db.String(10)) question_7 = db.Column(db.String(10)) question_8 = db.Column(db.String(10)) question_9 = db.Column(db.String(10)) question_10 = db.Column(db.String(10)) question_11 = db.Column(db.String(10)) question_12 = db.Column(db.String(10)) question_13 = db.Column(db.String(10)) question_14 = db.Column(db.String(10)) question_15 = db.Column(db.String(10)) question_16 = db.Column(db.String(10)) question_17 = db.Column(db.String(10)) question_18 = db.Column(db.String(10)) question_19 = db.Column(db.String(10)) question_20 = db.Column(db.String(10)) question_21 = db.Column(db.String(10)) question_22 = db.Column(db.String(10)) question_23 = db.Column(db.String(10)) question_24 = db.Column(db.String(10)) question_25 = db.Column(db.String(10)) question_26 = db.Column(db.String(10)) question_27 = db.Column(db.String(10)) question_28 = db.Column(db.String(10)) def __init__( self, rated_by, list1, list2, list3, timestamp1, timestamp2, timestamp3, timestamp4, timestamp5, timestamp6, timestamp7, question_1, question_2, question_3, question_4, question_5, question_6, question_7, question_8, question_9, question_10, question_11, question_12, question_13, question_14, question_15, question_16, question_17, question_18, question_19, question_20, question_21, question_22, question_23, question_24, question_25, question_26, question_27, question_28, ): self.user_id = rated_by self.list1 = list1 self.list2 = list2 self.list3 = list3 self.timestamp1 = timestamp1 self.timestamp2 = timestamp2 self.timestamp3 = timestamp3 self.timestamp4 = timestamp4 self.timestamp5 = timestamp5 self.timestamp6 = timestamp6 self.timestamp7 = timestamp7 self.question_1 = question_1 self.question_2 = question_2 self.question_3 = question_3 self.question_4 = question_4 self.question_5 = question_5 self.question_6 = question_6 self.question_7 = question_7 self.question_8 = question_8 self.question_9 = question_9 self.question_10 = question_10 self.question_11 = question_11 self.question_12 = question_12 self.question_13 = question_13 self.question_14 = question_14 self.question_15 = question_15 self.question_16 = question_16 self.question_17 = question_17 self.question_18 = question_18 self.question_19 = question_19 self.question_20 = question_20 self.question_21 = question_21 self.question_22 = question_22 self.question_23 = question_23 self.question_24 = question_24 self.question_25 = question_25 self.question_26 = question_26 self.question_27 = question_27 self.question_28 = question_28
class Personality(db.Model): __tablename__ = 'personality' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(50)) Extr_Enth = db.Column(db.String(10)) Crit_Quar = db.Column(db.String(10)) Depe_SeDi = db.Column(db.String(10)) Anxi_EaUp = db.Column(db.String(10)) OTNE_Comp = db.Column(db.String(10)) Rese_Quie = db.Column(db.String(10)) Symp_Warm = db.Column(db.String(10)) Diso_Care = db.Column(db.String(10)) Calm_EmSt = db.Column(db.String(10)) Conv_Uncr = db.Column(db.String(10)) def __init__(self, rated_by, Extr_Enth, Crit_Quar, Depe_SeDi, Anxi_EaUp, OTNE_Comp, Rese_Quie, Symp_Warm, Diso_Care, Calm_EmSt, Conv_Uncr, ): self.user_id = rated_by self.Extr_Enth = Extr_Enth self.Crit_Quar = Crit_Quar self.Depe_SeDi = Depe_SeDi self.Anxi_EaUp = Anxi_EaUp self.OTNE_Comp = OTNE_Comp self.Rese_Quie = Rese_Quie self.Symp_Warm = Symp_Warm self.Diso_Care = Diso_Care self.Calm_EmSt = Calm_EmSt self.Conv_Uncr = Conv_Uncr
class TimeLog(db.Model): __tablename__ = 'timelog' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(50)) SignUpPage = db.Column(db.String(10)) SignInPage = db.Column(db.String(10)) DemographicPage = db.Column(db.String(10)) PersonalityPage = db.Column(db.String(10)) PreCatalogPage = db.Column(db.String(10)) Ini0Page = db.Column(db.String(10)) Ini1Page = db.Column(db.String(10)) Ini2Page = db.Column(db.String(10)) Ini3Page = db.Column(db.String(10)) Ini4Page = db.Column(db.String(10)) Ini5Page = db.Column(db.String(10)) ProfilePage = db.Column(db.String(10)) ExplorePage = db.Column(db.String(10)) RecForYouPage = db.Column(db.String(10)) def __init__(self, rated_by, SignUpPage, SignInPage, DemographicPage, PersonalityPage, PreCatalogPage, Ini0Page, Ini1Page, Ini2Page, Ini3Page, Ini4Page, Ini5Page, ProfilePage, ExplorePage, RecForYouPage): self.user_id = rated_by self.SignUpPage = SignUpPage self.SignInPage = SignInPage self.DemographicPage = DemographicPage self.PersonalityPage = PersonalityPage self.PreCatalogPage = PreCatalogPage self.Ini0Page = Ini0Page self.Ini1Page = Ini1Page self.Ini2Page = Ini2Page self.Ini3Page = Ini3Page self.Ini4Page = Ini4Page self.Ini5Page = Ini5Page self.ProfilePage = ProfilePage self.ExplorePage = ExplorePage self.RecForYouPage = RecForYouPage
class Personality(db.Model): __tablename__ = 'personality' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.String(50)) Extr_Enth = db.Column(db.String(10)) Crit_Quar = db.Column(db.String(10)) Depe_SeDi = db.Column(db.String(10)) Anxi_EaUp = db.Column(db.String(10)) OTNE_Comp = db.Column(db.String(10)) Rese_Quie = db.Column(db.String(10)) Symp_Warm = db.Column(db.String(10)) Diso_Care = db.Column(db.String(10)) Calm_EmSt = db.Column(db.String(10)) Conv_Uncr = db.Column(db.String(10)) def TIPI_TO_OCEAN(self): return [(float(self.OTNE_Comp) + float(self.Conv_Uncr)) / float(2), (float(self.Depe_SeDi) + float(self.Diso_Care)) / float(2), (float(self.Extr_Enth) + float(self.Rese_Quie)) / float(2), (float(self.Crit_Quar) + float(self.Symp_Warm)) / float(2), (float(self.Anxi_EaUp) + float(self.Calm_EmSt)) / float(2)] def __init__( self, user_id, Extr_Enth, Crit_Quar, Depe_SeDi, Anxi_EaUp, OTNE_Comp, Rese_Quie, Symp_Warm, Diso_Care, Calm_EmSt, Conv_Uncr, ): self.user_id = user_id self.Extr_Enth = Extr_Enth self.Crit_Quar = Crit_Quar self.Depe_SeDi = Depe_SeDi self.Anxi_EaUp = Anxi_EaUp self.OTNE_Comp = OTNE_Comp self.Rese_Quie = Rese_Quie self.Symp_Warm = Symp_Warm self.Diso_Care = Diso_Care self.Calm_EmSt = Calm_EmSt self.Conv_Uncr = Conv_Uncr