def add_schemafield(slug, name, real_name,
                    pretty_name, pretty_name_plural=None,
                    display=True, display_order=0, 
                    is_lookup=False, is_filter=False,
                    is_searchable=True, is_charted=False,
                    force=False):

    # Deliberately blows up if no such schema.
    schema = Schema.objects.filter(slug=slug)[0]

    if force:
        SchemaField.objects.filter(schema=schema, real_name=real_name).delete()

    field = SchemaField()
    field.schema = schema
    # db_attribute model. Choices are: int01-07, text01,
    # bool01-05, datetime01-04, date01-05, time01-02,
    # varchar01-05. This value must be unique with respect to the
    # schema_id.
    field.real_name = real_name

    field.name = name
    field.pretty_name = pretty_name
    if not pretty_name_plural:
        if pretty_name.endswith('s'):
            pretty_name_plural = pretty_name
        else:
            pretty_name_plural = pretty_name + 's'
    field.pretty_name_plural = pretty_name_plural
    field.display = display
    field.is_lookup = is_lookup
    field.is_filter = is_filter
    field.is_charted = is_charted
    field.display_order = display_order
    field.is_searchable = is_searchable
    field.save()
Example #2
0
def add_schemafield(slug, name, real_name,
                    pretty_name, pretty_name_plural=None,
                    display=True, display_order=0, 
                    is_lookup=False, is_filter=False,
                    is_searchable=True, is_charted=False,
                    force=False):

    # Deliberately blows up if no such schema.
    schema = Schema.objects.filter(slug=slug)[0]

    if force:
        SchemaField.objects.filter(schema=schema, real_name=real_name).delete()

    field = SchemaField()
    field.schema = schema
    # db_attribute model. Choices are: int01-07, text01,
    # bool01-05, datetime01-04, date01-05, time01-02,
    # varchar01-05. This value must be unique with respect to the
    # schema_id.
    field.real_name = real_name

    field.name = name
    field.pretty_name = pretty_name
    if not pretty_name_plural:
        if pretty_name.endswith('s'):
            pretty_name_plural = pretty_name
        else:
            pretty_name_plural = pretty_name + 's'
    field.pretty_name_plural = pretty_name_plural
    field.display = display
    field.is_lookup = is_lookup
    field.is_filter = is_filter
    field.is_charted = is_charted
    field.display_order = display_order
    field.is_searchable = is_searchable
    field.save()
if __name__ == '__main__':
    # create schema
    crime_report = Schema()
    crime_report.indefinite_article = 'a'
    crime_report.name = "Crime Report"
    crime_report.plural_name = "Crime Reports"
    crime_report.slug = 'crimereport'
    crime_report.min_date = datetime.utcnow()
    crime_report.last_updated = datetime.utcnow()
    crime_report.has_newsitem_detail = True
    crime_report.is_public = True
    crime_report.save()

    # custom field officer name 
    officer = SchemaField()
    officer.schema = crime_report
    officer.pretty_name = "Reporting Officer's Name"
    officer.pretty_name_plural = "Reporting Officer's Names"
    officer.real_name = 'varchar01'
    officer.name = 'officer'
    officer.save()

    # custom field crime type 
    crime_name = SchemaField()
    crime_name.schema = crime_report
    crime_name.pretty_name = "Crime Type"
    crime_name.pretty_plural_name = "Crime Types"
    crime_name.real_name = "varchar02"
    crime_name.name = "crime_type"
    crime_name.save()
Example #4
0
if __name__ == '__main__':
    # create schema
    crime_report = Schema()
    crime_report.indefinite_article = 'a'
    crime_report.name = "Crime Report"
    crime_report.plural_name = "Crime Reports"
    crime_report.slug = 'crimereport'
    crime_report.min_date = datetime.utcnow()
    crime_report.last_updated = datetime.utcnow()
    crime_report.has_newsitem_detail = True
    crime_report.is_public = True
    crime_report.save()

    # custom field officer name
    officer = SchemaField()
    officer.schema = crime_report
    officer.pretty_name = "Reporting Officer's Name"
    officer.pretty_name_plural = "Reporting Officer's Names"
    officer.real_name = 'varchar01'
    officer.name = 'officer'
    officer.save()

    # custom field crime type
    crime_name = SchemaField()
    crime_name.schema = crime_report
    crime_name.pretty_name = "Crime Type"
    crime_name.pretty_plural_name = "Crime Types"
    crime_name.real_name = "varchar02"
    crime_name.name = "crime_type"
    crime_name.save()