"""Model mapped to the "Genre" table
Has a custom endpoint ("styles" rather than the default, "genres").
Only supports HTTP methods specified.
Has a custom validator for the GET method.
"""
__tablename__ = 'Genre'
__endpoint__ = 'styles'
__methods__ = ('GET', 'DELETE')
@staticmethod
def validate_GET(resource=None):
"""Return False if the request should not be processed.
:param resource: resource related to current request
:type resource: :class:`sandman.model.Model` or None
"""
if isinstance(resource, list):
return True
elif resource and resource.GenreId == 1:
return False
return True
register((Artist, Album, Playlist, Track))
register(Genre)
Has a custom endpoint ("styles" rather than the default, "genres").
Only supports HTTP methods specified.
Has a custom validator for the GET method.
"""
__tablename__ = 'Genre'
__endpoint__ = 'styles'
__methods__ = ('GET', 'DELETE')
@staticmethod
# pylint: disable=invalid-name
def validate_GET(resource=None):
"""Return False if the request should not be processed.
:param resource: resource related to current request
:type resource: :class:`sandman.model.Model` or None
"""
if isinstance(resource, list):
return True
elif resource and resource.GenreId == 1:
return False
return True
register((Artist, Album, Playlist, Track, MediaType))
register(Style)
activate(browser=True)
from sandman import app, db
from sandman.model import activate
app.config['SQLALCHEMY_DATABASE_URI'] = 'monreal.sqlite'
from sandman.model import register, Model
#class Artist(Model):
# __tablename__ = 'Artist'
#class Album(Model):
# __tablename__ = 'Album'
#class Playlist(Model):
# __tablename__ = 'Playlist'
#register((Artist, Album, Playlist))
class monrent(Model):
__tablename__ = 'monrent'
class plinks(Model):
__tablename__ = 'plinks'
register((monrent, plinks))
sandman.model.activate_admin_classes
app.run()
"""Model mapped to the "Genre" table
Has a custom endpoint ("styles" rather than the default, "genres").
Only supports HTTP methods specified.
Has a custom validator for the GET method.
"""
__tablename__ = 'Genre'
__endpoint__ = 'styles'
__methods__ = ('GET', 'DELETE')
@staticmethod
def validate_GET(resource=None):
"""Return False if the request should not be processed.
:param resource: resource related to current request
:type resource: :class:`sandman.model.Model` or None
"""
if isinstance(resource, list):
return True
elif resource and resource.GenreId == 1:
return False
return True
register((Artist, Album, Playlist, Track, MediaType))
register(Genre)
activate_admin_classes()
from sandman.model import register, Model
class Artist(Model):
__tablename__ = 'Artist'
class Album(Model):
__tablename__ = 'Album'
class Playlist(Model):
__tablename__ = 'Playlist'
class Genre(Model):
__tablename__ = 'Genre'
__endpoint__ = 'styles'
__methods__ = ('GET', 'DELETE')
@staticmethod
def do_GET(resource=None):
if isinstance(resource, list):
return True
elif resource and resource.GenreId == 1:
return False
return True
register((Artist, Album, Playlist))
register(Genre)
for tr in trs:
elems = tr.find_all('font')
# Get rid of 'Credits' field.
del elems[3]
elem_vals = [course.id] + [elem.text for elem in elems]
mapped_fields = dict(map(get_co_type, zip(fields, elem_vals)))
course_offering = CourseOffering(**mapped_fields)
session.add(course_offering)
session.commit()
if __name__ == '__main__':
if len(sys.argv) > 1 and sys.argv[1] == 'initdb':
from models import init_db
init_db()
# get_all_courses()
# get_all_course_offerings()
from sandman import app
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////tmp/catalog.db'
from sandman.model import register, activate
from sandman_models import SCourse, SCourseOffering
register((SCourse, SCourseOffering))
activate(browser=True)
app.run()
return self.Title
class Playlist(Model):
__tablename__ = "Playlist"
def __str__(self):
return self.Name
class Genre(Model):
__tablename__ = "Genre"
def __str__(self):
return self.Name
class PlaylistTrack(Model):
__tablename__ = "PlaylistTrack"
class MediaType(Model):
__tablename__ = "MediaType"
def __str__(self):
return self.Name
register((Artist, Album, Playlist, Genre, Track, MediaType, PlaylistTrack))
activate_admin_classes()
class Album(Model):
__tablename__ = 'Album'
def __str__(self):
return self.Title
class Playlist(Model):
__tablename__ = 'Playlist'
def __str__(self):
return self.Name
class Genre(Model):
__tablename__ = 'Genre'
def __str__(self):
return self.Name
class MediaType(Model):
__tablename__ = 'MediaType'
def __str__(self):
return self.Name
register((Artist, Album, Playlist, Genre, Track, MediaType))
activate_admin_classes()
from sandman import app, db
app.config['SQLALCHEMY_DATABASE_URI'] = '<your DB's SQLAlchemy connection string>'
from sandman.model import register, Model
class Artist(Model):
__tablename__ = 'Artist'
class Album(Model):
__tablename__ = 'Album'
class Playlist(Model):
__tablename__ = 'Playlist'
register((Artist, Album, Playlist))
app.run()
from sandman.model import register, Model
class Track(Model):
__tablename__ = 'Track'
class Artist(Model):
__tablename__ = 'Artist'
class Album(Model):
__tablename__ = 'Album'
class Playlist(Model):
__tablename__ = 'Playlist'
class Genre(Model):
__tablename__ = 'Genre'
register((Artist, Album, Playlist, Genre, Track))
return self.Title
class Playlist(Model):
__tablename__ = 'Playlist'
def __str__(self):
return self.Name
class Type(Model):
__tablename__ = 'Genre'
def __str__(self):
return self.Name
class PlaylistTrack(Model):
__tablename__ = 'PlaylistTrack'
class MediaType(Model):
__tablename__ = 'MediaType'
def __str__(self):
return self.Name
register((Artist, Album, Playlist, Type, Track, MediaType, PlaylistTrack))
activate(admin=True)
APP_PATH = os.path.dirname(os.path.abspath(__file__))
DB_PATH = os.path.join(APP_PATH, 'db.sqlite')
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////' + DB_PATH
from sandman.model import register, activate, Model
class Poll(Model):
__tablename__ = 'poll_poll'
class Vote(Model):
__tablename__ = 'poll_vote'
class Item(Model):
__tablename__ = 'poll_item'
class User(Model):
__tablename__ = 'auth_user'
# # register can be called with an iterable or a single class
register((Poll, Vote, Item, User))
activate(browser=False)
app.run()
'insect_attractor', 'insect_regulator', 'leaf_retention', 'shade_tol',
'soil_drainage_tol', 'spread_at_maturity', 'sun_needs', 'water_needs'
]
properties_1_to_many = ['family', 'family_common_name', 'url_tags']
properties_many_to_many = [
'biochemical_material_prod', 'cultural_and_amenity_prod', 'flower_color',
'foliage_color', 'food_prod', 'fruit_color', 'layer', 'medicinals_prod',
'mineral_nutrients_prod', 'raw_materials_prod'
]
register((Actions, ActiveGrowthPeriod, Allelopathic, Animals,
BiochemicalMaterialProd, CanopyDensity, CulturalAndAmenityProd,
DroughtTol, EndemicStatus, ErosionControl, Family, FloodTol,
FoodProd, FlowerColor, FoliageColor, FruitColor, HarvestPeriod,
HumidityTol, Insects, Layer, Lifespan, LeafRetention, MedicinalsProd,
MineralNutrientsProd, Plants, RawMaterialsProd, Regions, SaltTol,
ShadeTol, SunNeeds, ToxinRemoval, Toxicity, Transactions, Users,
WaterNeeds, WindTol))
def delete_plants():
Plants.query.delete()
db.session.commit()
def process_transactions():
for transaction in Transactions.query.filter_by(ignore=False).order_by(
Transactions.id).all():
print 'transaction_type = ' + transaction.transaction_type
print 'plant_id = ' + str(transaction.plants_id)
from sandman.model import register, activate, Model
class JobSchedule(Model):
__tablename__ = "job_schedule"
class DataSources(Model):
__tablename__ = "data_sources"
register((JobSchedule, DataSources))
activate(admin=False)
"""Model mapped to the "Genre" table
Has a custom endpoint ("styles" rather than the default, "genres").
Only supports HTTP methods specified.
Has a custom validator for the GET method.
"""
__tablename__ = 'Genre'
__endpoint__ = 'styles'
__methods__ = ('GET', 'DELETE')
@staticmethod
def validate_GET(resource=None):
"""Return False if the request should not be processed.
:param resource: resource related to current request
:type resource: :class:`sandman.model.Model` or None
"""
if isinstance(resource, list):
return True
elif resource and resource.GenreId == 1:
return False
return True
register((Artist, Album, Playlist, Track, MediaType))
register(Style)
activate()
from sandman.model import register, activate, Model
class JobSchedule(Model):
__tablename__ = 'job_schedule'
class DataSources(Model):
__tablename__ = 'data_sources'
register((JobSchedule, DataSources))
activate(admin=False)
