def _calculate_summary(self):
summary = db.get_data("SELECT parameter, value FROM digin_usage_summary "
"WHERE user_id = '{0}' AND tenant = '{1}'".format(self.user_id, self.tenant))
if summary['rows'] == ():
db.insert_data(self.insert_obj,'digin_usage_summary')
else:
update_obj = []
residue_insert = []
for i in self.insert_obj:
for j in summary['rows']:
if i['parameter'] == j[0]:
if self.is_increment:
update_obj.append({i['parameter']:str(int(j[1])+int(i['value']))})
else:
update_obj.append({i['parameter']: str(int(j[1])-int(i['value']))})
break
else:
residue_insert.append({'parameter':i['parameter'],'value':i['value'],'user_id':self.user_id,'tenant':self.tenant})
continue
if update_obj:
for record in update_obj:
db.update_data('digin_usage_summary',"WHERE parameter = '{0}' AND user_id = '{1}' AND tenant = '{2}' "
.format(list(record.keys())[0], self.user_id,self.tenant), value = record.itervalues().next(),
modifieddatetime=datetime.datetime.now())
if residue_insert:
db.insert_data(residue_insert,'digin_usage_summary')
def deactivate_packages(self):
""
if self.is_default:
try:
db.update_data('digin_tenant_package_details'," WHERE tenant_id = '{0}' AND package_id IN ({1},{2},{3},{4})".format(self.tenant,int(free_package),int(default_1),int(default_2),int(default_3)),
package_status = 'deactivated')
except Exception, err:
print "Error inserting to DB!"
return cmg.format_response(False, err, "Error occurred while deactivate_packages.. \n" + str(err),
exception=sys.exc_info())
def store_user_settings(params,user_id, domain):
data_object = [{'user_id': user_id,
'email': params['email'],
'components': params['components'],
'user_role': params['user_role'],
'cache_lifetime': 300 if params['cache_lifetime'] is None else int(params['cache_lifetime']),
'widget_limit': default_user_settings['widget_limit'] if params['widget_limit'] is None else int(params['widget_limit']),
'query_limit': default_user_settings['query_limit'] if params['query_limit'] is None else int(params['query_limit']),
'logo_path': '/digin_user_data/'+user_id+'/'+domain+'/logos/'+params['logo_name'],
'dp_path': '/digin_user_data/'+user_id+'/'+domain+'/DPs/'+params['dp_name'],
'theme_config': params['theme_config'],
'modified_date_time': datetime.datetime.now(),
'created_date_time': datetime.datetime.now(),
'domain': domain
}]
logger.info("Data received!")
logger.info(data_object)
existance = CC.get_data("SELECT user_id from digin_user_settings where user_id = '{0}' AND domain = '{1}'".format(user_id, domain))
if existance['rows'] != ():
try:
CC.update_data('digin_user_settings',"WHERE user_id='{0}'".format(user_id),
components=params['components'],
user_role=params['user_role'],
cache_lifetime=int(params['cache_lifetime']),
widget_limit=int(params['widget_limit']),
query_limit=int(params['query_limit']),
logo_path='/digin_user_data/'+user_id+'/'+domain+'/logos/'+params['logo_name'],
dp_path='/digin_user_data/'+user_id+'/'+domain+'/DPs/'+params['dp_name'],
theme_config=params['theme_config'],
modified_date_time=datetime.datetime.now())
return cmg.format_response(True,1,"User settings updated successfully")
except Exception, err:
logger.error("Error updating user settings")
logger.error(err)
print "Error updating user settings"
print err
raise
def _temporary_delete_components(comp_id, table, user_id, domain):
try:
is_access_valid = CC.get_data("SELECT digin_comp_id FROM digin_component_header a INNER JOIN "
"digin_component_access_details b ON a.digin_comp_id = b.component_id "
"WHERE digin_comp_id = {0} AND domain = '{1}' AND user_id = '{2}'".format(comp_id,domain,user_id))
if int(is_access_valid['rows'][0][0]) == int(comp_id):
result = CC.update_data(table,'WHERE digin_comp_id = {0}'.format(comp_id),is_active=False)
_rate_calculation_helper(False, comp_id, 'dashboard', user_id, domain) # Component count is decremented when components moved to Trash
print 'Component deleted user_id: {0}, tenant: {1}, component_id: {2}'.format(user_id, domain, comp_id)
else:
result = 'No component found for deletion user_id: {0}, tenant: {1}, component_id: {2}'.format(user_id,domain,comp_id)
print result
return result
except Exception, err:
print err
raise
def update_data(dj):
date = dt.datetime.now()
##update all the values
cache.update_data('wordcloud', 'WHERE d_name = "test1"', data = dj, DateTime = date)
logger.info('Inserted results into wordcloud table')
db.insert_data(package_data, 'digin_packagedetails')
except Exception, err:
print "Error inserting to DB!"
result = cmg.format_response(False, err,
"Error occurred while inserting additional_packages.. \n" + str(err),
exception=sys.exc_info())
return result
return cmg.format_response(True, 0, "Package updated successfully")
def deactivate_packages(self):
""
if self.is_default:
try:
db.update_data('digin_tenant_package_details'," WHERE tenant_id = '{0}' AND package_id IN ({1},{2},{3},{4})".format(self.tenant,int(free_package),int(default_1),int(default_2),int(default_3)),
package_status = 'deactivated')
except Exception, err:
print "Error inserting to DB!"
return cmg.format_response(False, err, "Error occurred while deactivate_packages.. \n" + str(err),
exception=sys.exc_info())
else:
try:
db.update_data('digin_tenant_package_details',
" WHERE package_id = '{0}' AND tenant_id = '{1}'".format(self.package_id, self.tenant),
package_status='deactivated')
except Exception, err:
print "Error inserting to DB!"
return cmg.format_response(False, err,
"Error occurred while deactivate additional_packages.. \n" + str(err),
exception=sys.exc_info())
'digin_comp_id':DiginCompID, 'version_id':1,'size_x':widget['sizeX'],'size_y':widget['sizeY'],'row':widget['row'],'col':widget['col'],
'comp_page_id': page_id}], 'digin_component_detail')
logger.info("Digin Widget Successfully created")
except Exception, err:
logger.error("Error in updating cache. %s" % err)
return cmg.format_response(False,None,'Error occurred while saving dashboard!',sys.exc_info())
logger.info("Dashboard saving successful!")
print "Dashboard saving successful!"
return cmg.format_response(True,DiginCompID,"Successfully saved!")
else:
try:
CC.update_data('digin_component_header','WHERE digin_comp_id ={0}'.format(data["compID"]),
modified_date_time=datetime.datetime.now(),
digin_comp_name=DiginCompName,
digin_comp_class=DiginCompClass,
digin_comp_type=DiginCompType,
digin_comp_category=DiginCompCategory,
refresh_interval=RefreshInterval,
last_modified_user=User_id
)
logger.info("Digin component successfully updated")
except Exception, err:
logger.error("Error in updating component. %s" % err)
pass
for page in pages:
try:
if page['pageID'] is not None:
CC.update_data('digin_component_page_detail','WHERE digin_comp_id ={0} AND page_id ={1}'
.format(data["compID"],page['pageID']),
page_name=page['pageName'],
