# You should have received a copy of the GNU General Public License
# along with Sageo. If not, see <http://www.gnu.org/licenses/>
from sqlalchemy import *
from sqlalchemy.orm import *
from app.db_model.base import Base
from flask.ext.babelex import lazy_gettext, gettext, ngettext, Babel
from app import babel, app
from flask import Flask
from app.db_model.view import View
from app.model.columns.builtin import get_columns_pairs
from app.model.columns.builtin import get_columns_name
import ast
_ = lazy_gettext
column_choices = get_columns_pairs()
column_names = get_columns_name()
enum_col = Enum(*column_names)
class ViewGrouper(Base):
__tablename__ = 'view_grouper'
id = Column(Integer, primary_key=True)
column = Column(enum_col,
info={
'choices': column_choices,
'label': _(u'Column')
})
parent_id = Column(Integer, ForeignKey(View.id), nullable=False)
view = relationship(View, backref='view_grouper')
def get_columns_choices(self):
return get_columns_pairs(self.__view.datasource)
from sqlalchemy import *
from sqlalchemy.orm import *
from app.db_model.base import Base
from flask.ext.babelex import lazy_gettext, gettext, ngettext, Babel
from app import babel, app
from flask import Flask
from app.db_model.view import View
from app.model.columns.builtin import get_columns_pairs
from app.model.columns.builtin import get_columns_name
import ast
_ = lazy_gettext
sort_option = {'0': 'Ascending', '1': 'Descending'}
column_choices = get_columns_pairs()
column_names = get_columns_name()
enum_col = Enum(*column_names)
enum_sorter_options = Enum(*sort_option.keys())
class ViewSorter(Base):
__tablename__ = 'view_sorter'
id = Column(Integer, primary_key=True)
column = Column(enum_col, info={'choices':column_choices} )
sorter_option = Column(enum_sorter_options, info={'choices':sorted(sort_option.items())})
parent_id = Column(Integer, ForeignKey(View.id), nullable=False)
view = relationship(
View,
backref = 'view_sorter'
)
def get_columns_choices(self):
return get_columns_pairs(self.__view.datasource)
