Python DbOperation 예제들

예제 #1

파일: download_taggingxml.py 프로젝트: vitomuzi/deepsight2.0-ai

def update_picture_xml(conn, number, all_lists):
    for all_list in all_lists:
        db.DbOperation(conn=conn,
                       sample_id=number,
                       url=all_list['imageUrl'],
                       xml_downloaded=1,
                       xml_name=all_list['picture_name'],
                       xml_url=all_list['imageXML']).db_update_xml()

예제 #2

파일: tagginghandle.py 프로젝트: vitomuzi/deepsight2.0-ai

def update_picture_analysis(conn, number, all_lists):
    for all_list in all_lists:
        db.DbOperation(conn=conn,
                       sample_id=number,
                       start_time=all_list['start_time'],
                       finish_time=all_list['finish_time'],
                       duration=all_list['duration'],
                       is_completed=1,
                       result=all_list['result'],
                       image_name=all_list['image_name']).db_update_results()

예제 #3

import os
import sys
import pymysql

# 确保单独执行该脚本时，能够引入其他模块以及django的环境变量
BASE_DIR = os.path.dirname(os.path.dirname(os.path.dirname(os.getcwd())))
sys.path.append(BASE_DIR)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "environconfig.settings.local")
from django.conf import settings
from deepsight.db import db

db_connect = pymysql.connect(host=settings.DB_HOST,
                             user=settings.DB_USERNAME,
                             password=settings.DB_PASSWORD,
                             db=settings.DB_DATABASE,
                             port=settings.DB_PORT,
                             charset='utf8mb4')
# db.DbOperation().db_select()
print(db.DbOperation(conn=db_connect, sample_id="HN0004").db_select())

예제 #4

import os
import sys
import pymysql

# 确保单独执行该脚本时，能够引入其他模块以及django的环境变量
BASE_DIR = os.path.dirname(os.path.dirname(os.path.dirname(os.getcwd())))
sys.path.append(BASE_DIR)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "environconfig.settings.local")
from django.conf import settings
from deepsight.db import db

db_connect = pymysql.connect(host=settings.DB_HOST,
                             user=settings.DB_USERNAME,
                             password=settings.DB_PASSWORD,
                             db=settings.DB_DATABASE,
                             port=settings.DB_PORT,
                             charset='utf8mb4')

for i in ["1", "2", "3", "5", "4", "6", "10"]:
    db.DbOperation(conn=db_connect,
                   sample_id="HN0003",
                   url=i,
                   image_name="wulei").db_insert()

예제 #5

파일: test_db_update_xml.py 프로젝트: vitomuzi/deepsight2.0-ai

import os
import sys
import pymysql

# 确保单独执行该脚本时，能够引入其他模块以及django的环境变量
BASE_DIR = os.path.dirname(os.path.dirname(os.path.dirname(os.getcwd())))
sys.path.append(BASE_DIR)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "environconfig.settings.local")
from django.conf import settings
from deepsight.db import db

db_connect = pymysql.connect(host=settings.DB_HOST,
                             user=settings.DB_USERNAME,
                             password=settings.DB_PASSWORD,
                             db=settings.DB_DATABASE,
                             port=settings.DB_PORT,
                             charset='utf8mb4')

db.DbOperation(
    conn=db_connect,
    sample_id="HN0004",
    url="http://192.168.1.32:9000/images/tag/04.jpg",
    xml_downloaded=1,
    xml_name="/opt/images",
    xml_url="http://192.168.1.32:9000/images/tag/03.xml").db_update_xml()

예제 #6

파일: download_taggingxml.py 프로젝트: vitomuzi/deepsight2.0-ai

def get_db_urls(conn, number):
    db_results = db.DbOperation(conn=conn, sample_id=number).db_select()
    return db_results

예제 #7

import os
import sys
import pymysql

# 确保单独执行该脚本时，能够引入其他模块以及django的环境变量
BASE_DIR = os.path.dirname(os.path.dirname(os.path.dirname(os.getcwd())))
sys.path.append(BASE_DIR)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "environconfig.settings.local")
from django.conf import settings
from deepsight.db import db

db_connect = pymysql.connect(host=settings.DB_HOST,
                             user=settings.DB_USERNAME,
                             password=settings.DB_PASSWORD,
                             db=settings.DB_DATABASE,
                             port=settings.DB_PORT,
                             charset='utf8mb4')

db.DbOperation(conn=db_connect,
               sample_id="HN0004",
               start_time="2020-01-08 09:18:04",
               finish_time="2020-01-08 10:24:43",
               duration=457,
               is_completed=1,
               result="[13,243],[53,65]",
               image_name="wulei").db_update_results()