connect to database
Project description
database操作(支持 mysql mongodb elasticSearch sqlite3)
How to use
mysql
connect
mysql = MySql("localhost", "root", "123456", "test")
insert
# insert into test values(1,'Mike','male')
mysql.insert_one("test", columns_list=[1, "Mike", "male"])
# insert into test(id,name,gender) values(1,'Mike','male')
mysql.insert_one("test", columns_dict={"id": 1, "name": "Mike", "gender": "male"})
update
# update test set id=12 where id>12
mysql.update('test', {'id': 12}, {"id": {
"compare": ">",
"value": 12
}})
# update test set id=12 where name='mike'
mysql.update('test', {'id': 12}, {"name": "mike"})
select
# select * from test;
mysql.select("test")
# select name,score,age from test;
mysql.select("test",["name","score","age"])
# select name,score,age from test where name='XiaoMing';
mysql.select("test",["name","score","age"],{'name':'XiaoMing'})
delete
# delete from test;
mysql.delete("test")
# delete from test where name='LiBai'
mysql.delete("test",{"name":"LiBai"})
mongodb
elasticSearch
sqlite3
connect
sqlite = Sqlite("localhost", "root", "123456", "test")
insert
# insert into test values(1,'Mike','male')
sqlite.insert_one("test", columns_list=[1, "Mike", "male"])
# insert into test(id,name,gender) values(1,'Mike','male')
sqlite.insert_one("test", columns_dict={"id": 1, "name": "Mike", "gender": "male"})
update
# update test set id=12 where id>12
sqlite.update('test', {'id': 12}, {"id": {
"compare": ">",
"value": 12
}})
# update test set id=12 where name='mike'
sqlite.update('test', {'id': 12}, {"name": "mike"})
select
# select * from test;
sqlite.select("test")
# select name,score,age from test;
sqlite.select("test",["name","score","age"])
# select name,score,age from test where name='XiaoMing';
sqlite.select("test",["name","score","age"],{'name':'XiaoMing'})
delete
# delete from test;
sqlite.delete("test")
# delete from test where name='LiBai'
sqlite.delete("test",{"name":"LiBai"})
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
py3db-0.0.19.tar.gz
(8.0 kB
view hashes)
Built Distribution
py3db-0.0.19-py3-none-any.whl
(11.3 kB
view hashes)