X-Git-Url: https://git.mdrn.pl/wolnelektury.git/blobdiff_plain/9b97d5a2faa6f56b439dcefe9c7bb23e0a84b39c..db833ba4517084f61a64907c6d15606e7c881edd:/apps/djangosphinx/apis/api275/templates/source-multiple.conf diff --git a/apps/djangosphinx/apis/api275/templates/source-multiple.conf b/apps/djangosphinx/apis/api275/templates/source-multiple.conf new file mode 100644 index 000000000..506e6f190 --- /dev/null +++ b/apps/djangosphinx/apis/api275/templates/source-multiple.conf @@ -0,0 +1,36 @@ +source {{ source_name }} +{ + type = {{ database_engine }} + strip_html = 0 + index_html_attrs = + sql_host = {{ database_host }} + sql_user = {{ database_user }} + sql_pass = {{ database_password }} + sql_db = {{ database_name }} + sql_port = {{ database_port }} + log = {{ log_file }} + + sql_query_pre = + sql_query_post = + sql_query = \ +{% for table_name, content_type in tables %} + SELECT {{ field_names|join:", " }}, {{ content_type.id }} as content_type \ + FROM `{{ table_name }}`{% if not loop.last %} UNION \{% endif %} +{% endfor %} +{% if group_columns %} + # ForeignKey's +{% for field_name in group_columns %} sql_attr_uint = {{ field_name }} +{% endfor %}{% endif %} +{% if date_columns %} + # DateField's and DateTimeField's +{% for field_name in date_columns %} sql_attr_timestamp = {{ field_name }} +{% endfor %}{% endif %} +{% if bool_columns %} + # BooleanField's +{% for field_name in bool_columns %} sql_attr_bool = {{ field_name }} +{% endfor %}{% endif %} +{% if float_columns %} + # FloatField's and DecimalField's +{% for field_name in float_columns %} sql_attr_float = {{ field_name }} +{% endfor %}{% endif %} +} \ No newline at end of file