Hi, I was just trying to understand why these print out (or log) and what controls this. That is, is there a way the client can direct them to go to a log directory? Or do they already do that? Is there a log name for them that has a level control that would turn them on and off (Debug/Info etc)?
Cheers, Rich On Mon, Nov 26, 2018 at 3:40 PM Mike Bayer <[email protected]> wrote: > These are all commands that the SQLAlchemy Pymysql dialect emits to > the database the first time it connects, and they are normal. > > What is the actual problem you are trying to solve ? > On Mon, Nov 26, 2018 at 1:18 PM Richard Katz <[email protected]> > wrote: > > > > Hi, > > > > I see the following messages during initialization of the engine. I'm > using pymysql. > > > > SHOW VARIABLES LIKE 'sql_mode' > > SELECT VERSION() > > SELECT DATABASE() > > SELECT @@transaction_isolation > > show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin' > > SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1 > > SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1 > > SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE > utf8_bin AS anon_1 > > > > It appears on the 1st call to set up the engine, I get this series of > messages back. > > > > I have the following command > > > > engine = sqlalchemy.create_engine(self.connstring) > > > > I have tried: create_engine(self.connstring, echo_pool=False, echo=False) > > > > I traced this down to self.__connect(first_connect_check=True) > > > > It calls base.__init__ which calls raw_connection > > - which calls base._wrap_poop_connect > > - which calls pool.unique_connection > > - which calls pool._checkout > > - _wrap_pool_connect > > - pool._do_get > > - starts to return: self._create_connection() > > - to return: _ConnectionRecord(self) > > - _ConnectionRecord __init__: > > calls > > - pool self.__connect( first_connect_check=True) > > calls pymysql Connect > > returns self.dbapi.connect(*cargs, **cparams) <- cparams contains > the connection string parameters. > > returns dialect.connect(*cargs, **cparams) > > > > to pool 671: connection = pool._invoke_creator(self) > > > > pool 679 if first_connect_check: > > 681 exec_once(self.connection, self) > > > > > > attr exec_once which is from _CompoundListener _ListenerCollection: > <sqlalchemy.event.attr._ListenerCollection object at 0x0000014EDA188748> > > > > executes a function fn which goes to langhelpers go if once: > > > > where once contains: > > > > <class 'list'>: [<function > DefaultEngineStrategy.create.<locals>.first_connect at 0x000001B3A579E598>] > > > > dialect.initialize > > > > It then calls self._detect_sql_mode(connection) > > > > which prints the line: SHOW VARIABLES LIKE 'sql_mode' and > > > > SHOW VARIABLES LIKE 'sql_mode' > > SELECT VERSION() > > SELECT DATABASE() > > SELECT @@transaction_isolation > > show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin' > > SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1 > > SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1 > > SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE > utf8_bin AS anon_1 > > > > I'm guessing there must be some switch in PyMySQL - but I don't know. > > > > > > Thanks for any help. > > > > Cheers, > > > > Rich > > > > -- > > SQLAlchemy - > > The Python SQL Toolkit and Object Relational Mapper > > > > http://www.sqlalchemy.org/ > > > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > > --- > > You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > To post to this group, send email to [email protected]. > > Visit this group at https://groups.google.com/group/sqlalchemy. > > For more options, visit https://groups.google.com/d/optout. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- *Richard Katz* [email protected] (415) 336-9559 https://www.linkedin.com/in/richardkatz/ [email protected] -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
