Print variable between "

[paulo79]

Hi all,

I'm trying to print variable between " (double quotes) .
Code is below:

import cx_Oracle as oracledb
import xml.etree.ElementTree as ET
def output_type_handler(cursor, name, default_type, size, precision, scale):
    if default_type == oracledb.CLOB:
        return cursor.var(oracledb.LONG_STRING, arraysize=cursor.arraysize)
    if default_type == oracledb.BLOB:
        return cursor.var(oracledb.LONG_BINARY, arraysize=cursor.arraysize)

conn = oracledb.connect("/", mode=oracledb.SYSASM)
conn.outputtypehandler = output_type_handler
prev_name = None
cursor = conn.cursor()
cursor.execute("select cellname, confval from v$cell_config where conftype='CELL' order by cellname desc")
print (cursor)
for val in cursor:
    print('"%s"' % val)
    print("\n #########################################") 

I tried {val}, [val], between commas and without but cannot get it. I would need """ (3 double quotes) at the beggining and at the end of variable output.

[ibreeden]

You forgot to tell us what the problem is. Do you get an error message? Then show the complete error message. Is the output not as expected? Then show (a sample of) the output and the desired output.

[paulo79]

Error is :

Error:
Traceback (most recent call last):
  File "<stdin>", line 2, in <module>
TypeError: not all arguments converted during string formatting
>>>

I could run using :

print ('"""', val)

But is shows all these at the beggining:

('"""', '<?xml version="1.0"

And I want only something like:

"""<?xml version="1.0" encoding="utf-8" ?>
<cli-output>
<version>1.0</version>
<timestamp>1646925662329</timestamp>
<context cell="celadm06"/>
<cell> <name>celadm06</name>
<accessLevelPerm>remoteLoginEnabled</accessLevelPerm>
<bbuStatus>normal</bbuStatus>
<cpuCount>96/96</cpuCount>
</cell>
</cli-output>"""

[paulo79]

I found a way that works:

print('"""{var}"""'.format(var=val))

[Gribouillis]

If you want to parse the xml code contained in val, you don't need the triple quote, nor do you need to print val. The triple quotes are only a syntactic token to help write LITERAL python strings. They are not part of the string itself.

>>> x = """hello world"""
>>> y = 'hello world'
>>> x == y
True

[deanhystad]

If you want to print quotes just escape the quotes to make them a normal character.

print("\"{}\"".format("Hi"))

Output:
"Hi"