Ejemplos de MySqlDataSouce.fetch_all_stations en Python

Ejemplo n.º 1

Archivo: map_stations.py Proyecto: nullpointer0x00/ds-sfb

class MapStations:
    def __init__(self):
        self.dao = MySqlDataSouce()

    def sf_locations_string(self):
        results = self.dao.fetch_all_stations()
        sf_coords = "[['Lat', 'Long', 'Name'],\n"
        coord_strs = []
        for row in results:
            if row[1] == 'San Francisco':
                coord_strs.append("[" + str(row[2]) + ", " + str(row[3]) +
                                  ", '" + str(row[5]) + "-" + str(row[0]) +
                                  "']")
        sf_coords += ",\n".join(coord_strs) + "]"
        return sf_coords

    def html(self):
        return HTML_FIRST_PART + self.sf_locations_string() + HTML_SECOND_PART

Ejemplo n.º 2

Archivo: experiments.py Proyecto: nullpointer0x00/ds-sfb

from database import MySqlDataSouce
import pandas as pd

dao = MySqlDataSouce()

results = dao.fetch_all_stations();
sf_coords = "[['Lat', 'Long', 'Name'],\n"
coord_strs = []
for row in results:
    if row[1] == 'San Francisco':
        coord_strs.append("[" + str(row[2]) + ", " + str(row[3]) + ", '" + str(row[5]) + "']")
sf_coords += ",\n".join(coord_strs) + "]"
print sf_coords

df = pd.read_sql("SELECT * FROM station", con=dao.get_connection())

print df.head()