def __init__(self):
self._table = 'user_activity'
self.setPK('id')
self._table_columns = [ 'id',
'uid',
'activity_id',
'create_time',
'status'
]
self._table_columns_rule = {'uid':['required'], 'activity_id':['required'], 'create_time':['required'], 'status':['required'] }
self._table_columns_autoload = {'create_time': utiles.dateToTimestamp(), 'status': 1}
super(UserActivity, self).__init__()
def __init__(self):
self._table = 'user_note_comment'
self.setPK('id')
self._table_columns = [
'id', 'note_id', 'content', 'create_time', 'create_uid', 'status'
]
self._table_columns_rule = {
'content': ['required'],
'note_id': ['required'],
'create_time': ['required'],
'create_uid': ['required']
}
self._table_columns_autoload = {
'create_time': utiles.dateToTimestamp()
}
super(userNoteComment, self).__init__()
def __init__(self):
self._table = 'user_note'
self.setPK('id')
self._table_columns = [
'id', 'title', 'content', 'create_time', 'update_time', 'view_num',
'is_open', 'is_comment', 'tag_ids', 'detete_time', 'create_uid'
]
self._table_columns_rule = {
'title': ['required'],
'content': ['required'],
'create_time': ['required']
}
self._table_columns_autoload = {
'create_time': utiles.dateToTimestamp()
}
super(UserNote, self).__init__()
def saveCharacterTest(self, uid, bfi_ids_vals, item):
if not bfi_ids_vals:
return False
now = dateToTimestamp()
info = self.queryOne([('uid', uid)], self._table_columns)
bct = BfiCharacterTest()
item['N'] = bct.N[item['N']] if (bct.N).has_key(item['N']) else 0
item['E'] = bct.E[item['E']] if (bct.E).has_key(item['E']) else 0
item['O'] = bct.O[item['O']] if (bct.O).has_key(item['O']) else 0
item['A'] = bct.A[item['A']] if (bct.A).has_key(item['A']) else 0
item['C'] = bct.C[item['C']] if (bct.C).has_key(item['C']) else 0
if info:
tmp = self.updateInfo(filterString=[('bfi_ids_vals', bfi_ids_vals),
('update_time', now),
('N_val', item['N']),
('E_val', item['E']),
('O_val', item['O']),
('A_val', item['A']),
('C_val', item['C'])],
where=[('uid', uid)])
if tmp:
sc = SysConfig()
item['N'] = item['N'] - info['N_val']
item['E'] = item['E'] - info['E_val']
item['O'] = item['O'] - info['O_val']
item['A'] = item['A'] - info['A_val']
item['C'] = item['C'] - info['C_val']
sc.updateConfig('bfi_total', item)
else:
tmp = self.saveOne({
'uid': uid,
'bfi_ids_vals': bfi_ids_vals,
'create_time': now,
'update_time': now,
'N_val': item['N'],
'E_val': item['E'],
'O_val': item['O'],
'A_val': item['A'],
'C_val': item['C']
})
if tmp:
sc = SysConfig()
sc.updateConfig('bfi_total', item) #N:0,E:0,O:0,A:0,C:0
sc.incConfig('bfi_user_total')
return tmp
def __init__(self):
self._table = 'user_newsfeed'
self.setPK('id')
self._table_columns = [
'id', 'uid', 'content', 'imgs', 'create_time', 'from_source',
'coordinate', 'status', 'is_open', 'rank_num', 'focus_num',
'activity_ids'
]
self._table_columns_rule = {
'uid': ['required'],
'content': ['required'],
'create_time': ['required'],
'status': ['required']
}
self._table_columns_autoload = {
'create_time': utiles.dateToTimestamp(),
'status': 1
}
super(UserNewsfeed, self).__init__()
def __init__(self):
self._table = 'tags'
self.setPK('id')
self._table_columns = ['id', 'name', 'create_time', 'type', 'click_num', 'use_num', 'rank_num']
self._table_columns_autoload = {'create_time': utiles.dateToTimestamp()}
super(Tags, self).__init__()