Open Mic Q&A: "IBM Lotus Notes Traveler" - December 8th, 2010
Рассылку ведет: Программист на Lotus NotesLotus CoderВыпуск No 344 от 2010-06-04
рассылка о программировании на Lotus Notes/Domino Обсуждения на форумах, блогах. Примеры программного кода на LotusScript,@formula, Java рассылка:выпускархивлентаблогсайт Бюллетень "Lotus Notes CodeStore" Выпуск 13 от 21.04.2008comp.soft.prog.lotuscodesrore
|
CodeStore. Примеры кодов
Форумы.Свежи темы и обсуждения
Tips. Советы
| Search For | Replace With |
| ". | "+ |
| ." | +" |
| echo " | context.Response.Write(" |
| $_POST[" | context.Request[" |
| $_GET[" | context.Request.QueryString[" |
| isset( | !String.IsNullOrEmpty( |
| htmlspecialchars( | HttpUtility.HtmlEncode( |
| $someVariable | someVariable |
| in_array("aString", $myArray) | myArray.Contains("aString") |
| $ |
With all of those replacement done I'd say that about 75% of the wiggly lines gone.
From MySQL to SQL Server
With all the syntax updated I then set about changing all the calls to MySQL to call SQL Server instead. Before I could do this I needed to recreate the database and tables. It's not a massive database so I did this by hand in the SQL Server Management Studio.
Once I'd re-created all the tables I added a Database Diagram in SQL Studio and defined the relationships between all the tables based on their primary key columns. Then in Visual Studio I added a new Data Set (.xsd) file and dragged all the tables on to there. Because I'd already defined their relationship in the Database Diagram, Visual Studio copied these relationships over for me.
With all the tables in the Data Set I then saved it and this then added a new TableAdapter class for each of my tables. Let's see how helpful these adapters are:
Here's the PHP code I was using to loop all the Products
$query="SELECT * FROM Products;";
$result = mysql_query($query);
$data = db_fetch_rowset($result);
mysql_free_result($result); foreach ($data as $key => $row) { echo $row["id"];
}
And the same thing in C#:
ProjectsTableAdapter pta = new ProjectsTableAdapter(); DataTable products = pta.GetData(); foreach (DataRow row in products.Rows) { context.Response.Write(row["id"]); }
Notice I've not had to use any SQL in the C# code. We'll see later on how much easier it makes adding data to the tables too.
Getting Data Via XML
The SQL data held in both versions came from Domino-based XML views. In PHP and C# it's actually quite easy to load and loop XML. Let's imagine we're loading XML in this format:
<products> <product> <id>1</id> <name>Product 1</name> </product> <product> <id>2</id> <name>Product 2</name> </product> </products>
In PHP you fetch, process and store the XML data like this (requires PHP5 to use "Simple XML"):
$products = simplexml_load_file($BasePath+"ProductsAsXML?OpenView&start="+$start+"&count="+$count); foreach ($products->products->product as $product) { $query = "INSERT INTO Products VALUES ("+$product->id+", '"+$product->name+"');"; $result = mysql_query($query); }
In C# you achieve the same thing like this:
XElement xml = XElement.Load(BasePath + "ProductsAsXML?OpenView&start=" + start.ToString() + "&count=" + count.ToString()); foreach (XElement product in xml.Element("products").Elements("product")) { pta.Insert(Convert.ToInt32(product.Element("id").Value), product.Element("name").Value); }
Not that "pta" is the same ProjectsTableAdapter we mentioned earlier. Notice how it added an Insert method when we created the Data Set and it takes the right number and types of arguments. Again, no need for any SQL code. It's much, much simple to deal with SQL in C# than PHP!
The XML processing code in PHP might read a little easier than in C# but they're both equally (and surprisingly) easy to achieve.
Summary
So, there you go. Porting PHP code to C# doesn't require you to re-write the code. Just tweak it a little. It's no 10 minute job but then nor does it take weeks. More likely to be days, but will always depend on size of app etc. The starting point has to be a find/replace though.
What did I get out of the exercise? Well, I learnt a bit more C# and all practice and exposure is good at this point. In the long run though I now have something that is much easier to maintain and development doesn't involve text editors and FTP clients. Instead I have a local web server to test on and full type-ahead predictive coding.
I'm not saying PHP is better than ASP.NET or vice versa. It's just that, given the choice of which I'd rather develop in, ASP.NET wins hands down. Give me a GUI any day!
On receiving the gift of some Minnie Mouse ears.
On learning we named her after a Disney character *
One day Minnie will hate anything to do with said mouse or the novelty ears. For now she loves them.
* We didn't.
In the interest of equality here are some recent pictures of Felix and Evelyn to accompany the earlier ones of Minnie.
Evelyn has in the last couple of weeks started to smile and interact. The point at which dads start to pay proper attention to their kids, is it not?
Felix is a real boy. Full of energy and great fun.
When he want to be that is.
And a loving brother. To Evelyn at least. It's a love/hate relationship with Minnie at the moment.
There. That should keep Karen at bay for a while. "When are you going to put pictures of the kids on your website?!".
Блоги. Что обсуждают и пишут
Tags: mail archiving delegation folder
Idea:
Tags: images
Idea:
Tags: images
Idea:
Tags: rss
Idea:
Статьи и Документация
| Ссылки | Утилиты и программы | Сайты о Lotus Notes |
| В избранное | ||
