import pandas as pd
import sys


df = pd.read_csv(sys.argv[1])
df.columns = [c.lower() for c in df.columns]

from sqlalchemy import create_engine
engine = create_engine('postgresql://pcawg_admin:pcawg@localhost:5432/germline_genotype_tracking')

df.to_sql("pcawg_samples", engine)
import pandas as pd
import sys


df = pd.read_csv(sys.argv[1])
df.columns = [c.lower() for c in df.columns]

from sqlalchemy import create_engine
engine = create_engine('postgresql://pcawg_admin:pcawg@run-tracking-db.service.consul:5432/germline_genotype_tracking')

df.to_sql("pcawg_samples", engine)
Use Tracking DB Service URL rather than localhost in the DB connection string.
Use Tracking DB Service URL rather than localhost in the DB connection string.

  import pandas as pd
  import sys
  
  
  df = pd.read_csv(sys.argv[1])
  df.columns = [c.lower() for c in df.columns]
  
  from sqlalchemy import create_engine
- engine = create_engine('postgresql://pcawg_admin:pcawg@localhost:5432/germline_genotype_tracking')
+ engine = create_engine('postgresql://pcawg_admin:pcawg@run-tracking-db.service.consul:5432/germline_genotype_tracking')
  
  df.to_sql("pcawg_samples", engine)
Use Tracking DB Service URL rather than localhost in the DB connection string.
## Code Before:
import pandas as pd
import sys


df = pd.read_csv(sys.argv[1])
df.columns = [c.lower() for c in df.columns]

from sqlalchemy import create_engine
engine = create_engine('postgresql://pcawg_admin:pcawg@localhost:5432/germline_genotype_tracking')

df.to_sql("pcawg_samples", engine)
## Instruction:
Use Tracking DB Service URL rather than localhost in the DB connection string.
## Code After:
import pandas as pd
import sys


df = pd.read_csv(sys.argv[1])
df.columns = [c.lower() for c in df.columns]

from sqlalchemy import create_engine
engine = create_engine('postgresql://pcawg_admin:pcawg@run-tracking-db.service.consul:5432/germline_genotype_tracking')

df.to_sql("pcawg_samples", engine)