jimmyh / mypois Goto Github PK

Traceback (most recent call last):
  File "./mypois.py", line 96, in <module>
    sys.exit(main())
  File "./mypois.py", line 93, in main
    create_mypois( cfg )
  File "./mypois.py", line 73, in create_mypois
    if not skipmib2tsd: mib2tsd.read_csv(config[section])
  File "/Users/1e1/Documents/repogit/mypois/mib2tsd.py", line 113, in read_csv
    poiaddr.to_sql(name='pPoiAddressTable',con=self.conn,if_exists='append',index=False)
  File "/usr/local/lib/python3.7/site-packages/pandas/core/generic.py", line 2130, in to_sql
    dtype=dtype)
  File "/usr/local/lib/python3.7/site-packages/pandas/io/sql.py", line 450, in to_sql
    chunksize=chunksize, dtype=dtype)
  File "/usr/local/lib/python3.7/site-packages/pandas/io/sql.py", line 1481, in to_sql
    table.insert(chunksize)
  File "/usr/local/lib/python3.7/site-packages/pandas/io/sql.py", line 641, in insert
    self._execute_insert(conn, keys, chunk_iter)
  File "/usr/local/lib/python3.7/site-packages/pandas/io/sql.py", line 1270, in _execute_insert
    conn.executemany(self.insert_statement(), data_list)
OverflowError: Python int too large to convert to SQLite INTEGER

CREATE VIRTUAL TABLE poicoord USING rtree (poiid INTEGER,latmin REAL,latmax REAL,lonmin REAL,lonmax REAL);
CREATE TABLE IF NOT EXISTS "poicoord_rowid"(rowid INTEGER PRIMARY KEY,nodeno);
CREATE TABLE IF NOT EXISTS "poicoord_node"(nodeno INTEGER PRIMARY KEY,data);
CREATE TABLE IF NOT EXISTS "poicoord_parent"(nodeno INTEGER PRIMARY KEY,parentnode);
CREATE TABLE poidata (poiid INTEGER,type INTEGER,namephon TEXT,ccode INTEGER,zipcode TEXT,city TEXT,street TEXT,housenr TEXT,phone TEXT,ntlimportance INTEGER,exttype TEXT,extcont TEXT,warning TEXT,warnphon TEXT,CONSTRAINT PK_poidata PRIMARY KEY (poiid));
CREATE VIRTUAL TABLE poiname USING fts3 (name TEXT);
CREATE TABLE IF NOT EXISTS 'poiname_content'(docid INTEGER PRIMARY KEY, 'c0name');
CREATE TABLE IF NOT EXISTS 'poiname_segments'(blockid INTEGER PRIMARY KEY, block BLOB);
CREATE TABLE IF NOT EXISTS 'poiname_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx));

# 
# This is the description file for the Software Update of Volkswagen components
# 
#################################################################################

[common]
skipSaveTrainName = "true"
vendor = "Delphi"
skipCheckSignatureAndVariant = "true"
region = "Europe"
region2 = "RoW"
region3 = "USA"
variant = "17245"
variant2 = "17246"
variant3 = "17250"
variant4 = "17251"
variant5 = "17247"
variant6 = "17252"
variant7 = "17254"
variant8 = "17255"
variant9 = "17268"
variant10 = "17269"
variant11 = "17270"
variant12 = "17271"
release = "2012/2013"
UserSWDL = "true"
skipMetaCRC = "true"
MetafileChecksum = "ab9032783ae6739433a0103b691a02a99f73cc95"
skipFileCopyCrc = "true"

[PersonalPOI]
VendorInfo = "Delphi"
DeviceDescription = "Personal POI Packages"

ConfigComponent = "PersonalPOI"
PacketName = "Package"
ConfigCheckPath = "../MIB2HIGH/PersonalPOI/Package/0/default"
ConfigFinalizePath = "/media/swdl/packages/PersonalPOI/Package"
IncludeModules = ",Package,"

[PersonalPOI\Package\0\default\Dir]
CheckSumSize = "524288"
CheckSum = "6184f75a6cc47d07d6dee27ff63b5b6d40340fa9"
FileSize = "7836017"
CheckType = "CheckReadData"
DeleteDestinationDirBeforeCopy = "true"
Version = "1"
UpdateOnlyExisting = "false"
IsDestinationInFFS = "false"
Source = "../../../../../MIB2HIGH/PersonalPOI/Package/0/default/"
Destination = "/media/swdl/packages/PersonalPOI/Package"
DisplayName = "Personal POIs"

[PersonalPOI\InfoFile\0\default\File]
CheckSumSize = "524288"
CheckSum = "3c52c35208731962315e14a939c031742dd90a27"
FileSize = "713"
Version = "3"
Source = "../../../../../MIB2HIGH/PersonalPOI/InfoFile/0/default/Update.txt"
Destination = "/media/swdl/packages/PersonalPOI/"
DisplayName = "Database Information"
DeleteDestinationDirBeforeCopy = "false"
UpdateOnlyExisting = "false"