SqlConfigParser Class Reference

Inheritance diagram for SqlConfigParser:

Collaboration diagram for SqlConfigParser:

Public Member Functions
	__init__ (self, tablename="sippeers")
	connect (self, user, password, host, port, database)
	read (self, filename, sect=None)
	write (self, config_file)
	write_dicts (self, config_file, mdicts)
Public Member Functions inherited from MultiOrderedConfigParser
	add_default (self, key, template_keys=None)
	add_include (self, filename, parser=None)
	add_section (self, key, template_keys=None, mdicts=None)
	default (self, key)
	defaults (self)
	find_value (self, sections, key)
	get (self, section, key)
	get_defaults (self, key)
	get_sections (self, key, attr='_sections', searched=None)
	includes (self)
	multi_get (self, section, key_list)
	section (self, key)
	sections (self)
	set (self, section, key, val)

Data Fields
	cnx

Protected Attributes
	_sections
	_tablename
Protected Attributes inherited from MultiOrderedConfigParser
	_defaults
	_includes
	_parent
	_sections

Static Protected Attributes
str	_tablename = "sippeers"

Additional Inherited Members
Protected Member Functions inherited from MultiOrderedConfigParser
	_read (self, config_file, sect)

Detailed Description

Definition at line 13 of file sqlconfigparser.py.

Constructor & Destructor Documentation

__init__()

__init__	(		self,
			tablename = "sippeers"
	)

Reimplemented from MultiOrderedConfigParser.

Definition at line 17 of file sqlconfigparser.py.

    def __init__(self,tablename="sippeers"):
        self._tablename=tablename
        MultiOrderedConfigParser.__init__(self)
 

Member Function Documentation

connect()

connect	(		self,
			user,
			password,
			host,
			port,
			database
	)

Definition at line 21 of file sqlconfigparser.py.

    def connect(self, user, password, host, port, database):
        self.cnx = MySQLdb.connect(user=user,passwd=password,host=host,port=int(port),db=database)
 

read()

read	(		self,
			filename,
			sect = None
	)

Parse configuration information from a file

Reimplemented from MultiOrderedConfigParser.

Definition at line 24 of file sqlconfigparser.py.

    def read(self, filename, sect=None):
        MultiOrderedConfigParser.read(self, filename, sect)
        # cursor = self.cnx.cursor(dictionary=True)
        cursor = self.cnx.cursor(cursorclass=MySQLdb.cursors.DictCursor)
        cursor.execute("SELECT * from `" + MySQLdb.escape_string(self._tablename) + "`")
        rows = cursor.fetchall()
 
        for row in rows:
            sect = self.add_section(row['name'])
            for key in row:
                if (row[key] != None):
                    for elem in str(row[key]).split(";"):
                        sect[key] = elem
                    #sect[key] = str(row[key]).split(";")
 

References SqlConfigParser._tablename, MultiOrderedConfigParser.add_section(), SqlConfigParser.cnx, and str.

write()

write	(		self,
			config_file
	)

Write configuration information out to a file

Reimplemented from MultiOrderedConfigParser.

Definition at line 67 of file sqlconfigparser.py.

    def write(self, config_file):
        """Write configuration information out to a file"""
        try:
            self.write_dicts(config_file, self._sections)
        except:
                print("Could not open file " + config_file + " for writing")
                traceback.print_exc()

Referenced by MultiOrderedConfigParser.write().

write_dicts()

write_dicts	(		self,
			config_file,
			mdicts
	)

Write the contents of the mdicts to the specified config file

Definition at line 39 of file sqlconfigparser.py.

    def write_dicts(self, config_file, mdicts):
        """Write the contents of the mdicts to the specified config file"""
        for section, sect_list in mdicts.iteritems():
            # every section contains a list of dictionaries
            for sect in sect_list:
                sql = "INSERT INTO "
                if (sect.get('type')[0] == "endpoint"):
                    sql += "ps_endpoints "
                elif (sect.get('type')[0] == "aor" and section != "sbc"):
                    sql += "ps_aors "
                elif (sect.get('type')[0] == "identify"):
                    sql += "ps_endpoint_id_ips"
                else:
                    continue
 
                sql += " SET `id` = " + "\"" + MySQLdb.escape_string(section) + "\""
                for key, val_list in sect.iteritems():
                    if key == "type":
                        continue
                    # every value is also a list
 
                    key_val = " `" + key + "`"
                    key_val += " = " + "\"" + MySQLdb.escape_string(";".join(val_list)) + "\""
                    sql += ","
                    sql += key_val
 
                config_file.write("%s;\n" % (sql))
 

Field Documentation

_sections

_sections

protected

Definition at line 70 of file sqlconfigparser.py.

Referenced by MultiOrderedConfigParser.add_section(), MultiOrderedConfigParser.sections(), MultiOrderedConfigParser.set(), and MultiOrderedConfigParser.write().

_tablename [1/2]

str _tablename = "sippeers"

staticprotected

Definition at line 15 of file sqlconfigparser.py.

Referenced by SqlConfigParser.read().

_tablename [2/2]

_tablename

protected

Definition at line 18 of file sqlconfigparser.py.

Referenced by SqlConfigParser.read().

cnx

cnx

Definition at line 22 of file sqlconfigparser.py.

Referenced by SqlConfigParser.read().

---

The documentation for this class was generated from the following file:

• sqlconfigparser.py