On Tuesday, April 28, 2015 at 3:42:40 PM UTC-4, Ivan Evstegneev wrote: > > Greetings everyone!!! > > I have a little question. > > Is there some way (tool) to print the contents of the tables in sqlalchemy? >
The most straightforward way to see the contents of a table in any SQL database is to execute the command "select * from table_name;". You could do this from your command line client or by using SQLAlchemy. > > My work is mostly with python, I load data from excel files, and then view > it's contents via console (for now). > Just print the data in some organized way (like list and dictionaries). > > Recently I started to play with sqlalchemy. > > I'm looking for some kind of data visualization in order to verify the way > I put my data inside db. > > I googled a lot, but somehow have been stuck and going rounds... > > There is sqlalchemy "reflection", but while reading documentation this is > not what I'm looking for, or at least that is what it seems to me, cause > there is a lack of examples (IMHO) for newbies. > > Them I found a way, by using mysql console: > > mysql> show databases > mysql> show tables > mysql> show columns from TABLE_NAME > > Here the example of what I'm talking about: > http://i.ytimg.com/vi/XiDnK9Lq-Ng/maxresdefault.jpg (just googled some > images) > > But in order to use this I need to install additional software and so on... > It looks like the mysql client does what you need. What additional software are you referring to? If you're looking for a GUI tool for exploring and modifying a MySQL database, many exist, but SQLAlchemy isn't one of them. > > -- 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 http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
