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}
