The Z Layout
I'm definitely going to use this technique on my next business site: http://design.tutsplus.com/articles/understanding-the-z-layout-in-web-design--webdesign-28Two Column Match - Flask + HandsOnTable
I'm getting more comfortable with Flask, so I decided to experiment with Google App Engine + Flask + HandsOnTable.Here's the application I made: http://twocolumnmatch.appspot.com/match
It takes the contents of the 2nd column and matches it to the rows of the first column. Just press the "Match" button to see what it does.
I've found myself doing what this application does a few times, but I manually create two python lists and compare them in IDLE. This application streamlines that process quite a bit.
Here's the code: https://github.com/pawl/2ColumnMatch
SQLalchemy - Simple Select Query
from sqlalchemy import create_engine, MetaData, Tableengine = create_engine('sqlite:///cars.db', echo=False)
metadata = MetaData(bind=engine)
table = Table('cars', metadata)
stmt = table.select()
for row in stmt.execute():
print row
Entity-Attribute-Value - Dynamic Database Columns
This page has a great example of when to use the Entity-Attribute-Value data model: http://stackoverflow.com/questions/7933596/django-dynamic-model-fieldsI'm planning to use it for an application I'm making which has user defined fields.
SHOW COLUMNS or Get Column Names From SQLalchemy SELECT Query
Rob Wouter's answer really helped me out:
You can either find the columns by calling result.keys() or you can access them through calling v.keys() inside the for loop.
Here's an example using items():
for v in result:
for column, value in v.items():
print('{0}: {1}'.format(column, value))
AttributeError: 'dict' object has no attribute '_set_parent_with_dispatch' - SQLalchemy
The documentation says: "Keyword arguments can be specified by specifying the last argument as a dictionary"
So you will need to change this:
__table_args__ = (
{'sqlite_autoincrement': True},
UniqueConstraint('filename', 'path')
)
to this:
__table_args__ = (
UniqueConstraint('filename', 'path'),
{'sqlite_autoincrement': True}
)
UniqueConstraint('filename', 'path'),
{'sqlite_autoincrement': True}
)
Flask-Admin Foreign Key Columns Allowing Editing
Make sure you have a row id number as your primary key for your child table. Having a composite primary key didn't seem to save when I was editing the form.PC Building Site
Awesome site for finding the best prices on PC parts: http://pcpartpicker.comjPanelMenu Causing Document.Ready() To Run Twice
This line in jquery.jpanelmenu.js is the cause:$('body > *').not(jP.menu + ', ' + jP.options.excludedPanelContent).wrapAll('<div class="' + 'jPanelMenu-panel' + '"/>');
You will need to comment it out and wrap everything in your body tag manually with:
<div class="jPanelMenu-panel" style="position: relative; left: 0px;">
</div>
The end result will look like:
<body>
<div class="jPanelMenu-panel" style="position: relative; left: 0px;">
all your code....
</div>
</body>
This page helped me figure it out: http://doctype.com/trying-jquery-wrapall-seems-wrap-content-twice
This page helped me figure it out: http://doctype.com/trying-jquery-wrapall-seems-wrap-content-twice