Python Script with JSON and SQL Interaction, Summaries of Computer science

Download Python Script with JSON and SQL Interaction and more Summaries Computer science in PDF only on Docsity!

OLMFMЎXGɨGOMЎRXLиGRɧ]XVSRKZMЖGɨTHдRK4]XLSRZɧS

GɺRKZMЖGXVSRKXš˜RKPEM

 ,IPPS[SVPH

 'ɾTLɨT

 4LɩRGLMEQSHYPI

 'PEWW

 8LESXɨGXVɱRXϼTXMR

 <мPʁLɳRLϲRL

 <мPʁJMPI.

 <мPʁJMPI<

 /ЎXRРM1]

 /ЎXRРM6IHMW

 /ЎXRРM1IQGEGLIH

 /ЎXRРM6EFFMX

 6IWXJYP'PMIRX

 +ЮMIQEMPZЪM

 7SGOIX4VSKVEQQMRK

'Lš˜RK,IPPS[SVPH

4 ]XLSRPɧQШXRKɺRRKоTLMɱRHКGL -RXIVTVIXIV0ERKYEKI 

XиGPɧOLɺRKG϶RFYMPHXLɧRLJMPIXLрGXLMQɧGLϰ]XVрGXMЎT

RLš4,4

,MЖRXϰM4]XLSRGɹRLɨRLGLɴRLPɧ\Zɧ\ЭRLɨRL\

чɪHкRKTLɨXXVMВRZɧчERKчиRKЮTLMɱRFϲR2LɨRL

4]XLSR\XLɳZϺRчERKчšвGXMЎTXдGTLɨXXVMВR

;IFWMXIGLɴRLXLиGGжE4]XLSR[[[T]XLSRSVK

'ɧMчІX

4]XLSRLЦXVвL϶YLЎXGɨGRАRXϲRKZɧVϴXHДXɳQXLϴ]WЄR

XVɱRQШXWРLЖчMАYLɧRLRLš1EG37ŷ

ɇВFMЎXPɧLЖXLРRKGжEFϰRчɪGɧM4]XLSRGLšEGɹXLВZɧS

QɧRLɳRLGSQQERHPMRIZɧKɻ

$ python --version

print PɧPЖRLG˜FϲRRLϴXчВ\YϴXQШXFMЎRVE XLšЬRKPɧ

QɧRLɳRL

7EYчɹZɧSQɧRLɳRLGSQQERHPMRIHMGLY]ВRчЎRXLš

QдGGLиEJMPIRɧ]ZɧKɻ

$ python helloworld.py

2 ЎYXLϴ]\YϴXLMЖRHɸRKGLо Hello world XиGPɧFϰRчɪ

LSɧRXLɧRLZMЖGZMЎXиRKHдRKT]XLSRч϶YXMɱR

'Lš˜RK'ɾTLɨT

&MЎRWР

/LEMFɨSFMЎRFЀRKQШXGɩYPЖRLKɨR

a = 1

FϰRGɹXLВKɨRRLMАYPSϰMKMɨXVК WРGLYЦM GLSQШXFMЎR

a = 1 a = 'Hello World' a = [1, 2, 3] a = [1.2, 'Hello', 'W', 2]

8SɨRXмWРLМG

4]XLSRGˢRKLЦXVвQШXWРXSɨRXмXSɨRLМGXLɺRKHдRK

RLš

+ TLɰTGШRK

x = 2

1 < x < 3 # True 10 < x < 20 # False 3 > x <= 2 # True 2 == x < 4 # True

8 SɨRXмOMВQXVETL϶RXмXVSRKQШXXϼTLвT in OMВQXVE

GɹXТRXϰM not in OMВQOLɺRKXТRXϰM

'good' in 'this is a greate example' # F alse 'good' not in 'this is a greate example' # True

'ϴYXVɾGчMАYOLMВR

4]XLSRLЦXVвQШXWРGϴYXVɾGчMАYOLMВRXLɺRKHдRK,϶Y

LЎXGɨGGϴYXVɾGчMАYOLMВRчАYHрEZɧSXLдXч϶YHɸRK

MRHIRXMSR чВXϰSXLɧRLQШXFPSGO\мPʁXLE]ZɳWмHдRK

{ ŷ } RLšGɨGRKɺRRKоOLɨG 4,4.EZEWGVMTX 

-JŷIPMJŷIPWI

if condition1 : indentedStatementBlockForTrueCondition elif condition2 : indentedStatementBlockForFirstTrueCondition elif condition3 : indentedStatementBlockForFirstTrueCondition elif condition4 : indentedStatementBlockForFirstTrueCondition else : indentedStatementBlockForEachConditionFalse

