SHOW COLUMNS or Get Column Names From SQLalchemy SELECT Query

18 Dec 2013

http://stackoverflow.com/questions/8947616/python-sqlalchemy-get-column-names-dynamically

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

11 Dec 2013

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}

)

Flask-Admin Foreign Key Columns Allowing Editing

11 Dec 2013 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

06 Dec 2013 Awesome site for finding the best prices on PC parts: http://pcpartpicker.com

jPanelMenu Causing Document.Ready() To Run Twice

27 Nov 2013 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>

The end result will look like:

<body>

all your code....

</div>

</body>

This page helped me figure it out: http://doctype.com/trying-jquery-wrapall-seems-wrap-content-twice

Best cArrayDataProvider Example - Yii

18 Nov 2013 http://queirozf.com/reminders/using-carraydataprovider-to-populate-a-cgridview-in-yii

Spreadsheet Parsing With Javascript

13 Nov 2013 http://oss.sheetjs.com/

Responsive Email Template

08 Nov 2013 Zurb Ink - http://zurb.com/ink/templates.php

Catch ldap_bind(): Unable to bind to server: Invalid credentials

06 Nov 2013 I used the tip from this page: http://bytes.com/topic/php/answers/600903-ldap_bind-warning-instead-false

"You can get around this if you supress warning and error messages by
putting a @ in front of the function name:

$ldapbind = @ldap_bind($ldapconn, $ldaprdn, $ldappass);"

Yii Google Chart Extension

05 Nov 2013 Here's YiiWheel's google chart wrapper extension: https://github.com/2amigos/yiiwheels/blob/master/widgets/google/WhVisualizationChart.php

I downloaded just the WhVisualizationChart file and put this in my view:

$this->widget('ext.WhVisualizationChart', array(
'visualization' => 'PieChart',
'data' => $chartDataProvider,
'options' => array(
'pieHole'=> '0.5',
'backgroundColor'=>array('fill'=>'transparent'),
),
'htmlOptions'=>array('style'=>'width:100%; height:375px'),
));

and this in my controller:

public function actionIndex()
{
$chartDataProvider = array(
array('Task', 'Hours per Day'),
array('Work', 11),
array('Eat', 2),
array('Commute', 2),
array('Watch TV', 2),
array('Sleep', 7)
);
$this->render('index', array('chartDataProvider'=>$chartDataProvider));
}

Examples on how to use it are at the bottom of this page: http://yiiwheels.2amigos.us/site/charts#visualizationchart

Older Newer