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()
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()
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())
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()
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()
def get_db_urls(conn, number): db_results = db.DbOperation(conn=conn, sample_id=number).db_select() return db_results
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()