Project

General

Profile

Feature #535

Add Django SQL query parsing

Added by Luke Murphey over 11 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
02/22/2013
Due date:
% Done:

100%


Description

Parse the SQL query logs including:

  • The query time
  • The action performed (SELECT, UPDATED, etc.)
2012-11-02 22:35:07,804 [DEBUG] django.db.backends: (0.000) UPDATE "reader_verse" SET "division_id" = 1250, "sequence_number" = 3, "indicator" = 311, "content" = ἐντυχὼν
οὖν ταῖς ἐπιστολαῖς εἰς Ἄρβηλα κώμην ἀφικόμην, ἔνθα σύνοδον
τῶν Γαλιλαίων ποιησάμενος ἐκέλευσα τοὺς πρέσβεις διηγεῖσθαι τὴν
ἐπὶ τοῖς πεπραγμένοις ὑπὸ τῶν περὶ τὸν Ἰωνάθην ὀργὴν καὶ μισοπονηρίαν, 
, "original_content" = <?xml version="1.0" ?><verse>e)ntuxw\n
ou)=n tai=s e)pistolai=s ei)s *)/arbhla kw/mhn a)fiko/mhn, e)/nqa su/nodon
tw=n *galilai/wn poihsa/menos e)ke/leusa tou\s pre/sbeis dihgei=sqai th\n
e)pi\ toi=s pepragme/nois u(po\ tw=n peri\ to\n *)iwna/qhn o)rgh\n kai\ misoponhri/an, 
</verse> WHERE "reader_verse"."id" = 3790 ; args=(1250, 3, u'311', '\xe1\xbc\x90\xce\xbd\xcf\x84\xcf\x85\xcf\x87\xe1\xbd\xbc\xce\xbd\n\xce\xbf\xe1\xbd\x96\xce\xbd \xcf\x84\xce\xb1\xe1\xbf\x96\xcf\x82 \xe1\xbc\x90\xcf\x80\xce\xb9\xcf\x83\xcf\x84\xce\xbf\xce\xbb\xce\xb1\xe1\xbf\x96\xcf\x82 \xce\xb5\xe1\xbc\xb0\xcf\x82 \xe1\xbc\x8c\xcf\x81\xce\xb2\xce\xb7\xce\xbb\xce\xb1 \xce\xba\xe1\xbd\xbd\xce\xbc\xce\xb7\xce\xbd \xe1\xbc\x80\xcf\x86\xce\xb9\xce\xba\xe1\xbd\xb9\xce\xbc\xce\xb7\xce\xbd, \xe1\xbc\x94\xce\xbd\xce\xb8\xce\xb1 \xcf\x83\xe1\xbd\xbb\xce\xbd\xce\xbf\xce\xb4\xce\xbf\xce\xbd\n\xcf\x84\xe1\xbf\xb6\xce\xbd \xce\x93\xce\xb1\xce\xbb\xce\xb9\xce\xbb\xce\xb1\xe1\xbd\xb7\xcf\x89\xce\xbd \xcf\x80\xce\xbf\xce\xb9\xce\xb7\xcf\x83\xe1\xbd\xb1\xce\xbc\xce\xb5\xce\xbd\xce\xbf\xcf\x82 \xe1\xbc\x90\xce\xba\xe1\xbd\xb3\xce\xbb\xce\xb5\xcf\x85\xcf\x83\xce\xb1 \xcf\x84\xce\xbf\xe1\xbd\xba\xcf\x82 \xcf\x80\xcf\x81\xe1\xbd\xb3\xcf\x83\xce\xb2\xce\xb5\xce\xb9\xcf\x82 \xce\xb4\xce\xb9\xce\xb7\xce\xb3\xce\xb5\xe1\xbf\x96\xcf\x83\xce\xb8\xce\xb1\xce\xb9 \xcf\x84\xe1\xbd\xb4\xce\xbd\n\xe1\xbc\x90\xcf\x80\xe1\xbd\xb6 \xcf\x84\xce\xbf\xe1\xbf\x96\xcf\x82 \xcf\x80\xce\xb5\xcf\x80\xcf\x81\xce\xb1\xce\xb3\xce\xbc\xe1\xbd\xb3\xce\xbd\xce\xbf\xce\xb9\xcf\x82 \xe1\xbd\x91\xcf\x80\xe1\xbd\xb8 \xcf\x84\xe1\xbf\xb6\xce\xbd \xcf\x80\xce\xb5\xcf\x81\xe1\xbd\xb6 \xcf\x84\xe1\xbd\xb8\xce\xbd \xe1\xbc\xb8\xcf\x89\xce\xbd\xe1\xbd\xb1\xce\xb8\xce\xb7\xce\xbd \xe1\xbd\x80\xcf\x81\xce\xb3\xe1\xbd\xb4\xce\xbd \xce\xba\xce\xb1\xe1\xbd\xb6 \xce\xbc\xce\xb9\xcf\x83\xce\xbf\xcf\x80\xce\xbf\xce\xbd\xce\xb7\xcf\x81\xe1\xbd\xb7\xce\xb1\xce\xbd, \n', u'<?xml version="1.0" ?><verse>e)ntuxw\\n\nou)=n tai=s e)pistolai=s ei)s *)/arbhla kw/mhn a)fiko/mhn, e)/nqa su/nodon\ntw=n *galilai/wn poihsa/menos e)ke/leusa tou\\s pre/sbeis dihgei=sqai th\\n\ne)pi\\ toi=s pepragme/nois u(po\\ tw=n peri\\ to\\n *)iwna/qhn o)rgh\\n kai\\ misoponhri/an, \n</verse>', 3790)
2012-11-02 22:35:07,805 [DEBUG] django.db.backends: (0.000) INSERT INTO "reader_verse" ("division_id", "sequence_number", "indicator", "content", "original_content") VALUES (1250, 4, 312, , ); args=[1250, 4, u'312', '', '']
2012-11-02 22:35:07,808 [DEBUG] django.db.backends: (0.000) SELECT (1) AS "a" FROM "reader_verse" WHERE "reader_verse"."id" = 3791  LIMIT 1; args=(3791,)
2012-11-02 22:35:07,809 [DEBUG] django.db.backends: (0.000) UPDATE "reader_verse" SET "division_id" = 1250, "sequence_number" = 4, "indicator" = 312, "content" = καὶ ὡς κυρώσειαν ἐμοὶ τῆς χώρας αὐτῶν τὴν προστασίαν,

History

#1 Updated by Luke Murphey over 11 years ago

  • Target version set to 1.0

#2 Updated by Luke Murphey over 11 years ago

  • Status changed from New to Closed
  • Assignee set to Luke Murphey
  • % Done changed from 0 to 100

Also available in: Atom PDF