Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- curl -XPUT 'localhost:9200/_river/fi/_meta' -d '{
- "type" : "jdbc",
- "jdbc" : {
- "url" : "jdbc:mysql://localhost:3306/future_image_typo3",
- "user" : "xxxxxxx",
- "password" : "xxxxxx",
- "sql" : "select * from 0_fotos"
- },
- "index" : {
- "index" : "jdbc",
- "type" : "jdbc",
- "index_settings" : {
- "refresh_interval": "1s",
- "analysis" : {
- "analyzer" : {
- "my_analyzer" : {
- "tokenizer" : "standard",
- "filter" : ["standard", "lowercase", "my_snow"]
- }
- },
- "filter" : {
- "my_snow" : {
- "type" : "snowball",
- "language" : "German2"
- }
- }
- }
- },
- "type_mapping":{
- "jdbc":{
- "properties":{
- "act_download":{
- "type":"long"
- },
- "active":{
- "type":"long"
- },
- "added":{
- "type":"string"
- },
- "camera":{
- "type":"string"
- },
- "cart_count":{
- "type":"long"
- },
- "category":{
- "type":"string"
- },
- "city":{
- "type":"string"
- },
- "code":{
- "type":"long"
- },
- "colormode":{
- "type":"string"
- },
- "copyright":{
- "type":"string"
- },
- "country":{
- "type":"string"
- },
- "create_date":{
- "type":"date",
- "format":"yyyy/MM/dd"
- },
- "credit":{
- "type":"string"
- },
- "deleted":{
- "type":"long"
- },
- "description":{
- "type":"string"
- },
- "filename":{
- "type":"string"
- },
- "flash":{
- "type":"string"
- },
- "headline":{
- "type":"string"
- },
- "imageformat":{
- "type":"string"
- },
- "keywords":{
- "type":"string"
- },
- "last_modified":{
- "type":"date",
- "format":"dateOptionalTime"
- },
- "lens":{
- "type":"string"
- },
- "orientation":{
- "type":"string"
- },
- "pfad_extern":{
- "type":"string"
- },
- "pfad_intern":{
- "type":"string"
- },
- "photog_show":{
- "type":"long"
- },
- "photographer":{
- "type":"long"
- },
- "photographer_name":{
- "type":"string"
- },
- "resolution":{
- "type":"string"
- },
- "size":{
- "type":"string"
- },
- "special_instructions":{
- "type":"string"
- },
- "state":{
- "type":"string"
- },
- "sub_category":{
- "type":"string"
- },
- "terms_of_use":{
- "type":"string"
- },
- "text_full":{
- "type":"string"
- },
- "title":{
- "type":"string"
- }
- }
- }
- }
- }
- }'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement