How to put a multi-row statement string into a variable? [duplicate]

Question

I want to a store a long string (specifically a SQL query) into a variable, which I'd like to have written on more row for a better readability.

I'm using Jupyter notebook on Python 3.5 (Anaconda) if that's important.

I've tried:

# SQL query

query = "
SELECT
 Sued 
,ApplicationNumber_Primary
--,ApprovedLoanAmount, ApprovedLoanDuration, ApprovedMonthlyPayment, 
,RequiredLoanDuration, RequiredMonthlyPaymentAmount, RequiredPaidAmount, RequiredCoefficientK1
,ClientFreeSources, ClientTotalIncome, ClientNetIncome, ClientTotalExpenditures 
,ClientAgeToApplicationDate, ClientFamilyStatusID, ClientEmploymentDuration, CreditExposure
,CalendarQuarter, MonthOfYear, WeekOfYear, DayOfMonth, DayOfWeek, RegionID, DistrictID, ZIPcodeID 

FROM 
dbo.vRisk
GO
"

...which does not store the string into the variable, as I'd like.

Help would be appreciated.

Of course! I thought I would just comment the statement out, but that obviously does not apply when putting it within a variable. — Stanislav Jirak
– Stanislav Jirak, Commented Apr 20, 2019 at 10:02

Patrick Artner · Accepted Answer · 2019-04-20 10:25:00Z

2

Try using triple quotes:

query = """
SELECT
 Sued 
,ApplicationNumber_Primary
--,ApprovedLoanAmount, ApprovedLoanDuration, ApprovedMonthlyPayment, 
,RequiredLoanDuration, RequiredMonthlyPaymentAmount, RequiredPaidAmount, RequiredCoefficientK1
,ClientFreeSources, ClientTotalIncome, ClientNetIncome, ClientTotalExpenditures 
,ClientAgeToApplicationDate, ClientFamilyStatusID, ClientEmploymentDuration, CreditExposure
,CalendarQuarter, MonthOfYear, WeekOfYear, DayOfMonth, DayOfWeek, RegionID, DistrictID, ZIPcodeID 

FROM 
dbo.vRisk
GO
"""

edited Apr 20, 2019 at 10:25

Patrick Artner

51.9k10 gold badges50 silver badges79 bronze badges

answered Apr 20, 2019 at 9:42

Raphael

1,8112 gold badges10 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Patrick Artner · Accepted Answer · 2019-04-20 10:32:19Z

0

Use multi-line strings or intersperse '\n' in it:

this_is_a_multiline_string = """

tata

"""

this_as_well = '''

tata

'''

and_this = "\ntata\n"

Python.org string documentation

and_like_so = ("Some string"      # no space after
               "that spans lots"  # no space after
               "of lines" )       # results in 'Some stringthat spans lotsof lines'

(Source for the last one: https://stackoverflow.com/a/10660443/7505395 )

edited Apr 20, 2019 at 10:32

answered Apr 20, 2019 at 9:41

Patrick Artner

51.9k10 gold badges50 silver badges79 bronze badges

Collectives™ on Stack Overflow

How to put a multi-row statement string into a variable? [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related