7[MXGLŷGEWI

4]XLSROLɺRKGɹGϴYXVɾG switch ŷ case

*SVŷMR

for iterating_var in sequence: statements(s)

:ɴHд

while expression: statement(s)

:ɴHд

count = 0 while (count < 9): print 'The count is:', count count = count + 1

print "Good bye!"

/ЎXUYϲLMВRXLКGжEZɴHдXVɱR

The count is: 0 The count is: 1 The count is: 2 The count is: 3 The count is: 4 The count is: 5 The count is: 6 The count is: 7 The count is: 8 Good bye!

,ɧQ

/LEMFɨSLɧQXLISGɾTLɨT

def functionname(param, param2,..): statements(s)

,ɧQRЎYOLɺRKXVϲHоPMЖYXLɳQІGчКRLWЌXVϲZАKMɨXVК

None

:ɴHдOLEMFɨSLɧQXɴRLZɧXVϲZАKMɨXVКXФRKGжEXLEQ

WРч϶YZɧS

GɨGLчІXXɱRXLEQWРOLMKМMLɧQ:ɴHдXEGɹXLВKМMLɧQ

sum(a,b) ЮZɴHдXVɱRFЀRKGɨGLXVY]АRXLEQWР b XVšЪG a

RLšWEY

sum(b = 1, a = 10)

<мPʁGLYЦM

1ШXGLYЦMGɹXLВOLEMFɨSFЀRKHϴYRLɨ]чɺM " LSІGч˜R

' :ɴHдGɨGGLYЦMWEY

str1 = "Hello" str2 = 'world'

'ɹXLВXVY]\YϴXXкRKOʁXрXVSRKQШXGLYЦMXLISLɳRLXLиG

MRHI\ZɴHд str1[0]  str1[1] ŷ

'ɹXLВWмHдRKHϴYRLɨ] чɺMLSІGч˜R чВOLEMFɨS

GLYЦMXVɱRRLMАYHɸRK:ɴHд

paragraph = """This is line 1 This is line 2 This is line 3"""

2РMGLYЦM

'ɹXLВXϰSQШXGLYЦMHɧMXкZMЖGRРMGɨGGLYЦMPϰMXLISGɾ

TLɨT

str = str1 + " " + str

8VɴGL\YϴXGLYЦMGSR

'ɹXLВXϰSGɨGGLYЦMGSRXLɺRKUYEXSɨRXмPϴ]OLSϲR

[start:end]  VERKI 1ІGчКRL start PɧXкZКXVɴч϶YGLYЦM

0 Zɧ end PɧчЎRZКXVɴGYРMGLYЦM:ɴHд

XLиG replace(search, replace[, max]) GжEQШXGLYЦM:ɴ

Hд

str = 'Hello world' newstr = str.replace('Hello', 'Bye') print newstr (Sҿ hiӅn thӍ chuәi "Bye world" trên màn hình)

8ɳQZКXVɴGLYЦMGSR

'ɹXLВXɳQZКXVɴGжEQШXGLYЦMGSRXVSRKGLYЦMPЪRFЀRK

GɨGLKМMTLš˜RKXLиG find(str, beg=

end=len(string)) &ϾXч϶YPɧZКXVɴ 0 RЎYOLɺRKXɳQVEXLɳ

XVϲZА -1 :ɴHд

str = 'Hello world' print str.find('world') (hiӅn thӍ 6)

print str.find('Bye'); (hiӅn thӍ -1)

,ɧQ find() WЌXɳQXLISXLиXрXкXVɨMUYETLϲMGжEGLYЦM

XиGPɧXкP϶R\YϴXLMЖRч϶YXMɱR'ɹXLВHɽRKLɧQ rfind()

чВXɳQXLISZКXVɴXкGYРMGLYЦMZАTLɴEXVšЪG

8ɨGLGLYЦM

'ɹXLВXɨGLGLYЦMHрEXLISQШXGLYЦMHIPMQIXIVFЀRKGɨGL

KМMTLš˜RKXLиG split(str="", num=string.count(str)) 

:ɴHд

str = 'Hello world' print str.split(' ') (Trҥ vӃ mӛt mҥng có 2 phҩn tӯ là 2 chuәi "Hello" và "world")

'ɹXLВWмHдRKLɧQ splitlines() чВXɨGLGLYЦMXLIS

XкRKLɧRKZɧPSϰMFОOʁXр2);0-2)

8VMQOʁXрOLSЂRKXVϾRK

'ɹXLВPSϰMFОGɨGOʁXр QІGчКRLPɧOʁXрOLSϲRKXVϾRK

XVšЪGZɧWEYQШXGLYЦMFЀRKGɨGLKМMGɨGTLš˜RKXLиG

WEY