U
O0di, @ s d dl Z d dlZd dlmZ d dlZd dlZd dlZd dlZd dl Z zd dl
Z
dZ W n d Z Y nX d dl Z d dl
Z
dej_dd Zdd Zd d
Zd d Zd
d Zdd Zdd Zdd Zdd Zdd Zdd Zdd Zd d Z d d Z dS )! N)FileMakerError i, c C s | d}|dkr2d}tj}|tjtjtjd}nz tj|}t
|}d}W n d}Y nX |dkrz |d }|d }d}|d }W q |d }|d
} |d }
|d } || |
| d}|d
}d}Y qX n d}i }i }|||fS )NZ payloadDataselftest)action
serverName databaseName
layoutNamer r fmWhatfmWherenewr r r r dataoldparameterMissing) getvaluefmInfostQuerystServer
stDatabasestLayouturllibparseunquotejsonloads) formZ
payloadRawr r r
Z payloadCleanZformJSONZ formErrorZ
dataSchemar r r r -/var/www/html/backup/fmpynew/fmpyfunctions.pyparseParameters, s:
r c C s2 t j| d tjtj| d | d dd}| |S )Nr r r F)userpassworddatabaselayout
verify_ssl)fmrestServerr userName
myPasswordlogin)r
fmsr r r fmConnectT s
r) c
C s d| d d | d d | d }t | t d |g}z|j|dd }d
|i}d }d }d
} t | |D ]L}
|| } |} i }
| }|D ]}| | }t |d|d qt d |d }qjW nB tk
r } z$t|}d }d} t | t | W 5 d }~X Y nX dS )Nz0Selftest....
Testing connectivity to:
r z
r z -> r z;
Note: Only the first 2 records are displayed
querylimitr r r z-
Test successful, server returned:
:z
------
z-
Test failed. FM Server responded:
z
Selftest Complete)printfindkeysr str)r
r r( Z resultLine1
find_queryfmResult returnArrayisuccessZ resultLine2r
thisRecord
keyFieldValuefr1 keyvalue findErrorr r r r a s8 $r c
C s z | d }W n d }i }Y nX z | d }W n d}Y nX z| d }i }W n d}Y nX |g}z|j |dd}d} W n* tk
r }
z |
}d} W 5 d }
~
X Y nX | dkr|dkr,d} g } |D ]L}
|| }i }| }|D ]}|| }|||< qd |i}| | | d } qd
| i}t|}ng } i }d} |D ]t}
|| }|dkr\|| }n| }i }| }|D ]}|| }|||< qp|d kr|||< n
| | | d } q<|d k rd
| i}t|}|S ) N
calledFromCSVkeyFieldnull fmResultRawr i@ r+ r fieldDatar )r0 r r1 appendr dumps)r
r r( r? r5 r@ rB r3 r4 r7 r> r6 Z dataArrayr8 r9 r; r1 r< r= wrapperr: r r r getRecord st
rG c C s* d| d< t | ||}t }| d }|dkr^t }d| d }|d | d }d | d } n,|d
krd | d }d | d }d | d } t|d
}
|
t| |
zt j
|dd} d} W n d} Y nX z| j |d d d}
W n d}
Y nX t |}| d |
}| }d|kr"|S |S d S )Nr r? r Windowszc:\temp\z.jsonz\files\z.csvz,https://wbv-fmr-p0004.systems.private/files/Linuxz/app/website/html/z(https://fmr-wb-p1.systems.private/files/wsplit)ZorientzRead OKz
Read Error)indexzWrite OKz Write Error Error)
rG platformsystemosgetcwdopenwriter2 closepandasZ read_jsonZto_csvremove)r
r r( ZtheDataZ thisPlatformZ tableName localPathZ jsonFilePathZ csvFilePathZ downloadLinkZ text_fileZtheCSVZ
csvResult1Z
csvResult2ZdeleteMeZcsvResultErrorZ csvResultOKr r r getRecordToCSV s@
rY c
C s> z| |}|}W n& tk
r8 } z|}W 5 d }~X Y nX |S )N)
create_recordr )r
r r( Z recordCreater4 createErrorr r r createRecord s
r\ c
C s |d }|d }| }||ig}z|j|d}d}W n& tk
r\ } z| }
W 5 d } ~ X Y nX |dkr|d } |D ]$} | dkrr| dkrr|| }
|
| | < qrz|| d}
W n& tk
r } z|}
W 5 d }~X Y nX d S )Nuuidpk)r, r r z000 OK)r1 r0 r edit)r
r r( r] r^ r1 r3 foundsetr7 r> r4 recordr< r= Z updateErrorr r r updateRecord s(
rb c
C sh | }d}|D ]R}t|}|| }z||}W n& tk
rX } z| }W 5 d } ~ X Y nX |d }q|S )Nr r )r1 r2 rZ r )
r
r r( r1 r6 r< ZiStringZaddArrayr4 r[ r r r createRecordMulti+ s
rc c
C s |d }z|d }t |}W n d}Y nX |d }|d }||ig}z |j|d||gid}|j} W n* tk
r }
z |
|f} W 5 d }
~
X Y nX | S )NZfmScriptfmScriptParameter r] r^ after)r, scripts)r rE r0 last_script_resultr ) r
r r( Z
scriptNamerd r] r^ r3 ZfoundSetr4 ZrunScriptErrorr r r runScript: s
ri c C s dS )NZfoor )r
r r r r saveFileL s rj c C s dS )Nz fmPy v2.5r r
r r( r r r versionO s rl c C s dS )Nz4No parameter supplied, or it isn't loadable as JSON.r rk r r r r R s r c C s( t | }t |}d| d | }|S )Nz fmWhere
z
fmWhat
)r rE )r
r r( Z
fmWhereStringZ fmWhatString returnStringr r r testU s
rn c C s t d d S )NzRIP Coolio 29/09/2022)r/ rk r r r gpar[ s ro ) requestsr# fmrest.exceptionsr r cgibase64 urllib.parser rQ rV isPandarO r utilsTIMEOUTr r) r rG rY r\ rb rc ri rj rl r rn ro r r r r s:
(
"O2