Store property in database, like pyjavaproperties(Property JAVA)
Project description
pydbproperties 0.3
==============
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)
==============
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)
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pydbproperties-0.3.tar.gz
(7.5 kB
view hashes)
Built Distribution
pydbproperties-0.3-py2.7.egg
(11.2 kB
view hashes)