![]() The program starts by importing the sqlite3 library. fetchall () for r in results : print ( r ) cursor. execute ( "SELECT Site.lat, Site.long FROM Site " ) results = cursor. connect ( "survey.db" ) cursor = connection. Agendaįor this tutorial we need to download a database that we will use for the queries. swcarpentry/sql-novice-survey, Īdaptations have been made to make this work better in a GTN/ Galaxy environment. This tutorial is significantly based on the Carpentries Databases and SQL lesson, which is licensed CC-BY 4.0.Ībigail Cabunoc and Sheldon McKay (eds): “Software Carpentry: Using Databases and SQL.” Version 2017.08, August 2017, Select the notebook that appears in the list of files on the left.Open a Terminal in JupyterLab with File -> New -> Terminal. ![]() ![]() Launching the notebook in Jupyter in Galaxy This tutorial is best viewed in a Jupyter notebook! You can load this notebook in Jupyter on one of the UseGalaxy.* servers
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |