#gamemodeler

[paburoviii]

#freelancer work a #wizard #hat made for an #RPG #ARGame made with #ZBrush #Maya #substance3dpainter and #marmosettoolbag

#3d #3dart #3dartist #gameart #lowpoly #videogame #game #medieval #fantasy #pbr #pbrtexture #games #loftr #gandalf #magician #antique #old #3dmodel #gamemodel #unity #unreal

[codehunter]

Python/SQL Alchemy Migrate - "ValueError: too many values to unpack" when migrating changes in db

I have several models in SQLAlchemy written and I just started getting an exception when running my migrate scripts: ValueError: too many values to unpack

Here are my models:

from app import dbROLE_USER = 0ROLE_ADMIN = 1class UserModel(db.Model): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(25), index=True) password = db.Column(db.String(50)) email = db.Column(db.String(50), index=True, unique=True) role = db.Column(db.SmallInteger, default=ROLE_USER) def __repr__(self): return '<User %r>' % (self.username)class ConferenceModel(db.Model): __tablename__ = 'conference' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(40), index=True, unique=True) teams = db.relationship('TeamModel', backref='conference', lazy='dynamic') def __repr__(self): return '<Conference %r>' % (self.name)class TeamModel(db.Model): __tablename__ = 'team' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), index=True, unique=True) conference_id = db.Column(db.Integer, db.ForeignKey('conference.id')) players = db.relationship('PlayerModel', backref='team', lazy='dynamic') def __repr__(self): return '<Team %r>' % (self.name)class PlayerModel(db.Model): __tablename__ = 'player' id = db.Column(db.Integer, primary_key=True) season = db.Column(db.String(4), index=True) name = db.Column(db.String(75), index=True) number = db.Column(db.String(3)) position = db.Column(db.String(4)) height = db.Column(db.Integer) weight = db.Column(db.Integer) academic_class = db.Column(db.String(2)) hometown = db.Column(db.String(40)) status = db.Column(db.SmallInteger) team_id = db.Column(db.Integer, db.ForeignKey('team.id')) def __repr__(self): return '<player %r>' % (self.name)class GameModel(db.Model): __tablename__ = 'game' id = db.Column(db.Integer, primary_key=True) espn_id = db.Column(db.Integer, index=True) date_time = db.Column(db.DateTime) location = db.Column(db.String(100)) home_final = db.Column(db.Integer) away_final = db.Column(db.Integer) game_type = db.Column(db.Integer) season = db.Column(db.Integer) home_team_id = db.Column(db.Integer, db.ForeignKey('team.id')) away_team_id = db.Column(db.Integer, db.ForeignKey('team.id')) home_team = db.relationship("TeamModel", backref="homegames", foreign_keys=[home_team_id]) away_team = db.relationship("TeamModel", backref="awaygames", foreign_keys=[away_team_id])class ScoreDataModel(db.Model): __tablename__ = 'scoredata' id = db.Column(db.Integer, primary_key=True) starter = db.Column(db.Boolean) minutes_played = db.Column(db.Integer) field_goals_made = db.Column(db.Integer) field_goals_attempted = db.Column(db.Integer) three_pointers_made = db.Column(db.Integer) three_pointers_attempted = db.Column(db.Integer) free_throws_made = db.Column(db.Integer) free_throws_attempted = db.Column(db.Integer) offensive_rebounds = db.Column(db.Integer) rebounds = db.Column(db.Integer) assists = db.Column(db.Integer) steals = db.Column(db.Integer) blocks = db.Column(db.Integer) turnovers = db.Column(db.Integer) personal_fouls = db.Column(db.Integer) points = db.Column(db.Integer) # Added the columns below and the migrate script blew up... # I've taken them out and added other columns, but the error still presents player_id = db.Column(db.Integer, db.ForeignKey('player.id')) game_id = db.Column(db.Integer, db.ForeignKey('game.id')) player = db.relationship("PlayerModel", backref="boxscores") game = db.relationship("GameModel", backref="boxscore")

