#100DaysOfCode in Python Transcripts
Chapter: Days 85-87: Fullstack web apps made easy
Lecture: Anvil server code
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
We have our data and we know
0:01
we can get to it from the server modules,
0:03
but not the forms cause we want to make sure
0:05
that's safe.
0:06
How do we write a server module?
0:08
Let's go and add one.
0:10
So it's called server_module1.
0:12
Not a super name.
0:13
Let's give it something better.
0:14
Let's call it data_layer
0:17
or something like that.
0:18
Now check this out over here.
0:20
It says okay we are going to import
0:21
some server and data stuff.
0:22
And all you really have to do is just
0:24
create any function that is callable,
0:27
has parameters, and return something
0:29
and we can call it.
0:30
So for example to say hello,
0:32
how would we get to that?
0:33
Let's go to our home form really quick.
0:35
And let's just in this lib we'll say print.
0:38
anvil.server.call
0:42
Now look what just happened here.
0:44
It takes a string, the server name,
0:46
but Anvils integrated to know what server
0:49
methods are available and is helping us
0:51
right here.
0:52
So say, say hello.
0:54
And then I could put my name,
0:56
which if you look back here it accepts a name.
0:59
It should say, "Hello there."
1:00
So that'll be the input in return 42
1:03
as it should. So let's run that.
1:08
See some output.
1:10
Server is yellow.
1:11
Client is clear or white.
1:13
It says, "Hello Michael 42."
1:15
How awesome is that?
1:16
Alright that is an incredibly simple
1:17
way to have a service.
1:19
Put that on there, done.
1:20
Then already host a service,
1:21
host a client, connects them, done.
1:23
So we don't want this.
1:24
We want code that talks to our database.
1:27
We put that here and I'll talk you through it.
1:30
So we're going to come over here
1:31
and we're going to talk to our
1:33
app tables and we say dot.
1:35
You see we have our 2 databases
1:37
that we created. Our 2 data tables and the data table service
1:40
we created, and we can go to them
1:43
and we can say, "Search"
1:44
and we can even do an order by.
1:45
And I'm going to convert that to a list
1:47
and then we'll turn it back.
1:48
Over here I'm going to do something
1:49
similar for categories.
1:51
And categories we're doing by name
1:52
so it's alphabetical.
1:54
Also can find individual documents by name.
1:56
Instead of doing a search,
1:57
you can do a get.
1:58
So here we're doing a where the name is
2:00
equal to what we pass.
2:02
So we're going to leave 4 categories.
2:03
Okay so these 4 functions are now
2:05
available to our code.
2:07
Let's try to add them into our add_doc_form.
2:10
So up here, we got our categories.
2:12
Let's go over here and say, "Categories",
2:15
call them all_categories.
2:18
We're going to go anvil.server.call
2:21
Now look.
2:22
All categories takes no parameters.
2:25
Now these are going to return rows
2:28
which are dictionaries which have things
2:29
and so what I really want is categories
2:32
is going to be c, it's going to be one of the rows.
2:35
And it's going to be named,
2:36
remember we had that in there,
2:38
for c in raw_cats.
2:41
So now we have Docs, Science, News, and Social,
2:44
but remember we put like press releases
2:46
and stuff.
2:47
Let's see what we get now.
2:49
Oh, whoops,
2:50
I got to take that out, don't I?
2:51
It's really cool how you can
2:52
click that to get back.
2:53
Alright that was just test run,
2:54
forgot about that.
2:56
Let's go to add a document,
2:59
and look at that.
3:00
That's now out of our database.
3:02
How slick is this?
3:03
Okay super, super cool.
3:05
One of the challenges there,
3:06
this is going to keep reloading it
3:07
if I do this, and do this.
3:09
Hitting the database again.
3:10
Turns out this is probably not going to
3:12
change that often, so we'll be able to do something slightly
3:14
better, but this is really really cool.
3:18
Add the name.
3:20
Add some stuff here.
3:21
Hit create.
3:22
And then we should be able to call one
3:24
more function on that server.
