Name file with sql query data

Question

Hello, I need to name each file created by the script with a data from a single column of my data bank. Follows the code:

for index, source in zip(list(range(0, len(self.sources))), self.sources):
  if self.jsonfile is not None and self.outdir is not None:
    path_file = '{}/{}_{}_{}'.format(self.outdir,datetime.now().strftime('%Y%m%d%H%M%S'), index, code[index]+'.json')

Where "code" is the data of my database column, and index is the number of the files and it will be like this:

20170920145732_0_CODE1.json

20170920145732_1_CODE2.json

20170920145732_2_CODE3.json

The starting numbers are date and time and after the first underscore comes the index, and finally comes the data from the database column.

My sql query:

sql = 'SELECT code from data.est where name = code and id = 13'