Here is my migrate script (this was taken frmo Miguel Grinberg's Mega Flask tutorial):

#!flask/bin/pythonimport impfrom migrate.versioning import apifrom app import dbfrom config import SQLALCHEMY_DATABASE_URIfrom config import SQLALCHEMY_MIGRATE_REPOmigration = SQLALCHEMY_MIGRATE_REPO + '/versions/%03d_migration.py' % (api.db_version(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO) + 1)tmp_module = imp.new_module('old_model')old_model = api.create_model(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)exec old_model in tmp_module.__dict__script = api.make_update_script_for_model(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, tmp_module.meta, db.metadata)open(migration, "wt").write(script)api.upgrade(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO)print 'New migration saved as ' + migrationprint 'Current database version: ' + str(api.db_version(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO))

And here is the traceback:

/Users/johncaine/anaconda/bin/python /Volumes/Spano/Dropbox/Dropbox/eclipse-workspace/CAUDLE/src/caudle/caudle/db_migrate.pyTraceback (most recent call last): File "/Volumes/Spano/Dropbox/Dropbox/eclipse-workspace/CAUDLE/src/caudle/caudle/db_migrate.py", line 11, in <module> script = api.make_update_script_for_model(SQLALCHEMY_DATABASE_URI, SQLALCHEMY_MIGRATE_REPO, tmp_module.meta, db.metadata) File "<string>", line 2, in make_update_script_for_model File "/Users/johncaine/anaconda/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 89, in catch_known_errors return f(*a, **kw) File "<string>", line 2, in make_update_script_for_model File "/Users/johncaine/anaconda/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 159, in with_engine return f(*a, **kw) File "/Users/johncaine/anaconda/lib/python2.7/site-packages/migrate/versioning/api.py", line 321, in make_update_script_for_model engine, oldmodel, model, repository, **opts) File "/Users/johncaine/anaconda/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 69, in make_update_script_for_model genmodel.ModelGenerator(diff,engine).genB2AMigration() File "/Users/johncaine/anaconda/lib/python2.7/site-packages/migrate/versioning/genmodel.py", line 197, in genB2AMigration for modelCol, databaseCol, modelDecl, databaseDecl in td.columns_different:ValueError: too many values to unpack

I believe the only change I made was adding the ScoreDataModel when this started blowing up. I can't seem to follow back to where I can fix this.

https://codehunter.cc/a/flask/python-sql-alchemy-migrate-valueerror-too-many-values-to-unpack-when-migrating-changes-in-db

[deliamartellie]

Need inspiration for your avatar? Read on to find some awesome Roblox avatars!

[strawberrywafflez]

Here is QuickBMS and all available scripts

NifSkope 

Noesis

also just some random possibilities! even areas are possible

I’m just someone who randomly likes to rip from my favorite games so I’m not extremely knowledged and there may be easier ways to go about it but this is the way I learned :) but hope this helps some and is understandable!  @that-wizard-oki

[pokechars]

Warden Baoba, model from “Pokemon Let’s Go: Pikachu/Eevee”. When I think about things that LGPE did right (not much of this stuff, indeed), Baoba’s design is definitely one of them. I was afraid they’d just use a generic model for him but fortunately, GF did remember that they gave the Warden his one-off overworld sprite back in Generation I and decided to give him a full design for the new Kanto remakes. The design came out as quite memorable and even somewhat reminiscent of his original RGBY sprite (though I guess it’s just my imagination, considering what Gen I overworld sprites look like). Although it’s a pity that they didn’t acknowledge his name, which they established in HGSS. And that they never released a complete artbook for LGPE (like the one for USUM). I’d definitely want to see some concept sketches for characters such as LGPE Baoba, Bill, Jessie & James, Officer Jenny, Mr. Fuji and the like. Picture courtesy of The Models Resource.

[beyondergod]

