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