From 4b64732ce6acdf75cf5b8469e42f15e625fee8b0 Mon Sep 17 00:00:00 2001 From: Hui Lan Date: Wed, 7 Aug 2024 11:41:02 +0800 Subject: Important files and directories --- Code/merge_edges.py | 11 +++++------ 1 file changed, 5 insertions(+), 6 deletions(-) (limited to 'Code/merge_edges.py') diff --git a/Code/merge_edges.py b/Code/merge_edges.py index 780da95..6bbd2f0 100644 --- a/Code/merge_edges.py +++ b/Code/merge_edges.py @@ -22,7 +22,7 @@ import os, operator, sys, math, datetime, glob from log import write_log_file -from configure import EDGE_POOL_DIR, MERGED_EDGE_FILE, UPDATE_NETWORK_LOG_FILE +from configure import EDGE_POOL_DIR, MERGED_EDGE_FILE, SQLITE_EDGE_FILE, UPDATE_NETWORK_LOG_FILE import sqlite3 def get_number_of_RNAseq_ids(s): @@ -210,13 +210,12 @@ fout.close() # Write edge information to SQLite database file, which could be opened using software called "DB Browser for SQLite" # Biologists may use this file for filtering the information they need. -db_fname = os.path.join(folder_path, 'edges.sqlite') -write_log_file('[merge_edges.py] Make SQLite database file %s.' % (db_fname), UPDATE_NETWORK_LOG_FILE) +write_log_file('[merge_edges.py] Make SQLite database file %s.' % (SQLITE_EDGE_FILE), UPDATE_NETWORK_LOG_FILE) -if os.path.exists(db_fname): - os.remove(db_fname) +if os.path.exists(SQLITE_EDGE_FILE): + os.remove(SQLITE_EDGE_FILE) -conn = sqlite3.connect(db_fname) +conn = sqlite3.connect(SQLITE_EDGE_FILE) c = conn.cursor() c.execute('CREATE TABLE IF NOT EXISTS edge (target_id text, target_name text, tf_id text, tf_name text, strength text, date text, method text, evidence text)') for k in d: -- cgit v1.2.1