Yo! @deadbydaylight the real #QuentinSmith himself @kylegface have given you personal permission to use his likeness! Lets make it happen! #KyleGallner #DeadByDaylight #Petition #DBD #Twitter #TwitterPosts #VideoGames #Development #GameModels #Gaming #Gamers #Horror #HorrorGaming #anightmareonelmstreet #Actor #Model #Suggestions https://www.instagram.com/p/B2Bu76CFuAl/?igshid=1ostoqwp3mxw5

[speedsculpting-blog]

Day 2 4.4.19 15, maybe 20 mins. . . . . #sculpt #sculpting #zbrush #gamemodel #3d #thursday https://www.instagram.com/p/Bv0v-O1FUwW/?utm_source=ig_tumblr_share&igshid=11f7536z2hfnp

[joyganic]

Just a few snippets of how I made this stud muffin 😏 . . . . . . . . . #ZBrush #3D #3Dmodels #Art #PixoLogic #Animation #Character #Character #DigitalArt #autodeskmaya #maya #autodesk #blender3d #3DSculpture #GameModels #3DSculpt #DigitalDesign #3DDesign #CharacterDesign #ZBrushSculpt #3DArtist #3DModeling #CGI #ConceptDesign #3DArtworks #3DAnimation #blender3d #blender #zbrushcentral #maya3d (at Atlanta, Georgia) https://www.instagram.com/p/Bt3ZypKBv_K/?utm_source=ig_tumblr_share&igshid=1xqll63tg34y0

[alexvanarsdale]

A little something I've been working on. by AlexVanArsdale

[lozblockshop]

HC Magic Blocks Merry Go Round Game Model

[ajaygamedev]

I created this landmine model for my upcoming mobile fps game Ajax Town. Follow me to support development of the game #gameasset #gamemodel #3dmodeling #timelapseart #landmine #ww2 #gameprop #propdesign #3d https://www.instagram.com/p/CGXOuWvnYbI/?igshid=j5321vgf3w34

[pimplik]

W.I.P. #3dmodel #3D #3dart #gamemodel #blender #blender3d

[luanneboudier]

Finished the modelling, now for the Poly count and UV clean-up . . #zeldabotw #silentprincess #3dmodel #3d #3dmodeling #botw #gamemodel #gamedev #gamemodeling #maya2018 #maya (at Brighton)

[redrustgame]

Rocket sculpt is in, now its time for the low-poly and maps! And, of course, implementation. We'll have to do it super quickly! . . #gamemodel #rocket #sovietunion #3dsculpt #redrustgame #gamedevelopers https://www.instagram.com/p/CE3wU7hnMLP/?igshid=iw4g2kgn3mz5

[pokechars]

[FEATURE POST, a bit wordy] Top picture: Game Director from OmegaRuby/AlphaSapphire (based on Shigeru Ohmori), in-game model picture. Bottom picture: GAME FREAK Iwao from UltraSun/UltraMoon (based on Kazumasa Iwao, the game’s director), in-game VS portrait. As you probably noticed, all mainline Pokemon games feature Game Freak’s staff appearing in some location of the game. They make various remarks about the game’s features, some of them also battle the player (since BW) and the Game Director typically gives you the Diploma if you complete your Pokedex. But why am I singling out these two? Well, that’s because they are the only staff cameos so far that have their designs modelled after their real-life counterparts, rather than using generic imagery (for example, Morimoto, who battles the player in most games since BW, always uses the design of Veteran Trainer Class). But while they are based on real-life Game Freak developers, they both have traits of certain Trainer Classes (Ohmori wears Pokemaniac costume, while Iwao has a Blackbelt robe). I wonder... what are your opinions about the game authors putting themselves into the game in such straightforward way? Do you like it, or did you prefer the times when their appearances were less overt and more subtle? Nevertheless, I’m wondering how will Game Freak cameos look like in future games... Images courtesy of VG Resources.

[meinkaiser-blog1]

Blocking out is about done, its taken forever, there is so many pieces, i am going to fix some pieces and there forms, just trying to get all the pieces layed out, found a good way of low poly blocking in zbrush for body fitting armor, its a long process and it works. Loving all zbrush work flow #3dmodeling #3dmodel #gamemodel #gamecharacters #zbrush