Re: #cherrypy #tornado #sqlalchemy
Sviatoslav Sydorenko <[email protected]> Fri, 4 Jan 2019 20:35:42 +0100
| Newsgroups | gmane.comp.python.cherrypy |
|---|---|
| Message-ID | <CAFYONRDJ72wrnLEMoEWpxn213cX-p4coiad0=qhf0SAw3Bm7Dw@mail.gmail.com> |
--000000000000bb82ee057ea6fcbf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This is actually a CherryPy users group, not Tornado. So I'm not sure how much insight you could get from us. But OTOH nobody is going to guess what failed for you unless you actually describe what you have tried already. Current dialogue is in style of "- It doesn't work! - Yes, it doesn't." isn't helpful, is it? Show us the code. =D0=BF=D1=82, 4 =D1=81=D1=96=D1=87. 2019 =D0=BE 20:30 vahid peivandy <tarfa= [email protected]> =D0=BF=D0=B8=D1=88=D0=B5: > I cannot connect mu db on web server tornado or web server cherrypy this > is my problem and see this page but not help me > https://tornado-sqlalchemy.readthedocs.io/en/latest/ > > On Fri, Jan 4, 2019 at 10:54 PM Sviatoslav Sydorenko <[email protected]= > > wrote: > >> Hi Vahid, >> >> I'm not sure where are you stuck at? I have a feeling that you just don'= t >> know how to integrate SA with CherryPy. Am I right? If so, here's some a= pp >> example: https://github.com/Lawouach/Twiseless/blob/master/lib/tool/db.p= y >> >> =D0=BF=D1=82, 4 =D1=81=D1=96=D1=87. 2019 =D0=BE 20:16 vahid peivandy <ta= [email protected]> =D0=BF=D0=B8=D1=88=D0=B5: >> >>> I want on the first-page show a simple list page HTML that shows Patien= t >>> order by id, name, family name >>> and when a user clicked to for example Patient Alex goes to the second >>> page that includes lists of Patient Referral order by id, date and when >>> the user clicked to special date go to the last page that shows picture= s of >>> for example hand, foot, etc of Alex. >>> >>> On Fri, Jan 4, 2019 at 10:27 PM Tim Roberts <[email protected]> wrote: >>> >>>> vahid peivandy wrote: >>>> >>>> >>>> I write db but now connect to the web server and this is my problem an= d >>>> need help >>>> >>>> Well, you take it one step at a time. You will want to sketch out on >>>> paper what forms you will need. What is the user story? What will th= ey >>>> see first? Is there a menu? Is there a search? Which tables do they= need >>>> to see? How does the flow go? Where do the buttons go? >>>> >>>> After that, you're going to want to sketch out some simple HTML forms, >>>> just so you can see how they look with data in them. How can you pres= ent >>>> the fields in an attractive and useful way? >>>> >>>> After that, I usually do a couple of the pages as CGI scripts behind a= n >>>> Apache server somewhere, so I can check out the flow without having to >>>> worry about a web server. >>>> >>>> Once you have that basic outline, then you can choose your web server >>>> and start doing more coding. You can adapt the CGI pages you've alrea= dy >>>> done, and switch over to whatever template engine is provided. >>>> >>>> -- >>>> Tim Roberts, [email protected] >>>> Providenza & Boekelheide, Inc. >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "cherrypy-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to cherrypy-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected] >>>> To post to this group, send email to cherrypy-users-/JYPxA39Uh5TLH3MbocFF+G/[email protected] >>>> Visit this group at https://groups.google.com/group/cherrypy-users. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "cherrypy-users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to cherrypy-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected] >>> To post to this group, send email to cherrypy-users-/JYPxA39Uh5TLH3MbocFF+G/[email protected] >>> Visit this group at https://groups.google.com/group/cherrypy-users. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> -- >> Cheers, >> Sviatoslav. >> >> -- >> You received this message because you are subscribed to the Google Group= s >> "cherrypy-users" group. >> To unsubscribe from this group and stop receiving emails from it, send a= n >> email to cherrypy-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected] >> To post to this group, send email to cherrypy-users-/JYPxA39Uh5TLH3MbocFF+G/[email protected] >> Visit this group at https://groups.google.com/group/cherrypy-users. >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "cherrypy-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to cherrypy-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected] > To post to this group, send email to cherrypy-users-/JYPxA39Uh5TLH3MbocFF+G/[email protected] > Visit this group at https://groups.google.com/group/cherrypy-users. > For more options, visit https://groups.google.com/d/optout. > --=20 Cheers, Sviatoslav. --=20 You received this message because you are subscribed to the Google Groups "= cherrypy-users" group. To unsubscribe from this group and stop receiving emails from it, send an e= mail to cherrypy-users+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/[email protected] To post to this group, send email to cherrypy-users-/JYPxA39Uh5TLH3MbocFF+G/[email protected] Visit this group at https://groups.google.com/group/cherrypy-users. For more options, visit https://groups.google.com/d/optout. --000000000000bb82ee057ea6fcbf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"ltr">This is actually a CherryPy users group, = not Tornado. So I'm not sure how much insight you could get from us.<di= v>But OTOH nobody is going to guess what failed for you unless you actually= describe what you have tried already.</div><div>Current dialogue is in sty= le of "- It doesn't work! - Yes, it doesn't." isn't h= elpful, is it?<div><br></div><div>Show us the code.</div></div><img src=3D"= https://t.sidekickopen76.com/s1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v= 5dpzzVdDPRz2m64_PW3xgp7472TP1pf2mbxc201?si=3D5180645064310784&pi=3Dced3= c841-c766-440b-f2f1-d75693a61b41&ti=3Dnull" style=3D"display:none!impor= tant" height=3D"1" width=3D"1"></div><br><div class=3D"gmail_quote"><div di= r=3D"ltr">=D0=BF=D1=82, 4 =D1=81=D1=96=D1=87. 2019 =D0=BE 20:30 vahid peiva= ndy <<a href=3D"mailto:[email protected]">[email protected]<= /a>> =D0=BF=D0=B8=D1=88=D0=B5:<br></div><blockquote class=3D"gmail_quote= " style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);= padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div style=3D"font-fami= ly:"comic sans ms",sans-serif">I cannot connect mu db on web serv= er tornado or web server cherrypy this is my problem and see this page but = not help me <br></div><div style=3D"font-family:"comic sans ms",s= ans-serif"><a href=3D"https://tornado-sqlalchemy.readthedocs.io/en/latest/"= target=3D"_blank">https://tornado-sqlalchemy.readthedocs.io/en/latest/</a>= <br></div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">On Fr= i, Jan 4, 2019 at 10:54 PM Sviatoslav Sydorenko <<a href=3D"mailto:wk@sy= dorenko.org.ua" target=3D"_blank">[email protected]</a>> wrote:<br></d= iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord= er-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div = dir=3D"ltr"><div dir=3D"ltr">Hi Vahid,<div><br></div><div>I'm not sure = where are you stuck at? I have a feeling that you just don't know how t= o integrate SA with CherryPy. Am I right? If so, here's some app exampl= e: <a href=3D"https://github.com/Lawouach/Twiseless/blob/master/lib/tool/db= .py" target=3D"_blank">https://github.com/Lawouach/Twiseless/blob/master/li= b/tool/db.py</a></div></div><img src=3D"https://t.sidekickopen76.com/s1t/o/= 5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v5dpzzVdDPRz2m64_PW3xgp7472TP1pf2mbx= c201?si=3D5180645064310784&pi=3Da221339a-f23e-4c6d-cf1e-59b050aac5f5&am= p;ti=3Dnull" style=3D"display: none;" width=3D"1" height=3D"1"></div><br><d= iv class=3D"gmail_quote"><div dir=3D"ltr">=D0=BF=D1=82, 4 =D1=81=D1=96=D1= =87. 2019 =D0=BE 20:16 vahid peivandy <<a href=3D"mailto:tarfand.vahid@g= mail.com" target=3D"_blank">[email protected]</a>> =D0=BF=D0=B8=D1= =88=D0=B5:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0= px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div = dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div style=3D"font-family:&qu= ot;comic sans ms",sans-serif">I want on the first-page show a simple l= ist page HTML that shows Patient order by id, name, family name <br></div><= div style=3D"font-family:"comic sans ms",sans-serif">and when a u= ser clicked to for example=C2=A0 Patient Alex goes to the second page that = includes lists of <span class=3D"gmail-m_4207992493663676910gmail-m_-818531= 6781262791gmail-m_8371773478030908163gmail-tlid-translation gmail-m_4207992= 493663676910gmail-m_-8185316781262791gmail-m_8371773478030908163gmail-trans= lation"><span title=3D"" class=3D"gmail-m_4207992493663676910gmail-m_-81853= 16781262791gmail-m_8371773478030908163gmail-">Patient Referral order by id,= date and when the user clicked to special date go to the last page that sh= ows pictures of for example hand, foot, etc of Alex.</span></span> </div></= div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">On Fri, Jan= 4, 2019 at 10:27 PM Tim Roberts <<a href=3D"mailto:[email protected]" targ= et=3D"_blank">[email protected]</a>> wrote:<br></div><blockquote class=3D"g= mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204= ,204,204);padding-left:1ex"> =20 =20 =20 <div bgcolor=3D"#FFFFFF"> <div class=3D"gmail-m_4207992493663676910gmail-m_-8185316781262791gmail= -m_8371773478030908163gmail-m_316193385299837982moz-cite-prefix">vahid peiv= andy wrote:<br> </div> <blockquote type=3D"cite"> =20 <div dir=3D"ltr"> <div style=3D"font-family:"comic sans ms",sans-serif"><br= > I write db but now connect to the web server and this is my problem and need help <br> </div> </div> </blockquote> <p>Well, you take it one step at a time.=C2=A0 You will want to sketch out on paper what forms you will need.=C2=A0 What is the user story?= =C2=A0 What will they see first?=C2=A0 Is there a menu?=C2=A0 Is there a sea= rch?=C2=A0 Which tables do they need to see?=C2=A0 How does the flow go?=C2=A0 W= here do the buttons go?<br> </p> <p>After that, you're going to want to sketch out some simple HTML forms, just so you can see how they look with data in them.=C2=A0 How can you present the fields in an attractive and useful way?</p> <p>After that, I usually do a couple of the pages as CGI scripts behind an Apache server somewhere, so I can check out the flow without having to worry about a web server.<br> </p> <p>Once you have that basic outline, then you can choose your web server and start doing more coding.=C2=A0 You can adapt the CGI pages you've already done, and switch over to whatever template engine is provided.<br> </p> <pre class=3D"gmail-m_4207992493663676910gmail-m_-8185316781262791gmail= -m_8371773478030908163gmail-m_316193385299837982moz-signature" cols=3D"72">= --=20 Tim Roberts, <a class=3D"gmail-m_4207992493663676910gmail-m_-81853167812627= 91gmail-m_8371773478030908163gmail-m_316193385299837982moz-txt-link-abbrevi= ated" href=3D"mailto:[email protected]" target=3D"_blank">[email protected]</a> Providenza & Boekelheide, Inc. </pre> </div> <p></p> -- <br> You received this message because you are subscribed to the Google Groups &= quot;cherrypy-users" group.<br> To unsubscribe from this group and stop receiving emails from it, send an e= mail to <a href=3D"mailto:cherrypy-users+unsubscribe-/[email protected]" targ= et=3D"_blank">cherrypy-users+unsubscribe-/[email protected]</a>.<br> To post to this group, send email to <a href=3D"mailto:cherrypy-users@googl= egroups.com" target=3D"_blank">cherrypy-users-/[email protected]</a>.<br> Visit this group at <a href=3D"https://groups.google.com/group/cherrypy-use= rs" target=3D"_blank">https://groups.google.com/group/cherrypy-users</a>.<b= r> For more options, visit <a href=3D"https://groups.google.com/d/optout" targ= et=3D"_blank">https://groups.google.com/d/optout</a>.<br> </blockquote></div> <p></p> -- <br> You received this message because you are subscribed to the Google Groups &= quot;cherrypy-users" group.<br> To unsubscribe from this group and stop receiving emails from it, send an e= mail to <a href=3D"mailto:cherrypy-users+unsubscribe-/[email protected]" targ= et=3D"_blank">cherrypy-users+unsubscribe-/[email protected]</a>.<br> To post to this group, send email to <a href=3D"mailto:cherrypy-users@googl= egroups.com" target=3D"_blank">cherrypy-users-/[email protected]</a>.<br> Visit this group at <a href=3D"https://groups.google.com/group/cherrypy-use= rs" target=3D"_blank">https://groups.google.com/group/cherrypy-users</a>.<b= r> For more options, visit <a href=3D"https://groups.google.com/d/optout" targ= et=3D"_blank">https://groups.google.com/d/optout</a>.<br> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= class=3D"gmail-m_4207992493663676910gmail-m_-8185316781262791gmail_signatu= re"><div dir=3D"ltr">Cheers,<div>Sviatoslav.</div></div></div></div> <p></p> -- <br> You received this message because you are subscribed to the Google Groups &= quot;cherrypy-users" group.<br> To unsubscribe from this group and stop receiving emails from it, send an e= mail to <a href=3D"mailto:cherrypy-users+unsubscribe-/[email protected]" targ= et=3D"_blank">cherrypy-users+unsubscribe-/[email protected]</a>.<br> To post to this group, send email to <a href=3D"mailto:cherrypy-users@googl= egroups.com" target=3D"_blank">cherrypy-users-/[email protected]</a>.<br> Visit this group at <a href=3D"https://groups.google.com/group/cherrypy-use= rs" target=3D"_blank">https://groups.google.com/group/cherrypy-users</a>.<b= r> For more options, visit <a href=3D"https://groups.google.com/d/optout" targ= et=3D"_blank">https://groups.google.com/d/optout</a>.<br> </blockquote></div> <p></p> -- <br> You received this message because you are subscribed to the Google Groups &= quot;cherrypy-users" group.<br> To unsubscribe from this group and stop receiving emails from it, send an e= mail to <a href=3D"mailto:cherrypy-users+unsubscribe-/[email protected]" targ= et=3D"_blank">cherrypy-users+unsubscribe-/[email protected]</a>.<br> To post to this group, send email to <a href=3D"mailto:cherrypy-users@googl= egroups.com" target=3D"_blank">cherrypy-users-/[email protected]</a>.<br> Visit this group at <a href=3D"https://groups.google.com/group/cherrypy-use= rs" target=3D"_blank">https://groups.google.com/group/cherrypy-users</a>.<b= r> For more options, visit <a href=3D"https://groups.google.com/d/optout" targ= et=3D"_blank">https://groups.google.com/d/optout</a>.<br> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= class=3D"gmail_signature"><div dir=3D"ltr">Cheers,<div>Sviatoslav.</div></= div></div></div> <p></p> -- <br /> You received this message because you are subscribed to the Google Groups &= quot;cherrypy-users" group.<br /> To unsubscribe from this group and stop receiving emails from it, send an e= mail to <a href=3D"mailto:cherrypy-users+unsubscribe-/[email protected]">cher= rypy-users+unsubscribe-/[email protected]</a>.<br /> To post to this group, send email to <a href=3D"mailto:cherrypy-users@googl= egroups.com">cherrypy-users-/[email protected]</a>.<br /> Visit this group at <a href=3D"https://groups.google.com/group/cherrypy-use= rs">https://groups.google.com/group/cherrypy-users</a>.<br /> For more options, visit <a href=3D"https://groups.google.com/d/optout">http= s://groups.google.com/d/optout</a>.<br /> --000000000000bb82ee057ea6fcbf--