pydbproperties 0.1

Store property in database, like pyjavaproperties(Property JAVA)

pydbproperties 0.1
==============
With this script, you can use store properties into a
MySQL table, you can change the name of the table, and
list the properties into a output stream or file
stream, etc.

Right now it only works with MySQL Database, I will be
working in other databases.

Dependencies:
=============
MySQL-python (1.2.3)
MysqlSimpleQueryBuilder (0.2.8)

Installation:
=============
MySQL-python has issues when installing by pip
you can install it with your package manage of
your distribution

ubuntu: sudo apt-get install python2.7-mysqldb
Centos/RHEL/Fedora: yum install MySQL-python

Once MySQL-python is installed, you can install
MysqlSimpleQueryBuilder:

pip install MysqlSimpleQueryBuilder

And now you are ready to install pydbproperties:

pip install pydbproperties

Example:
========
from pydbproperties import pydbproperties
prop = pydbproperties()
prop.set_table_name('my_table')
for b in range(5):
prop.set_property('key' + str(b), 'value' + str(b))

config = {
"host": 'localhost',
"user": 'root',
"passwd": '',
"db": 'test_pydbproperties',
}
prop.conn(**config)
# prop.load()
prop.list()
prop.set_property('key_test', 'value_test')
prop.store()
prop.list()

======================
Output:
-- listing properties --
key3=value3
key2=value2
key1=value1
key0=value0
key4=value4
-- listing properties --
key3=value3
key2=value2
key1=value1
key0=value0
key4=value4
key_test=value_test

=====================
Table in MySQL:

MariaDB [test_pydbproperties]> use test_pydbproperties
Database changed
MariaDB [test_pydbproperties]> show tables;
+-------------------------------+
| Tables_in_test_pydbproperties |
+-------------------------------+
| my_table |
+-------------------------------+
1 row in set (0.00 sec)

MariaDB [test_pydbproperties]> select * from my_table;
+----------+------------+
| key | value |
+----------+------------+
| key0 | value0 |
| key1 | value1 |
| key2 | value2 |
| key3 | value3 |
| key4 | value4 |
| key_test | value_test |
+----------+------------+
6 rows in set (0.00 sec)