#gamemodels

[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

[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

[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

[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

[xxbalamazxx]

A Great New Artist Arises

Hey, my readers, friends, and all others that causally browse this humble website. I usually don’t do this but I have been impressed with an artist I have come across. Their work is next level in the CGI Area, I figured I would show you all some of the stuff they have to offer. But before I do, let me tell you about them. The Artist goes by CynderBlue and has been growing in the CGI Community for years. Their work has grown phenomenal. A lot of their work is boarder line lifelike and those that aren't are next-level fantasy and brings creativity seldom match. CynderBlue is from the United Kingdoms and wishes to keep her name for the most part unknown as she wishes for her work to speak for herself. Though I personally believe she should get some recognition for the work she does. That being said she seems to be too humble to take credit for what she makes… She just recently opened her new website which is at Cynderblue.com and has begun to cater very high-quality models at affordable prices for everyday persons like you and me. She offers great content which I am sure is going to expand rather fast. Not only that, for indie devs like myself that dabble in game development she is releasing affordable prices to help us get ahead. At a minimum, you should drop by and leave a comment and or a review on her stuff. Let her know she is appreciated. If you are a dev like me, show your support, buy a product and item and leave her a great review! In a day where the CGI market is becoming quickly dominated by three companies, it is imperative that we keep the doors open for indies such as Cynderblue. Remember when Indie Devs, like musicians, fade away, we are left with bland vanilla which is then just forced upon us. So hats off for CynderBlue and her New Website CynderBlue.com and we all hope you succeed in your magnificent art and endeavors to entertain us. I know I look forward to seeing what you have to bring! Show Your Support and Check Out https://cynderblue.com

ArtWork

ArtWork Read the full article

[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.

[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

[deliamartellie]

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

[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.