python日志内容存储到文件里_如何使用python解析日志文件并将数据存储在数据库中？...

我试图分析一个日志文件。它包含下面给出的结构

我想用python实现它，并希望将提取的数据存储在数据库中，我该怎么做呢？在

我能够解析简单的键值对，但面临一些问题。在

1:如果示例文件中的context字段嵌套在主组中，如何解析嵌套结构？在

2:如果分隔符是字符串，如何处理条件。喜欢键：值对分隔符是冒号（：），在“site”键中有一个键：值对站点url:http://something.com这里的url也包含冒号（：），这给出了错误的答案。在{

"username": "lavania",

"host": "10.105.22.32",

"event_source": "server",

"event_type": "/courses/XYZ/CS101/2014_T1/xblock

/i4x:;_;_XYZ;_CS101;_video;_d333fa637a074b41996dc2fd5e675818/handler/xmodule_handler/save_user_state",

"context": {

"course_id": "XYZ/CS101/2014_T1",

"course_user_tags": {},

"user_id": 42,

"org_id": "XYZ"

},

"time": "2014-06-20T05:49:10.468638+00:00",

"site":"http://something.com",

"ip": "127.0.0.1",

"event": "{\"POST\": {\"saved_video_position\": [\"00:02:10\"]}, \"GET\": {}}",

"agent": "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0",

"page": null

}

{

"username": "rihana",

"host": "10.105.22.32",

"event_source": "server",

"event_type": "problem_check",

"context": {

"course_id": "XYZ/CS101/2014_T1",

"course_user_tags": {},

"user_id": 40,

"org_id": "XYZ",

"module": {

"display_name": ""

}

},

"time": "2014-06-20T06:43:52.716455+00:00",

"ip": "127.0.0.1",

"event": {

"submission": {

"i4x-XYZ-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1": {

"input_type": "choicegroup",

"question": "",

"response_type": "multiplechoiceresponse",

"answer": "MenuInflater.inflate()",

"variant": "",

"correct": true

}

},

"success": "correct",

"grade": 1,

"correct_map": {

"i4x-XYZ-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1": {

"hint": "",

"hintmode": null,

"correctness": "correct",

"npoints": null,

"msg": "",

"queuestate": null

}

},

"state": {

"student_answers": {},

"seed": 1,

"done": null,

"correct_map": {},

"input_state": {

"i4x-XYZ-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1": {}

}

},

"answers": {

"i4x-XYZ-CS101-problem-33e4aac93dc84f368c93b1d08fa984fc_2_1": "choice_0"

},

"attempts": 1,

"max_grade": 1,

"problem_id": "i4x://XYZ/CS101/problem/33e4aac93dc84f368c93b1d08fa984fc"

},

"agent": "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:29.0) Gecko/20100101 Firefox/29.0",

"page": "x_module"

}

{

"username": "troysa",

"host": "localhost",

"event_source": "server",

"event_type": "/courses/XYZ/CS101/2014_T1/instructor_dashboard/api/list_instructor_tasks",

"context": {

"course_id": "XYZ/CS101/2014_T1",

"course_user_tags": {},

"user_id": 6,

"org_id": "XYZ"

},

"time": "2014-06-20T05:49:26.780244+00:00",

"ip": "127.0.0.1",

"event": "{\"POST\": {}, \"GET\": {}}",

"agent": "Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:29.0) Gecko/20100101 Firefox/29.0",

"page": null

}