database - best strategy for multiple insertions in db from one file -

-

let me clarify title of question.

i'm implementing web application's back-end.

this create in 1 single .html file

  • user inserts point,line or polygon on map.
  • user fills form text data. data relative geometry inserted on map.
  • user uploads photos , videos via html5 websockets/drag'n'drop. relative geometry inserted on map.

there 1 button @ bottom of page, named "save all" saves data @ once on database (insert).

the problem? have 2 seperate tables in database. 1 named "pins" , geometry data , form data.

the other named "multimedia" , images/videos.

now "multimedia" has column named "multipin" contains "pins" id, can relate pins , multimedia.

all columns containig ids "serial" (with each insertion, id automatically grows +1).

i thinking if both insertions @ same time there no way can new "pins" id , insert "multipin" column of "multimedia". have wait new "pins" id created , insert "multipin".

so, 2 insertions (?) solution came creating 3 html files. on first, user inserts geometry , form data. hits button named "click here add multimedia". button sends data file inserts in "pins" , gets new id. redirects third file , sends new "pins". user can insert photo/video , code knows "pins" id , can put in "multipin".

does sounds fine? there better way or strategy?

for "save @ once" version thinking websockets...for "3 files version" ? should use "traditional" ajax , websockets multimedia?

i apologize big question. , english (not native language)

thank time

slevin

save @ once better strategy user.

assuming you're using transactional relational database, can save following way.

  • insert pins table data.

  • commit

  • get pins sequential id

  • insert multimedia

  • commit

if there's problem multimedia, rollback multimedia inserts , delete pins table data row keep database consistency.


Comments

Post a Comment

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

-
this svg contains rect overflows svg element: <svg id='svg' width='10' height='10'> <rect x='-10' y='-10' width='30' height='30'/> </svg> chrome 28 , opera 12 return getboundingclientrect() svg element width , height of 10. firefox 23 reports width , height of 30. correct? jsfiddle the relevant spec cssom , delegates svg spec if svg element not "have associated css layout box". haven't found definition of "having associated css layout box", correct result seem hinge on definition, getbbox returns 30x30 rect in browsers. this firefox bug fixed now, fix in firefox nightlies , should make through firefox 33 released on 14 october 2014. see bug 530985 details.
Read more

gcc - Calling fftR4() in c from assembly -

-
i trying asm fft implementation www.embeddedsignals.com work. running make gives error: undefined reference fftr4(short*, short*, int) at top of asm have .syntax unified .thumb .global fftr4 .type fftr4, %function and there #define's associate c functions arguments registers followed macros fftr4 function uses. after that, fftr4 called .thumb_func fftr4: stmfd sp!, {r4-r11, lr} mov tmp0, #0 // bit reversed counter mov tmp1, #0 .word 0xf3a2fa92 //rbit r3,r2 //rbit r,n lsl r,#3 and c code follows: void fftr4(short *y, short *x, int n); short x[512]; short y[512]; int i; void loop() { (i=0;i<512;i++) x[i]=0; (i=0;i<512;i=i+8) { x[i+0]=16384; x[i+2]=16384; x[i+4]=-16384; x[i+6]=-16384;} fftr4(y, x, 256); serialusb.println(y[128]); serialusb.println(y[129]); serialusb.println(y[384]); serialusb.println(y[385]); // expected results: //y[128]is 8191; y[129] -8190 y[...
Read more

.htaccess - Matching full URL in RewriteCond -

-
i'm trying block post access site (and return 403), except 2 ip's , 1 url ( http://mydomain.com/about-us/contact-us/ ). here's have: rewritecond %{request_method} post rewritecond %{remote_addr} !=1.2.3.4 rewritecond %{remote_addr} !=4.3.2.1 rewritecond %{request_uri} !^http://mydomain.com/about-us/contact-us/$ rewriterule ^ / [f] these rules allowing access ip properly, contact page still not accessible. i'm not sure i'm using request_uri correctly? i've tried variations relative urls rewritecond %{request_uri} !^/about-us/contact-us$ , rewritecond %{request_uri} !^/about-us/contact-us/$ without luck. what doing wrong please? it looks me rule on file name specific. if relax bit, should work. made few other esthetic tweaks. give try: rewritecond %{request_method} post rewritecond %{remote_addr} !^1.2.3.4 rewritecond %{remote_addr} !^4.3.2.1 rewritecond %{request_uri} !about-us/contact-us rewriterule ^ - [f]
Read more