postgis_interface.py 文件源码

def select_fromindexs(dbname,field,indexs,**kwargs):
    normal_db = False
    tablename = False

    # handling even if indexs arent in str format
    if type(indexs[0]) == int:
        indexs = [str(row) for row in indexs]

    for key,value in kwargs.iteritems():
        if key == 'size':
            size = value
        if key == 'normal_db':
            normal_db = value
        if key == 'tablename':
            tablename = value
    a,engine = make_query(dbname,tablename=tablename,normal_db=normal_db)

    stringindexs = ','.join(indexs)

    if not tablename == False:
        dbname = tablename

    # now making querry
    query = '''SELECT * FROM %s WHERE %s IN (%s);''' % (dbname,field,stringindexs)

    return pd.read_sql_query(query,engine)