Python DbManager.grant_all_privileges Examples

Example #1

def create_database_and_user(force, verbose):
    db_name = frappe.local.conf.db_name
    db_name = db_name[:16]
    if "." in db_name:
        dn = db_name.split('.')
        db_name = dn[0]
    dbman = DbManager(frappe.local.db)
    #print db_name
    #print dbman.get_database_list()
    if force or (db_name not in dbman.get_database_list()):
        #print "in if"
        dbman.delete_user(db_name)
        dbman.drop_database(db_name)
    else:
        raise Exception("Database %s already exists" % (db_name, ))

    dbman.create_user(db_name, frappe.conf.db_password)
    if verbose: print "Created user %s" % db_name

    dbman.create_database(db_name)
    if verbose: print "Created database %s" % db_name

    dbman.grant_all_privileges(db_name, db_name)
    dbman.flush_privileges()
    if verbose:
        print "Granted privileges to user %s and database %s" % (db_name,
                                                                 db_name)

    # close root connection
    frappe.db.close()

Example #2

File: installer.py Project: elmantorres1997/frappe

def create_database_and_user(force, verbose, no_mariadb_socket):
	db_name = frappe.local.conf.db_name
	dbman = DbManager(frappe.local.db)
	if force or (db_name not in dbman.get_database_list()):
		dbman.delete_user(db_name)
		if no_mariadb_socket:
			dbman.delete_user(db_name, host="%")
		dbman.drop_database(db_name)
	else:
		raise Exception("Database %s already exists" % (db_name,))

	dbman.create_user(db_name, frappe.conf.db_password)
	if no_mariadb_socket:
		dbman.create_user(db_name, frappe.conf.db_password, host="%")
	if verbose: print("Created user %s" % db_name)

	dbman.create_database(db_name)
	if verbose: print("Created database %s" % db_name)

	dbman.grant_all_privileges(db_name, db_name)
	if no_mariadb_socket:
		dbman.grant_all_privileges(db_name, db_name, host="%")
	dbman.flush_privileges()
	if verbose: print("Granted privileges to user %s and database %s" % (db_name, db_name))

	# close root connection
	frappe.db.close()

Example #3

File: installer.py Project: gangadhar-kadam/laganfrappe

def create_database_and_user(force, verbose):
	db_name = frappe.local.conf.db_name
	db_name=db_name[:16]
	if "." in db_name: 
		dn=db_name.split('.')
		db_name=dn[0]
	dbman = DbManager(frappe.local.db)
	#print db_name
	#print dbman.get_database_list()
	if force or (db_name not in dbman.get_database_list()):
		#print "in if"
		dbman.delete_user(db_name)
		dbman.drop_database(db_name)
	else:
		raise Exception("Database %s already exists" % (db_name,))

	dbman.create_user(db_name, frappe.conf.db_password)
	if verbose: print "Created user %s" % db_name

	dbman.create_database(db_name)
	if verbose: print "Created database %s" % db_name

	dbman.grant_all_privileges(db_name, db_name)
	dbman.flush_privileges()
	if verbose: print "Granted privileges to user %s and database %s" % (db_name, db_name)

	# close root connection
	frappe.db.close()

Example #4

File: help.py Project: MostafaBalata/frappe

	def make_database(self):
		dbman = DbManager(get_root_connection())

		# make database
		if not help_db_name in dbman.get_database_list():
			dbman.create_user(help_db_name, help_db_name)
			dbman.create_database(help_db_name)
			dbman.grant_all_privileges(help_db_name, help_db_name)
			dbman.flush_privileges()

Example #5

File: help.py Project: sagar30051991/kalashetra-frappe

    def make_database(self):
        dbman = DbManager(get_root_connection())

        # make database
        if not help_db_name in dbman.get_database_list():
            dbman.create_user(help_db_name, help_db_name)
            dbman.create_database(help_db_name)
            dbman.grant_all_privileges(help_db_name, help_db_name)
            dbman.flush_privileges()

Example #6

File: help.py Project: JiShangShiDai/frappe

	def make_database(self):
		'''make database for global help setup'''
		if not self.global_help_setup:
			return

		dbman = DbManager(get_root_connection())
		dbman.drop_database(self.help_db_name)

		# make database
		if not self.help_db_name in dbman.get_database_list():
			try:
				dbman.create_user(self.help_db_name, self.help_db_name)
			except Exception as e:
				# user already exists
				if e.args[0] != 1396: raise
			dbman.create_database(self.help_db_name)
			dbman.grant_all_privileges(self.help_db_name, self.help_db_name)
			dbman.flush_privileges()

Example #7

File: help.py Project: stevenpegas/frappe

    def make_database(self):
        '''make database for global help setup'''
        if not self.global_help_setup:
            return

        dbman = DbManager(get_root_connection())
        dbman.drop_database(self.help_db_name)

        # make database
        if not self.help_db_name in dbman.get_database_list():
            try:
                dbman.create_user(self.help_db_name, self.help_db_name)
            except Exception as e:
                # user already exists
                if e.args[0] != 1396: raise
            dbman.create_database(self.help_db_name)
            dbman.grant_all_privileges(self.help_db_name, self.help_db_name)
            dbman.flush_privileges()

Example #8

File: installer.py Project: AhmedHamedTN/frappe

def create_database_and_user(force, verbose):
	db_name = frappe.local.conf.db_name
	dbman = DbManager(frappe.local.db)
	if force or (db_name not in dbman.get_database_list()):
		dbman.delete_user(db_name, get_current_host())
		dbman.drop_database(db_name)
	else:
		raise Exception("Database %s already exists" % (db_name,))

	dbman.create_user(db_name, frappe.conf.db_password, get_current_host())
	if verbose: print "Created user %s" % db_name

	dbman.create_database(db_name)
	if verbose: print "Created database %s" % db_name

	dbman.grant_all_privileges(db_name, db_name, get_current_host())
	dbman.flush_privileges()
	if verbose: print "Granted privileges to user %s and database %s" % (db_name, db_name)

	# close root connection
	frappe.db.close()