April 2018
Beginner to intermediate
440 pages
11h 36m
English
With the connection established, we can now execute SQL statements in the Python script that will generate tables in the MapD Core instance. The following statement will create a simple table called county, with a MULTIPOLYGON geometry type, an integer id field, and three VARCHAR-type fields (or strings, as they would be called in Python):
from pymapd import connectconnection = connect(user="mapd", password= "{password}", host="{my.host.com}", dbname="mapd")cursor = connection.cursor()create = """CREATE TABLE county ( id integer NOT NULL, name VARCHAR(50), statefips VARCHAR(3), stpostal VARCHAR(3), geom MULTIPOLYGON );"""cursor.execute(create)connection.commit()
The next code block will create a table called address, with ...