跳到主要內容

Python-資料庫-mongodb-pymongo

Python
資料庫
mongodb-pymongo

安裝：
linux、mac：pip3 install pymongo
windows：

import pymongo

client = pymongo.MongoClient("mongodb://localhost:27017/")
db = client['demo_db']
col = db['demo_col']

dict1 = { "name": "ab123ab456g", "day": "1890-04-05" }
result = col.insert_one(dict1) 

dict2 = [
  { "name": "ki", "day": "1666-1-1"},
  { "name": "aa", "day": "1222-11-11"},
  { "name": "gg-gg", "day": "1333-02-22"},
  { "name": "T-T", "day": "1444-03-02"},
  { "name": "f-f", "day": "1555-01-01"}
]


result = col.insert_many(dict2)
result = col.find_one()
print(result)

results = col.find()
for result in col.find():
print(result)


results = col.find()
query = {'name':'ki'}
for result in col.find(query):
print(result)

query = {'name':'ki'}
update_query = {'$set':{'day':'1000-01-01'}}

result = col.update_many(query, update_query)

col.delete_ont(query)

for result in col.find():
print(result)

程式碼說明

匯入模組
連結資料庫
使用資料庫
使用collection，等於表格
定義單一筆資料
加入單一筆資料
定義多筆資料
加入多筆資料
搜尋一筆資料
搜尋全部資料
搜尋特定條件資料
更新資料
刪除資料
標籤：

留言

張貼留言

這個網誌中的熱門文章

Python-程式優化設計-module

class Objects, values and types CPython implementation detail:  For CPython,  The standard type hierarchy User-defined functions __doc__ The function’s documentation string, or  None  if unavailable; not inherited by subclasses Writable __name__ The function’s name Writable __qualname__ The function’s  qualified name New in version 3.3. Writable __module__ The name of the module the function was defined in, or  None  if unavailable. Writable __defaults__ A tuple containing default argument values for those arguments that have defaults, or  None  if no arguments have a default value Writable __code__ The code object representing the compiled function body. Writable __globals__ A reference to the dictionary that holds the function’s global variables — the global namespace of the module in which the function was defined. Read-only __dict__ The namespace supporting arbitrary function attributes. Writable __closure__ None ...
張貼留言
閱讀完整內容

Python-開啟檔案-excel

Python 開啟檔案 excel 安裝: linux、mac :pip3 install openpyxl、pip3 install xlwt、pip3 install xlrd windows    :之後補上 程式碼說明 2007年版後 寫入 from openpyxl import Workbook,load_workbook wb = Workbook() ws = wb.active ws1 = wb.create_sheet('Mysheet') ws2 = wb.create_sheet('Mysheet', 0) ws1.title = 'New Title' print(wb.sheetnames) ws['A4'] = 4 ws.cell(row=4, column=2, value=10) wb.save('demo.xlsx')  讀取 wb_load = load_workbook('demo.xlsx')  sheet_ranges = wb_load['Sheet'] print(sheet_ranges['A4'].value) 2007年版前 寫入 import xlwt from datetime import datetime style0 = xlwt.easyxf('font: name Times New Roman, \ color-index red, bold on',num_format_str='#,##0.00') style1 = xlwt.easyxf(num_format_str='D-MMM-YY') wb = xlwt.Workbook() ws = wb.add_sheet('A Test Sheet') ws.write(0, 0, 124, style0) ws.write(1, 0, datetime.now(), sty...
張貼留言
閱讀完整內容

python-設計模式-原型模式

python 設計模式 原型模式 import copy  class Prototype:     def __init__(self):        self.obj = {}     def Registor(self, key,new_obj):        self.obj[key] = new_obj     def UnRegistor(self, key):        del self.obj[key]    def DeepClone(self, name, **attr):        obj_clone = copy.deepcopy(self.obj.get(name))        obj_clone.__dict__.update(attr)        return obj_clone     def Clone(self, name, **attr):        obj_clone = copy.copy(self.obj.get(name))        obj_clone.__dict__.update(attr)        return obj_clone  class a:     def __init__(self):        self.name = ['a1','a2']  class b:     def __init__(self):        self.name = 'b'...
張貼留言
閱讀完整內容