def activate_deactivate(site_name , is_active, _type='POST'): # return "hi" from webnotes.model.doc import Document from webnotes.utils import now site_details = webnotes.conn.sql("select database_name, database_password from `tabSite Details` where name = '%s'"%(site_name)) # return site_details if site_details: import MySQLdb try: myDB = MySQLdb.connect(user="******"%site_details[0][0], passwd="%s"%site_details[0][1], db="%s"%site_details[0][0]) cHandler = myDB.cursor() cHandler.execute("update tabSingles set value = '%s' where field='is_active' and doctype = 'Global Defaults'"%is_active) cHandler.execute("commit") myDB.close() d = Document("Site Log") d.site_name =site_name d.is_active = is_active d.date_time = now() d.save() webnotes.conn.sql("commit") return {"status":"200", 'name':d.name} except Exception as inst: return {"status":"417", "error":inst} else: return{"status":"404", "Error":"Site Not Fount"}
def update_user_limit(site_name , max_users, _type='POST'): from webnotes.model.doc import Document from webnotes.utils import now site_name = get_site_name(site_name) site_details = webnotes.conn.sql("select database_name, database_password from `tabSite Details` where name = '%s'"%(site_name)) if site_details: import MySQLdb try: myDB = MySQLdb.connect(user="******"%site_details[0][0], passwd="%s"%site_details[0][1], db="%s"%site_details[0][0]) cHandler = myDB.cursor() cHandler.execute("update tabSingles set value = '%s' where field='max_users' and doctype = 'Global Defaults'"%max_users) cHandler.execute("commit") myDB.close() d = Document("Site Log") d.site_name =site_name d.date_time = now() d.purpose = 'Max User Setting' d.max_users = max_users d.save() webnotes.conn.sql("commit") return {"status":"200", 'name':d.name} except Exception as inst: return {"status":"417", "error":inst}