A usage example of JsonDB-PHP开发-php.cn

JsonDB is a lightweight database open source project based on JSON format implemented in python. You can download and install it through github. The project address is: https://github.com/hujiang001/jsonDB/.

The author provides a complete reference document, and it is in Chinese, so it is very easy to get started. This is the address of his Chinese document: https://github.com/hujiang001/jsonDB/wiki/reference-document. Currently, this document is also included in the project project: reference.md.

The project also provides an example of use. In example.py, let’s paste this example below. There are detailed comments on it. It can be seen that it is quite simple to use:

#!usr/bin/env python# -*- coding: utf-8 -*-from database import JSONDBif __name__=="__main__": shopDb = JSONDB('shop_db',hashSize=1) #create shop db userDb = JSONDB('sellerDb',hashSize=1) #create user db #specify key shopDb.ensureKey('shop',['id']) shopDb.ensureKey('goods',['id']) userDb.ensureKey('seller',['id','name']) userDb.ensureKey('customer',['id','name']) #for debugging, you can start perfDot and open debug switch shopDb.perfDotStart() userDb.perfDotStart() shopDb.debugSwitch(1) userDb.debugSwitch(1) #insert data #here we insert some data for i in range(0,100): #insert data one by one shopDb.insert('shop',[{'id':i, 'name':'my shop', 'description':'this is a telephone shop'}]) #inset a data list goodsList = [{'id':10001, 'class':'telephone', 'brand':'apple', 'color':'white'}, {'id':10002, 'class':'telephone', 'brand':'huawei', 'color':'black'}, {'id':10003, 'class':'telephone', 'brand':'zte', 'color':'white'}, {'id':10004, 'class':'telephone', 'brand':'xiaomi', 'color':'black'}, {'id':10005, 'class':'telephone', 'brand':'moto', 'color':'white'}, {'id':10006, 'class':'telephone', 'brand':'oppo', 'color':'black'},] shopDb.insert('goods',goodsList) sellersList = [{'id':0x34200,'name':'li','sex':'female','birth':'1985-09-03','tel':'0816-19876545432'}, {'id':0x34201,'name':'wang','sex':'male','birth':'1988-11-03','tel':'0816-2345453453'}, {'id':0x34202,'name':'hong','sex':'female','birth':'1995-10-19','tel':'0816-144567589'}] userDb.insert('seller',sellersList) customersList = [{'id':0x7800,'name':'zhu','sex':'female','profile':['dress','mother','sport']}, {'id':0x7801,'name':'rong','sex':'male','profile':['baby','read','tech']}, {'id':0x7802,'name':'guo','sex':'female','profile':['phone','dress','food']}] userDb.insert('customer',customersList) #export to default file shopDb.exportToFile() userDb.exportToFile(fileName='user') #find # find with key findList = shopDb.find('goods',filter={'id':{'$lt':10004}}) JSONDB.rprint(findList) findList = shopDb.find('goods',filter={'id':10004}) JSONDB.rprint(findList) findList = userDb.find('customer',filter={'name':'guo'}) JSONDB.rprint(findList) #delete shopDb.delete('goods',{'id':10005}) #update shopDb.update('goods',set={'class':'phone'}) #merge shopDb.merge(userDb) shopDb.exportToFile('mergeDb') #show pref time shopDb.perfDotEnd() userDb.perfDotEnd() #import importDb = JSONDB('importDb') importDb.debugSwitch(1) importDb.importFromFile(fileName='mergeDb') #importDb.printAll() importDb.exportToFile() print importDb

Copy after login