open All Channels
seplocked EVE Technology Lab
blankseplocked Incarna Static Data Export and first Conversion
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Krathos Morpheus
Legion Infernal
Posted - 2011.07.02 11:05:00 - [1]
 

The original Data Export can be found here:
http://content.eveonline.com/data/Incarna_1.0_43729_db.zip
(Thanks to Mintoko for noticing it)

My first conversion: SQLite
http://eve-files.com/dl/245054

It is the first time I make the conversion and have not tested it yet, hope it's useful for someone.

Thart
U.K.R.A.I.N.E
SOLAR FLEET
Posted - 2011.07.02 14:04:00 - [2]
 

Thank you!
Downloading and going to test it.

Thart
U.K.R.A.I.N.E
SOLAR FLEET
Posted - 2011.07.02 15:21:00 - [3]
 

Edited by: Thart on 02/07/2011 17:12:14
Devs heavily changed data types in the database. And my app doesn't work with it. Seems like a great piece of work waiting for me this weekend ;)

Thart
U.K.R.A.I.N.E
SOLAR FLEET
Posted - 2011.07.02 17:43:00 - [4]
 

Originally by: Thart
Devs heavily changed data types in the database. And my app doesn't work with it. Seems like a great piece of work waiting for me this weekend ;)

I was wrong. Seems like this conversion is inaccurate.
Compare it with previous conversions to see the difference.

Krathos Morpheus
Legion Infernal
Posted - 2011.07.02 18:37:00 - [5]
 

Originally by: Thart
Originally by: Thart
Devs heavily changed data types in the database. And my app doesn't work with it. Seems like a great piece of work waiting for me this weekend ;)

I was wrong. Seems like this conversion is inaccurate.
Compare it with previous conversions to see the difference.
What do you mean? SQLite have very few datatypes compared to MSsql, in reality it has only five storage classes. I guess the converter may simplify some of the names but in the end the ground types are the same and should not break your software. Am I wrong? If so please explain how so, I'm only recently learning all this and would like to know, I could also poke the software author a little and have a better conversion next time if it's important. In my case is the get method that specifies the data type.

Thart
U.K.R.A.I.N.E
SOLAR FLEET
Posted - 2011.07.02 18:49:00 - [6]
 

Originally by: Krathos Morpheus
What do you mean? SQLite have very few datatypes compared to MSsql, in reality it has only five storage classes. I guess the converter may simplify some of the names but in the end the ground types are the same and should not break your software. Am I wrong? If so please explain how so, I'm only recently learning all this and would like to know, I could also poke the software author a little and have a better conversion next time if it's important. In my case is the get method that specifies the data type.

Yes, sqlite has only 5 internal datatypes.
But each of these types can be used with different aliases. And these aliases can be important for the caller.

For instance, if you "describe" invTypes table you will see that typeID has "integer" type. In previous conversion it was "int".

SQLiteDataReader treats "integer" type as 64-bit and "int" as 32-bit.

Your invTypes:
Quote:
-- Describe INVTYPES
CREATE TABLE [invTypes] (
"typeID" integer NOT NULL,
"groupID" smallint,
"typeName" nvarchar(100) COLLATE NOCASE,
"description" nvarchar(3000),
"graphicID" integer,
"radius" float,
"mass" float,
"volume" float,
"capacity" float,
"portionSize" integer,
"raceID" smallint,
"basePrice" numeric,
"published" bit,
"marketGroupID" smallint,
"chanceOfDuplicating" float,
"iconID" integer,
PRIMARY KEY ([typeID])
)


Expected invTypes:
Quote:
-- Describe INVTYPES
CREATE TABLE "invTypes" (
"typeID" int(11) NOT NULL,
"groupID" smallint(6) DEFAULT NULL,
"typeName" varchar(100) DEFAULT NULL,
"description" varchar(3000) DEFAULT NULL,
"graphicID" smallint(6) DEFAULT NULL,
"radius" double DEFAULT NULL,
"mass" double DEFAULT NULL,
"volume" double DEFAULT NULL,
"capacity" double DEFAULT NULL,
"portionSize" int(11) DEFAULT NULL,
"raceID" tinyint(3) DEFAULT NULL,
"basePrice" double DEFAULT NULL,
"published" tinyint(1) DEFAULT NULL,
"marketGroupID" smallint(6) DEFAULT NULL,
"chanceOfDuplicating" double DEFAULT NULL,
"iconID" smallint(6) DEFAULT NULL,
PRIMARY KEY ("typeID")
)

Krathos Morpheus
Legion Infernal
Posted - 2011.07.02 18:53:00 - [7]
 

I see... so some software uses the aliases to establish the data type. Thanks.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only