fstring

433 ワード

st_geomfromtext = "st_geomfromtext('point(%s %s)',4326)"
insert_sql = f"insert into poi_hn_prd ({util.list_join(to_fields, ',')}) 
values({'%s,' * (len(to_fields) - 1) + st_geomfromtext})"
  limit                   
f"select {util.list_join(from_fields, ',')} from poi_hn_edit 
ORDER BY hn_id limit {page_size} offset {start}"