Regularly read sql2005 database to generate a json file-CodePudding

I novice one, just contact with programming, to realize the data read from the database, automatically generate a json file, and regularly updated to cover the entire file, cover cannot affect the access of users, how to implement?

CodePudding user response:

Generate multiple json file, have a great god online, etc

CodePudding user response:

Actually very easy to write a service, the service is always in the running, set a sleep time, an hour to run time, add a judgment, if you need the hour is executed to retrieve data from a database, assembled into a JSON format, print to TXT file is OK, also does not affect user access,

CodePudding user response:

reference flow Maple Maple 2 floor response:

actually very easy to write a service, the service is always in the running, set a sleep time, an hour to run time, add a judgment, if you need the hour is executed to retrieve data from a database, assembled into a JSON format, print to TXT file is OK, also does not affect user access,

Can understand the logical theory, but don't know how to write the code... I want to use the.net environment

CodePudding user response:

https://www.imooc.com/article/28639

CodePudding user response:

SQL is a mission, under the baidu is very simple

CodePudding user response:

refer to fifth floor curiosity is to learn response:

SQL has a mission, under the baidu very simple

Is it? I am a little white, what all don't understand ah, a few times SQL can perform tasks can timing automatically generated automatically json file?

CodePudding user response:

refer to 6th floor mind wander reply:

Quote: refer to fifth floor curiosity is to learn response:

SQL has a mission, under the baidu very simple

Is it? I am a little white, what all don't understand ah, a few times SQL can perform tasks can timing automatically generated automatically json file?

The SQL table becomes a JSON, first search search SQL execution plan, how long can be set up once

CodePudding user response:

refer to fifth floor curiosity is to learn response:

SQL has a mission, under the baidu very simple

If you really can do this, can be great, thank you, I now learn to search,

CodePudding user response:

https://blog.csdn.net/yenange/article/details/101838134

I also upload the code, but is reviewing, may need a day or two,

You use Windows task regularly call the batch file, batch call exe file,
You need to do is something configurable,

CodePudding user response:

references 9 f gypsy song response:

https://blog.csdn.net/yenange/article/details/101838134
I also upload the code, but is reviewing, may need a day or two,

You use Windows task regularly call the batch file, batch call exe file,
You need to do is something configurable,

Thank you very much the moderator a great god, and I'll download learning,

CodePudding user response:

https://download.csdn.net/download/yenange/11831073

Resource audit, you see

CodePudding user response:

11 references gypsy song response:

https://download.csdn.net/download/yenange/11831073
Resource audit, you see

Just download vs2008, 4 g good slow, I for a while to try downloading, thank moderator great god,

CodePudding user response:

11 references gypsy song response:

Can't download, a download member VIP popup Windows, I try to use the code you provided in vs2008 wrote, suggests three warning
1: warning 1 predefined type "System.Runtime.Com pilerServices ExtensionAttribute" is defined in global alias multiple assemblies; Will the use of "C: \ Users \ asus \ Documents \ Visual Studio 2008 \ Projects \ Project1 \ GetJson \ JsonHelper cs" defined in the GetJson
2 and 3 are: warning statement the variable "ex", but never use

Generation solution, but the generated is several documents, one GetJson file should be executable program, I can't open it,...

CodePudding user response:

refer to the eighth floor mind wander reply:

Quote: refer to fifth floor curiosity is to learn response:

SQL has a mission, under the baidu very simple

If you really can do this, can be great, thank you, I now learn to search,

Search for the timer?

CodePudding user response:

BCP "SELECT TOP 30 [bom_no], [LEVEL] FROM [sqladmin] [dbo]. (bom) FOR XML path, TYPE, ELEMENTS, ROOT (' RegionSales)"
QUERYOUT "d: \ temp \ test XML" - c - t - t -s localhost

CodePudding user response:

refer to the eighth floor mind wander reply:

Quote: refer to fifth floor curiosity is to learn response:

SQL has a mission, under the baidu very simple

If you really can do this, can be great, thank you, I now learn to search,

SQL Server has a job, but if takes performance task, try not to use the database Server will be big pressure

CodePudding user response:

refer to the 13th floor mind wander reply:

Quote: refer to the gypsy 11 songs response:

Can't download, a download member VIP popup Windows, I try to use the code you provided in vs2008 wrote, suggests three warning
1: warning 1 predefined type "System.Runtime.Com pilerServices ExtensionAttribute" is defined in global alias multiple assemblies; Will the use of "C: \ Users \ asus \ Documents \ Visual Studio 2008 \ Projects \ Project1 \ GetJson \ JsonHelper cs" defined in the GetJson
2 and 3 are: warning statement the variable "ex", but never use

Generation solution, but the generated is several documents, one GetJson file should be executable program, I can't open it,...

Can't download because you do not have integral, it also does not have method,
What will he do warn you tube? Don't tube,
GetJson. Exe executable file, use this,

Sql task can execute exe regularly, but open xp_cmshell sql2005 wanted to execute exe file, there is a big risk,
If you can use sql2014 or higher, use powershell to perform good,
https://blog.csdn.net/yenange/article/details/78436083

CodePudding user response:

This simple

If is to write a TXT document

If your user is HTTP requests can be designed so that

Just do a cache just a matter of...

Step 1: a single thread to read database Newtonsoft. Json. JsonConvert. SerializeObject (obj); Preserved.

This data memory to the cache MemoryCache

nullnullnull