These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
Previous page12
 

The SDE for Galatea 1.0 is now available

First post First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#21 - 2015-08-27 19:49:54 UTC
I've corrected it in my conversion process.

(unless someone really wants it, I'll leave it till the next patch?)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Legedric Striker
State War Academy
Caldari State
#22 - 2015-08-28 05:45:20 UTC
Anyone knows what happened to tables certcerts and certskills? They were in there until last patch but now vanished?

Perhaps I missed something as I am not that active in EVE at the moment ;)

EVE-Skillplan.net - Plan your pilot skill training online on PC, Mac, tablet or smartphone!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#23 - 2015-08-28 11:56:30 UTC
Legedric Striker wrote:
Anyone knows what happened to tables certcerts and certskills? They were in there until last patch but now vanished?

Perhaps I missed something as I am not that active in EVE at the moment ;)



certCerts? and certSkills?

Those are tables I put together from the yaml. Not official tables. (They're in my conversion. It's case sensitive on most platforms.)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Legedric Striker
State War Academy
Caldari State
#24 - 2015-08-28 17:18:01 UTC
Ok but they were included in the mySQL conversion and when I downloaded it today they were not ;)

EVE-Skillplan.net - Plan your pilot skill training online on PC, Mac, tablet or smartphone!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#25 - 2015-08-28 18:13:58 UTC
Legedric Striker wrote:
Ok but they were included in the mySQL conversion and when I downloaded it today they were not ;)



uhh...

oops?

I know what happened. Must not have run that conversion script the second time. (I had a script failure due to a change, so needed to rebuild it. And must have not run that one Sad)

Sorry about that.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Chloe Westminstrel
Federal Defense Union
Gallente Federation
#26 - 2015-09-08 09:48:46 UTC
The postgresql conversion seems to be missing Primary Key constraints. Aegis dump was working correctly, but in the Galatea version the pk's are defined only as UNIQUE.
Zifrian
The Frog Pond
Ribbit.
#27 - 2015-09-08 11:37:42 UTC
Steve Ronuken wrote:
Ydnari wrote:
Steve Ronuken wrote:
mysql
https://www.fuzzwork.co.uk/dump/mysql56-galatea-1.114618.tbz2
sqlite
https://www.fuzzwork.co.uk/dump/galatea-1.114618/eve.db.bz2
Postgres
https://www.fuzzwork.co.uk/dump/galatea-1.114618/postgres-galatea-1.114618.dmp.bz2
MS SQL
https://www.fuzzwork.co.uk/dump/galatea-1.114618/galatea-1.114618.bak.bz2
other stuff
https://www.fuzzwork.co.uk/dump/galatea-1.114618/


Conversion was done with:
https://github.com/fuzzysteve/SDE-loaders

The mysql migration toolkit
A mysql > sqlite conversion script
pgloader (from mysql)

It's getting there. Smile

Some datatypes may have changed a bit, as the conversion process is different. Just be aware. Translation data is loaded back into trnTranslations.

The scripts on github load everything into an SQL server DB. (that's why there's an mssql db backup there now)


Hmm - industryActivityMaterials.consume appears to have disappeared.



It stopped being in the SDE a while ago. I just had it auto fill with 1.

With the change in process, I didn't bother filling it in again.

I noticed you did this too. I took a different approach and kept it but marked skills as 0. It was really just to maintain my old code but worth a thought to include.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#28 - 2015-09-08 16:39:37 UTC
Chloe Westminstrel wrote:
The postgresql conversion seems to be missing Primary Key constraints. Aegis dump was working correctly, but in the Galatea version the pk's are defined only as UNIQUE.



I'll see about poking sqlalchemy for the next one, to make it create appropriately.

(the php conversion process involved me precreating the tables with handcrafted sql. The python one uses sqlalchemy to create as needed.)

I had a few problems with pgloader, which may have been related.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Previous page12